Parameter | Type | Description | Example |
---|
Parameter | Type | Description | Example |
---|---|---|---|
object | The queried table. | ||
TblId | long | The table ID. | 123 |
DbName | string | The logical name of the database. | example |
TableName | string | The logical name of the table. | tableName |
TableType | string | The type of the table. | external_table |
PartitionKeys | array | The partition key. | |
FieldSchemaModel | The partition column. | ||
Parameters | object | The parameter. | |
string | The value of the parameter. | key:value | |
Sd | StorageDescriptorModel | The storage description. | |
CreateTime | string | The time when the table was created. | 2023-01-05 13:17:55 |
ViewOriginalText | string | The SQL statement that is used to create the table or view. | ViewOriginalText |
ViewExpandedText | string | The standardized SQL statement that is used to create the table or view. | ViewExpandedText |
Temporary | boolean | Indicates whether the table is a temporary table. | false |
Comment | string | The description of the table. | description |
Cols | array | The columns in the table. | |
FieldSchemaModel | The column in the table. | ||
DistributeColumns | array | The distribution columns. | |
FieldSchemaModel | The distribution column. | ||
PhysicalTableName | string | The physical name of the table. | physicalTableName |
PhysicalDatabaseName | string | The physical name of the database. | physicalDatabaseName |
DistributeType | string | The distribution type. | DistributeType |
PartitionType | string | The partition type. | PartitionType |
PartitionColumn | string | The partition column. | colName |
PartitionCount | long | The number of partitions. | 16 |
PreviousVersion | long | The previous version. | 1 |
CurrentVersion | long | The current version. | 2 |
UpdateTime | string | The time when the table was updated. | 2023-01-05 13:17:55 |
TableEngineName | string | The engine name of the table. | hive |
IsAllIndex | boolean | Indicates whether the table is fully indexed. | true |
BlockSize | long | The block size. | 64 |
Compression | string | The compression method. | Compression |
RawTableName | string | The original name of the table. | RawTableName |
SubpartitionType | string | The subpartition type. | SubpartitionColumn |
SubpartitionColumn | string | The subpartition column. | SubpartitionColumn |
SubpartitionCount | long | The number of subpartitions. | 64 |
ArchiveType | string | The archive type. | ArchiveType |
MaxColumnId | long | The maximum column ID. | MaxColumnId |
EnableDfs | boolean | Indicates whether a distributed file system (DFS) is allowed. | false |
StoragePolicy | string | The storage policy. | StoragePolicy |
HotPartitionCount | long | The number of hot partitions. | 32 |
IsFulltextDict | boolean | Indicates whether a full-text index dictionary is used. | false |
RtIndexAll | boolean | Indicates whether all indexes are routed. | false |
RouteColumns | array | The route columns. | |
FieldSchemaModel | The route column. | ||
RouteEffectiveColumn | FieldSchemaModel | The effective route column. | |
RtEngineType | string | The route engine type. | RtEngineType |
RtModeType | string | The route mode type. | RtModeType |
RouteType | string | The route type. | routeType |
DictEncode | boolean | Indicates whether data is encrypted. | false |
BucketCount | long | The number of buckets. | 16 |
Bucket | long | The bucket ID. | 16 |
ViewSecurityMode | string | The security mode of the table or view. | ViewSecurityMode |
Indexes | array | The index. | |
CstoreIndexModel | The index column. |