hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject [23/26] hive git commit: HIVE-15708 : Upgrade calcite version to 1.12 (Remus Rusanu via Ashutosh Chauhan)
Date Thu, 13 Apr 2017 20:50:28 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/be59e024/ql/src/test/results/clientpositive/join_alt_syntax.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_alt_syntax.q.out b/ql/src/test/results/clientpositive/join_alt_syntax.q.out
index cef5272..1c08e6a 100644
--- a/ql/src/test/results/clientpositive/join_alt_syntax.q.out
+++ b/ql/src/test/results/clientpositive/join_alt_syntax.q.out
@@ -230,7 +230,7 @@ STAGE PLANS:
       Processor Tree:
         ListSink
 
-Warning: Shuffle Join JOIN[7][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a
cross product
+Warning: Shuffle Join JOIN[13][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Stage-2:MAPRED'
is a cross product
 PREHOOK: query: explain select p1.p_name, p2.p_name, p3.p_name
 from part p1 , part p2 , part p3 
 where p2.p_partkey + p1.p_partkey = p1.p_partkey and p3.p_name = p2.p_name
@@ -249,17 +249,6 @@ STAGE PLANS:
     Map Reduce
       Map Operator Tree:
           TableScan
-            alias: p1
-            Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-            Select Operator
-              expressions: p_partkey (type: int), p_name (type: string)
-              outputColumnNames: _col0, _col1
-              Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-              Reduce Output Operator
-                sort order: 
-                Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-                value expressions: _col0 (type: int), _col1 (type: string)
-          TableScan
             alias: p2
             Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
             Filter Operator
@@ -270,42 +259,11 @@ STAGE PLANS:
                 outputColumnNames: _col0, _col1
                 Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
                 Reduce Output Operator
-                  sort order: 
+                  key expressions: _col1 (type: string)
+                  sort order: +
+                  Map-reduce partition columns: _col1 (type: string)
                   Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-                  value expressions: _col0 (type: int), _col1 (type: string)
-      Reduce Operator Tree:
-        Join Operator
-          condition map:
-               Inner Join 0 to 1
-          keys:
-            0 
-            1 
-          outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 676 Data size: 164320 Basic stats: COMPLETE Column stats:
NONE
-          Filter Operator
-            predicate: ((_col2 + _col0) = _col0) (type: boolean)
-            Statistics: Num rows: 338 Data size: 82160 Basic stats: COMPLETE Column stats:
NONE
-            Select Operator
-              expressions: _col1 (type: string), _col3 (type: string)
-              outputColumnNames: _col1, _col3
-              Statistics: Num rows: 338 Data size: 82160 Basic stats: COMPLETE Column stats:
NONE
-              File Output Operator
-                compressed: false
-                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
-      Map Operator Tree:
-          TableScan
-            Reduce Output Operator
-              key expressions: _col3 (type: string)
-              sort order: +
-              Map-reduce partition columns: _col3 (type: string)
-              Statistics: Num rows: 338 Data size: 82160 Basic stats: COMPLETE Column stats:
NONE
-              value expressions: _col1 (type: string)
+                  value expressions: _col0 (type: int)
           TableScan
             alias: p3
             Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
@@ -326,21 +284,59 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           keys:
-            0 _col3 (type: string)
+            0 _col1 (type: string)
             1 _col0 (type: string)
-          outputColumnNames: _col1, _col3, _col4
-          Statistics: Num rows: 371 Data size: 90376 Basic stats: COMPLETE Column stats:
NONE
-          Select Operator
-            expressions: _col1 (type: string), _col3 (type: string), _col4 (type: string)
-            outputColumnNames: _col0, _col1, _col2
-            Statistics: Num rows: 371 Data size: 90376 Basic stats: COMPLETE Column stats:
NONE
-            File Output Operator
-              compressed: false
-              Statistics: Num rows: 371 Data size: 90376 Basic stats: COMPLETE Column stats:
NONE
-              table:
-                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+          outputColumnNames: _col0, _col1, _col2
+          Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats: NONE
+          File Output Operator
+            compressed: false
+            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
+      Map Operator Tree:
+          TableScan
+            Reduce Output Operator
+              sort order: 
+              Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats:
NONE
+              value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string)
+          TableScan
+            alias: p1
+            Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
+            Select Operator
+              expressions: p_partkey (type: int), p_name (type: string)
+              outputColumnNames: _col0, _col1
+              Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
+              Reduce Output Operator
+                sort order: 
+                Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
+                value expressions: _col0 (type: int), _col1 (type: string)
+      Reduce Operator Tree:
+        Join Operator
+          condition map:
+               Inner Join 0 to 1
+          keys:
+            0 
+            1 
+          outputColumnNames: _col0, _col1, _col2, _col3, _col4
+          Statistics: Num rows: 728 Data size: 178830 Basic stats: COMPLETE Column stats:
NONE
+          Filter Operator
+            predicate: ((_col0 + _col3) = _col3) (type: boolean)
+            Statistics: Num rows: 364 Data size: 89415 Basic stats: COMPLETE Column stats:
NONE
+            Select Operator
+              expressions: _col4 (type: string), _col1 (type: string), _col2 (type: string)
+              outputColumnNames: _col0, _col1, _col2
+              Statistics: Num rows: 364 Data size: 89415 Basic stats: COMPLETE Column stats:
NONE
+              File Output Operator
+                compressed: false
+                Statistics: Num rows: 364 Data size: 89415 Basic stats: COMPLETE Column stats:
NONE
+                table:
+                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/be59e024/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out
index 9461a1b..831d84f 100644
--- a/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out
+++ b/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out
@@ -172,7 +172,7 @@ STAGE PLANS:
       Processor Tree:
         ListSink
 
-Warning: Shuffle Join JOIN[7][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a
cross product
+Warning: Shuffle Join JOIN[13][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Stage-2:MAPRED'
is a cross product
 PREHOOK: query: explain select *
 from part p1 join part p2 join part p3 on p2.p_partkey + p1.p_partkey = p1.p_partkey and
p3.p_name = p2.p_name
 PREHOOK: type: QUERY
@@ -189,17 +189,6 @@ STAGE PLANS:
     Map Reduce
       Map Operator Tree:
           TableScan
-            alias: p1
-            Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-            Select Operator
-              expressions: p_partkey (type: int), p_name (type: string), p_mfgr (type: string),
p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string),
p_retailprice (type: double), p_comment (type: string)
-              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
-              Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-              Reduce Output Operator
-                sort order: 
-                Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-                value expressions: _col0 (type: int), _col1 (type: string), _col2 (type:
string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string),
_col7 (type: double), _col8 (type: string)
-          TableScan
             alias: p2
             Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
             Filter Operator
@@ -210,38 +199,11 @@ STAGE PLANS:
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
                 Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
                 Reduce Output Operator
-                  sort order: 
+                  key expressions: _col1 (type: string)
+                  sort order: +
+                  Map-reduce partition columns: _col1 (type: string)
                   Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-                  value expressions: _col0 (type: int), _col1 (type: string), _col2 (type:
string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string),
_col7 (type: double), _col8 (type: string)
-      Reduce Operator Tree:
-        Join Operator
-          condition map:
-               Inner Join 0 to 1
-          keys:
-            0 
-            1 
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8,
_col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17
-          Statistics: Num rows: 676 Data size: 164320 Basic stats: COMPLETE Column stats:
NONE
-          Filter Operator
-            predicate: ((_col9 + _col0) = _col0) (type: boolean)
-            Statistics: Num rows: 338 Data size: 82160 Basic stats: COMPLETE Column stats:
NONE
-            File Output Operator
-              compressed: false
-              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
-      Map Operator Tree:
-          TableScan
-            Reduce Output Operator
-              key expressions: _col10 (type: string)
-              sort order: +
-              Map-reduce partition columns: _col10 (type: string)
-              Statistics: Num rows: 338 Data size: 82160 Basic stats: COMPLETE Column stats:
NONE
-              value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string),
_col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7
(type: double), _col8 (type: string), _col9 (type: int), _col11 (type: string), _col12 (type:
string), _col13 (type: string), _col14 (type: int), _col15 (type: string), _col16 (type: double),
_col17 (type: string)
+                  value expressions: _col0 (type: int), _col2 (type: string), _col3 (type:
string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double),
_col8 (type: string)
           TableScan
             alias: p3
             Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
@@ -263,17 +225,59 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           keys:
-            0 _col10 (type: string)
+            0 _col1 (type: string)
             1 _col1 (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
-          Statistics: Num rows: 371 Data size: 90376 Basic stats: COMPLETE Column stats:
NONE
+          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8,
_col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17
+          Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 371 Data size: 90376 Basic stats: COMPLETE Column stats:
NONE
             table:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+
+  Stage: Stage-2
+    Map Reduce
+      Map Operator Tree:
+          TableScan
+            Reduce Output Operator
+              sort order: 
+              Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats:
NONE
+              value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string),
_col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7
(type: double), _col8 (type: string), _col9 (type: int), _col10 (type: string), _col11 (type:
string), _col12 (type: string), _col13 (type: string), _col14 (type: int), _col15 (type: string),
_col16 (type: double), _col17 (type: string)
+          TableScan
+            alias: p1
+            Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
+            Select Operator
+              expressions: p_partkey (type: int), p_name (type: string), p_mfgr (type: string),
p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string),
p_retailprice (type: double), p_comment (type: string)
+              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
+              Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
+              Reduce Output Operator
+                sort order: 
+                Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
+                value expressions: _col0 (type: int), _col1 (type: string), _col2 (type:
string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string),
_col7 (type: double), _col8 (type: string)
+      Reduce Operator Tree:
+        Join Operator
+          condition map:
+               Inner Join 0 to 1
+          keys:
+            0 
+            1 
+          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
+          Statistics: Num rows: 728 Data size: 178830 Basic stats: COMPLETE Column stats:
NONE
+          Filter Operator
+            predicate: ((_col0 + _col18) = _col18) (type: boolean)
+            Statistics: Num rows: 364 Data size: 89415 Basic stats: COMPLETE Column stats:
NONE
+            Select Operator
+              expressions: _col18 (type: int), _col19 (type: string), _col20 (type: string),
_col21 (type: string), _col22 (type: string), _col23 (type: int), _col24 (type: string), _col25
(type: double), _col26 (type: string), _col0 (type: int), _col1 (type: string), _col2 (type:
string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string),
_col7 (type: double), _col8 (type: string), _col9 (type: int), _col10 (type: string), _col11
(type: string), _col12 (type: string), _col13 (type: string), _col14 (type: int), _col15 (type:
string), _col16 (type: double), _col17 (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
+              Statistics: Num rows: 364 Data size: 89415 Basic stats: COMPLETE Column stats:
NONE
+              File Output Operator
+                compressed: false
+                Statistics: Num rows: 364 Data size: 89415 Basic stats: COMPLETE Column stats:
NONE
+                table:
+                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/be59e024/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out
index 2205c4e..560b8e0 100644
--- a/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out
+++ b/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out
@@ -176,7 +176,7 @@ STAGE PLANS:
       Processor Tree:
         ListSink
 
-Warning: Shuffle Join JOIN[7][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a
cross product
+Warning: Shuffle Join JOIN[13][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Stage-2:MAPRED'
is a cross product
 PREHOOK: query: explain select *
 from part p1 join part p2 join part p3 
 where p2.p_partkey + p1.p_partkey = p1.p_partkey and p3.p_name = p2.p_name
@@ -195,17 +195,6 @@ STAGE PLANS:
     Map Reduce
       Map Operator Tree:
           TableScan
-            alias: p1
-            Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-            Select Operator
-              expressions: p_partkey (type: int), p_name (type: string), p_mfgr (type: string),
p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string),
p_retailprice (type: double), p_comment (type: string)
-              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
-              Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-              Reduce Output Operator
-                sort order: 
-                Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-                value expressions: _col0 (type: int), _col1 (type: string), _col2 (type:
string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string),
_col7 (type: double), _col8 (type: string)
-          TableScan
             alias: p2
             Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
             Filter Operator
@@ -216,38 +205,11 @@ STAGE PLANS:
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
                 Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
                 Reduce Output Operator
-                  sort order: 
+                  key expressions: _col1 (type: string)
+                  sort order: +
+                  Map-reduce partition columns: _col1 (type: string)
                   Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-                  value expressions: _col0 (type: int), _col1 (type: string), _col2 (type:
string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string),
_col7 (type: double), _col8 (type: string)
-      Reduce Operator Tree:
-        Join Operator
-          condition map:
-               Inner Join 0 to 1
-          keys:
-            0 
-            1 
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8,
_col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17
-          Statistics: Num rows: 676 Data size: 164320 Basic stats: COMPLETE Column stats:
NONE
-          Filter Operator
-            predicate: ((_col9 + _col0) = _col0) (type: boolean)
-            Statistics: Num rows: 338 Data size: 82160 Basic stats: COMPLETE Column stats:
NONE
-            File Output Operator
-              compressed: false
-              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
-      Map Operator Tree:
-          TableScan
-            Reduce Output Operator
-              key expressions: _col10 (type: string)
-              sort order: +
-              Map-reduce partition columns: _col10 (type: string)
-              Statistics: Num rows: 338 Data size: 82160 Basic stats: COMPLETE Column stats:
NONE
-              value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string),
_col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7
(type: double), _col8 (type: string), _col9 (type: int), _col11 (type: string), _col12 (type:
string), _col13 (type: string), _col14 (type: int), _col15 (type: string), _col16 (type: double),
_col17 (type: string)
+                  value expressions: _col0 (type: int), _col2 (type: string), _col3 (type:
string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double),
_col8 (type: string)
           TableScan
             alias: p3
             Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
@@ -269,17 +231,59 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           keys:
-            0 _col10 (type: string)
+            0 _col1 (type: string)
             1 _col1 (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
-          Statistics: Num rows: 371 Data size: 90376 Basic stats: COMPLETE Column stats:
NONE
+          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8,
_col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17
+          Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 371 Data size: 90376 Basic stats: COMPLETE Column stats:
NONE
             table:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+
+  Stage: Stage-2
+    Map Reduce
+      Map Operator Tree:
+          TableScan
+            Reduce Output Operator
+              sort order: 
+              Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats:
NONE
+              value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string),
_col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7
(type: double), _col8 (type: string), _col9 (type: int), _col10 (type: string), _col11 (type:
string), _col12 (type: string), _col13 (type: string), _col14 (type: int), _col15 (type: string),
_col16 (type: double), _col17 (type: string)
+          TableScan
+            alias: p1
+            Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
+            Select Operator
+              expressions: p_partkey (type: int), p_name (type: string), p_mfgr (type: string),
p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string),
p_retailprice (type: double), p_comment (type: string)
+              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
+              Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
+              Reduce Output Operator
+                sort order: 
+                Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
+                value expressions: _col0 (type: int), _col1 (type: string), _col2 (type:
string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string),
_col7 (type: double), _col8 (type: string)
+      Reduce Operator Tree:
+        Join Operator
+          condition map:
+               Inner Join 0 to 1
+          keys:
+            0 
+            1 
+          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
+          Statistics: Num rows: 728 Data size: 178830 Basic stats: COMPLETE Column stats:
NONE
+          Filter Operator
+            predicate: ((_col0 + _col18) = _col18) (type: boolean)
+            Statistics: Num rows: 364 Data size: 89415 Basic stats: COMPLETE Column stats:
NONE
+            Select Operator
+              expressions: _col18 (type: int), _col19 (type: string), _col20 (type: string),
_col21 (type: string), _col22 (type: string), _col23 (type: int), _col24 (type: string), _col25
(type: double), _col26 (type: string), _col0 (type: int), _col1 (type: string), _col2 (type:
string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string),
_col7 (type: double), _col8 (type: string), _col9 (type: int), _col10 (type: string), _col11
(type: string), _col12 (type: string), _col13 (type: string), _col14 (type: int), _col15 (type:
string), _col16 (type: double), _col17 (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
+              Statistics: Num rows: 364 Data size: 89415 Basic stats: COMPLETE Column stats:
NONE
+              File Output Operator
+                compressed: false
+                Statistics: Num rows: 364 Data size: 89415 Basic stats: COMPLETE Column stats:
NONE
+                table:
+                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/be59e024/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out
index 966330d..f77c75c 100644
--- a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out
+++ b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out
@@ -228,7 +228,7 @@ STAGE PLANS:
       Processor Tree:
         ListSink
 
-Warning: Shuffle Join JOIN[7][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a
cross product
+Warning: Shuffle Join JOIN[10][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is
a cross product
 PREHOOK: query: explain select *
 from part p1 join part2 p2 join part3 p3 on p2_partkey + p_partkey = p1.p_partkey and p3_name
= p2_name
 PREHOOK: type: QUERY

http://git-wip-us.apache.org/repos/asf/hive/blob/be59e024/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out
index 54a2d06..f15d536 100644
--- a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out
+++ b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out
@@ -232,7 +232,7 @@ STAGE PLANS:
       Processor Tree:
         ListSink
 
-Warning: Shuffle Join JOIN[7][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a
cross product
+Warning: Shuffle Join JOIN[10][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is
a cross product
 PREHOOK: query: explain select *
 from part p1 join part2 p2 join part3 p3 
 where p2_partkey + p1.p_partkey = p1.p_partkey and p3_name = p2_name

http://git-wip-us.apache.org/repos/asf/hive/blob/be59e024/ql/src/test/results/clientpositive/join_merging.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_merging.q.out b/ql/src/test/results/clientpositive/join_merging.q.out
index 79a7023..7cc04f5 100644
--- a/ql/src/test/results/clientpositive/join_merging.q.out
+++ b/ql/src/test/results/clientpositive/join_merging.q.out
@@ -97,19 +97,18 @@ from part p1 left outer join part p2 on p1.p_partkey = p2.p_partkey
               p1.p_size > 10 and p1.p_size > p2.p_size + 10
 POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
-  Stage-2 is a root stage
-  Stage-1 depends on stages: Stage-2
+  Stage-1 is a root stage
   Stage-0 depends on stages: Stage-1
 
 STAGE PLANS:
-  Stage: Stage-2
+  Stage: Stage-1
     Map Reduce
       Map Operator Tree:
           TableScan
             alias: p1
             Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
             Filter Operator
-              predicate: (p_size > 10) (type: boolean)
+              predicate: ((p_size > 10) and p_partkey is not null) (type: boolean)
               Statistics: Num rows: 8 Data size: 968 Basic stats: COMPLETE Column stats:
NONE
               Select Operator
                 expressions: p_partkey (type: int), p_size (type: int)
@@ -124,38 +123,19 @@ STAGE PLANS:
           TableScan
             alias: p2
             Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-            Select Operator
-              expressions: p_partkey (type: int), p_size (type: int)
-              outputColumnNames: _col0, _col1
+            Filter Operator
+              predicate: p_partkey is not null (type: boolean)
               Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-              Reduce Output Operator
-                key expressions: _col0 (type: int)
-                sort order: +
-                Map-reduce partition columns: _col0 (type: int)
+              Select Operator
+                expressions: p_partkey (type: int), p_size (type: int)
+                outputColumnNames: _col0, _col1
                 Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-                value expressions: _col1 (type: int)
-      Reduce Operator Tree:
-        Join Operator
-          condition map:
-               Left Outer Join0 to 1
-          keys:
-            0 _col0 (type: int)
-            1 _col0 (type: int)
-          outputColumnNames: _col1, _col2, _col3
-          Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats: NONE
-          Filter Operator
-            predicate: (_col1 > (_col3 + 10)) (type: boolean)
-            Statistics: Num rows: 9 Data size: 1112 Basic stats: COMPLETE Column stats: NONE
-            File Output Operator
-              compressed: false
-              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
-      Map Operator Tree:
+                Reduce Output Operator
+                  key expressions: _col0 (type: int)
+                  sort order: +
+                  Map-reduce partition columns: _col0 (type: int)
+                  Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
+                  value expressions: _col1 (type: int)
           TableScan
             alias: p3
             Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
@@ -168,29 +148,25 @@ STAGE PLANS:
                 sort order: +
                 Map-reduce partition columns: _col0 (type: int)
                 Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
-          TableScan
-            Reduce Output Operator
-              key expressions: _col2 (type: int)
-              sort order: +
-              Map-reduce partition columns: _col2 (type: int)
-              Statistics: Num rows: 9 Data size: 1112 Basic stats: COMPLETE Column stats:
NONE
-              value expressions: _col1 (type: int), _col3 (type: int)
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Inner Join 0 to 1
+               Right Outer Join1 to 2
           keys:
             0 _col0 (type: int)
-            1 _col2 (type: int)
-          outputColumnNames: _col2, _col4
-          Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats: NONE
+            1 _col0 (type: int)
+            2 _col0 (type: int)
+          outputColumnNames: _col1, _col3
+          residual filter predicates: {(_col1 > (_col3 + 10))}
+          Statistics: Num rows: 57 Data size: 6923 Basic stats: COMPLETE Column stats: NONE
           Select Operator
-            expressions: _col2 (type: int), _col4 (type: int)
+            expressions: _col1 (type: int), _col3 (type: int)
             outputColumnNames: _col0, _col1
-            Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats:
NONE
+            Statistics: Num rows: 57 Data size: 6923 Basic stats: COMPLETE Column stats:
NONE
             File Output Operator
               compressed: false
-              Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats:
NONE
+              Statistics: Num rows: 57 Data size: 6923 Basic stats: COMPLETE Column stats:
NONE
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat

http://git-wip-us.apache.org/repos/asf/hive/blob/be59e024/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out b/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out
index a867bd2..841ef14 100644
--- a/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out
@@ -1044,7 +1044,7 @@ STAGE PLANS:
                   alias: a
                   Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
-                    predicate: (key + 1) is not null (type: boolean)
+                    predicate: key is not null (type: boolean)
                     Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats:
NONE
                     Select Operator
                       expressions: (key + 1) (type: int)
@@ -1063,7 +1063,7 @@ STAGE PLANS:
                   alias: a
                   Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
-                    predicate: (key + 1) is not null (type: boolean)
+                    predicate: key is not null (type: boolean)
                     Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats:
NONE
                     Select Operator
                       expressions: (key + 1) (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/be59e024/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out
index c08a534..b69d0bd 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out
@@ -1261,7 +1261,7 @@ STAGE PLANS:
                   alias: a
                   Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
-                    predicate: (key + 1) is not null (type: boolean)
+                    predicate: key is not null (type: boolean)
                     Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats:
NONE
                     Select Operator
                       expressions: (key + 1) (type: int)
@@ -1293,7 +1293,7 @@ STAGE PLANS:
                   alias: a
                   Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
-                    predicate: (key + 1) is not null (type: boolean)
+                    predicate: key is not null (type: boolean)
                     Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats:
NONE
                     Select Operator
                       expressions: (key + 1) (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/be59e024/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out b/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out
index 98d2328..4bdb186 100644
--- a/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out
+++ b/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out
@@ -274,7 +274,7 @@ Stage-0
               Select Operator [SEL_5] (rows=2 width=3)
                 Output:["_col0","_col1"]
                 Filter Operator [FIL_16] (rows=2 width=3)
-                  predicate:((id = 100) and (id = 100) is not null)
+                  predicate:(id = 100)
                   TableScan [TS_3] (rows=5 width=3)
                     default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
 
@@ -311,7 +311,7 @@ Stage-0
             Select Operator [SEL_2] (rows=5 width=20)
               Output:["_col0","_col1","_col2"]
               Filter Operator [FIL_15] (rows=5 width=20)
-                predicate:((dimid = 100) and (dimid = 100) is not null)
+                predicate:(dimid = 100)
                 TableScan [TS_0] (rows=10 width=20)
                   default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"]
         <-Map 3 [SIMPLE_EDGE] llap
@@ -322,7 +322,7 @@ Stage-0
               Select Operator [SEL_5] (rows=2 width=3)
                 Output:["_col0","_col1"]
                 Filter Operator [FIL_16] (rows=2 width=3)
-                  predicate:((id = 100) and (id = 100) is not null)
+                  predicate:(id = 100)
                   TableScan [TS_3] (rows=5 width=3)
                     default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
 
@@ -372,7 +372,7 @@ Stage-0
               Select Operator [SEL_5] (rows=2 width=3)
                 Output:["_col0","_col1"]
                 Filter Operator [FIL_16] (rows=2 width=3)
-                  predicate:((id = 100) and (id = 100) is not null)
+                  predicate:(id = 100)
                   TableScan [TS_3] (rows=5 width=3)
                     default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
 
@@ -409,7 +409,7 @@ Stage-0
             Select Operator [SEL_2] (rows=5 width=20)
               Output:["_col0","_col1","_col2"]
               Filter Operator [FIL_15] (rows=5 width=20)
-                predicate:((dimid = 100) and (dimid = 100) is not null)
+                predicate:(dimid = 100)
                 TableScan [TS_0] (rows=10 width=20)
                   default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"]
         <-Map 3 [SIMPLE_EDGE] llap
@@ -420,7 +420,7 @@ Stage-0
               Select Operator [SEL_5] (rows=2 width=3)
                 Output:["_col0","_col1"]
                 Filter Operator [FIL_16] (rows=2 width=3)
-                  predicate:((id = 100) and (id = 100) is not null)
+                  predicate:(id = 100)
                   TableScan [TS_3] (rows=5 width=3)
                     default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
 
@@ -459,7 +459,7 @@ Stage-0
             Select Operator [SEL_2] (rows=5 width=20)
               Output:["_col0","_col1","_col2"]
               Filter Operator [FIL_15] (rows=5 width=20)
-                predicate:((dimid = 100) and (dimid = 100) is not null)
+                predicate:(dimid = 100)
                 TableScan [TS_0] (rows=10 width=20)
                   default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"]
         <-Map 3 [SIMPLE_EDGE] llap
@@ -470,7 +470,7 @@ Stage-0
               Select Operator [SEL_5] (rows=2 width=3)
                 Output:["_col0","_col1"]
                 Filter Operator [FIL_16] (rows=2 width=3)
-                  predicate:((id = 100) and (id = 100) is not null)
+                  predicate:(id = 100)
                   TableScan [TS_3] (rows=5 width=3)
                     default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/be59e024/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out
index d291e7d..a5fdd90 100644
--- a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out
@@ -105,10 +105,10 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: tt2
-                  filterExpr: ((timestamp_col_18 = timestamp_col_18) and decimal1911_col_16
is not null and (timestamp_col_18 BETWEEN DynamicValue(RS_23_t1_timestamp_col_18_min) AND
DynamicValue(RS_23_t1_timestamp_col_18_max) and in_bloom_filter(timestamp_col_18, DynamicValue(RS_23_t1_timestamp_col_18_bloom_filter))))
(type: boolean)
+                  filterExpr: (timestamp_col_18 is not null and decimal1911_col_16 is not
null and (timestamp_col_18 BETWEEN DynamicValue(RS_23_t1_timestamp_col_18_min) AND DynamicValue(RS_23_t1_timestamp_col_18_max)
and in_bloom_filter(timestamp_col_18, DynamicValue(RS_23_t1_timestamp_col_18_bloom_filter))))
(type: boolean)
                   Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
                   Filter Operator
-                    predicate: ((timestamp_col_18 = timestamp_col_18) and decimal1911_col_16
is not null and (timestamp_col_18 BETWEEN DynamicValue(RS_23_t1_timestamp_col_18_min) AND
DynamicValue(RS_23_t1_timestamp_col_18_max) and in_bloom_filter(timestamp_col_18, DynamicValue(RS_23_t1_timestamp_col_18_bloom_filter))))
(type: boolean)
+                    predicate: (timestamp_col_18 is not null and decimal1911_col_16 is not
null and (timestamp_col_18 BETWEEN DynamicValue(RS_23_t1_timestamp_col_18_min) AND DynamicValue(RS_23_t1_timestamp_col_18_max)
and in_bloom_filter(timestamp_col_18, DynamicValue(RS_23_t1_timestamp_col_18_bloom_filter))))
(type: boolean)
                     Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
                     Select Operator
                       expressions: decimal1911_col_16 (type: decimal(19,11)), timestamp_col_18
(type: timestamp)


Mime
View raw message