Feature
This view shows the locations of tables or partitions, including system tables, user tables, and index tables.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| DATABASE_NAME | varchar(128) | NO | The name of the database. |
| TABLE_NAME | varchar(256) | NO | The name of the table. |
| TABLE_ID | bigint(20) | NO | The ID of the table. |
| TABLE_TYPE | varchar(13) | NO | The type of the table. Valid values: |
| PARTITION_NAME | varchar(64) | NO | The name of the partition. The default value is NULL for non-partitioned tables. |
| SUBPARTITION_NAME | varchar(64) | NO | The name of the subpartition. The value is NULL for non-subpartitioned tables. |
| INDEX_NAME | varchar(256) | NO | The name of the index table. For tables other than index tables, the value is NULL. |
| DATA_TABLE_ID | bigint(20) | NO | The ID of the primary table. If the table is not an index table or LOB table, the value is NULL. |
| TABLET_ID | bigint(20) | NO | The TABLET ID. |
| LS_ID | bigint(20) | NO | The log stream where the object resides. |
| ZONE | varchar(128) | NO | The zone where the replica resides. |
| SVR_IP | varchar(46) | NO | The IP information of the OBServer where the replica resides. |
| SVR_PORT | bigint(20) | NO | The port information of the OBServer where the replica resides. |
| ROLE | varchar(8) | NO | The role of the replica. |
| REPLICA_TYPE | varchar(18) | NO | The type of the log stream. Currently, only FULL is supported, which indicates full-featured replicas. |