Unlock the Power of AI

1 million free tokens

88% Price Reduction

Activate Now

TableModel

Updated at: 2025-03-10 07:03
ParameterTypeDescriptionExample
ParameterTypeDescriptionExample
object

The queried table.

TblIdlong

The table ID.

123
DbNamestring

The logical name of the database.

example
TableNamestring

The logical name of the table.

tableName
TableTypestring

The type of the table.

external_table
PartitionKeysarray

The partition key.

FieldSchemaModel

The partition column.

Parametersobject

The parameter.

string

The value of the parameter.

key:value
SdStorageDescriptorModel

The storage description.

CreateTimestring

The time when the table was created.

2023-01-05 13:17:55
ViewOriginalTextstring

The SQL statement that is used to create the table or view.

ViewOriginalText
ViewExpandedTextstring

The standardized SQL statement that is used to create the table or view.

ViewExpandedText
Temporaryboolean

Indicates whether the table is a temporary table.

false
Commentstring

The description of the table.

description
Colsarray

The columns in the table.

FieldSchemaModel

The column in the table.

DistributeColumnsarray

The distribution columns.

FieldSchemaModel

The distribution column.

PhysicalTableNamestring

The physical name of the table.

physicalTableName
PhysicalDatabaseNamestring

The physical name of the database.

physicalDatabaseName
DistributeTypestring

The distribution type.

DistributeType
PartitionTypestring

The partition type.

PartitionType
PartitionColumnstring

The partition column.

colName
PartitionCountlong

The number of partitions.

16
PreviousVersionlong

The previous version.

1
CurrentVersionlong

The current version.

2
UpdateTimestring

The time when the table was updated.

2023-01-05 13:17:55
TableEngineNamestring

The engine name of the table.

hive
IsAllIndexboolean

Indicates whether the table is fully indexed.

true
BlockSizelong

The block size.

64
Compressionstring

The compression method.

Compression
RawTableNamestring

The original name of the table.

RawTableName
SubpartitionTypestring

The subpartition type.

SubpartitionColumn
SubpartitionColumnstring

The subpartition column.

SubpartitionColumn
SubpartitionCountlong

The number of subpartitions.

64
ArchiveTypestring

The archive type.

ArchiveType
MaxColumnIdlong

The maximum column ID.

MaxColumnId
EnableDfsboolean

Indicates whether a distributed file system (DFS) is allowed.

false
StoragePolicystring

The storage policy.

StoragePolicy
HotPartitionCountlong

The number of hot partitions.

32
IsFulltextDictboolean

Indicates whether a full-text index dictionary is used.

false
RtIndexAllboolean

Indicates whether all indexes are routed.

false
RouteColumnsarray

The route columns.

FieldSchemaModel

The route column.

RouteEffectiveColumnFieldSchemaModel

The effective route column.

RtEngineTypestring

The route engine type.

RtEngineType
RtModeTypestring

The route mode type.

RtModeType
RouteTypestring

The route type.

routeType
DictEncodeboolean

Indicates whether data is encrypted.

false
BucketCountlong

The number of buckets.

16
Bucketlong

The bucket ID.

16
ViewSecurityModestring

The security mode of the table or view.

ViewSecurityMode
Indexesarray

The index.

CstoreIndexModel

The index column.

    Feedback
    phone Contact Us

    Chat now with Alibaba Cloud Customer Service to assist you in finding the right products and services to meet your needs.

    alicare alicarealicarealicare