Hive之Show、Describe语句使用

1.表及分区格式化信息
包含存储位置、分隔符格式、创建时间等信息。
describe formatted table_name [PARTITION(partition_desc)];

describe formatted recommend_data_view partition (pt_day='2018-07-19');
describe formatted recommend_data_view;

2.表及分区的查看
可以进行模糊查询。
SHOW TABLES [IN database_name] [identifier_with_wildcards];
SHOW PARTITIONS table_name  [PARTITION(partition_desc)];

show tables 're*';
show partitions recommend_data_view partition (pt_day='2018-07-19');

3.表及视图建表语句查看
SHOW CREATE TABLE ([db_name.]table_name|view_name)

show create table recommend_data_view;

4.列信息查看
SHOW COLUMNS(FROM|IN) table_name [(FROM|IN) db_name]

show columns in recommend_data_view;

5.带描述列信息查看
DESCRIBE [EXTENDED|FORMATTED] [db_name.]table_name PARTITION partition_spec;

desc recommend_data_view;
desc recommend_data_view partition (pt_day='2018-07-19');

6.其他方面信息查看
SHOW TBLPROPERTIES table_name;

SHOW TBLPROPERTIES table_name ('');
SHOW TBLPROPERTIES recommend_data_view;

SHOW TABLE EXTENDED[IN|FROM database_name] LIKE identifier_with_wildcards [PARTITION (partition_desc)]

SHOW TABLE EXTENDED in default LIKE 'recommend_data_view' partition (pt_day='2018-07-19');