Added: hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out?rev=1537500&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out (added) +++ hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out Thu Oct 31 14:10:54 2013 @@ -0,0 +1,683 @@ +PREHOOK: query: DROP TABLE part +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE part +POSTHOOK: type: DROPTABLE +PREHOOK: query: -- data setup +CREATE TABLE part( + p_partkey INT, + p_name STRING, + p_mfgr STRING, + p_brand STRING, + p_type STRING, + p_size INT, + p_container STRING, + p_retailprice DOUBLE, + p_comment STRING +) +PREHOOK: type: CREATETABLE +POSTHOOK: query: -- data setup +CREATE TABLE part( + p_partkey INT, + p_name STRING, + p_mfgr STRING, + p_brand STRING, + p_type STRING, + p_size INT, + p_container STRING, + p_retailprice DOUBLE, + p_comment STRING +) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@part +PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part +PREHOOK: type: LOAD +PREHOOK: Output: default@part +POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part +POSTHOOK: type: LOAD +POSTHOOK: Output: default@part +PREHOOK: query: explain select * +from part p1 join part p2 join part p3 on p1.p_name = p2.p_name join part p4 on p2.p_name = p3.p_name and p1.p_name = p4.p_name +PREHOOK: type: QUERY +POSTHOOK: query: explain select * +from part p1 join part p2 join part p3 on p1.p_name = p2.p_name join part p4 on p2.p_name = p3.p_name and p1.p_name = p4.p_name +POSTHOOK: type: QUERY +ABSTRACT SYNTAX TREE: + (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME part) p1) (TOK_TABREF (TOK_TABNAME part) p2)) (TOK_TABREF (TOK_TABNAME part) p3) (= (. (TOK_TABLE_OR_COL p1) p_name) (. (TOK_TABLE_OR_COL p2) p_name))) (TOK_TABREF (TOK_TABNAME part) p4) (and (= (. (TOK_TABLE_OR_COL p2) p_name) (. (TOK_TABLE_OR_COL p3) p_name)) (= (. (TOK_TABLE_OR_COL p1) p_name) (. (TOK_TABLE_OR_COL p4) p_name))))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)))) + +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 is a root stage + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Alias -> Map Operator Tree: + p1 + TableScan + alias: p1 + Reduce Output Operator + key expressions: + expr: p_name + type: string + sort order: + + Map-reduce partition columns: + expr: p_name + type: string + tag: 0 + value expressions: + expr: p_partkey + type: int + expr: p_name + type: string + expr: p_mfgr + type: string + expr: p_brand + type: string + expr: p_type + type: string + expr: p_size + type: int + expr: p_container + type: string + expr: p_retailprice + type: double + expr: p_comment + type: string + p2 + TableScan + alias: p2 + Reduce Output Operator + key expressions: + expr: p_name + type: string + sort order: + + Map-reduce partition columns: + expr: p_name + type: string + tag: 1 + value expressions: + expr: p_partkey + type: int + expr: p_name + type: string + expr: p_mfgr + type: string + expr: p_brand + type: string + expr: p_type + type: string + expr: p_size + type: int + expr: p_container + type: string + expr: p_retailprice + type: double + expr: p_comment + type: string + p3 + TableScan + alias: p3 + Reduce Output Operator + key expressions: + expr: p_name + type: string + sort order: + + Map-reduce partition columns: + expr: p_name + type: string + tag: 2 + value expressions: + expr: p_partkey + type: int + expr: p_name + type: string + expr: p_mfgr + type: string + expr: p_brand + type: string + expr: p_type + type: string + expr: p_size + type: int + expr: p_container + type: string + expr: p_retailprice + type: double + expr: p_comment + type: string + p4 + TableScan + alias: p4 + Reduce Output Operator + key expressions: + expr: p_name + type: string + sort order: + + Map-reduce partition columns: + expr: p_name + type: string + tag: 3 + value expressions: + expr: p_partkey + type: int + expr: p_name + type: string + expr: p_mfgr + type: string + expr: p_brand + type: string + expr: p_type + type: string + expr: p_size + type: int + expr: p_container + type: string + expr: p_retailprice + type: double + expr: p_comment + type: string + Reduce Operator Tree: + Join Operator + condition map: + Inner Join 0 to 1 + Inner Join 1 to 2 + Inner Join 0 to 3 + condition expressions: + 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} + 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} + 2 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} + 3 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} + handleSkewJoin: false + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30, _col33, _col34, _col35, _col36, _col37, _col38, _col39, _col40, _col41 + Select Operator + expressions: + expr: _col0 + type: int + expr: _col1 + type: string + expr: _col2 + type: string + expr: _col3 + type: string + expr: _col4 + type: string + expr: _col5 + type: int + expr: _col6 + type: string + expr: _col7 + type: double + expr: _col8 + type: string + expr: _col11 + type: int + expr: _col12 + type: string + expr: _col13 + type: string + expr: _col14 + type: string + expr: _col15 + type: string + expr: _col16 + type: int + expr: _col17 + type: string + expr: _col18 + type: double + expr: _col19 + type: string + expr: _col22 + type: int + expr: _col23 + type: string + expr: _col24 + type: string + expr: _col25 + type: string + expr: _col26 + type: string + expr: _col27 + type: int + expr: _col28 + type: string + expr: _col29 + type: double + expr: _col30 + type: string + expr: _col33 + type: int + expr: _col34 + type: string + expr: _col35 + type: string + expr: _col36 + type: string + expr: _col37 + type: string + expr: _col38 + type: int + expr: _col39 + type: string + expr: _col40 + type: double + expr: _col41 + type: string + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30, _col31, _col32, _col33, _col34, _col35 + File Output Operator + compressed: false + GlobalTableId: 0 + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + Stage: Stage-0 + Fetch Operator + limit: -1 + + +PREHOOK: query: explain select * +from part p1 join part p2 join part p3 on p2.p_name = p1.p_name join part p4 on p2.p_name = p3.p_name and p1.p_partkey = p4.p_partkey + and p1.p_partkey = p2.p_partkey +PREHOOK: type: QUERY +POSTHOOK: query: explain select * +from part p1 join part p2 join part p3 on p2.p_name = p1.p_name join part p4 on p2.p_name = p3.p_name and p1.p_partkey = p4.p_partkey + and p1.p_partkey = p2.p_partkey +POSTHOOK: type: QUERY +ABSTRACT SYNTAX TREE: + (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME part) p1) (TOK_TABREF (TOK_TABNAME part) p2)) (TOK_TABREF (TOK_TABNAME part) p3) (= (. (TOK_TABLE_OR_COL p2) p_name) (. (TOK_TABLE_OR_COL p1) p_name))) (TOK_TABREF (TOK_TABNAME part) p4) (and (and (= (. (TOK_TABLE_OR_COL p2) p_name) (. (TOK_TABLE_OR_COL p3) p_name)) (= (. (TOK_TABLE_OR_COL p1) p_partkey) (. (TOK_TABLE_OR_COL p4) p_partkey))) (= (. (TOK_TABLE_OR_COL p1) p_partkey) (. (TOK_TABLE_OR_COL p2) p_partkey))))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)))) + +STAGE DEPENDENCIES: + Stage-3 is a root stage + Stage-2 depends on stages: Stage-3 + Stage-1 depends on stages: Stage-2 + Stage-0 is a root stage + +STAGE PLANS: + Stage: Stage-3 + Map Reduce + Alias -> Map Operator Tree: + p1 + TableScan + alias: p1 + Reduce Output Operator + key expressions: + expr: p_name + type: string + expr: p_partkey + type: int + sort order: ++ + Map-reduce partition columns: + expr: p_name + type: string + expr: p_partkey + type: int + tag: 0 + value expressions: + expr: p_partkey + type: int + expr: p_name + type: string + expr: p_mfgr + type: string + expr: p_brand + type: string + expr: p_type + type: string + expr: p_size + type: int + expr: p_container + type: string + expr: p_retailprice + type: double + expr: p_comment + type: string + p2 + TableScan + alias: p2 + Reduce Output Operator + key expressions: + expr: p_name + type: string + expr: p_partkey + type: int + sort order: ++ + Map-reduce partition columns: + expr: p_name + type: string + expr: p_partkey + type: int + tag: 1 + value expressions: + expr: p_partkey + type: int + expr: p_name + type: string + expr: p_mfgr + type: string + expr: p_brand + type: string + expr: p_type + type: string + expr: p_size + type: int + expr: p_container + type: string + expr: p_retailprice + type: double + expr: p_comment + type: string + Reduce Operator Tree: + Join Operator + condition map: + Inner Join 0 to 1 + condition expressions: + 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} + 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} + handleSkewJoin: false + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19 + File Output Operator + compressed: false + GlobalTableId: 0 + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + + Stage: Stage-2 + Map Reduce + Alias -> Map Operator Tree: + $INTNAME + TableScan + Reduce Output Operator + key expressions: + expr: _col12 + type: string + sort order: + + Map-reduce partition columns: + expr: _col12 + type: string + tag: 0 + value expressions: + expr: _col11 + type: int + expr: _col12 + type: string + expr: _col13 + type: string + expr: _col14 + type: string + expr: _col15 + type: string + expr: _col16 + type: int + expr: _col17 + type: string + expr: _col18 + type: double + expr: _col19 + type: string + expr: _col0 + type: int + expr: _col1 + type: string + expr: _col2 + type: string + expr: _col3 + type: string + expr: _col4 + type: string + expr: _col5 + type: int + expr: _col6 + type: string + expr: _col7 + type: double + expr: _col8 + type: string + p3 + TableScan + alias: p3 + Reduce Output Operator + key expressions: + expr: p_name + type: string + sort order: + + Map-reduce partition columns: + expr: p_name + type: string + tag: 1 + value expressions: + expr: p_partkey + type: int + expr: p_name + type: string + expr: p_mfgr + type: string + expr: p_brand + type: string + expr: p_type + type: string + expr: p_size + type: int + expr: p_container + type: string + expr: p_retailprice + type: double + expr: p_comment + type: string + Reduce Operator Tree: + Join Operator + condition map: + Inner Join 0 to 1 + condition expressions: + 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18} {VALUE._col19} + 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} + handleSkewJoin: false + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30 + File Output Operator + compressed: false + GlobalTableId: 0 + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + + Stage: Stage-1 + Map Reduce + Alias -> Map Operator Tree: + $INTNAME + TableScan + Reduce Output Operator + key expressions: + expr: _col11 + type: int + sort order: + + Map-reduce partition columns: + expr: _col11 + type: int + tag: 0 + value expressions: + expr: _col22 + type: int + expr: _col23 + type: string + expr: _col24 + type: string + expr: _col25 + type: string + expr: _col26 + type: string + expr: _col27 + type: int + expr: _col28 + type: string + expr: _col29 + type: double + expr: _col30 + type: string + expr: _col0 + type: int + expr: _col1 + type: string + expr: _col2 + type: string + expr: _col3 + type: string + expr: _col4 + type: string + expr: _col5 + type: int + expr: _col6 + type: string + expr: _col7 + type: double + expr: _col8 + type: string + expr: _col11 + type: int + expr: _col12 + type: string + expr: _col13 + type: string + expr: _col14 + type: string + expr: _col15 + type: string + expr: _col16 + type: int + expr: _col17 + type: string + expr: _col18 + type: double + expr: _col19 + type: string + p4 + TableScan + alias: p4 + Reduce Output Operator + key expressions: + expr: p_partkey + type: int + sort order: + + Map-reduce partition columns: + expr: p_partkey + type: int + tag: 1 + value expressions: + expr: p_partkey + type: int + expr: p_name + type: string + expr: p_mfgr + type: string + expr: p_brand + type: string + expr: p_type + type: string + expr: p_size + type: int + expr: p_container + type: string + expr: p_retailprice + type: double + expr: p_comment + type: string + Reduce Operator Tree: + Join Operator + condition map: + Inner Join 0 to 1 + condition expressions: + 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18} {VALUE._col19} {VALUE._col22} {VALUE._col23} {VALUE._col24} {VALUE._col25} {VALUE._col26} {VALUE._col27} {VALUE._col28} {VALUE._col29} {VALUE._col30} + 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} + handleSkewJoin: false + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30, _col33, _col34, _col35, _col36, _col37, _col38, _col39, _col40, _col41 + Select Operator + expressions: + expr: _col22 + type: int + expr: _col23 + type: string + expr: _col24 + type: string + expr: _col25 + type: string + expr: _col26 + type: string + expr: _col27 + type: int + expr: _col28 + type: string + expr: _col29 + type: double + expr: _col30 + type: string + expr: _col11 + type: int + expr: _col12 + type: string + expr: _col13 + type: string + expr: _col14 + type: string + expr: _col15 + type: string + expr: _col16 + type: int + expr: _col17 + type: string + expr: _col18 + type: double + expr: _col19 + type: string + expr: _col0 + type: int + expr: _col1 + type: string + expr: _col2 + type: string + expr: _col3 + type: string + expr: _col4 + type: string + expr: _col5 + type: int + expr: _col6 + type: string + expr: _col7 + type: double + expr: _col8 + type: string + expr: _col33 + type: int + expr: _col34 + type: string + expr: _col35 + type: string + expr: _col36 + type: string + expr: _col37 + type: string + expr: _col38 + type: int + expr: _col39 + type: string + expr: _col40 + type: double + expr: _col41 + type: string + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30, _col31, _col32, _col33, _col34, _col35 + File Output Operator + compressed: false + GlobalTableId: 0 + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + Stage: Stage-0 + Fetch Operator + limit: -1 + +