set hive.explain.user=false;
SET hive.vectorized.execution.enabled=true;
SET hive.auto.convert.join=true;
SET hive.vectorized.execution.mapjoin.native.enabled=true;
set hive.fetch.task.conversion=none;

-- SORT_QUERY_RESULTS

create temporary table foo(x int) stored as orc;
insert into foo values(1),(2);
create temporary table bar(y int) stored as orc;

explain vectorization detail
select count(*) from bar right outer join foo; -- = 2

select count(*) from bar right outer join foo; -- = 2

explain vectorization detail
select count(*) from bar, foo; -- = 0 

select count(*) from bar, foo; -- = 0