set hive.mapred.mode=nonstrict;
set hive.explain.user=false;
set hive.auto.convert.sortmerge.join = true;

create table t1_n42(
id string,
od string);

create table t2_n26(
id string,
od string);

explain
select vt1_n42.id from
(select rt1_n42.id from
(select t1_n42.id, t1_n42.od from t1_n42 order by t1_n42.id, t1_n42.od) rt1_n42) vt1_n42
join
(select rt2_n26.id from
(select t2_n26.id, t2_n26.od from t2_n26 order by t2_n26.id, t2_n26.od) rt2_n26) vt2_n26
where vt1_n42.id=vt2_n26.id;

select vt1_n42.id from
(select rt1_n42.id from
(select t1_n42.id, t1_n42.od from t1_n42 order by t1_n42.id, t1_n42.od) rt1_n42) vt1_n42
join
(select rt2_n26.id from
(select t2_n26.id, t2_n26.od from t2_n26 order by t2_n26.id, t2_n26.od) rt2_n26) vt2_n26
where vt1_n42.id=vt2_n26.id;