hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jcama...@apache.org
Subject [4/9] hive git commit: HIVE-13982: Extensions to RS dedup: execute with different column order and sorting direction if possible (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
Date Sun, 26 Jun 2016 02:16:45 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/a70c82fd/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainuser_1.q.out b/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
index 1871c7e..d4b29c6 100644
--- a/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
@@ -478,75 +478,73 @@ Stage-0
           Output:["_col0","_col1","_col2"]
         <-Reducer 6 [SIMPLE_EDGE]
           SHUFFLE [RS_37]
-            Select Operator [SEL_35] (rows=1 width=20)
-              Output:["_col0","_col1","_col2"]
-              Group By Operator [GBY_34] (rows=1 width=20)
-                Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0,
KEY._col1
-              <-Reducer 5 [SIMPLE_EDGE]
-                SHUFFLE [RS_33]
-                  PartitionCols:_col0, _col1
-                  Group By Operator [GBY_32] (rows=1 width=20)
-                    Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col2,
_col6
-                    Select Operator [SEL_31] (rows=1 width=16)
-                      Output:["_col2","_col6"]
-                      Filter Operator [FIL_30] (rows=1 width=16)
-                        predicate:(((_col1 > 0) or (_col6 >= 0)) and ((_col6 >=
1) or (_col2 >= 1)) and ((UDFToLong(_col6) + _col2) >= 0))
-                        Merge Join Operator [MERGEJOIN_48] (rows=3 width=16)
-                          Conds:RS_27._col0=RS_28._col0(Inner),Output:["_col1","_col2","_col6"]
-                        <-Map 10 [SIMPLE_EDGE]
-                          SHUFFLE [RS_28]
-                            PartitionCols:_col0
-                            Select Operator [SEL_26] (rows=18 width=79)
-                              Output:["_col0","_col1"]
-                              Filter Operator [FIL_46] (rows=18 width=79)
-                                predicate:((c_int > 0) and key is not null)
-                                TableScan [TS_24] (rows=20 width=80)
-                                  default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
-                        <-Reducer 4 [SIMPLE_EDGE]
-                          SHUFFLE [RS_27]
-                            PartitionCols:_col0
-                            Select Operator [SEL_23] (rows=1 width=101)
-                              Output:["_col0","_col1","_col2"]
-                              Filter Operator [FIL_22] (rows=1 width=101)
-                                predicate:((_col1 + _col4) >= 0)
-                                Merge Join Operator [MERGEJOIN_47] (rows=1 width=101)
-                                  Conds:RS_19._col0=RS_20._col0(Left Outer),Output:["_col0","_col1","_col2","_col4"]
-                                <-Reducer 3 [SIMPLE_EDGE]
-                                  SHUFFLE [RS_19]
-                                    PartitionCols:_col0
-                                    Select Operator [SEL_9] (rows=1 width=97)
-                                      Output:["_col0","_col1","_col2"]
-                                    <-Reducer 2 [SIMPLE_EDGE]
-                                      SHUFFLE [RS_8]
-                                        Select Operator [SEL_6] (rows=1 width=105)
-                                          Output:["_col0","_col1","_col2","_col3"]
-                                          Group By Operator [GBY_5] (rows=1 width=101)
-                                            Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0,
KEY._col1, KEY._col2
-                                          <-Map 1 [SIMPLE_EDGE]
-                                            SHUFFLE [RS_4]
-                                              PartitionCols:_col0, _col1, _col2
-                                              Group By Operator [GBY_3] (rows=1 width=101)
-                                                Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key,
c_int, c_float
-                                                Filter Operator [FIL_44] (rows=1 width=93)
-                                                  predicate:(((c_int + 1) >= 0) and ((c_int
> 0) or (c_float >= 0.0)) and (c_float > 0.0) and ((c_int >= 1) or (c_float >=
1.0)) and ((UDFToFloat(c_int) + c_float) >= 0.0) and key is not null)
-                                                  TableScan [TS_0] (rows=20 width=83)
-                                                    default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
-                                <-Reducer 9 [SIMPLE_EDGE]
-                                  SHUFFLE [RS_20]
-                                    PartitionCols:_col0
-                                    Select Operator [SEL_17] (rows=1 width=89)
-                                      Output:["_col0","_col1"]
-                                      Group By Operator [GBY_16] (rows=1 width=93)
-                                        Output:["_col0","_col1","_col2"],keys:KEY._col0,
KEY._col1, KEY._col2
-                                      <-Map 8 [SIMPLE_EDGE]
-                                        SHUFFLE [RS_15]
-                                          PartitionCols:_col0, _col1, _col2
-                                          Group By Operator [GBY_14] (rows=1 width=93)
-                                            Output:["_col0","_col1","_col2"],keys:key, c_int,
c_float
-                                            Filter Operator [FIL_45] (rows=1 width=93)
-                                              predicate:(((c_int + 1) >= 0) and ((c_int
> 0) or (c_float >= 0.0)) and (c_float > 0.0) and ((c_int >= 1) or (c_float >=
1.0)) and ((UDFToFloat(c_int) + c_float) >= 0.0) and key is not null)
-                                              TableScan [TS_11] (rows=20 width=83)
-                                                default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+            Group By Operator [GBY_34] (rows=1 width=20)
+              Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0,
KEY._col1
+            <-Reducer 5 [SIMPLE_EDGE]
+              SHUFFLE [RS_33]
+                PartitionCols:_col0, _col1
+                Group By Operator [GBY_32] (rows=1 width=20)
+                  Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col6, _col2
+                  Select Operator [SEL_31] (rows=1 width=16)
+                    Output:["_col6","_col2"]
+                    Filter Operator [FIL_30] (rows=1 width=16)
+                      predicate:(((_col1 > 0) or (_col6 >= 0)) and ((_col6 >= 1)
or (_col2 >= 1)) and ((UDFToLong(_col6) + _col2) >= 0))
+                      Merge Join Operator [MERGEJOIN_48] (rows=3 width=16)
+                        Conds:RS_27._col0=RS_28._col0(Inner),Output:["_col1","_col2","_col6"]
+                      <-Map 10 [SIMPLE_EDGE]
+                        SHUFFLE [RS_28]
+                          PartitionCols:_col0
+                          Select Operator [SEL_26] (rows=18 width=79)
+                            Output:["_col0","_col1"]
+                            Filter Operator [FIL_46] (rows=18 width=79)
+                              predicate:((c_int > 0) and key is not null)
+                              TableScan [TS_24] (rows=20 width=80)
+                                default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
+                      <-Reducer 4 [SIMPLE_EDGE]
+                        SHUFFLE [RS_27]
+                          PartitionCols:_col0
+                          Select Operator [SEL_23] (rows=1 width=101)
+                            Output:["_col0","_col1","_col2"]
+                            Filter Operator [FIL_22] (rows=1 width=101)
+                              predicate:((_col1 + _col4) >= 0)
+                              Merge Join Operator [MERGEJOIN_47] (rows=1 width=101)
+                                Conds:RS_19._col0=RS_20._col0(Left Outer),Output:["_col0","_col1","_col2","_col4"]
+                              <-Reducer 3 [SIMPLE_EDGE]
+                                SHUFFLE [RS_19]
+                                  PartitionCols:_col0
+                                  Select Operator [SEL_9] (rows=1 width=97)
+                                    Output:["_col0","_col1","_col2"]
+                                  <-Reducer 2 [SIMPLE_EDGE]
+                                    SHUFFLE [RS_8]
+                                      Select Operator [SEL_6] (rows=1 width=105)
+                                        Output:["_col0","_col1","_col2","_col3"]
+                                        Group By Operator [GBY_5] (rows=1 width=101)
+                                          Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0,
KEY._col1, KEY._col2
+                                        <-Map 1 [SIMPLE_EDGE]
+                                          SHUFFLE [RS_4]
+                                            PartitionCols:_col0, _col1, _col2
+                                            Group By Operator [GBY_3] (rows=1 width=101)
+                                              Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key,
c_int, c_float
+                                              Filter Operator [FIL_44] (rows=1 width=93)
+                                                predicate:(((c_int + 1) >= 0) and ((c_int
> 0) or (c_float >= 0.0)) and (c_float > 0.0) and ((c_int >= 1) or (c_float >=
1.0)) and ((UDFToFloat(c_int) + c_float) >= 0.0) and key is not null)
+                                                TableScan [TS_0] (rows=20 width=83)
+                                                  default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                              <-Reducer 9 [SIMPLE_EDGE]
+                                SHUFFLE [RS_20]
+                                  PartitionCols:_col0
+                                  Select Operator [SEL_17] (rows=1 width=89)
+                                    Output:["_col0","_col1"]
+                                    Group By Operator [GBY_16] (rows=1 width=93)
+                                      Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1,
KEY._col2
+                                    <-Map 8 [SIMPLE_EDGE]
+                                      SHUFFLE [RS_15]
+                                        PartitionCols:_col0, _col1, _col2
+                                        Group By Operator [GBY_14] (rows=1 width=93)
+                                          Output:["_col0","_col1","_col2"],keys:key, c_int,
c_float
+                                          Filter Operator [FIL_45] (rows=1 width=93)
+                                            predicate:(((c_int + 1) >= 0) and ((c_int
> 0) or (c_float >= 0.0)) and (c_float > 0.0) and ((c_int >= 1) or (c_float >=
1.0)) and ((UDFToFloat(c_int) + c_float) >= 0.0) and key is not null)
+                                            TableScan [TS_11] (rows=20 width=83)
+                                              default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as
b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or
cbo_t1.c_float >= 0)  group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0
and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by b+c, a desc)
cbo_t1 right outer join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where
(cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)  group by c_float,
cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int
+ c_float) >= 0) cbo_t2 on cbo_t1.a=p right outer join cbo_t3 on cbo_t1.a=key where (b
+ cbo_t2.q >= 2) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c
 PREHOOK: type: QUERY
@@ -651,70 +649,68 @@ Stage-0
           Output:["_col0","_col1","_col2"]
         <-Reducer 5 [SIMPLE_EDGE]
           SHUFFLE [RS_35]
-            Select Operator [SEL_34] (rows=1 width=20)
-              Output:["_col0","_col1","_col2"]
-              Group By Operator [GBY_33] (rows=1 width=20)
-                Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0,
KEY._col1
-              <-Reducer 4 [SIMPLE_EDGE]
-                SHUFFLE [RS_32]
-                  PartitionCols:_col0, _col1
-                  Group By Operator [GBY_31] (rows=1 width=20)
-                    Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col2,
_col6
-                    Select Operator [SEL_30] (rows=1 width=20)
-                      Output:["_col2","_col6"]
-                      Filter Operator [FIL_29] (rows=1 width=20)
-                        predicate:(((_col1 + _col4) >= 0) and ((_col1 > 0) or (_col6
>= 0)) and ((_col6 >= 1) or (_col2 >= 1)) and ((UDFToLong(_col6) + _col2) >= 0))
-                        Merge Join Operator [MERGEJOIN_42] (rows=4 width=20)
-                          Conds:RS_25._col0=RS_26._col0(Outer),RS_25._col0=RS_27._col0(Right
Outer),Output:["_col1","_col2","_col4","_col6"]
-                        <-Map 10 [SIMPLE_EDGE]
-                          SHUFFLE [RS_27]
-                            PartitionCols:_col0
-                            Select Operator [SEL_24] (rows=20 width=80)
-                              Output:["_col0","_col1"]
-                              Filter Operator [FIL_41] (rows=20 width=80)
-                                predicate:(c_int > 0)
-                                TableScan [TS_22] (rows=20 width=80)
-                                  default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
-                        <-Reducer 3 [SIMPLE_EDGE]
-                          SHUFFLE [RS_25]
-                            PartitionCols:_col0
-                            Select Operator [SEL_9] (rows=1 width=97)
-                              Output:["_col0","_col1","_col2"]
-                            <-Reducer 2 [SIMPLE_EDGE]
-                              SHUFFLE [RS_8]
-                                Select Operator [SEL_6] (rows=1 width=105)
-                                  Output:["_col0","_col1","_col2","_col3"]
-                                  Group By Operator [GBY_5] (rows=1 width=101)
-                                    Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0,
KEY._col1, KEY._col2
-                                  <-Map 1 [SIMPLE_EDGE]
-                                    SHUFFLE [RS_4]
-                                      PartitionCols:_col0, _col1, _col2
-                                      Group By Operator [GBY_3] (rows=1 width=101)
-                                        Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key,
c_int, c_float
-                                        Filter Operator [FIL_39] (rows=1 width=93)
-                                          predicate:(((c_int + 1) >= 0) and ((c_int >
0) or (c_float >= 0.0)) and (c_float > 0.0) and ((c_int >= 1) or (c_float >= 1.0))
and ((UDFToFloat(c_int) + c_float) >= 0.0))
-                                          TableScan [TS_0] (rows=20 width=83)
-                                            default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
-                        <-Reducer 9 [SIMPLE_EDGE]
-                          SHUFFLE [RS_26]
-                            PartitionCols:_col0
-                            Select Operator [SEL_20] (rows=1 width=89)
-                              Output:["_col0","_col1"]
-                            <-Reducer 8 [SIMPLE_EDGE]
-                              SHUFFLE [RS_19]
-                                Select Operator [SEL_17] (rows=1 width=105)
-                                  Output:["_col0","_col1","_col2","_col3"]
-                                  Group By Operator [GBY_16] (rows=1 width=101)
-                                    Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0,
KEY._col1, KEY._col2
-                                  <-Map 7 [SIMPLE_EDGE]
-                                    SHUFFLE [RS_15]
-                                      PartitionCols:_col0, _col1, _col2
-                                      Group By Operator [GBY_14] (rows=1 width=101)
-                                        Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key,
c_int, c_float
-                                        Filter Operator [FIL_40] (rows=1 width=93)
-                                          predicate:(((c_int + 1) >= 0) and ((c_int >
0) or (c_float >= 0.0)) and (c_float > 0.0) and ((c_int >= 1) or (c_float >= 1.0))
and ((UDFToFloat(c_int) + c_float) >= 0.0))
-                                          TableScan [TS_11] (rows=20 width=83)
-                                            default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+            Group By Operator [GBY_33] (rows=1 width=20)
+              Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0,
KEY._col1
+            <-Reducer 4 [SIMPLE_EDGE]
+              SHUFFLE [RS_32]
+                PartitionCols:_col0, _col1
+                Group By Operator [GBY_31] (rows=1 width=20)
+                  Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col6, _col2
+                  Select Operator [SEL_30] (rows=1 width=20)
+                    Output:["_col6","_col2"]
+                    Filter Operator [FIL_29] (rows=1 width=20)
+                      predicate:(((_col1 + _col4) >= 0) and ((_col1 > 0) or (_col6
>= 0)) and ((_col6 >= 1) or (_col2 >= 1)) and ((UDFToLong(_col6) + _col2) >= 0))
+                      Merge Join Operator [MERGEJOIN_42] (rows=4 width=20)
+                        Conds:RS_25._col0=RS_26._col0(Outer),RS_25._col0=RS_27._col0(Right
Outer),Output:["_col1","_col2","_col4","_col6"]
+                      <-Map 10 [SIMPLE_EDGE]
+                        SHUFFLE [RS_27]
+                          PartitionCols:_col0
+                          Select Operator [SEL_24] (rows=20 width=80)
+                            Output:["_col0","_col1"]
+                            Filter Operator [FIL_41] (rows=20 width=80)
+                              predicate:(c_int > 0)
+                              TableScan [TS_22] (rows=20 width=80)
+                                default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
+                      <-Reducer 3 [SIMPLE_EDGE]
+                        SHUFFLE [RS_25]
+                          PartitionCols:_col0
+                          Select Operator [SEL_9] (rows=1 width=97)
+                            Output:["_col0","_col1","_col2"]
+                          <-Reducer 2 [SIMPLE_EDGE]
+                            SHUFFLE [RS_8]
+                              Select Operator [SEL_6] (rows=1 width=105)
+                                Output:["_col0","_col1","_col2","_col3"]
+                                Group By Operator [GBY_5] (rows=1 width=101)
+                                  Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0,
KEY._col1, KEY._col2
+                                <-Map 1 [SIMPLE_EDGE]
+                                  SHUFFLE [RS_4]
+                                    PartitionCols:_col0, _col1, _col2
+                                    Group By Operator [GBY_3] (rows=1 width=101)
+                                      Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key,
c_int, c_float
+                                      Filter Operator [FIL_39] (rows=1 width=93)
+                                        predicate:(((c_int + 1) >= 0) and ((c_int >
0) or (c_float >= 0.0)) and (c_float > 0.0) and ((c_int >= 1) or (c_float >= 1.0))
and ((UDFToFloat(c_int) + c_float) >= 0.0))
+                                        TableScan [TS_0] (rows=20 width=83)
+                                          default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                      <-Reducer 9 [SIMPLE_EDGE]
+                        SHUFFLE [RS_26]
+                          PartitionCols:_col0
+                          Select Operator [SEL_20] (rows=1 width=89)
+                            Output:["_col0","_col1"]
+                          <-Reducer 8 [SIMPLE_EDGE]
+                            SHUFFLE [RS_19]
+                              Select Operator [SEL_17] (rows=1 width=105)
+                                Output:["_col0","_col1","_col2","_col3"]
+                                Group By Operator [GBY_16] (rows=1 width=101)
+                                  Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0,
KEY._col1, KEY._col2
+                                <-Map 7 [SIMPLE_EDGE]
+                                  SHUFFLE [RS_15]
+                                    PartitionCols:_col0, _col1, _col2
+                                    Group By Operator [GBY_14] (rows=1 width=101)
+                                      Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key,
c_int, c_float
+                                      Filter Operator [FIL_40] (rows=1 width=93)
+                                        predicate:(((c_int + 1) >= 0) and ((c_int >
0) or (c_float >= 0.0)) and (c_float > 0.0) and ((c_int >= 1) or (c_float >= 1.0))
and ((UDFToFloat(c_int) + c_float) >= 0.0))
+                                        TableScan [TS_11] (rows=20 width=83)
+                                          default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as
b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or
cbo_t1.c_float >= 0)  group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0
and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t1 join (select key
as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int
> 0 or cbo_t2.c_float >= 0)  group by c_float, cbo_t2.c_int, key having cbo_t2.c_float
> 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t2 on cbo_t1.a=p
join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group
by cbo_t3.c_int, c
 PREHOOK: type: QUERY
@@ -1348,28 +1344,26 @@ Stage-0
             Output:["_col0","_col1","_col2"]
           <-Reducer 3 [SIMPLE_EDGE]
             SHUFFLE [RS_12]
-              Select Operator [SEL_11] (rows=5 width=20)
-                Output:["_col0","_col1","_col2"]
-                Group By Operator [GBY_10] (rows=5 width=20)
-                  Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0,
KEY._col1
-                <-Reducer 2 [SIMPLE_EDGE]
-                  SHUFFLE [RS_9]
-                    PartitionCols:_col0, _col1
-                    Group By Operator [GBY_8] (rows=5 width=20)
-                      Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col0,
_col1
-                      Select Operator [SEL_5] (rows=10 width=91)
-                        Output:["_col0","_col1"]
-                        Group By Operator [GBY_4] (rows=10 width=91)
-                          Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0,
KEY._col1, KEY._col2
-                        <-Map 1 [SIMPLE_EDGE]
-                          SHUFFLE [RS_3]
-                            PartitionCols:_col0, _col1, _col2
-                            Group By Operator [GBY_2] (rows=10 width=91)
-                              Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key,
c_int, c_float
-                              Select Operator [SEL_1] (rows=20 width=83)
-                                Output:["key","c_int","c_float"]
-                                TableScan [TS_0] (rows=20 width=83)
-                                  default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+              Group By Operator [GBY_10] (rows=5 width=20)
+                Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0,
KEY._col1
+              <-Reducer 2 [SIMPLE_EDGE]
+                SHUFFLE [RS_9]
+                  PartitionCols:_col0, _col1
+                  Group By Operator [GBY_8] (rows=5 width=20)
+                    Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col1,
_col0
+                    Select Operator [SEL_5] (rows=10 width=91)
+                      Output:["_col0","_col1"]
+                      Group By Operator [GBY_4] (rows=10 width=91)
+                        Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0,
KEY._col1, KEY._col2
+                      <-Map 1 [SIMPLE_EDGE]
+                        SHUFFLE [RS_3]
+                          PartitionCols:_col0, _col1, _col2
+                          Group By Operator [GBY_2] (rows=10 width=91)
+                            Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key,
c_int, c_float
+                            Select Operator [SEL_1] (rows=20 width=83)
+                              Output:["key","c_int","c_float"]
+                              TableScan [TS_0] (rows=20 width=83)
+                                default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select key from(select key from (select key from cbo_t1 limit 5)cbo_t2
 limit 5)cbo_t3  limit 5
 PREHOOK: type: QUERY
@@ -1676,72 +1670,74 @@ Stage-0
           Output:["_col0","_col1","_col2"]
         <-Reducer 5 [SIMPLE_EDGE]
           SHUFFLE [RS_39]
-            Group By Operator [GBY_37] (rows=1 width=101)
-              Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0,
KEY._col1
-            <-Reducer 4 [SIMPLE_EDGE]
-              SHUFFLE [RS_36]
-                PartitionCols:_col0, _col1
-                Group By Operator [GBY_35] (rows=1 width=101)
-                  Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col0, _col1
-                  Merge Join Operator [MERGEJOIN_51] (rows=1 width=93)
-                    Conds:RS_30._col0=RS_31._col0(Left Semi),RS_30._col0=RS_32._col0(Left
Semi),Output:["_col0","_col1"]
-                  <-Map 10 [SIMPLE_EDGE]
-                    SHUFFLE [RS_32]
-                      PartitionCols:_col0
-                      Group By Operator [GBY_29] (rows=3 width=56)
-                        Output:["_col0"],keys:_col0
-                        Select Operator [SEL_25] (rows=6 width=70)
-                          Output:["_col0"]
-                          Filter Operator [FIL_50] (rows=6 width=70)
-                            predicate:(UDFToDouble(key) > 0.0)
-                            TableScan [TS_23] (rows=20 width=76)
-                              default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
-                  <-Reducer 3 [SIMPLE_EDGE]
-                    SHUFFLE [RS_30]
-                      PartitionCols:_col0
-                      Select Operator [SEL_10] (rows=1 width=93)
-                        Output:["_col0","_col1"]
-                      <-Reducer 2 [SIMPLE_EDGE]
-                        SHUFFLE [RS_9]
-                          Select Operator [SEL_8] (rows=1 width=101)
-                            Output:["_col0","_col1","_col2"]
-                            Filter Operator [FIL_7] (rows=1 width=101)
-                              predicate:(((UDFToDouble(_col2) >= 1.0) or (_col3 >=
1)) and ((UDFToDouble(_col2) + UDFToDouble(_col3)) >= 0.0))
-                              Select Operator [SEL_6] (rows=1 width=101)
-                                Output:["_col1","_col2","_col3"]
-                                Group By Operator [GBY_5] (rows=1 width=101)
+            Select Operator [SEL_38] (rows=1 width=101)
+              Output:["_col0","_col1","_col2"]
+              Group By Operator [GBY_37] (rows=1 width=101)
+                Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0,
KEY._col1
+              <-Reducer 4 [SIMPLE_EDGE]
+                SHUFFLE [RS_36]
+                  PartitionCols:_col0, _col1
+                  Group By Operator [GBY_35] (rows=1 width=101)
+                    Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col1,
_col0
+                    Merge Join Operator [MERGEJOIN_51] (rows=1 width=93)
+                      Conds:RS_30._col0=RS_31._col0(Left Semi),RS_30._col0=RS_32._col0(Left
Semi),Output:["_col0","_col1"]
+                    <-Map 10 [SIMPLE_EDGE]
+                      SHUFFLE [RS_32]
+                        PartitionCols:_col0
+                        Group By Operator [GBY_29] (rows=3 width=56)
+                          Output:["_col0"],keys:_col0
+                          Select Operator [SEL_25] (rows=6 width=70)
+                            Output:["_col0"]
+                            Filter Operator [FIL_50] (rows=6 width=70)
+                              predicate:(UDFToDouble(key) > 0.0)
+                              TableScan [TS_23] (rows=20 width=76)
+                                default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
+                    <-Reducer 3 [SIMPLE_EDGE]
+                      SHUFFLE [RS_30]
+                        PartitionCols:_col0
+                        Select Operator [SEL_10] (rows=1 width=93)
+                          Output:["_col0","_col1"]
+                        <-Reducer 2 [SIMPLE_EDGE]
+                          SHUFFLE [RS_9]
+                            Select Operator [SEL_8] (rows=1 width=101)
+                              Output:["_col0","_col1","_col2"]
+                              Filter Operator [FIL_7] (rows=1 width=101)
+                                predicate:(((UDFToDouble(_col2) >= 1.0) or (_col3 >=
1)) and ((UDFToDouble(_col2) + UDFToDouble(_col3)) >= 0.0))
+                                Select Operator [SEL_6] (rows=1 width=101)
+                                  Output:["_col1","_col2","_col3"]
+                                  Group By Operator [GBY_5] (rows=1 width=101)
+                                    Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0,
KEY._col1, KEY._col2
+                                  <-Map 1 [SIMPLE_EDGE]
+                                    SHUFFLE [RS_4]
+                                      PartitionCols:_col0, _col1, _col2
+                                      Group By Operator [GBY_3] (rows=1 width=101)
+                                        Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key,
c_int, c_float
+                                        Filter Operator [FIL_48] (rows=1 width=93)
+                                          predicate:(((c_int + 1) >= 0) and ((c_int >
0) or (c_float >= 0.0)) and (c_float > 0.0) and ((c_int >= 1) or (c_float >= 1.0))
and ((UDFToFloat(c_int) + c_float) >= 0.0) and (((c_int + 1) + 1) >= 0) and (((c_int
+ 1) > 0) or (UDFToDouble(key) >= 0.0)) and (UDFToDouble(key) > 0.0))
+                                          TableScan [TS_0] (rows=20 width=83)
+                                            default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                    <-Reducer 9 [SIMPLE_EDGE]
+                      SHUFFLE [RS_31]
+                        PartitionCols:_col0
+                        Group By Operator [GBY_27] (rows=1 width=85)
+                          Output:["_col0"],keys:_col0
+                          Select Operator [SEL_21] (rows=1 width=85)
+                            Output:["_col0"]
+                          <-Reducer 8 [SIMPLE_EDGE]
+                            SHUFFLE [RS_20]
+                              Select Operator [SEL_18] (rows=1 width=93)
+                                Output:["_col0","_col1"]
+                                Group By Operator [GBY_17] (rows=1 width=101)
                                   Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0,
KEY._col1, KEY._col2
-                                <-Map 1 [SIMPLE_EDGE]
-                                  SHUFFLE [RS_4]
+                                <-Map 7 [SIMPLE_EDGE]
+                                  SHUFFLE [RS_16]
                                     PartitionCols:_col0, _col1, _col2
-                                    Group By Operator [GBY_3] (rows=1 width=101)
+                                    Group By Operator [GBY_15] (rows=1 width=101)
                                       Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key,
c_int, c_float
-                                      Filter Operator [FIL_48] (rows=1 width=93)
-                                        predicate:(((c_int + 1) >= 0) and ((c_int >
0) or (c_float >= 0.0)) and (c_float > 0.0) and ((c_int >= 1) or (c_float >= 1.0))
and ((UDFToFloat(c_int) + c_float) >= 0.0) and (((c_int + 1) + 1) >= 0) and (((c_int
+ 1) > 0) or (UDFToDouble(key) >= 0.0)) and (UDFToDouble(key) > 0.0))
-                                        TableScan [TS_0] (rows=20 width=83)
-                                          default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
-                  <-Reducer 9 [SIMPLE_EDGE]
-                    SHUFFLE [RS_31]
-                      PartitionCols:_col0
-                      Group By Operator [GBY_27] (rows=1 width=85)
-                        Output:["_col0"],keys:_col0
-                        Select Operator [SEL_21] (rows=1 width=85)
-                          Output:["_col0"]
-                        <-Reducer 8 [SIMPLE_EDGE]
-                          SHUFFLE [RS_20]
-                            Select Operator [SEL_18] (rows=1 width=93)
-                              Output:["_col0","_col1"]
-                              Group By Operator [GBY_17] (rows=1 width=101)
-                                Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0,
KEY._col1, KEY._col2
-                              <-Map 7 [SIMPLE_EDGE]
-                                SHUFFLE [RS_16]
-                                  PartitionCols:_col0, _col1, _col2
-                                  Group By Operator [GBY_15] (rows=1 width=101)
-                                    Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key,
c_int, c_float
-                                    Filter Operator [FIL_49] (rows=1 width=93)
-                                      predicate:(((c_int + 1) >= 0) and ((c_int > 0)
or (c_float >= 0.0)) and (c_float > 0.0) and ((c_int >= 1) or (c_float >= 1.0))
and ((UDFToFloat(c_int) + c_float) >= 0.0) and (UDFToDouble(key) > 0.0))
-                                      TableScan [TS_12] (rows=20 width=83)
-                                        default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                                      Filter Operator [FIL_49] (rows=1 width=93)
+                                        predicate:(((c_int + 1) >= 0) and ((c_int >
0) or (c_float >= 0.0)) and (c_float > 0.0) and ((c_int >= 1) or (c_float >= 1.0))
and ((UDFToFloat(c_int) + c_float) >= 0.0) and (UDFToDouble(key) > 0.0))
+                                        TableScan [TS_12] (rows=20 width=83)
+                                          default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select cbo_t1.key as x, c_int as c_int, (((c_int+c_float)*10)+5)
as y from cbo_t1
 PREHOOK: type: QUERY
@@ -1873,11 +1869,13 @@ Stage-0
                     SHUFFLE [RS_6]
                       PartitionCols:_col0, _col1
                       Group By Operator [GBY_5] (rows=83 width=178)
-                        Output:["_col0","_col1"],keys:key, value
-                        Filter Operator [FIL_16] (rows=166 width=178)
-                          predicate:(value > 'val_2')
-                          TableScan [TS_2] (rows=500 width=178)
-                            default@src_cbo,b,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
+                        Output:["_col0","_col1"],keys:value, key
+                        Select Operator [SEL_4] (rows=166 width=178)
+                          Output:["value","key"]
+                          Filter Operator [FIL_16] (rows=166 width=178)
+                            predicate:(value > 'val_2')
+                            TableScan [TS_2] (rows=500 width=178)
+                              default@src_cbo,b,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
 
 PREHOOK: query: explain select * 
 from src_cbo b 
@@ -1914,10 +1912,10 @@ Stage-0
           Filter Operator [FIL_12] (rows=1 width=265)
             predicate:_col3 is null
             Merge Join Operator [MERGEJOIN_17] (rows=1 width=265)
-              Conds:RS_9._col1, _col0=RS_10._col0, _col1(Left Outer),Output:["_col0","_col1","_col3"]
+              Conds:RS_9._col0, _col1=RS_10._col1, _col0(Left Outer),Output:["_col0","_col1","_col3"]
             <-Map 4 [SIMPLE_EDGE]
               SHUFFLE [RS_10]
-                PartitionCols:_col0, _col1
+                PartitionCols:_col1, _col0
                 Select Operator [SEL_8] (rows=166 width=178)
                   Output:["_col0","_col1"]
                   Filter Operator [FIL_16] (rows=166 width=178)
@@ -1926,7 +1924,7 @@ Stage-0
                       default@src_cbo,b,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
             <-Reducer 2 [SIMPLE_EDGE]
               SHUFFLE [RS_9]
-                PartitionCols:_col1, _col0
+                PartitionCols:_col0, _col1
                 Group By Operator [GBY_4] (rows=250 width=178)
                   Output:["_col0","_col1"],keys:KEY._col0, KEY._col1
                 <-Map 1 [SIMPLE_EDGE]
@@ -1977,10 +1975,10 @@ Stage-0
       Reducer 2
       File Output Operator [FS_12]
         Merge Join Operator [MERGEJOIN_17] (rows=2 width=178)
-          Conds:RS_8._col1, _col0=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1"]
+          Conds:RS_8._col0, _col1=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1"]
         <-Map 1 [SIMPLE_EDGE]
           SHUFFLE [RS_8]
-            PartitionCols:_col1, _col0
+            PartitionCols:_col0, _col1
             Select Operator [SEL_2] (rows=166 width=178)
               Output:["_col0","_col1"]
               Filter Operator [FIL_15] (rows=166 width=178)
@@ -2029,10 +2027,10 @@ Stage-0
       Reducer 2
       File Output Operator [FS_12]
         Merge Join Operator [MERGEJOIN_17] (rows=2 width=178)
-          Conds:RS_8._col1, _col0=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1"]
+          Conds:RS_8._col0, _col1=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1"]
         <-Map 1 [SIMPLE_EDGE]
           SHUFFLE [RS_8]
-            PartitionCols:_col1, _col0
+            PartitionCols:_col0, _col1
             Select Operator [SEL_2] (rows=166 width=178)
               Output:["_col0","_col1"]
               Filter Operator [FIL_15] (rows=166 width=178)


Mime
View raw message