Hive格式化输出数据库和表详细信息

hive> desc database extended wx_test;
OK
wx_test  hdfs://ns1/user/hive/warehouse/wx_test.db hadoop USER {t_date=2015-06-21, creator=wx}
Time taken: 0.027 seconds, Fetched: 1 row(s)

hive> desc formatted page_view;
OK
# col_name             data_type            comment            
   
viewtime             int                                     
userid               bigint                                  
page_url             string                                  
referrer_url         string                                  
ip                   string               IP Address of the User
   
# Partition Information   
# col_name             data_type            comment            
   
dt                   string                                  
country              string                                  
   
# Detailed Table Information   
Database:            wx_test              
Owner:               hadoop               
CreateTime:          Sun Jul 12 20:03:18 CST 2015 
LastAccessTime:      UNKNOWN              
Protect Mode:        None                 
Retention:           0                    
Location:            hdfs://ns1/user/hive/warehouse/wx_test.db/page_view 
Table Type:          MANAGED_TABLE        
Table Parameters:   
 comment              This is the page view table
 creator              wx                 
 t_date               2015-06-21         
 transient_lastDdlTime 1436702598         
   
# Storage Information   
SerDe Library:       org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 
InputFormat:         org.apache.hadoop.mapred.SequenceFileInputFormat 
OutputFormat:        org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat 
Compressed:          No                   
Num Buckets:         -1                   
Bucket Columns:      []                   
Sort Columns:        []                   
Storage Desc Params:   
 serialization.format 1                  
Time taken: 0.089 seconds, Fetched: 39 row(s)

Hive格式化输出数据库和表详细信息

标签：