1、创建hive分区表：

create table invites (id int, name string)

partitioned by (ds string)

row format delimited

fields terminated by 't' stored as textfile;

2、像hive中插入一条数据;hive仓库其实一般不建议insert,delete,update一行数据

insert into table invites partition(ds='2017-11-15') values(1,'xiaoming');

 

3、查询tab数据

select * from invtes;