hive 操作表

[xujinli88]

--插入表一条数据
insert into dm.PLAN_ES_D PARTITION (statis_date='20191106' )
values
('107423328DC0163000550D0240001','2.0','A002','tyrt','S01','ert','1','1')

--插入表一条数据（会先清空表再插入）
insert overwrite table dm.T_DW_D PARTITION (statis_date='20191106' )
values
('107423328DC0163000550D0240001','2.0','A002','tyrt','S01','ert','1','1')

--插入一条数据利用虚表
insert OVERWRITE table dm.T_DWD_D PARTITION (statis_date='20191106' )
select '107423328DC0163000550D0240001','2.0','A002','tyrt','S01','ert','1','1' from dual


---给表增加一个分区
alter table dm.T_DWD_SCN_PS_D add partition (statis_date='20191105')

--查看表字段
desc dm.T_DWD_SCN_PS_D

--查看表分区
show partitions dm.T_DWD_SCN_PS_D