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

--! qt:dataset:src
From (select * from src) a
insert overwrite directory 'target/warehouse/destemp.out/dir1/'
select key
where key=200 limit 1
insert overwrite directory 'target/warehouse/destemp.out/dir2/'
select 'header'
limit 0
insert overwrite directory 'target/warehouse/destemp.out/dir3/'
select key
where key = 100 limit 1;

dfs -cat ${system:test.warehouse.dir}/destemp.out/dir1/000000_0;
dfs -cat ${system:test.warehouse.dir}/destemp.out/dir2/000000_0;
dfs -cat ${system:test.warehouse.dir}/destemp.out/dir3/000000_0;
dfs -rmr ${system:test.warehouse.dir}/destemp.out;

From (select * from src) a
insert overwrite directory 'target/warehouse/destemp.out/dir1/'
select key
where key=200 limit 1
insert overwrite directory 'target/warehouse/destemp.out/dir2/'
select 'header'
where 1=2
insert overwrite directory 'target/warehouse/destemp.out/dir3/'
select key
where key = 100 limit 1;

dfs -cat ${system:test.warehouse.dir}/destemp.out/dir1/000000_0;
dfs -cat ${system:test.warehouse.dir}/destemp.out/dir2/000000_0;
dfs -cat ${system:test.warehouse.dir}/destemp.out/dir3/000000_0;
dfs -rmr ${system:test.warehouse.dir}/destemp.out;

explain select a.value from src a join src b on a.key = b.key where a.key=100 limit 0;
select a.value from src a join src b on a.key = b.key where a.key=100 limit 0;