tables_config
tables_config
provides information about the configuration of tables.
The following fields are provided in tables_config
:
Field | Description |
---|---|
TABLE_SCHEMA | Name of the database that stores the table. |
TABLE_NAME | Name of the table. |
TABLE_ENGINE | Engine type of the table. |
TABLE_MODEL | Data model of the table. Valid values: DUP_KEYS , AGG_KEYS , UNQ_KEYS or PRI_KEYS . |
PRIMARY_KEY | Primary key of a Primary Key table or a Unique Key table. An empty string is returned if the table is not a Primary Key table or a Unique Key table. |
PARTITION_KEY | Partitioning columns of the table. |
DISTRIBUTE_KEY | Bucketing columns of the table. |
DISTRIBUTE_TYPE | Data distribution method of the table. |
DISTRUBTE_BUCKET | Number of buckets in the table. |
SORT_KEY | Sort keys of the table. |
PROPERTIES | Properties of the table. |
TABLE_ID | ID of the table. |