DESCRIBE
Function
This command shows detailed information or statistics about a table.
Syntax
Show statistics about a table:
DESCRIBE [EXTENDED|FORMATTED] [database_name.]table_name|DELTA.`obs://bucket_name/tbl_path`;
Show detailed information about a table:
DESCRIBE DETAIL [database_name.]table_name|DELTA.`obs://bucket_name/tbl_path`;
Required Permissions
- SQL permissions
Permission Description |
---|
DESCRIBE_TABLE permission on a table |
- Fine-grained permission: dli:table:describeTable
- Metadata services provided by LakeFormation. Refer to the LakeFormation documentation for details on permission configuration.
Examples
DESCRIBE FORMATTED delta_table0; DESCRIBE FORMATTED delta.`obs://bucket_name0/db0/delta_table0`; DESCRIBE DETAIL delta_table0;
System Response
Returns details or statistics about a table.
Parameter |
Description |
---|---|
format |
Format of the table, which is delta in this example |
id |
Unique ID of the table |
name |
Table name defined in MetaServer |
description |
Description about the table |
location |
Storage path of the table |
createdAt |
Timestamp when the table was created |
lastModified |
Timestamp when the table was last modified |
partitionColumns |
Partition column |
numFiles |
Number of files in the latest version of the table |
sizeInBytes |
Size of the latest snapshot of the table, in bytes |
properties |
All the attributes set for this table |
minReaderVersion |
Earliest reader version that can read the table |
minWriterVersion |
Earliest writer version that can write the table |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot