StarRocks如何查看一张表是否是单副本?
多副本:
MySQL [twdata]> show tablet 90695659; +--------+----------------------------+---------------+----------------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ | DbName | TableName | PartitionName | IndexName | DbId | TableId | PartitionId | IndexId | IsSync | DetailCmd | +--------+----------------------------+---------------+----------------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ | data | sr_event | p20260710 | sr_event | 3169361 | 27379459 | 90695658 | 27379460 | true | SHOW PROC '/dbs/3169361/27379459/partitions/90695658/27379460/90695659'; | +--------+----------------------------+---------------+----------------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ 1 row in set (0.00 sec) MySQL [twdata]> SHOW PROC '/dbs/3169361/27379459/partitions/90695658/27379460/90695659'; +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+---------------------------------------------------+----------------------------------------------------------------------------------------+--------------+ | ReplicaId | BackendId | Version | VersionHash | LstSuccessVersion | LstSuccessVersionHash | LstFailedVersion | LstFailedVersionHash | LstFailedTime | SchemaHash | DataSize | RowCount | State | IsBad | IsSetBadForce | VersionCount | PathHash | MetaUrl | CompactionStatus | IsErrorState | +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+---------------------------------------------------+----------------------------------------------------------------------------------------+--------------+ | 90695660 | 35468871 | 7 | 0 | 7 | 0 | -1 | 0 | NULL | 1696049109 | 75420319 | 7093908 | NORMAL | false | false | 1 | -6043518985966267869 | http://127.0.0.131:8040/api/meta/header/90695659 | http://127.0.0.131:8040/api/compaction/show?tablet_id=90695659&schema_hash=1696049109 | false | | 90695661 | 41350191 | 7 | 0 | 7 | 0 | -1 | 0 | NULL | 1696049109 | 75420319 | 7093908 | NORMAL | false | false | 1 | 5916097581675239323 | http://127.0.0.154:8040/api/meta/header/90695659 | http://127.0.0.154:8040/api/compaction/show?tablet_id=90695659&schema_hash=1696049109 | false | | 90695662 | 39894719 | 7 | 0 | 7 | 0 | -1 | 0 | NULL | 1696049109 | 75420319 | 7093908 | NORMAL | false | false | 1 | -5318340163987254342 | http://127.0.0.44:8040/api/meta/header/90695659 | http://127.0.0.44:8040/api/compaction/show?tablet_id=90695659&schema_hash=1696049109 | false | +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+---------------------------------------------------+----------------------------------------------------------------------------------------+--------------+ 3 rows in set (0.00 sec)单副本:
MySQL [twdata]> show tablet 85091038; +--------+----------------------+-----------------------------+----------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ | DbName | TableName | PartitionName | IndexName | DbId | TableId | PartitionId | IndexId | IsSync | DetailCmd | +--------+----------------------+-----------------------------+----------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ | twdata | test | $shadow_automatic_partition | test | 3169361 | 52051104 | 52051103 | 85091037 | true | SHOW PROC '/dbs/3169361/52051104/partitions/52051103/85091037/85091038'; | +--------+----------------------+-----------------------------+----------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ 1 row in set (0.00 sec) MySQL [twdata]> SHOW PROC '/dbs/3169361/52051104/partitions/52051103/85091037/85091038'; +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+--------------------------------------------------+--------------------------------------------------------------------------------------+--------------+ | ReplicaId | BackendId | Version | VersionHash | LstSuccessVersion | LstSuccessVersionHash | LstFailedVersion | LstFailedVersionHash | LstFailedTime | SchemaHash | DataSize | RowCount | State | IsBad | IsSetBadForce | VersionCount | PathHash | MetaUrl | CompactionStatus | IsErrorState | +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+--------------------------------------------------+--------------------------------------------------------------------------------------+--------------+ | 85091039 | 35468872 | 1 | 0 | 1 | 0 | -1 | 0 | NULL | 459811504 | 0 | 0 | NORMAL | false | false | 1 | -6897070086613041248 | http://127.0.0.81:8040/api/meta/header/85091038 | http://127.0.0.81:8040/api/compaction/show?tablet_id=85091038&schema_hash=459811504 | false | +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+--------------------------------------------------+--------------------------------------------------------------------------------------+--------------+ 1 row in set (0.00 sec)