Note
This view is available starting with V5.0.1.
Overview
This view is used to query external catalog table-level statistics for external tables.
Columns
Column |
Type |
Is NULL |
Description |
|---|---|---|---|
| CATALOG_NAME | varchar(128) | NO | Represents the catalog name. |
| DATABASE_NAME | varchar(128) | NO | Represents the database name. |
| TABLE_NAME | varchar(128) | NO | The table name. |
| PARTITION_VALUE | text | NO | Represents the partition value. |
| OBJECT_TYPE | varchar(12) | NO | Indicates the type of the current statistics object, which can be a table or a partition. |
| NUM_ROWS | decimal(20,0) | NO | Represents the number of rows obtained from the overall sampling, expressed as a multiple of the sampling base. |
| AVG_ROW_LEN | decimal(10,0) | NO | Average row length. |
| SAMPLE_SIZE | decimal(20,0) | YES | Represents the sample size. |
| LAST_ANALYZED | datetime(6) | NO | Indicates the most recent analysis time. |
| LAST_MODIFIED | datetime(6) | NO | Indicates the last time statistics were written. |
| STATTYPE_LOCKED | varchar(5) | NO | The current status of the statistics (lock type). Valid values:
|