更新时间:2024-07-24 GMT+08:00

DESCRIBE FORMATTED COLUMNS

语法

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

描述

描述表或分区的列信息,将包含指定表或分区的列的统计数据。

示例

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)