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 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 formatted output database and table details