blob: 75a85c7e748bca66f55d5e8913ec14f432c6fffb [file] [log] [blame]
--! qt:dataset:src1
--! qt:dataset:src
set hive.auto.convert.join=true;
set hive.auto.convert.join.noconditionaltask.size=3000;
set hive.strict.checks.cartesian.product=false;
set hive.merge.nway.joins=false;
set hive.vectorized.execution.enabled=true;
explain
select * from (
select count(*) as h8_30_to_9
from src
join src1 on src.key = src1.key
where src1.value = "val_278") s1
join (
select count(*) as h9_to_9_30
from src
join src1 on src.key = src1.key
where src1.value = "val_255") s2;
select * from (
select count(*) as h8_30_to_9
from src
join src1 on src.key = src1.key
where src1.value = "val_278") s1
join (
select count(*) as h9_to_9_30
from src
join src1 on src.key = src1.key
where src1.value = "val_255") s2;