hive分区表增加字段会导致新增字段无法显示值的BUG
问题:
创建了hive表:
create table default.temp (id int,name string) partitioned by (logdate string);
插入数据:
insert into table default.temp partition (logdate='2019-03-01') values(1,'zhangsan'),(2,'lisi');
清空表数据:
truncate table default.temp;
新增字段:
alter table default.temp add columns (address string);
再次插入数据(注意是同上面是相同的分区情况下):
insert into table default.temp partition (logdate='2019-03-01') values(1,'zhangsan','shanghai'),(2,'lisi','beijin');
hive查询结果:
hive>select * from defaul.temp;
1 zhangsan NULL 2019-03-01
2 lisi NULL 2019-03-01
sparksql(presto同sparksql)查询结