ql/src/test/queries/clientpositive/join_cond_pushdown_unqual3.q

--! qt:dataset:part
set hive.mapred.mode=nonstrict;
create table part2_n5( 
    p2_partkey INT,
    p2_name STRING,
    p2_mfgr STRING,
    p2_brand STRING,
    p2_type STRING,
    p2_size INT,
    p2_container STRING,
    p2_retailprice DOUBLE,
    p2_comment STRING
);

create table part3_n2( 
    p3_partkey INT,
    p3_name STRING,
    p3_mfgr STRING,
    p3_brand STRING,
    p3_type STRING,
    p3_size INT,
    p3_container STRING,
    p3_retailprice DOUBLE,
    p3_comment STRING
);

explain select *
from part p1 join part2_n5 p2 join part3_n2 p3 
where p1.p_name = p2_name and p2_name = p3_name;

explain select *
from part p1 join part2_n5 p2 join part3_n2 p3 
where p2_name = p1.p_name and p3_name = p2_name;

explain select *
from part p1 join part2_n5 p2 join part3_n2 p3 
where p2_partkey + p1.p_partkey = p1.p_partkey and p3_name = p2_name;

explain select *
from part p1 join part2_n5 p2 join part3_n2 p3 
where p2_partkey = 1 and p3_name = p2_name;