hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gunt...@apache.org
Subject svn commit: r1614214 [5/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/ppd_join4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join4.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join4.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join4.q.out Mon Jul 28 23:20:54 2014
@@ -58,18 +58,13 @@ STAGE PLANS:
               predicate: ((id is not null and (name = 'c')) and (id = 'a')) (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
-                expressions: id (type: string), name (type: string)
-                outputColumnNames: _col0, _col1
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Reduce Output Operator
-                  key expressions: _col0 (type: string)
+                  key expressions: 'a' (type: string)
                   sort order: +
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-                  value expressions: _col1 (type: string)
       Reduce Operator Tree:
         Select Operator
-          expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
-          outputColumnNames: _col0, _col1
           Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
           File Output Operator
             compressed: false
@@ -88,28 +83,24 @@ STAGE PLANS:
               predicate: (id is not null and (id = 'a')) (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Reduce Output Operator
-                key expressions: id (type: string)
+                key expressions: 'a' (type: string)
                 sort order: +
-                Map-reduce partition columns: id (type: string)
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
           TableScan
             Reduce Output Operator
-              key expressions: _col0 (type: string)
+              key expressions: 'a' (type: string)
               sort order: +
-              Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-              value expressions: _col1 (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {KEY.reducesinkkey0} {VALUE._col0}
+            0 
             1 
-          outputColumnNames: _col0, _col1
           Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
           Select Operator
-            expressions: _col0 (type: string), _col1 (type: string)
+            expressions: 'a' (type: string), 'c' (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/ppd_outer_join5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_outer_join5.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/ppd_outer_join5.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/ppd_outer_join5.q.out Mon Jul 28 23:20:54 2014
@@ -45,9 +45,8 @@ STAGE PLANS:
               predicate: (id = 20) (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Reduce Output Operator
-                key expressions: id (type: int)
+                key expressions: 20 (type: int)
                 sort order: +
-                Map-reduce partition columns: id (type: int)
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 value expressions: key (type: string), value (type: string)
           TableScan
@@ -82,11 +81,11 @@ STAGE PLANS:
           condition expressions:
             0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
             1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
-            2 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
-          outputColumnNames: _col0, _col1, _col2, _col5, _col6, _col7, _col10, _col11, _col12
+            2 {VALUE._col0} {VALUE._col1}
+          outputColumnNames: _col0, _col1, _col2, _col5, _col6, _col7, _col11, _col12
           Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
           Select Operator
-            expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: string), _col10 (type: int), _col11 (type: string), _col12 (type: string)
+            expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: string), 20 (type: int), _col11 (type: string), _col12 (type: string)
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
             File Output Operator
@@ -134,9 +133,8 @@ STAGE PLANS:
               predicate: (id = 20) (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Reduce Output Operator
-                key expressions: id (type: int)
+                key expressions: 20 (type: int)
                 sort order: +
-                Map-reduce partition columns: id (type: int)
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 value expressions: key (type: string), value (type: string)
           TableScan
@@ -146,9 +144,8 @@ STAGE PLANS:
               predicate: (id = 20) (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Reduce Output Operator
-                key expressions: id (type: int)
+                key expressions: 20 (type: int)
                 sort order: +
-                Map-reduce partition columns: id (type: int)
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 value expressions: key (type: string), value (type: string)
       Reduce Operator Tree:
@@ -157,13 +154,13 @@ STAGE PLANS:
                Inner Join 0 to 1
                Left Outer Join1 to 2
           condition expressions:
-            0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
-            1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
+            0 {VALUE._col0} {VALUE._col1}
+            1 {VALUE._col0} {VALUE._col1}
             2 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
-          outputColumnNames: _col0, _col1, _col2, _col5, _col6, _col7, _col10, _col11, _col12
+          outputColumnNames: _col1, _col2, _col6, _col7, _col10, _col11, _col12
           Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
           Select Operator
-            expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: string), _col10 (type: int), _col11 (type: string), _col12 (type: string)
+            expressions: 20 (type: int), _col1 (type: string), _col2 (type: string), 20 (type: int), _col6 (type: string), _col7 (type: string), _col10 (type: int), _col11 (type: string), _col12 (type: string)
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
             File Output Operator
@@ -211,9 +208,8 @@ STAGE PLANS:
               predicate: (id = 20) (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Reduce Output Operator
-                key expressions: id (type: int)
+                key expressions: 20 (type: int)
                 sort order: +
-                Map-reduce partition columns: id (type: int)
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 value expressions: key (type: string), value (type: string)
           TableScan
@@ -223,9 +219,8 @@ STAGE PLANS:
               predicate: (id = 20) (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Reduce Output Operator
-                key expressions: id (type: int)
+                key expressions: 20 (type: int)
                 sort order: +
-                Map-reduce partition columns: id (type: int)
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 value expressions: key (type: string), value (type: string)
       Reduce Operator Tree:
@@ -234,13 +229,13 @@ STAGE PLANS:
                Inner Join 0 to 1
                Left Outer Join0 to 2
           condition expressions:
-            0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
-            1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
+            0 {VALUE._col0} {VALUE._col1}
+            1 {VALUE._col0} {VALUE._col1}
             2 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
-          outputColumnNames: _col0, _col1, _col2, _col5, _col6, _col7, _col10, _col11, _col12
+          outputColumnNames: _col1, _col2, _col6, _col7, _col10, _col11, _col12
           Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
           Select Operator
-            expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: string), _col10 (type: int), _col11 (type: string), _col12 (type: string)
+            expressions: 20 (type: int), _col1 (type: string), _col2 (type: string), 20 (type: int), _col6 (type: string), _col7 (type: string), _col10 (type: int), _col11 (type: string), _col12 (type: string)
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
             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/ppd_repeated_alias.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out Mon Jul 28 23:20:54 2014
@@ -72,7 +72,7 @@ STAGE PLANS:
             predicate: (_col6 = 3) (type: boolean)
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
             Select Operator
-              expressions: _col0 (type: int), _col5 (type: int), _col6 (type: int)
+              expressions: _col0 (type: int), _col5 (type: int), 3 (type: int)
               outputColumnNames: _col0, _col1, _col2
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               File Output Operator
@@ -206,18 +206,17 @@ STAGE PLANS:
                 sort order: +
                 Map-reduce partition columns: foo (type: int)
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-                value expressions: bar (type: int)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {KEY.reducesinkkey0} {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 {KEY.reducesinkkey0}
-          outputColumnNames: _col0, _col1, _col5
+          outputColumnNames: _col0, _col5
           Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
           Select Operator
-            expressions: _col0 (type: int), _col5 (type: int), _col1 (type: int)
+            expressions: _col0 (type: int), _col5 (type: int), 3 (type: int)
             outputColumnNames: _col0, _col1, _col2
             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/ppd_udf_case.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_udf_case.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/ppd_udf_case.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/ppd_udf_case.q.out Mon Jul 28 23:20:54 2014
@@ -70,8 +70,8 @@ STAGE PLANS:
             predicate: (((_col2 = '2008-04-08') and (_col8 = '2008-04-08')) and CASE (_col0) WHEN ('27') THEN (true) WHEN ('38') THEN (false) ELSE (null) END) (type: boolean)
             Statistics: Num rows: 1 Data size: 205 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: string), _col9 (type: string)
-              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+              expressions: _col0 (type: string), _col1 (type: string), _col3 (type: string), _col6 (type: string), _col7 (type: string), _col9 (type: string)
+              outputColumnNames: _col0, _col1, _col3, _col4, _col5, _col7
               Statistics: Num rows: 1 Data size: 205 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
                 compressed: false
@@ -85,12 +85,12 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             Reduce Output Operator
-              key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string)
+              key expressions: _col0 (type: string), _col1 (type: string), '2008-04-08' (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), '2008-04-08' (type: string), _col7 (type: string)
               sort order: ++++++++
               Statistics: Num rows: 1 Data size: 205 Basic stats: COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Select Operator
-          expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type: string), KEY.reducesinkkey6 (type: string), KEY.reducesinkkey7 (type: string)
+          expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), '2008-04-08' (type: string), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type: string), '2008-04-08' (type: string), KEY.reducesinkkey7 (type: string)
           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
           Statistics: Num rows: 1 Data size: 205 Basic stats: COMPLETE Column stats: NONE
           File Output Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ppd_udf_col.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_udf_col.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/ppd_udf_col.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/ppd_udf_col.q.out Mon Jul 28 23:20:54 2014
@@ -18,24 +18,24 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key = 100) (type: boolean)
-              Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), rand() (type: double)
-                outputColumnNames: _col0, _col2
-                Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+                expressions: rand() (type: double)
+                outputColumnNames: _col2
+                Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE
                 Filter Operator
                   predicate: (_col2 <= 0.1) (type: boolean)
-                  Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col0 (type: string), _col2 (type: double)
+                    expressions: '100' (type: string), _col2 (type: double)
                     outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -71,34 +71,34 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key = 100) (type: boolean)
-              Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), rand() (type: double)
-                outputColumnNames: _col0, _col2
-                Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+                expressions: rand() (type: double)
+                outputColumnNames: _col2
+                Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE
                 Filter Operator
                   predicate: (_col2 <= 0.1) (type: boolean)
-                  Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col0 (type: string), _col2 (type: double)
-                    outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                    expressions: _col2 (type: double)
+                    outputColumnNames: _col1
+                    Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                     Filter Operator
                       predicate: (_col1 > 0.1) (type: boolean)
-                      Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 107 Data size: 321 Basic stats: COMPLETE Column stats: NONE
                       Select Operator
-                        expressions: _col0 (type: string), _col1 (type: double)
+                        expressions: '100' (type: string), _col1 (type: double)
                         outputColumnNames: _col0, _col1
-                        Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 107 Data size: 321 Basic stats: COMPLETE Column stats: NONE
                         Limit
                           Number of rows: 20
-                          Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 20 Data size: 60 Basic stats: COMPLETE Column stats: NONE
                           File Output Operator
                             compressed: false
-                            Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 20 Data size: 60 Basic stats: COMPLETE Column stats: NONE
                             table:
                                 input format: org.apache.hadoop.mapred.TextInputFormat
                                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -130,24 +130,24 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key = 100) (type: boolean)
-              Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), rand() (type: double), hex(4) (type: string)
-                outputColumnNames: _col0, _col2, _col3
-                Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+                expressions: rand() (type: double), '4' (type: string)
+                outputColumnNames: _col2, _col3
+                Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE
                 Filter Operator
                   predicate: (_col3 <= 3) (type: boolean)
-                  Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col0 (type: string), _col2 (type: double), _col3 (type: string)
+                    expressions: '100' (type: string), _col2 (type: double), _col3 (type: string)
                     outputColumnNames: _col0, _col1, _col2
-                    Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -179,24 +179,24 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            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 = 100) (type: boolean)
-              Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 28 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), rand() (type: double), (value * 10) (type: double)
-                outputColumnNames: _col0, _col2, _col3
-                Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                expressions: rand() (type: double), (value * 10) (type: double)
+                outputColumnNames: _col2, _col3
+                Statistics: Num rows: 28 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
                 Filter Operator
                   predicate: (_col3 <= 200.0) (type: boolean)
-                  Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 9 Data size: 934 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col0 (type: string), _col2 (type: double), _col3 (type: double)
+                    expressions: '100' (type: string), _col2 (type: double), _col3 (type: double)
                     outputColumnNames: _col0, _col1, _col2
-                    Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 9 Data size: 934 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 9 Data size: 934 Basic stats: COMPLETE Column stats: NONE
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -228,24 +228,24 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key = 100) (type: boolean)
-              Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), rand() (type: double)
-                outputColumnNames: _col0, _col2
-                Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+                expressions: rand() (type: double)
+                outputColumnNames: _col2
+                Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE
                 Filter Operator
                   predicate: (_col2 <= 0.1) (type: boolean)
-                  Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col0 (type: string), _col2 (type: double)
+                    expressions: '100' (type: string), _col2 (type: double)
                     outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -281,27 +281,27 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key = 100) (type: boolean)
-              Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), rand() (type: double)
-                outputColumnNames: _col0, _col2
-                Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+                expressions: rand() (type: double)
+                outputColumnNames: _col2
+                Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE
                 Filter Operator
                   predicate: ((_col2 <= 0.1) and (_col2 > 0.1)) (type: boolean)
-                  Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 107 Data size: 321 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col0 (type: string), _col2 (type: double)
+                    expressions: '100' (type: string), _col2 (type: double)
                     outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 107 Data size: 321 Basic stats: COMPLETE Column stats: NONE
                     Limit
                       Number of rows: 20
-                      Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 20 Data size: 60 Basic stats: COMPLETE Column stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 20 Data size: 60 Basic stats: COMPLETE Column stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -333,24 +333,24 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key = 100) (type: boolean)
-              Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), rand() (type: double), hex(4) (type: string)
-                outputColumnNames: _col0, _col2, _col3
-                Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+                expressions: rand() (type: double), '4' (type: string)
+                outputColumnNames: _col2, _col3
+                Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE
                 Filter Operator
                   predicate: (_col3 <= 3) (type: boolean)
-                  Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col0 (type: string), _col2 (type: double), _col3 (type: string)
+                    expressions: '100' (type: string), _col2 (type: double), _col3 (type: string)
                     outputColumnNames: _col0, _col1, _col2
-                    Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -382,24 +382,24 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            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 = 100) (type: boolean)
-              Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 28 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), rand() (type: double), (value * 10) (type: double)
-                outputColumnNames: _col0, _col2, _col3
-                Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                expressions: rand() (type: double), (value * 10) (type: double)
+                outputColumnNames: _col2, _col3
+                Statistics: Num rows: 28 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
                 Filter Operator
                   predicate: (_col3 <= 200.0) (type: boolean)
-                  Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 9 Data size: 934 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col0 (type: string), _col2 (type: double), _col3 (type: double)
+                    expressions: '100' (type: string), _col2 (type: double), _col3 (type: double)
                     outputColumnNames: _col0, _col1, _col2
-                    Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 9 Data size: 934 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 9 Data size: 934 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/ppd_union_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_union_view.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/ppd_union_view.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/ppd_union_view.q.out Mon Jul 28 23:20:54 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/query_result_fileformat.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/query_result_fileformat.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/query_result_fileformat.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/query_result_fileformat.q.out Mon Jul 28 23:20:54 2014
@@ -53,7 +53,7 @@ STAGE PLANS:
               predicate: (key = 'key1') (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: 'key1' (type: string), value (type: string)
                 outputColumnNames: _col0, _col1
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 File Output Operator
@@ -124,7 +124,7 @@ STAGE PLANS:
               predicate: (key = 'key1') (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: 'key1' (type: string), 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/quotedid_basic.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/quotedid_basic.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/quotedid_basic.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/quotedid_basic.q.out Mon Jul 28 23:20:54 2014
@@ -76,7 +76,7 @@ STAGE PLANS:
               predicate: (!@#$%^&*()_q = '1') (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
-                expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
+                expressions: x+1 (type: string), y&y (type: string), '1' (type: string)
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 File Output Operator
@@ -112,7 +112,7 @@ STAGE PLANS:
               predicate: (!@#$%^&*()_q = '1') (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
-                expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
+                expressions: x+1 (type: string), y&y (type: string), '1' (type: string)
                 outputColumnNames: x+1, y&y, !@#$%^&*()_q
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Group By Operator
@@ -171,7 +171,7 @@ STAGE PLANS:
               predicate: (!@#$%^&*()_q = '1') (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
-                expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
+                expressions: x+1 (type: string), y&y (type: string), '1' (type: string)
                 outputColumnNames: x+1, y&y, !@#$%^&*()_q
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Group By Operator
@@ -254,7 +254,7 @@ STAGE PLANS:
               predicate: (!@#$%^&*()_q = '1') (type: boolean)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
-                expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
+                expressions: x+1 (type: string), y&y (type: string), '1' (type: string)
                 outputColumnNames: x+1, y&y, !@#$%^&*()_q
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Group By Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/quotedid_partition.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/quotedid_partition.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/quotedid_partition.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/quotedid_partition.q.out Mon Jul 28 23:20:54 2014
@@ -45,7 +45,7 @@ STAGE PLANS:
               predicate: (x+1 = '10') (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
+                expressions: '10' (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
                 outputColumnNames: x+1, y&y, !@#$%^&*()_q
                 Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                 Group By Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/regex_col.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/regex_col.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/regex_col.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/regex_col.q.out Mon Jul 28 23:20:54 2014
@@ -179,26 +179,26 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: b
-            Statistics: Num rows: 232 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 7748 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: ((key = 103) and key is not null) (type: boolean)
-              Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
-                key expressions: key (type: string), hr (type: string), ds (type: string)
+                key expressions: '103' (type: string), hr (type: string), ds (type: string)
                 sort order: +++
-                Map-reduce partition columns: key (type: string), hr (type: string), ds (type: string)
-                Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+                Map-reduce partition columns: hr (type: string), ds (type: string)
+                Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
           TableScan
             alias: a
-            Statistics: Num rows: 232 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 7748 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: ((key = 103) and key is not null) (type: boolean)
-              Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
-                key expressions: key (type: string), hr (type: string), ds (type: string)
+                key expressions: '103' (type: string), hr (type: string), ds (type: string)
                 sort order: +++
-                Map-reduce partition columns: key (type: string), hr (type: string), ds (type: string)
-                Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+                Map-reduce partition columns: hr (type: string), ds (type: string)
+                Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -207,11 +207,11 @@ STAGE PLANS:
             0 
             1 {KEY.reducesinkkey2} {KEY.reducesinkkey1}
           outputColumnNames: _col8, _col9
-          Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
+          Statistics: Num rows: 2130 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
           Select Operator
             expressions: _col8 (type: string), _col9 (type: string)
             outputColumnNames: _col0, _col1
-            Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 2130 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
             File Output Operator
               compressed: false
               table:
@@ -226,15 +226,15 @@ STAGE PLANS:
             Reduce Output Operator
               key expressions: _col0 (type: string), _col1 (type: string)
               sort order: ++
-              Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 2130 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
+          Statistics: Num rows: 2130 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 2130 Data size: 6393 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/regexp_extract.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/regexp_extract.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/regexp_extract.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/regexp_extract.q.out Mon Jul 28 23:20:54 2014 differ

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

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/select_dummy_source.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/select_dummy_source.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/select_dummy_source.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/select_dummy_source.q.out Mon Jul 28 23:20:54 2014
@@ -64,7 +64,7 @@ STAGE PLANS:
             Row Limit Per Split: 1
             Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
             Select Operator
-              expressions: (1 + 1) (type: int)
+              expressions: 2 (type: int)
               outputColumnNames: _col0
               Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
               File Output Operator
@@ -193,7 +193,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
           Select Operator
-            expressions: (1 + 1) (type: int)
+            expressions: 2 (type: int)
             outputColumnNames: _col0
             Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
             ListSink
@@ -277,7 +277,7 @@ STAGE PLANS:
             Row Limit Per Split: 1
             Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
             Select Operator
-              expressions: (2 + 3) (type: int), (1 + 2) (type: int)
+              expressions: 5 (type: int), (1 + 2) (type: int)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
               File Output Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/select_unquote_and.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/select_unquote_and.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/select_unquote_and.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/select_unquote_and.q.out Mon Jul 28 23:20:54 2014
@@ -58,7 +58,7 @@ STAGE PLANS:
             alias: npe_test
             Statistics: Num rows: 498 Data size: 5290 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
-              predicate: ((ds > ((2012 - 11) - 31)) and (ds < ((2012 - 12) - 15))) (type: boolean)
+              predicate: ((ds > 1970) and (ds < 1985)) (type: boolean)
               Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string), ds (type: string)

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/select_unquote_not.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/select_unquote_not.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/select_unquote_not.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/select_unquote_not.q.out Mon Jul 28 23:20:54 2014
@@ -58,7 +58,7 @@ STAGE PLANS:
             alias: npe_test
             Statistics: Num rows: 498 Data size: 5290 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
-              predicate: (not (ds < ((2012 - 11) - 31))) (type: boolean)
+              predicate: (not (ds < 1970)) (type: boolean)
               Statistics: Num rows: 332 Data size: 3526 Basic stats: COMPLETE Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string), ds (type: string)

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/select_unquote_or.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/select_unquote_or.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/select_unquote_or.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/select_unquote_or.q.out Mon Jul 28 23:20:54 2014
@@ -58,7 +58,7 @@ STAGE PLANS:
             alias: npe_test
             Statistics: Num rows: 498 Data size: 5290 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
-              predicate: ((ds > ((2012 - 11) - 31)) or (ds < ((2012 - 12) - 15))) (type: boolean)
+              predicate: ((ds > 1970) or (ds < 1985)) (type: boolean)
               Statistics: Num rows: 332 Data size: 3526 Basic stats: COMPLETE Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string), ds (type: string)

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/set_processor_namespaces.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/set_processor_namespaces.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/set_processor_namespaces.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/set_processor_namespaces.q.out Mon Jul 28 23:20:54 2014
@@ -17,17 +17,17 @@ 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 = 5) (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
               Select Operator
-                expressions: key (type: string), value (type: string)
+                expressions: '5' (type: string), value (type: string)
                 outputColumnNames: _col0, _col1
-                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
                 File Output Operator
                   compressed: false
-                  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
                   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/set_variable_sub.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/set_variable_sub.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/set_variable_sub.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/set_variable_sub.q.out Mon Jul 28 23:20:54 2014
@@ -12,17 +12,17 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 54 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key = 'value1') (type: boolean)
-              Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), value (type: string)
+                expressions: 'value1' (type: string), value (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -48,17 +48,17 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: src
-            Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 54 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key = 'value1') (type: boolean)
-              Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), value (type: string)
+                expressions: 'value1' (type: string), value (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -84,17 +84,17 @@ 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 = '1') (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
               Select Operator
-                expressions: key (type: string), value (type: string)
+                expressions: '1' (type: string), value (type: string)
                 outputColumnNames: _col0, _col1
-                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
                 File Output Operator
                   compressed: false
-                  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
                   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/smb_mapjoin_18.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/smb_mapjoin_18.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/smb_mapjoin_18.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/smb_mapjoin_18.q.out Mon Jul 28 23:20:54 2014
@@ -208,12 +208,14 @@ POSTHOOK: Input: default@test_table2@ds=
 253
 PREHOOK: query: -- Insert data into the bucketed table by selecting from another bucketed table
 -- This should be a map-only operation, one of the buckets should be empty
+
 EXPLAIN
 INSERT OVERWRITE TABLE test_table2 PARTITION (ds = '2')
 SELECT a.key, a.value FROM test_table1 a WHERE a.ds = '1' and a.key = 238
 PREHOOK: type: QUERY
 POSTHOOK: query: -- Insert data into the bucketed table by selecting from another bucketed table
 -- This should be a map-only operation, one of the buckets should be empty
+
 EXPLAIN
 INSERT OVERWRITE TABLE test_table2 PARTITION (ds = '2')
 SELECT a.key, a.value FROM test_table1 a WHERE a.ds = '1' and a.key = 238

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out Mon Jul 28 23:20:54 2014
@@ -66,9 +66,8 @@ STAGE PLANS:
               predicate: (key is not null and (key = 5)) (type: boolean)
               Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
-                key expressions: key (type: int)
+                key expressions: 5 (type: int)
                 sort order: +
-                Map-reduce partition columns: key (type: int)
                 Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE
           TableScan
             alias: a
@@ -77,21 +76,19 @@ STAGE PLANS:
               predicate: (key is not null and (key = 5)) (type: boolean)
               Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
-                key expressions: key (type: int)
+                key expressions: 5 (type: int)
                 sort order: +
-                Map-reduce partition columns: key (type: int)
                 Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {KEY.reducesinkkey0}
+            0 
             1 
-          outputColumnNames: _col0
           Statistics: Num rows: 14 Data size: 57 Basic stats: COMPLETE Column stats: NONE
           Select Operator
-            expressions: _col0 (type: int)
+            expressions: 5 (type: int)
             outputColumnNames: _col0
             Statistics: Num rows: 14 Data size: 57 Basic stats: COMPLETE Column stats: NONE
             File Output Operator
@@ -129,7 +126,7 @@ STAGE PLANS:
             predicate: (_col1 = 5) (type: boolean)
             Statistics: Num rows: 8 Data size: 33 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col0 (type: int), _col1 (type: int)
+              expressions: _col0 (type: int), 5 (type: int)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 8 Data size: 33 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -150,9 +147,8 @@ STAGE PLANS:
               predicate: (key is not null and (key = 5)) (type: boolean)
               Statistics: Num rows: 14 Data size: 56 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
-                key expressions: key (type: int)
+                key expressions: 5 (type: int)
                 sort order: +
-                Map-reduce partition columns: key (type: int)
                 Statistics: Num rows: 14 Data size: 56 Basic stats: COMPLETE Column stats: NONE
           TableScan
             alias: c
@@ -161,21 +157,19 @@ STAGE PLANS:
               predicate: (key is not null and (key = 5)) (type: boolean)
               Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
-                key expressions: key (type: int)
+                key expressions: 5 (type: int)
                 sort order: +
-                Map-reduce partition columns: key (type: int)
                 Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {KEY.reducesinkkey0}
+            0 
             1 
-          outputColumnNames: _col0
           Statistics: Num rows: 15 Data size: 61 Basic stats: COMPLETE Column stats: NONE
           Select Operator
-            expressions: _col0 (type: int)
+            expressions: 5 (type: int)
             outputColumnNames: _col0
             Statistics: Num rows: 15 Data size: 61 Basic stats: COMPLETE Column stats: NONE
             File Output Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out Mon Jul 28 23:20:54 2014
@@ -28,26 +28,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: 51 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (key = 'no_such_value') (type: boolean)
-              Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 25 Data size: 2849 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: key (type: string), value (type: string)
+                expressions: 'no_such_value' (type: string), value (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 25 Data size: 2849 Basic stats: COMPLETE Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col1 (type: string)
                   sort order: +
                   Map-reduce partition columns: _col1 (type: string)
-                  Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 25 Data size: 2849 Basic stats: COMPLETE Column stats: NONE
                   value expressions: _col0 (type: string), _col1 (type: string)
       Reduce Operator Tree:
         Extract
-          Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+          Statistics: Num rows: 25 Data size: 2849 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 25 Data size: 2849 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/subq_where_serialization.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subq_where_serialization.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subq_where_serialization.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subq_where_serialization.q.out Mon Jul 28 23:20:54 2014
@@ -93,17 +93,15 @@ STAGE PLANS:
                   0 key (type: string)
                   1 _col0 (type: string)
                 outputColumnNames: _col0
-                Filter Operator
-                  predicate: (1 = 1) (type: boolean)
-                  Select Operator
-                    expressions: _col0 (type: string)
-                    outputColumnNames: _col0
-                    File Output Operator
-                      compressed: false
-                      table:
-                          input format: org.apache.hadoop.mapred.TextInputFormat
-                          output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                          serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                Select Operator
+                  expressions: _col0 (type: string)
+                  outputColumnNames: _col0
+                  File Output Operator
+                    compressed: false
+                    table:
+                        input format: org.apache.hadoop.mapred.TextInputFormat
+                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
       Local Work:
         Map Reduce Local Work
 
@@ -136,20 +134,17 @@ STAGE PLANS:
             1 
           outputColumnNames: _col0
           Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
-          Filter Operator
-            predicate: (1 = 1) (type: boolean)
+          Select Operator
+            expressions: _col0 (type: string)
+            outputColumnNames: _col0
             Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: _col0 (type: string)
-              outputColumnNames: _col0
+            File Output Operator
+              compressed: false
               Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_exists.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_exists.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_exists.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_exists.q.out Mon Jul 28 23:20:54 2014
@@ -66,20 +66,17 @@ STAGE PLANS:
             1 
           outputColumnNames: _col0, _col1
           Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
-          Filter Operator
-            predicate: (1 = 1) (type: boolean)
+          Select Operator
+            expressions: _col0 (type: string), _col1 (type: string)
+            outputColumnNames: _col0, _col1
             Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: _col0 (type: string), _col1 (type: string)
-              outputColumnNames: _col0, _col1
+            File Output Operator
+              compressed: false
               Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_exists_having.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_exists_having.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_exists_having.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_exists_having.q.out Mon Jul 28 23:20:54 2014
@@ -104,20 +104,17 @@ STAGE PLANS:
             1 
           outputColumnNames: _col0, _col1
           Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
-          Filter Operator
-            predicate: (1 = 1) (type: boolean)
+          Select Operator
+            expressions: _col0 (type: string), _col1 (type: bigint)
+            outputColumnNames: _col0, _col1
             Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: _col0 (type: string), _col1 (type: bigint)
-              outputColumnNames: _col0, _col1
+            File Output Operator
+              compressed: false
               Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator
@@ -244,20 +241,17 @@ STAGE PLANS:
                   1 
                 outputColumnNames: _col0, _col1
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-                Filter Operator
-                  predicate: (1 = 1) (type: boolean)
+                Select Operator
+                  expressions: _col0 (type: string), _col1 (type: bigint)
+                  outputColumnNames: _col0, _col1
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-                  Select Operator
-                    expressions: _col0 (type: string), _col1 (type: bigint)
-                    outputColumnNames: _col0, _col1
+                  File Output Operator
+                    compressed: false
                     Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-                    File Output Operator
-                      compressed: false
-                      Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-                      table:
-                          input format: org.apache.hadoop.mapred.TextInputFormat
-                          output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                          serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                    table:
+                        input format: org.apache.hadoop.mapred.TextInputFormat
+                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           Mux Operator
             Statistics: Num rows: 51 Data size: 5862 Basic stats: COMPLETE Column stats: NONE
             Join Operator
@@ -268,20 +262,17 @@ STAGE PLANS:
                 1 
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-              Filter Operator
-                predicate: (1 = 1) (type: boolean)
+              Select Operator
+                expressions: _col0 (type: string), _col1 (type: bigint)
+                outputColumnNames: _col0, _col1
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-                Select Operator
-                  expressions: _col0 (type: string), _col1 (type: bigint)
-                  outputColumnNames: _col0, _col1
+                File Output Operator
+                  compressed: false
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-                  File Output Operator
-                    compressed: false
-                    Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-                    table:
-                        input format: org.apache.hadoop.mapred.TextInputFormat
-                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                  table:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_in.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_in.q.out?rev=1614214&r1=1614213&r2=1614214&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_in.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_in.q.out Mon Jul 28 23:20:54 2014
@@ -157,20 +157,17 @@ STAGE PLANS:
             1 
           outputColumnNames: _col0, _col1
           Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
-          Filter Operator
-            predicate: (1 = 1) (type: boolean)
+          Select Operator
+            expressions: _col0 (type: string), _col1 (type: string)
+            outputColumnNames: _col0, _col1
             Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: _col0 (type: string), _col1 (type: string)
-              outputColumnNames: _col0, _col1
+            File Output Operator
+              compressed: false
               Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator
@@ -269,20 +266,17 @@ STAGE PLANS:
             1 
           outputColumnNames: _col0, _col1
           Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
-          Filter Operator
-            predicate: (1 = 1) (type: boolean)
+          Select Operator
+            expressions: _col0 (type: string), _col1 (type: string)
+            outputColumnNames: _col0, _col1
             Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: _col0 (type: string), _col1 (type: string)
-              outputColumnNames: _col0, _col1
+            File Output Operator
+              compressed: false
               Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator
@@ -447,20 +441,17 @@ STAGE PLANS:
             1 
           outputColumnNames: _col1, _col5
           Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE
-          Filter Operator
-            predicate: (1 = 1) (type: boolean)
+          Select Operator
+            expressions: _col1 (type: string), _col5 (type: int)
+            outputColumnNames: _col0, _col1
             Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: _col1 (type: string), _col5 (type: int)
-              outputColumnNames: _col0, _col1
+            File Output Operator
+              compressed: false
               Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator
@@ -618,20 +609,17 @@ STAGE PLANS:
             1 
           outputColumnNames: _col1, _col2, _col5
           Statistics: Num rows: 4 Data size: 930 Basic stats: COMPLETE Column stats: NONE
-          Filter Operator
-            predicate: (1 = 1) (type: boolean)
+          Select Operator
+            expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int)
+            outputColumnNames: _col0, _col1, _col2
             Statistics: Num rows: 4 Data size: 930 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int)
-              outputColumnNames: _col0, _col1, _col2
+            File Output Operator
+              compressed: false
               Statistics: Num rows: 4 Data size: 930 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 4 Data size: 930 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator
@@ -763,20 +751,17 @@ STAGE PLANS:
             1 
           outputColumnNames: _col0, _col1
           Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
-          Filter Operator
-            predicate: (1 = 1) (type: boolean)
+          Select Operator
+            expressions: _col0 (type: string), _col1 (type: string)
+            outputColumnNames: _col0, _col1
             Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: _col0 (type: string), _col1 (type: string)
-              outputColumnNames: _col0, _col1
+            File Output Operator
+              compressed: false
               Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator
@@ -947,24 +932,24 @@ STAGE PLANS:
               value expressions: _col0 (type: int), _col3 (type: int)
           TableScan
             alias: lineitem
-            Statistics: Num rows: 116 Data size: 12099 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 1728 Data size: 12099 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: ((l_shipmode = 'AIR') and l_orderkey is not null) (type: boolean)
-              Statistics: Num rows: 29 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 432 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
               Select Operator
                 expressions: l_orderkey (type: int)
                 outputColumnNames: _col0
-                Statistics: Num rows: 29 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 432 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
                 Group By Operator
                   keys: _col0 (type: int)
                   mode: hash
                   outputColumnNames: _col0
-                  Statistics: Num rows: 29 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 432 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
                   Reduce Output Operator
                     key expressions: _col0 (type: int)
                     sort order: +
                     Map-reduce partition columns: _col0 (type: int)
-                    Statistics: Num rows: 29 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 432 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Join Operator
           condition map:



Mime
View raw message