hive查看一张表的分区字段_Hive常规操作(查看和操作分区，字段，注释)

查看分区

describe formatted tableName partition(date_id="2019-01-07");

查看table在hdfs上的存储路径及建表语句

show create table tableName ;

操作分区和表语句

alter table tableName add IF NOT EXISTS partition(date_id="$year-$mon-$day") location "${dest}";

删除分区

ALTER TABLEtableName DROP IF EXISTS PARTITION (date_id='2019-01-07');

新增分区

ALTER TABLE tableName ADD PARTITION (date_id = '2019-01-07') location 'hdfs://wecloud-cluster/project/logcenter/dw_logs/2019-01-07';

添加分区

ALTER TABLE table_name ADD PARTITION (partCol = 'value1') location 'loc1'; //示例

ALTER TABLE table_name ADD IF NOT EXISTS PARTITION (date_id='2019-01-07') LOCATION '/user/hadoop/warehouse/table_name/date_id=20190107'; //一次添加一个分区

ALTER TABLE page_view ADD PARTITION (date_id='2019-01-07