Help Center/ Data Lake Insight/ HetuEngine SQL Syntax Reference/ HetuEngine SQL Syntax/ Auxiliary Command Syntax/ DESCRIBE FORMATTED COLUMNS
Updated on 2025-08-06 GMT+08:00
View PDF

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 and collect statistics on the columns of specified tables or partitions.

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)
Parent topic: Auxiliary Command Syntax