hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1548331 [7/7] - in /hive/trunk: common/src/java/org/apache/hadoop/hive/conf/ ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/ ql/src/java/org/apache/hadoop/hive/ql/plan/ ql/src/java/org/apache/hadoop/hive/ql/stats/ ql/src/...
Date Thu, 05 Dec 2013 23:58:26 GMT
Modified: hive/trunk/ql/src/test/results/clientpositive/stats11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats11.q.out?rev=1548331&r1=1548330&r2=1548331&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats11.q.out Thu Dec  5 23:58:22 2013
@@ -349,7 +349,7 @@ STAGE PLANS:
           TableScan
             alias: b
             Statistics:
-                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 55 dataSize: 5812 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             HashTable Sink Operator
               condition expressions:
@@ -375,7 +375,7 @@ STAGE PLANS:
           TableScan
             alias: a
             Statistics:
-                numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 26 dataSize: 2750 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Map Join Operator
               condition map:
@@ -390,7 +390,7 @@ STAGE PLANS:
               outputColumnNames: _col0, _col1, _col5
               Position of Big Table: 0
               Statistics:
-                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+                  numRows: 60 dataSize: 6393 basicStatsState: COMPLETE colStatsState: NONE
               BucketMapJoin: true
               Select Operator
                 expressions:
@@ -402,14 +402,14 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2
                 Statistics:
-                    numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+                    numRows: 60 dataSize: 6393 basicStatsState: COMPLETE colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Statistics:
-                      numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+                      numRows: 60 dataSize: 6393 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
@@ -850,7 +850,7 @@ STAGE PLANS:
           TableScan
             alias: a
             Statistics:
-                numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 26 dataSize: 2750 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             HashTable Sink Operator
               condition expressions:
@@ -876,7 +876,7 @@ STAGE PLANS:
           TableScan
             alias: b
             Statistics:
-                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 55 dataSize: 5812 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Map Join Operator
               condition map:
@@ -891,7 +891,7 @@ STAGE PLANS:
               outputColumnNames: _col0, _col1, _col5
               Position of Big Table: 1
               Statistics:
-                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+                  numRows: 60 dataSize: 6393 basicStatsState: COMPLETE colStatsState: NONE
               BucketMapJoin: true
               Select Operator
                 expressions:
@@ -903,14 +903,14 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2
                 Statistics:
-                    numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+                    numRows: 60 dataSize: 6393 basicStatsState: COMPLETE colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Statistics:
-                      numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+                      numRows: 60 dataSize: 6393 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/trunk/ql/src/test/results/clientpositive/transform_ppr1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/transform_ppr1.q.out?rev=1548331&r1=1548330&r2=1548331&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/transform_ppr1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/transform_ppr1.q.out Thu Dec  5 23:58:22 2013
@@ -31,7 +31,7 @@ STAGE PLANS:
           TableScan
             alias: src
             Statistics:
-                numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 116 dataSize: 23248 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
@@ -43,7 +43,7 @@ STAGE PLANS:
                     type: string
               outputColumnNames: _col0, _col1, _col2
               Statistics:
-                  numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 116 dataSize: 23248 basicStatsState: COMPLETE colStatsState: NONE
               Transform Operator
                 command: cat
                 output info:
@@ -57,14 +57,14 @@ STAGE PLANS:
                       serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 Statistics:
-                    numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 116 dataSize: 23248 basicStatsState: COMPLETE colStatsState: NONE
                 Filter Operator
                   isSamplingPred: false
                   predicate:
                       expr: ((_col1 < 100) and (_col0 = '2008-04-08'))
                       type: boolean
                   Statistics:
-                      numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
                   Reduce Output Operator
                     key expressions:
                           expr: _col1
@@ -74,7 +74,7 @@ STAGE PLANS:
                           expr: _col1
                           type: string
                     Statistics:
-                        numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                        numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
                     tag: -1
                     value expressions:
                           expr: _col0
@@ -263,7 +263,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col1
@@ -272,14 +272,14 @@ STAGE PLANS:
                   type: string
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/trunk/ql/src/test/results/clientpositive/transform_ppr2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/transform_ppr2.q.out?rev=1548331&r1=1548330&r2=1548331&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/transform_ppr2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/transform_ppr2.q.out Thu Dec  5 23:58:22 2013
@@ -33,7 +33,7 @@ STAGE PLANS:
           TableScan
             alias: src
             Statistics:
-                numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 58 dataSize: 11624 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
@@ -45,7 +45,7 @@ STAGE PLANS:
                     type: string
               outputColumnNames: _col0, _col1, _col2
               Statistics:
-                  numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 58 dataSize: 11624 basicStatsState: COMPLETE colStatsState: NONE
               Transform Operator
                 command: cat
                 output info:
@@ -59,14 +59,14 @@ STAGE PLANS:
                       serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 Statistics:
-                    numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 58 dataSize: 11624 basicStatsState: COMPLETE colStatsState: NONE
                 Filter Operator
                   isSamplingPred: false
                   predicate:
                       expr: (_col1 < 100)
                       type: boolean
                   Statistics:
-                      numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
                   Reduce Output Operator
                     key expressions:
                           expr: _col1
@@ -76,7 +76,7 @@ STAGE PLANS:
                           expr: _col1
                           type: string
                     Statistics:
-                        numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                        numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
                     tag: -1
                     value expressions:
                           expr: _col0
@@ -179,7 +179,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col1
@@ -188,14 +188,14 @@ STAGE PLANS:
                   type: string
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out?rev=1548331&r1=1548330&r2=1548331&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out Thu Dec  5 23:58:22 2013
@@ -240,7 +240,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
+              numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
@@ -249,14 +249,14 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
+                numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -553,7 +553,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1, _col2
           Statistics:
-              numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
+              numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
@@ -564,14 +564,14 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1, _col2
             Statistics:
-                numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
+                numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/trunk/ql/src/test/results/clientpositive/udf_reflect.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_reflect.q.out?rev=1548331&r1=1548330&r2=1548331&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_reflect.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_reflect.q.out Thu Dec  5 23:58:22 2013
@@ -48,7 +48,7 @@ STAGE PLANS:
           alias: src
           Row Limit Per Split: 1
           Statistics:
-              numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 58 dataSize: 5812 basicStatsState: COMPLETE colStatsState: NONE
           GatherStats: false
           Select Operator
             expressions:
@@ -70,7 +70,7 @@ STAGE PLANS:
                   type: string
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
             Statistics:
-                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 58 dataSize: 5812 basicStatsState: COMPLETE colStatsState: NONE
             ListSink
 
 

Modified: hive/trunk/ql/src/test/results/clientpositive/udf_reflect2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_reflect2.q.out?rev=1548331&r1=1548330&r2=1548331&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_reflect2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_reflect2.q.out Thu Dec  5 23:58:22 2013
@@ -93,7 +93,7 @@ STAGE PLANS:
           TableScan
             alias: src
             Statistics:
-                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 29 dataSize: 5812 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
@@ -105,7 +105,7 @@ STAGE PLANS:
                     type: timestamp
               outputColumnNames: _col0, _col1, _col2
               Statistics:
-                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 29 dataSize: 5812 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: _col0
@@ -172,17 +172,17 @@ STAGE PLANS:
                       type: bigint
                 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, _col27, _col28, _col29, _col30
                 Statistics:
-                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 29 dataSize: 5812 basicStatsState: COMPLETE colStatsState: NONE
                 Limit
                   Statistics:
-                      numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 5 dataSize: 1000 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                        numRows: 5 dataSize: 1000 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out?rev=1548331&r1=1548330&r2=1548331&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out Thu Dec  5 23:58:22 2013
@@ -310,7 +310,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
+              numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
@@ -319,14 +319,14 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
+                numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -624,7 +624,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1, _col2
           Statistics:
-              numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
+              numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
@@ -635,14 +635,14 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1, _col2
             Statistics:
-                numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
+                numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/trunk/ql/src/test/results/clientpositive/union22.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union22.q.out?rev=1548331&r1=1548330&r2=1548331&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union22.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union22.q.out Thu Dec  5 23:58:22 2013
@@ -334,7 +334,7 @@ STAGE PLANS:
             GatherStats: false
             Union
               Statistics:
-                  numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 348 dataSize: 9684 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: _col0
@@ -347,7 +347,7 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 348 dataSize: 9684 basicStatsState: COMPLETE colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
@@ -355,7 +355,7 @@ STAGE PLANS:
                   NumFilesPerFileSink: 1
                   Static Partition Specification: ds=2/
                   Statistics:
-                      numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 348 dataSize: 9684 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
@@ -388,7 +388,7 @@ STAGE PLANS:
                   expr: (k0 <= 50)
                   type: boolean
               Statistics:
-                  numRows: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 166 dataSize: 5622 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: k1
@@ -401,10 +401,10 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 166 dataSize: 5622 basicStatsState: COMPLETE colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 348 dataSize: 9684 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -417,7 +417,7 @@ STAGE PLANS:
                           type: string
                     outputColumnNames: _col0, _col1, _col2, _col3
                     Statistics:
-                        numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 348 dataSize: 9684 basicStatsState: COMPLETE colStatsState: NONE
                     File Output Operator
                       compressed: false
                       GlobalTableId: 1
@@ -425,7 +425,7 @@ STAGE PLANS:
                       NumFilesPerFileSink: 1
                       Static Partition Specification: ds=2/
                       Statistics:
-                          numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 348 dataSize: 9684 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
@@ -558,7 +558,7 @@ STAGE PLANS:
                   expr: (k1 > 20)
                   type: boolean
               Statistics:
-                  numRows: 250 dataSize: 5500 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 166 dataSize: 3693 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: k1
@@ -568,7 +568,7 @@ STAGE PLANS:
                       expr: k1
                       type: string
                 Statistics:
-                    numRows: 250 dataSize: 5500 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 166 dataSize: 3693 basicStatsState: COMPLETE colStatsState: NONE
                 tag: 0
                 value expressions:
                       expr: k1
@@ -589,7 +589,7 @@ STAGE PLANS:
                   expr: ((k0 > 50) and (k1 > 20))
                   type: boolean
               Statistics:
-                  numRows: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 55 dataSize: 1862 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: k1
@@ -600,7 +600,7 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col1, _col3, _col4
                 Statistics:
-                    numRows: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 55 dataSize: 1862 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col1
@@ -610,7 +610,7 @@ STAGE PLANS:
                         expr: _col1
                         type: string
                   Statistics:
-                      numRows: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 55 dataSize: 1862 basicStatsState: COMPLETE colStatsState: NONE
                   tag: 1
                   value expressions:
                         expr: _col3
@@ -721,7 +721,7 @@ STAGE PLANS:
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col10, _col11
           Statistics:
-              numRows: 31250 dataSize: 1718750 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 182 dataSize: 4062 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -734,7 +734,7 @@ STAGE PLANS:
                   type: string
             outputColumnNames: _col0, _col1, _col2, _col3
             Statistics:
-                numRows: 31250 dataSize: 1718750 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 182 dataSize: 4062 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0

Modified: hive/trunk/ql/src/test/results/clientpositive/union24.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union24.q.out?rev=1548331&r1=1548330&r2=1548331&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union24.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union24.q.out Thu Dec  5 23:58:22 2013
@@ -74,14 +74,14 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
                       type: string
                 outputColumnNames: key
                 Statistics:
-                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                 Group By Operator
                   aggregations:
                         expr: count(1)
@@ -92,7 +92,7 @@ STAGE PLANS:
                   mode: hash
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                   Reduce Output Operator
                     key expressions:
                           expr: _col0
@@ -102,7 +102,7 @@ STAGE PLANS:
                           expr: _col0
                           type: string
                     Statistics:
-                        numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                     tag: -1
                     value expressions:
                           expr: _col1
@@ -166,7 +166,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 77 dataSize: 308 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 51 dataSize: 244 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -175,7 +175,7 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 77 dataSize: 308 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 51 dataSize: 244 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
@@ -202,7 +202,7 @@ STAGE PLANS:
             GatherStats: false
             Union
               Statistics:
-                  numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: _col0
@@ -211,7 +211,7 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -220,7 +220,7 @@ STAGE PLANS:
                         type: bigint
                   sort order: ++
                   Statistics:
-                      numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -239,7 +239,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -248,10 +248,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -260,7 +260,7 @@ STAGE PLANS:
                           type: bigint
                     outputColumnNames: _col0, _col1
                     Statistics:
-                        numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -269,7 +269,7 @@ STAGE PLANS:
                             type: bigint
                       sort order: ++
                       Statistics:
-                          numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -288,7 +288,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -297,10 +297,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -309,7 +309,7 @@ STAGE PLANS:
                           type: bigint
                     outputColumnNames: _col0, _col1
                     Statistics:
-                        numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -318,7 +318,7 @@ STAGE PLANS:
                             type: bigint
                       sort order: ++
                       Statistics:
-                          numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -337,7 +337,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -346,10 +346,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -358,7 +358,7 @@ STAGE PLANS:
                           type: bigint
                     outputColumnNames: _col0, _col1
                     Statistics:
-                        numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -367,7 +367,7 @@ STAGE PLANS:
                             type: bigint
                       sort order: ++
                       Statistics:
-                          numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -532,14 +532,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
             Statistics:
-                numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 360 dataSize: 1726 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -661,7 +661,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: key
@@ -671,7 +671,7 @@ STAGE PLANS:
                       expr: key
                       type: string
                 Statistics:
-                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                 tag: 0
                 value expressions:
                       expr: key
@@ -688,7 +688,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: key
@@ -698,7 +698,7 @@ STAGE PLANS:
                       expr: key
                       type: string
                 Statistics:
-                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                 tag: 1
                 value expressions:
                       expr: count
@@ -804,7 +804,7 @@ STAGE PLANS:
           handleSkewJoin: false
           outputColumnNames: _col0, _col5
           Statistics:
-              numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 113 dataSize: 543 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -813,7 +813,7 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 113 dataSize: 543 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
@@ -840,7 +840,7 @@ STAGE PLANS:
             GatherStats: false
             Union
               Statistics:
-                  numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 319 dataSize: 1531 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: _col0
@@ -849,7 +849,7 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 319 dataSize: 1531 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -858,7 +858,7 @@ STAGE PLANS:
                         type: bigint
                   sort order: ++
                   Statistics:
-                      numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 319 dataSize: 1531 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -877,7 +877,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -886,10 +886,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 319 dataSize: 1531 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -898,7 +898,7 @@ STAGE PLANS:
                           type: bigint
                     outputColumnNames: _col0, _col1
                     Statistics:
-                        numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 319 dataSize: 1531 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -907,7 +907,7 @@ STAGE PLANS:
                             type: bigint
                       sort order: ++
                       Statistics:
-                          numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 319 dataSize: 1531 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -926,7 +926,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -935,10 +935,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 319 dataSize: 1531 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -947,7 +947,7 @@ STAGE PLANS:
                           type: bigint
                     outputColumnNames: _col0, _col1
                     Statistics:
-                        numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 319 dataSize: 1531 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -956,7 +956,7 @@ STAGE PLANS:
                             type: bigint
                       sort order: ++
                       Statistics:
-                          numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 319 dataSize: 1531 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -1078,14 +1078,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 319 dataSize: 1531 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
             Statistics:
-                numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 319 dataSize: 1531 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1198,7 +1198,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: key
@@ -1208,7 +1208,7 @@ STAGE PLANS:
                       expr: key
                       type: string
                 Statistics:
-                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                 tag: 0
                 value expressions:
                       expr: key
@@ -1225,7 +1225,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: key
@@ -1235,7 +1235,7 @@ STAGE PLANS:
                       expr: key
                       type: string
                 Statistics:
-                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                 tag: 1
       Path -> Alias:
 #### A masked pattern was here ####
@@ -1338,14 +1338,14 @@ STAGE PLANS:
           handleSkewJoin: false
           outputColumnNames: _col0
           Statistics:
-              numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 113 dataSize: 543 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
                   type: string
             outputColumnNames: _col0
             Statistics:
-                numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 113 dataSize: 543 basicStatsState: COMPLETE colStatsState: NONE
             Group By Operator
               aggregations:
                     expr: count(1)
@@ -1356,7 +1356,7 @@ STAGE PLANS:
               mode: hash
               outputColumnNames: _col0, _col1
               Statistics:
-                  numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 113 dataSize: 543 basicStatsState: COMPLETE colStatsState: NONE
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
@@ -1390,7 +1390,7 @@ STAGE PLANS:
                     expr: _col0
                     type: string
               Statistics:
-                  numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 113 dataSize: 543 basicStatsState: COMPLETE colStatsState: NONE
               tag: -1
               value expressions:
                     expr: _col1
@@ -1432,7 +1432,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 5929 dataSize: 47432 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 56 dataSize: 269 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -1441,7 +1441,7 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 5929 dataSize: 47432 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 56 dataSize: 269 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
@@ -1468,7 +1468,7 @@ STAGE PLANS:
             GatherStats: false
             Union
               Statistics:
-                  numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 262 dataSize: 1257 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: _col0
@@ -1477,7 +1477,7 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 262 dataSize: 1257 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -1486,7 +1486,7 @@ STAGE PLANS:
                         type: bigint
                   sort order: ++
                   Statistics:
-                      numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 262 dataSize: 1257 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -1505,7 +1505,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -1514,10 +1514,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 262 dataSize: 1257 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -1526,7 +1526,7 @@ STAGE PLANS:
                           type: bigint
                     outputColumnNames: _col0, _col1
                     Statistics:
-                        numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 262 dataSize: 1257 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -1535,7 +1535,7 @@ STAGE PLANS:
                             type: bigint
                       sort order: ++
                       Statistics:
-                          numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 262 dataSize: 1257 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -1554,7 +1554,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -1563,10 +1563,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 103 dataSize: 494 basicStatsState: COMPLETE colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 262 dataSize: 1257 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -1575,7 +1575,7 @@ STAGE PLANS:
                           type: bigint
                     outputColumnNames: _col0, _col1
                     Statistics:
-                        numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 262 dataSize: 1257 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -1584,7 +1584,7 @@ STAGE PLANS:
                             type: bigint
                       sort order: ++
                       Statistics:
-                          numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 262 dataSize: 1257 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -1706,14 +1706,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 262 dataSize: 1257 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
             Statistics:
-                numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 262 dataSize: 1257 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out?rev=1548331&r1=1548330&r2=1548331&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out Thu Dec  5 23:58:22 2013
@@ -31,7 +31,7 @@ STAGE PLANS:
           TableScan
             alias: x
             Statistics:
-                numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 58 dataSize: 11624 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
@@ -39,7 +39,7 @@ STAGE PLANS:
                   expr: (key < 100)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -52,10 +52,10 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 38 dataSize: 7614 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -68,7 +68,7 @@ STAGE PLANS:
                           type: string
                     outputColumnNames: _col0, _col1, _col2, _col3
                     Statistics:
-                        numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                        numRows: 38 dataSize: 7614 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -81,7 +81,7 @@ STAGE PLANS:
                             type: string
                       sort order: ++++
                       Statistics:
-                          numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                          numRows: 38 dataSize: 7614 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -96,7 +96,7 @@ STAGE PLANS:
           TableScan
             alias: y
             Statistics:
-                numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 58 dataSize: 11624 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
@@ -104,7 +104,7 @@ STAGE PLANS:
                   expr: (key < 100)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -117,10 +117,10 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 19 dataSize: 3807 basicStatsState: COMPLETE colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 38 dataSize: 7614 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -133,7 +133,7 @@ STAGE PLANS:
                           type: string
                     outputColumnNames: _col0, _col1, _col2, _col3
                     Statistics:
-                        numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                        numRows: 38 dataSize: 7614 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -146,7 +146,7 @@ STAGE PLANS:
                             type: string
                       sort order: ++++
                       Statistics:
-                          numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                          numRows: 38 dataSize: 7614 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -251,14 +251,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 38 dataSize: 7614 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
             Statistics:
-                numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 38 dataSize: 7614 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat



Mime
View raw message