Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using HetuEngine/ Common HetuEngine SQL Syntax/ HetuEngine Auxiliary Command Syntax/ DESCRIBE FORMATTED COLUMNS
Updated on 2024-12-13 GMT+08:00
View PDF
Share

DESCRIBE FORMATTED COLUMNS

Syntax

DESCRIBE FORMATTED [db_name.]table_name [PARTITION partition_spec] col_name

Description

This statement is used to describe the column information of a table or partition.

Collect statistics on the columns of specified tables or partitions.

The following is an example.

Example

describe formatted show_table1 a;
  Describe Formatted Column   
------------------------------
 col_name             a       
 data_type            integer 
 min                          
 max                          
 num_nulls                    
 distinct_count       0       
 avg_col_len                  
 max_col_len                  
 num_trues                    
 num_falses                   
 comment                      
(1 row)