http://git-wip-us.apache.org/repos/asf/hive/blob/be9735e1/ql/src/test/results/clientpositive/tez/constprog_dpp.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/constprog_dpp.q.out b/ql/src/test/results/clientpositive/tez/constprog_dpp.q.out index acebd05..1614cb0 100644 --- a/ql/src/test/results/clientpositive/tez/constprog_dpp.q.out +++ b/ql/src/test/results/clientpositive/tez/constprog_dpp.q.out @@ -47,70 +47,41 @@ Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 5 (SIMPLE_EDGE) Reducer 5 <- Union 4 (SIMPLE_EDGE) Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Reducer 2 - File Output Operator [FS_17] - compressed:false - Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - 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"} - Merge Join Operator [MERGEJOIN_21] - | condition map:[{"":"Left Outer Join0 to 1"}] - | keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"} - | outputColumnNames:["_col0"] - | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - |<-Map 1 [SIMPLE_EDGE] - | Reduce Output Operator [RS_13] - | key expressions:_col0 (type: int) - | Map-reduce partition columns:_col0 (type: int) - | sort order:+ - | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - | Select Operator [SEL_1] - | outputColumnNames:["_col0"] - | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - | TableScan [TS_0] - | alias:a - | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - |<-Reducer 5 [SIMPLE_EDGE] - Reduce Output Operator [RS_14] - key expressions:_col0 (type: int) - Map-reduce partition columns:_col0 (type: int) - sort order:+ - Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE - Limit [LIM_11] - Number of rows:1 - Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE - Select Operator [SEL_10] - | outputColumnNames:["_col0"] - | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE - |<-Union 4 [SIMPLE_EDGE] - |<-Map 3 [CONTAINS] - | Reduce Output Operator [RS_9] - | sort order: - | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE - | value expressions:_col0 (type: int) - | Limit [LIM_8] - | Number of rows:1 - | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE - | Select Operator [SEL_3] - | outputColumnNames:["_col0"] - | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - | TableScan [TS_2] - | alias:tb2 - | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - |<-Map 6 [CONTAINS] - Reduce Output Operator [RS_9] - sort order: - Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE - value expressions:_col0 (type: int) - Limit [LIM_8] - Number of rows:1 - Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE - Select Operator [SEL_5] - outputColumnNames:["_col0"] - Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE - TableScan [TS_4] - alias:tb2 - Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE + Fetch Operator + limit:-1 + Stage-1 + Reducer 2 + File Output Operator [FS_17] + Merge Join Operator [MERGEJOIN_21] (rows=1 width=0) + Conds:RS_13._col0=RS_14._col0(Left Outer),Output:["_col0"] + <-Map 1 [SIMPLE_EDGE] + SHUFFLE [RS_13] + PartitionCols:_col0 + Select Operator [SEL_1] (rows=1 width=0) + Output:["_col0"] + TableScan [TS_0] (rows=1 width=0) + default@tb1,a,Tbl:PARTIAL,Col:NONE,Output:["id"] + <-Reducer 5 [SIMPLE_EDGE] + SHUFFLE [RS_14] + PartitionCols:_col0 + Limit [LIM_11] (rows=1 width=0) + Number of rows:1 + Select Operator [SEL_10] (rows=1 width=0) + Output:["_col0"] + <-Union 4 [SIMPLE_EDGE] + <-Map 3 [CONTAINS] + Reduce Output Operator [RS_9] + Limit [LIM_8] (rows=1 width=0) + Number of rows:1 + Select Operator [SEL_3] (rows=1 width=0) + Output:["_col0"] + TableScan [TS_2] (rows=1 width=0) + Output:["id"] + <-Map 6 [CONTAINS] + Reduce Output Operator [RS_9] + Limit [LIM_8] (rows=1 width=0) + Number of rows:1 + Select Operator [SEL_5] (rows=1 width=0) + Output:["_col0"] + TableScan [TS_4] (rows=1 width=0)
http://git-wip-us.apache.org/repos/asf/hive/blob/be9735e1/ql/src/test/results/clientpositive/tez/empty_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/empty_join.q.out b/ql/src/test/results/clientpositive/tez/empty_join.q.out index ca351ec..06eea6f 100644 --- a/ql/src/test/results/clientpositive/tez/empty_join.q.out +++ b/ql/src/test/results/clientpositive/tez/empty_join.q.out @@ -56,43 +56,27 @@ Vertex dependency in root stage Map 1 <- Map 2 (BROADCAST_EDGE), Map 3 (BROADCAST_EDGE) Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Map 1 - File Output Operator [FS_8] - compressed:false - Statistics:Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats: NONE - 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"} - Select Operator [SEL_7] - outputColumnNames:["_col0","_col1","_col2"] - Statistics:Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats: NONE - Map Join Operator [MAPJOIN_16] - | condition map:[{"":"Left Outer Join0 to 1"},{"":"Inner Join 0 to 2"}] - | keys:{"Map 1":"id (type: int)","Map 2":"id (type: int)","Map 3":"id (type: int)"} - | outputColumnNames:["_col0","_col4","_col8"] - | Statistics:Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats: NONE - |<-Map 2 [BROADCAST_EDGE] - | Reduce Output Operator [RS_4] - | key expressions:id (type: int) - | Map-reduce partition columns:id (type: int) - | sort order:+ - | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - | TableScan [TS_1] - | alias:t2 - | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - |<-Map 3 [BROADCAST_EDGE] - | Reduce Output Operator [RS_5] - | key expressions:id (type: int) - | Map-reduce partition columns:id (type: int) - | sort order:+ - | Statistics:Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: NONE - | TableScan [TS_2] - | alias:t3 - | Statistics:Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: NONE - |<-TableScan [TS_0] - alias:t1 - Statistics:Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: NONE + Fetch Operator + limit:-1 + Stage-1 + Map 1 + File Output Operator [FS_8] + Select Operator [SEL_7] (rows=2 width=1) + Output:["_col0","_col1","_col2"] + Map Join Operator [MAPJOIN_16] (rows=2 width=1) + Conds:TS_0.id=RS_4.id(Left Outer),TS_0.id=RS_5.id(Inner),Output:["_col0","_col4","_col8"] + <-Map 2 [BROADCAST_EDGE] + BROADCAST [RS_4] + PartitionCols:id + TableScan [TS_1] (rows=1 width=0) + default@test_2,t2,Tbl:PARTIAL,Col:NONE,Output:["id"] + <-Map 3 [BROADCAST_EDGE] + BROADCAST [RS_5] + PartitionCols:id + TableScan [TS_2] (rows=1 width=1) + default@test_3,t3,Tbl:COMPLETE,Col:NONE,Output:["id"] + <-TableScan [TS_0] (rows=1 width=1) + default@test_1,t1,Tbl:COMPLETE,Col:NONE,Output:["id"] PREHOOK: query: SELECT t1.id, t2.id, t3.id FROM test_1 t1
