ql/src/test/queries/clientpositive/query_properties.q

--! qt:dataset:src
set hive.cbo.enable=false;
set hive.exec.post.hooks = org.apache.hadoop.hive.ql.hooks.CheckQueryPropertiesHook;

select * from src a join src b on a.key = b.key limit 0;
select * from src group by src.key, src.value limit 0;
select * from src order by src.key limit 0;
select * from src sort by src.key limit 0;
select a.key, sum(b.value) from src a join src b on a.key = b.key group by a.key limit 0;
select transform(*) using 'cat' from src limit 0;
select * from src distribute by src.key limit 0;
select * from src cluster by src.key limit 0;

select key, sum(value) from (select a.key as key, b.value as value from src a join src b on a.key = b.key) c group by key limit 0;
select * from src a join src b on a.key = b.key order by a.key limit 0;
select * from src a join src b on a.key = b.key distribute by a.key sort by a.key, b.value limit 0;