--! qt:dataset:src | |
set hive.mapred.mode=nonstrict; | |
create table partition_vs_table(key string, value string) partitioned by (ds string); | |
insert overwrite table partition_vs_table partition(ds='100') select key, value from src; | |
alter table partition_vs_table add columns (newcol string); | |
insert overwrite table partition_vs_table partition(ds='101') select key, value, key from src; | |
select key, value, newcol from partition_vs_table | |
order by key, value, newcol; | |