--! qt:dataset:srcpart
set hive.mapred.mode=nonstrict;
explain
select key,value,'hello' as ds, 'world' as hr from srcpart where hr=11 order by 1 limit 1;
select key,value,'hello' as ds, 'world' as hr from srcpart where hr=11 order by 1 limit 1;
create table testpartbucket (key string, value string) partitioned by (ds string, hr string) clustered by(key) sorted by(key) into 2 buckets;
explain
insert overwrite table testpartbucket partition(ds,hr) select key,value,'hello' as ds, 'world' as hr from srcpart where hr=11;
insert overwrite table testpartbucket partition(ds,hr) select key,value,'hello' as ds, 'world' as hr from srcpart where hr=11;
select * from testpartbucket limit 3;
drop table testpartbucket;
reset hive.exec.dynamic.partition.mode;