- hive的分区表添加数据的时候,要指定分区,如果不指定分区会报错
CREATE TABLE test_stu(
stu_name string,
stu_id string,
create_date_time bigint,
update_date_time bigint,
data_date int)
partitioned by(
ta_no string
)
stored as ORC;
insert into test_stu partition (ta_no = 1) values('zhangsan','123456',20211212,20211213,20211214);
select * from test_stu;