hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gunt...@apache.org
Subject svn commit: r1614214 [3/9] - in /hive/branches/cbo: ./ common/ common/src/java/org/apache/hadoop/hive/conf/ conf/ contrib/src/test/results/clientpositive/ hbase-handler/src/test/results/positive/ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/...
Date Mon, 28 Jul 2014 23:20:59 GMT
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/index_stale.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/index_stale.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/index_stale.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/index_stale.q.out Mon Jul 28 23:20:54 2014
@@ -71,7 +71,7 @@ STAGE PLANS:
               predicate: (key = 86) (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), val (type: string)
+                expressions: '86' (type: string), val (type: string)
                 outputColumnNames: _col0, _col1
                 Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/index_stale_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/index_stale_partitioned.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/index_stale_partitioned.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/index_stale_partitioned.q.out Mon Jul 28 23:20:54 2014
@@ -92,7 +92,7 @@ STAGE PLANS:
               predicate: (key = 86) (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), val (type: string), foo (type: string)
+                expressions: '86' (type: string), val (type: string), foo (type: string)
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/infer_const_type.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/infer_const_type.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/infer_const_type.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/infer_const_type.q.out Mon Jul 28 23:20:54 2014
@@ -56,12 +56,12 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: infertypes
-            Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE
+            Statistics: Num rows: 3 Data size: 117 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (((((((ti = 127) and (si = 32767)) and (i = 12345)) and (bi = -12345)) and (fl = 906.0)) and (db = -307.0)) and (str = 1234)) (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
-                expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string)
+                expressions: 127 (type: tinyint), 32767 (type: smallint), 12345 (type: int), -12345 (type: bigint), 906.0 (type: float), -307.0 (type: double), '1234' (type: string)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 File Output Operator
@@ -135,7 +135,7 @@ STAGE PLANS:
             alias: infertypes
             Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE
             Filter Operator
-              predicate: (((((false or false) or false) or false) or false) or false) (type: boolean)
+              predicate: false (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
                 expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string)
@@ -199,7 +199,7 @@ STAGE PLANS:
             alias: infertypes
             Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE
             Filter Operator
-              predicate: ((false or false) or false) (type: boolean)
+              predicate: false (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
                 expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string)
@@ -253,12 +253,12 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: infertypes
-            Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE
+            Statistics: Num rows: 3 Data size: 117 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (((ti < 127.0) and (i > 100.0)) and (str = 1.57)) (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
-                expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string)
+                expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), '1.57' (type: string)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 File Output Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/input18.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/input18.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/input18.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/input18.q.out Mon Jul 28 23:20:54 2014
@@ -36,7 +36,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: key (type: string), value (type: string), (1 + 2) (type: int), (3 + 4) (type: int)
+              expressions: key (type: string), value (type: string), 3 (type: int), 7 (type: int)
               outputColumnNames: _col0, _col1, _col2, _col3
               Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
               Transform Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/input23.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/input23.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/input23.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/input23.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/input26.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/input26.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/input26.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/input26.q.out Mon Jul 28 23:20:54 2014
@@ -85,7 +85,7 @@ STAGE PLANS:
     Map Reduce
       Reduce Operator Tree:
         Select Operator
-          expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: string)
+          expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), '2008-04-08' (type: string), '14' (type: string)
           outputColumnNames: _col0, _col1, _col2, _col3
           Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
           Limit

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/input38.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/input38.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/input38.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/input38.q.out Mon Jul 28 23:20:54 2014
@@ -39,7 +39,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: key (type: string), value (type: string), (1 + 2) (type: int), (3 + 4) (type: int)
+              expressions: key (type: string), value (type: string), 3 (type: int), 7 (type: int)
               outputColumnNames: _col0, _col1, _col2, _col3
               Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
               Transform Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/input39_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/input39_hadoop20.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/input39_hadoop20.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/input39_hadoop20.q.out Mon Jul 28 23:20:54 2014
@@ -73,24 +73,24 @@ STAGE PLANS:
             alias: t2
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
-              predicate: (((hash(rand(460476415)) & 2147483647) % 32) = 0) (type: boolean)
-              Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+              predicate: ((((hash(rand(460476415)) & 2147483647) % 32) = 0) and key is not null) (type: boolean)
+              Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: string)
                 sort order: +
                 Map-reduce partition columns: key (type: string)
-                Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
           TableScan
             alias: t1
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
-              predicate: (((hash(rand(460476415)) & 2147483647) % 32) = 0) (type: boolean)
-              Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+              predicate: ((((hash(rand(460476415)) & 2147483647) % 32) = 0) and key is not null) (type: boolean)
+              Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: string)
                 sort order: +
                 Map-reduce partition columns: key (type: string)
-                Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -98,9 +98,9 @@ STAGE PLANS:
           condition expressions:
             0 
             1 
-          Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+          Statistics: Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
           Select Operator
-            Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
             Group By Operator
               aggregations: count(1)
               mode: hash

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/input6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/input6.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/input6.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/input6.q.out Mon Jul 28 23:20:54 2014
@@ -34,7 +34,7 @@ STAGE PLANS:
               predicate: key is null (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
-                expressions: key (type: string), value (type: string)
+                expressions: null (type: void), value (type: string)
                 outputColumnNames: _col0, _col1
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 File Output Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/input_part2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/input_part2.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/input_part2.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/input_part2.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/input_part4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/input_part4.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/input_part4.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/input_part4.q.out Mon Jul 28 23:20:54 2014
@@ -19,7 +19,7 @@ STAGE PLANS:
             predicate: ((ds = '2008-04-08') and (hr = 15)) (type: boolean)
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
             Select Operator
-              expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
+              expressions: key (type: string), value (type: string), '2008-04-08' (type: string), '15' (type: string)
               outputColumnNames: _col0, _col1, _col2, _col3
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               ListSink

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/input_part6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/input_part6.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/input_part6.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/input_part6.q.out Mon Jul 28 23:20:54 2014
@@ -16,12 +16,12 @@ STAGE PLANS:
             alias: x
             Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
-              predicate: (ds = ((2008 - 4) - 8)) (type: boolean)
-              Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+              predicate: (ds = 1996) (type: boolean)
+              Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
+                expressions: key (type: string), value (type: string), '1996' (type: string), hr (type: string)
                 outputColumnNames: _col0, _col1, _col2, _col3
-                Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
                 Limit
                   Number of rows: 10
                   Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/insert1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/insert1.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/insert1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/insert1.q.out Mon Jul 28 23:20:54 2014
@@ -48,10 +48,10 @@ STAGE PLANS:
             alias: a
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
             Filter Operator
-              predicate: (key = (- 1)) (type: boolean)
+              predicate: (key = -1) (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
-                expressions: key (type: int), value (type: string)
+                expressions: -1 (type: int), value (type: string)
                 outputColumnNames: _col0, _col1
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 File Output Operator
@@ -137,10 +137,10 @@ STAGE PLANS:
             alias: a
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
             Filter Operator
-              predicate: (key = (- 1)) (type: boolean)
+              predicate: (key = -1) (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
-                expressions: key (type: int), value (type: string)
+                expressions: -1 (type: int), value (type: string)
                 outputColumnNames: _col0, _col1
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 File Output Operator
@@ -239,10 +239,10 @@ STAGE PLANS:
             alias: a
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
             Filter Operator
-              predicate: (key = (- 1)) (type: boolean)
+              predicate: (key = -1) (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
-                expressions: key (type: int), value (type: string)
+                expressions: -1 (type: int), value (type: string)
                 outputColumnNames: _col0, _col1
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 File Output Operator
@@ -328,10 +328,10 @@ STAGE PLANS:
             alias: a
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
             Filter Operator
-              predicate: (key = (- 1)) (type: boolean)
+              predicate: (key = -1) (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
-                expressions: key (type: int), value (type: string)
+                expressions: -1 (type: int), value (type: string)
                 outputColumnNames: _col0, _col1
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 File Output Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/join14_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/join14_hadoop20.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/join14_hadoop20.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/join14_hadoop20.q.out Mon Jul 28 23:20:54 2014
@@ -30,7 +30,7 @@ STAGE PLANS:
             alias: srcpart
             Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
-              predicate: (key > 100) (type: boolean)
+              predicate: ((key > 100) and key is not null) (type: boolean)
               Statistics: Num rows: 19 Data size: 3807 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: string)
@@ -42,7 +42,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
-              predicate: (key > 100) (type: boolean)
+              predicate: ((key > 100) and key is not null) (type: boolean)
               Statistics: Num rows: 19 Data size: 1903 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: string)

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/join38.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/join38.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/join38.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/join38.q.out Mon Jul 28 23:20:54 2014
@@ -63,17 +63,17 @@ STAGE PLANS:
         a 
           TableScan
             alias: a
-            Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key is not null and (key = 111)) (type: boolean)
-              Statistics: Num rows: 7 Data size: 1402 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 14 Data size: 1453 Basic stats: COMPLETE Column stats: NONE
               HashTable Sink Operator
                 condition expressions:
                   0 {value}
                   1 {col5}
                 keys:
-                  0 key (type: string)
-                  1 col11 (type: string)
+                  0 '111' (type: string)
+                  1 '111' (type: string)
 
   Stage: Stage-1
     Map Reduce
@@ -91,25 +91,25 @@ STAGE PLANS:
                   0 {value}
                   1 {col5}
                 keys:
-                  0 key (type: string)
-                  1 col11 (type: string)
+                  0 '111' (type: string)
+                  1 '111' (type: string)
                 outputColumnNames: _col1, _col9
-                Statistics: Num rows: 7 Data size: 1542 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
                   expressions: _col1 (type: string), _col9 (type: string)
                   outputColumnNames: _col1, _col9
-                  Statistics: Num rows: 7 Data size: 1542 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE
                   Group By Operator
                     aggregations: count(1)
                     keys: _col1 (type: string), _col9 (type: string)
                     mode: hash
                     outputColumnNames: _col0, _col1, _col2
-                    Statistics: Num rows: 7 Data size: 1542 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE
                     Reduce Output Operator
                       key expressions: _col0 (type: string), _col1 (type: string)
                       sort order: ++
                       Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
-                      Statistics: Num rows: 7 Data size: 1542 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE
                       value expressions: _col2 (type: bigint)
       Local Work:
         Map Reduce Local Work
@@ -119,14 +119,14 @@ STAGE PLANS:
           keys: KEY._col0 (type: string), KEY._col1 (type: string)
           mode: mergepartial
           outputColumnNames: _col0, _col1, _col2
-          Statistics: Num rows: 3 Data size: 660 Basic stats: COMPLETE Column stats: NONE
+          Statistics: Num rows: 7 Data size: 745 Basic stats: COMPLETE Column stats: NONE
           Select Operator
             expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint)
             outputColumnNames: _col0, _col1, _col2
-            Statistics: Num rows: 3 Data size: 660 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 7 Data size: 745 Basic stats: COMPLETE Column stats: NONE
             File Output Operator
               compressed: false
-              Statistics: Num rows: 3 Data size: 660 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 7 Data size: 745 Basic stats: COMPLETE Column stats: NONE
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out Mon Jul 28 23:20:54 2014
@@ -323,7 +323,7 @@ STAGE PLANS:
               Reduce Output Operator
                 sort order: 
                 Statistics: Num rows: 1 Data size: 634 Basic stats: COMPLETE Column stats: NONE
-                value 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)
+                value expressions: 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)
           TableScan
             alias: p1
             Statistics: Num rows: 5 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -337,8 +337,8 @@ STAGE PLANS:
                Inner Join 0 to 1
           condition expressions:
             0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
-            1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
+            1 {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
+          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
           Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
             compressed: false
@@ -368,18 +368,18 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col12 (type: string)
               Statistics: Num rows: 5 Data size: 3490 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), _col11 (type: int), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
+              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), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
+            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
             1 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7}
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
+          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
           Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
           Select Operator
-            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), _col11 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string)
+            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), 1 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (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: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
             File Output Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out Mon Jul 28 23:20:54 2014
@@ -340,7 +340,7 @@ STAGE PLANS:
               Reduce Output Operator
                 sort order: 
                 Statistics: Num rows: 1 Data size: 634 Basic stats: COMPLETE Column stats: NONE
-                value 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)
+                value expressions: 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)
           TableScan
             alias: p1
             Statistics: Num rows: 5 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -354,8 +354,8 @@ STAGE PLANS:
                Inner Join 0 to 1
           condition expressions:
             0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
-            1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
+            1 {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
+          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
           Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
             compressed: false
@@ -385,26 +385,26 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col12 (type: string)
               Statistics: Num rows: 5 Data size: 3490 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), _col11 (type: int), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
+              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), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
+            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
             1 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7}
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
+          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
           Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
           Filter Operator
-            predicate: ((_col11 = 1) and (_col23 = _col12)) (type: boolean)
-            Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE
+            predicate: (_col23 = _col12) (type: boolean)
+            Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              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), _col11 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string)
+              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), 1 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (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: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
                 compressed: false
-                Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out Mon Jul 28 23:20:54 2014
@@ -377,7 +377,7 @@ STAGE PLANS:
               Reduce Output Operator
                 sort order: 
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-                value expressions: p2_partkey (type: int), p2_name (type: string), p2_mfgr (type: string), p2_brand (type: string), p2_type (type: string), p2_size (type: int), p2_container (type: string), p2_retailprice (type: double), p2_comment (type: string)
+                value expressions: p2_name (type: string), p2_mfgr (type: string), p2_brand (type: string), p2_type (type: string), p2_size (type: int), p2_container (type: string), p2_retailprice (type: double), p2_comment (type: string)
           TableScan
             alias: p1
             Statistics: Num rows: 5 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -391,8 +391,8 @@ STAGE PLANS:
                Inner Join 0 to 1
           condition expressions:
             0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
-            1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
+            1 {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
+          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
           Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
             compressed: false
@@ -422,18 +422,18 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col12 (type: string)
               Statistics: Num rows: 5 Data size: 3490 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), _col11 (type: int), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
+              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), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
+            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
             1 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7}
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
+          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
           Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
           Select Operator
-            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), _col11 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string)
+            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), 1 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (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: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
             File Output Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out Mon Jul 28 23:20:54 2014
@@ -394,7 +394,7 @@ STAGE PLANS:
               Reduce Output Operator
                 sort order: 
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-                value expressions: p2_partkey (type: int), p2_name (type: string), p2_mfgr (type: string), p2_brand (type: string), p2_type (type: string), p2_size (type: int), p2_container (type: string), p2_retailprice (type: double), p2_comment (type: string)
+                value expressions: p2_name (type: string), p2_mfgr (type: string), p2_brand (type: string), p2_type (type: string), p2_size (type: int), p2_container (type: string), p2_retailprice (type: double), p2_comment (type: string)
           TableScan
             alias: p1
             Statistics: Num rows: 5 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -408,8 +408,8 @@ STAGE PLANS:
                Inner Join 0 to 1
           condition expressions:
             0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
-            1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
+            1 {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
+          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
           Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
             compressed: false
@@ -439,26 +439,26 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col12 (type: string)
               Statistics: Num rows: 5 Data size: 3490 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), _col11 (type: int), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
+              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), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
+            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
             1 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7}
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
+          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
           Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
           Filter Operator
-            predicate: ((_col11 = 1) and (_col23 = _col12)) (type: boolean)
-            Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE
+            predicate: (_col23 = _col12) (type: boolean)
+            Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              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), _col11 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string)
+              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), 1 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (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: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
                 compressed: false
-                Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/join_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/join_view.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/join_view.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/join_view.q.out Mon Jul 28 23:20:54 2014
@@ -50,8 +50,8 @@ STAGE PLANS:
                Inner Join 0 to 1
           condition expressions:
             0 {VALUE._col1}
-            1 {VALUE._col0} {KEY.reducesinkkey0}
-          outputColumnNames: _col1, _col5, _col7
+            1 {VALUE._col0}
+          outputColumnNames: _col1, _col5
           Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
           Select Operator
             expressions: _col1 (type: string), _col5 (type: int), _col7 (type: string)

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/lateral_view_ppd.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/lateral_view_ppd.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/lateral_view_ppd.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/lateral_view_ppd.q.out Mon Jul 28 23:20:54 2014
@@ -12,26 +12,26 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 57 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key = '0') (type: boolean)
-              Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
               Lateral View Forward
-                Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
                   expressions: value (type: string)
                   outputColumnNames: value
-                  Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                   Lateral View Join Operator
                     outputColumnNames: _col1, _col4
-                    Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: _col1 (type: string), _col4 (type: int)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -39,20 +39,20 @@ STAGE PLANS:
                 Select Operator
                   expressions: array(1,2,3) (type: array<int>)
                   outputColumnNames: _col0
-                  Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                   UDTF Operator
-                    Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                     function name: explode
                     Lateral View Join Operator
                       outputColumnNames: _col1, _col4
-                      Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                       Select Operator
                         expressions: _col1 (type: string), _col4 (type: int)
                         outputColumnNames: _col0, _col1
-                        Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                         File Output Operator
                           compressed: false
-                          Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                           table:
                               input format: org.apache.hadoop.mapred.TextInputFormat
                               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -95,26 +95,26 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 57 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key = '0') (type: boolean)
-              Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
               Lateral View Forward
-                Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
                   expressions: value (type: string)
                   outputColumnNames: value
-                  Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                   Lateral View Join Operator
                     outputColumnNames: _col1, _col4
-                    Statistics: Num rows: 21 Data size: 4207 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: _col1 (type: string), _col4 (type: int)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 21 Data size: 4207 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 21 Data size: 4207 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -122,23 +122,23 @@ STAGE PLANS:
                 Select Operator
                   expressions: array(1,2,3) (type: array<int>)
                   outputColumnNames: _col0
-                  Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                   UDTF Operator
-                    Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                     function name: explode
                     Filter Operator
                       predicate: (col = 1) (type: boolean)
-                      Statistics: Num rows: 7 Data size: 1402 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 14 Data size: 1427 Basic stats: COMPLETE Column stats: NONE
                       Lateral View Join Operator
                         outputColumnNames: _col1, _col4
-                        Statistics: Num rows: 21 Data size: 4207 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col1 (type: string), _col4 (type: int)
                           outputColumnNames: _col0, _col1
-                          Statistics: Num rows: 21 Data size: 4207 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
                           File Output Operator
                             compressed: false
-                            Statistics: Num rows: 21 Data size: 4207 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
                             table:
                                 input format: org.apache.hadoop.mapred.TextInputFormat
                                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -266,35 +266,35 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 57 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key = '0') (type: boolean)
-              Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
               Lateral View Forward
-                Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
                   expressions: value (type: string)
                   outputColumnNames: value
-                  Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                   Lateral View Join Operator
                     outputColumnNames: _col1, _col4
-                    Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                     Lateral View Forward
-                      Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                       Select Operator
                         expressions: _col1 (type: string), _col4 (type: int)
                         outputColumnNames: _col1, _col4
-                        Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                         Lateral View Join Operator
                           outputColumnNames: _col1, _col4, _col5
-                          Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
                           Select Operator
                             expressions: _col1 (type: string), _col4 (type: int)
                             outputColumnNames: _col0, _col1
-                            Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
                             File Output Operator
                               compressed: false
-                              Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+                              Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
                               table:
                                   input format: org.apache.hadoop.mapred.TextInputFormat
                                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -302,20 +302,20 @@ STAGE PLANS:
                       Select Operator
                         expressions: array(1,2,3) (type: array<int>)
                         outputColumnNames: _col0
-                        Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                         UDTF Operator
-                          Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                           function name: explode
                           Lateral View Join Operator
                             outputColumnNames: _col1, _col4, _col5
-                            Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
                             Select Operator
                               expressions: _col1 (type: string), _col4 (type: int)
                               outputColumnNames: _col0, _col1
-                              Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+                              Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
                               File Output Operator
                                 compressed: false
-                                Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+                                Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
                                 table:
                                     input format: org.apache.hadoop.mapred.TextInputFormat
                                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -323,29 +323,29 @@ STAGE PLANS:
                 Select Operator
                   expressions: array(1,2,3) (type: array<int>)
                   outputColumnNames: _col0
-                  Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                   UDTF Operator
-                    Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                     function name: explode
                     Lateral View Join Operator
                       outputColumnNames: _col1, _col4
-                      Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                       Lateral View Forward
-                        Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col1 (type: string), _col4 (type: int)
                           outputColumnNames: _col1, _col4
-                          Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                           Lateral View Join Operator
                             outputColumnNames: _col1, _col4, _col5
-                            Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
                             Select Operator
                               expressions: _col1 (type: string), _col4 (type: int)
                               outputColumnNames: _col0, _col1
-                              Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+                              Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
                               File Output Operator
                                 compressed: false
-                                Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+                                Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
                                 table:
                                     input format: org.apache.hadoop.mapred.TextInputFormat
                                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -353,20 +353,20 @@ STAGE PLANS:
                         Select Operator
                           expressions: array(1,2,3) (type: array<int>)
                           outputColumnNames: _col0
-                          Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                           UDTF Operator
-                            Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
                             function name: explode
                             Lateral View Join Operator
                               outputColumnNames: _col1, _col4, _col5
-                              Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+                              Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
                               Select Operator
                                 expressions: _col1 (type: string), _col4 (type: int)
                                 outputColumnNames: _col0, _col1
-                                Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+                                Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
                                 File Output Operator
                                   compressed: false
-                                  Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+                                  Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
                                   table:
                                       input format: org.apache.hadoop.mapred.TextInputFormat
                                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -429,26 +429,26 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 57 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key = '0') (type: boolean)
-              Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
               Lateral View Forward
-                Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
                   expressions: value (type: string)
                   outputColumnNames: value
-                  Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                   Lateral View Join Operator
                     outputColumnNames: _col1, _col4
-                    Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: _col1 (type: string), _col4 (type: int)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -456,23 +456,23 @@ STAGE PLANS:
                 Select Operator
                   expressions: array(1,2,3) (type: array<int>)
                   outputColumnNames: _col0
-                  Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                   UDTF Operator
-                    Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
                     function name: explode
                     Filter Operator
                       predicate: (col > 1) (type: boolean)
-                      Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 9 Data size: 917 Basic stats: COMPLETE Column stats: NONE
                       Lateral View Join Operator
                         outputColumnNames: _col1, _col4
-                        Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col1 (type: string), _col4 (type: int)
                           outputColumnNames: _col0, _col1
-                          Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
                           File Output Operator
                             compressed: false
-                            Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
                             table:
                                 input format: org.apache.hadoop.mapred.TextInputFormat
                                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out Mon Jul 28 23:20:54 2014
@@ -223,7 +223,7 @@ STAGE PLANS:
               predicate: (x = 484) (type: boolean)
               Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: x (type: int)
+                expressions: 484 (type: int)
                 outputColumnNames: _col0
                 Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
@@ -370,7 +370,7 @@ STAGE PLANS:
               predicate: (x = 495) (type: boolean)
               Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: x (type: int)
+                expressions: 495 (type: int)
                 outputColumnNames: _col0
                 Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
@@ -513,7 +513,7 @@ STAGE PLANS:
               predicate: (x = 1) (type: boolean)
               Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: x (type: int)
+                expressions: 1 (type: int)
                 outputColumnNames: _col0
                 Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator



Mime
View raw message