--! qt:dataset:src
create table t1_n59 as select cast(key as int) key, value from src;

create table t2_n37 as select cast(key as int) key, value from src;

set hive.cbo.enable=false;

explain
select count(1)
from
  (select key
  from t1_n59
  where key = 0) t1_n59
left semi join
  (select key
  from t2_n37
  where key = 0) t2_n37
on 1 = 1;

select count(1)
from
  (select key
  from t1_n59
  where key = 0) t1_n59
left semi join
  (select key
  from t2_n37
  where key = 0) t2_n37
on 1 = 1;