--! qt:dataset:srcbucket
--! qt:dataset:src1
--! qt:dataset:lineitem
set hive.mapred.mode=nonstrict;
set hive.fetch.task.conversion=more;
set hive.optimize.constant.propagation=true;

set mapred.reduce.tasks=4;

EXPLAIN
SELECT src1.key, src1.key + 1, src2.value
       FROM srcbucket src1 join srcbucket src2 ON src1.key = src2.key AND src1.key = 100;

EXPLAIN
SELECT l_partkey, l_suppkey
FROM lineitem li
WHERE li.l_linenumber = 1 AND
 li.l_orderkey IN (SELECT l_orderkey FROM lineitem WHERE l_shipmode = 'AIR' AND l_linenumber = li.l_linenumber)
;