blob: eca49e2902a7fe172935ab8d4bcd4ab692fcae2b [file] [log] [blame]
--! 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;