--! qt:dataset:src

set hive.vectorized.execution.enabled=false;

create database if not exists test;
drop table if exists test.test_orc_src;
drop table if exists test.test_orc_src2;
create table test.test_orc_src (a int, b int, c int) stored as orc;
create table test.test_orc_src2 (a int, b int, d int) stored as orc;
insert overwrite table test.test_orc_src select 1,2,3 from src limit 1;
insert overwrite table test.test_orc_src2 select 1,2,4 from src limit 1;

set hive.auto.convert.join = false;

select
    tb.c
from test.test_orc_src tb
join (
    select * from test.test_orc_src2
) tm
on tb.a = tm.a
where tb.b = 2;