hive (test)> desc database extended wx_test;
OK
db_name     comment                 location
wx_test hdfs://master.cloudera.com:8020/user/hive/warehouse/wx_test.db

owner_name     owner_type     parameters
hadoop USER             {t_date=2015-06-21, creator=wx}
Time taken: 0.075 seconds, Fetched: 1 row(s)

hive (test)> desc formatted page_view_1;
OK
col_name data_type comment
# 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: test
Owner: hadoop
CreateTime: Sun Jun 21 16:37:49 CST 2015
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Location: hdfs://master.cloudera.com:8020/user/hive/warehouse/test.db/page_view_1
Table Type: MANAGED_TABLE
Table Parameters:
comment This is the page view table
creator wx
t_date 2015-06-21
transient_lastDdlTime 1434875869

# 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.096 seconds, Fetched: 39 row(s)

ITPub博客

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

最新文章