--! qt:dataset:src
set hive.mapred.mode=nonstrict;
set hive.explain.user=false;
set hive.tez.cartesian-product.enabled=true;
set hive.auto.convert.join=true;
set hive.convert.join.bucket.mapjoin.tez=true;

create table X_n2 (key string, value string) clustered by (key) into 2 buckets;
insert overwrite table X_n2 select distinct * from src order by key limit 10;

create table Y_n0 as
select * from src order by key limit 1;

explain select * from Y_n0, (select * from X_n2 as A join X_n2 as B on A.key=B.key) as C where Y_n0.key=C.key;