You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by rh...@apache.org on 2013/11/25 20:15:56 UTC

svn commit: r1545372 [3/7] - in /hive/trunk/ql/src: java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/ java/org/apache/hadoop/hive/ql/plan/ java/org/apache/hadoop/hive/ql/stats/ test/queries/clientpositive/ test/results/clientpositive/

Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_sort_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_sort_1.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_sort_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_sort_1.q.out Mon Nov 25 19:15:54 2013
@@ -86,7 +86,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -95,14 +95,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -527,7 +527,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1, _col2
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -538,14 +538,14 @@ STAGE PLANS:
                   type: int
             outputColumnNames: _col0, _col1, _col2
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -688,7 +688,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -697,14 +697,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1092,7 +1092,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -1101,14 +1101,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1522,7 +1522,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1, _col2
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -1533,14 +1533,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1, _col2
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2013,7 +2013,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1, _col2, _col3
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -2026,14 +2026,14 @@ STAGE PLANS:
                   type: int
             outputColumnNames: _col0, _col1, _col2, _col3
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2290,7 +2290,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1, _col2
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -2301,14 +2301,14 @@ STAGE PLANS:
                   type: int
             outputColumnNames: _col0, _col1, _col2
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2507,7 +2507,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -2516,7 +2516,7 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Group By Operator
                     aggregations:
                           expr: sum(_col1)
@@ -2527,7 +2527,7 @@ STAGE PLANS:
                     mode: hash
                     outputColumnNames: _col0, _col1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -2537,7 +2537,7 @@ STAGE PLANS:
                             expr: _col0
                             type: double
                       Statistics:
-                          numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col1
@@ -2605,7 +2605,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -2614,14 +2614,14 @@ STAGE PLANS:
                   type: int
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2833,7 +2833,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -2842,10 +2842,10 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Union
                     Statistics:
-                        numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                     Select Operator
                       expressions:
                             expr: UDFToInteger(_col0)
@@ -2854,14 +2854,14 @@ STAGE PLANS:
                             type: int
                       outputColumnNames: _col0, _col1
                       Statistics:
-                          numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                       File Output Operator
                         compressed: false
                         GlobalTableId: 1
 #### A masked pattern was here ####
                         NumFilesPerFileSink: 1
                         Statistics:
-                            numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                            numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2909,7 +2909,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -2918,10 +2918,10 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Union
                     Statistics:
-                        numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                     Select Operator
                       expressions:
                             expr: UDFToInteger(_col0)
@@ -2930,14 +2930,14 @@ STAGE PLANS:
                             type: int
                       outputColumnNames: _col0, _col1
                       Statistics:
-                          numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                       File Output Operator
                         compressed: false
                         GlobalTableId: 1
 #### A masked pattern was here ####
                         NumFilesPerFileSink: 1
                         Statistics:
-                            numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                            numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3473,7 +3473,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -3482,7 +3482,7 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
@@ -3509,7 +3509,7 @@ STAGE PLANS:
             GatherStats: false
             Union
               Statistics:
-                  numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: UDFToInteger(_col0)
@@ -3518,14 +3518,14 @@ STAGE PLANS:
                       type: int
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Statistics:
-                      numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3573,7 +3573,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToDouble(_col0)
@@ -3582,10 +3582,10 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Union
                     Statistics:
-                        numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                     Select Operator
                       expressions:
                             expr: UDFToInteger(_col0)
@@ -3594,14 +3594,14 @@ STAGE PLANS:
                             type: int
                       outputColumnNames: _col0, _col1
                       Statistics:
-                          numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                       File Output Operator
                         compressed: false
                         GlobalTableId: 1
 #### A masked pattern was here ####
                         NumFilesPerFileSink: 1
                         Statistics:
-                            numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                            numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4080,7 +4080,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -4089,7 +4089,7 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Reduce Output Operator
                     key expressions:
                           expr: _col0
@@ -4099,7 +4099,7 @@ STAGE PLANS:
                           expr: _col0
                           type: string
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                     tag: 0
                     value expressions:
                           expr: _col0
@@ -4129,7 +4129,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -4138,7 +4138,7 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Reduce Output Operator
                     key expressions:
                           expr: _col0
@@ -4148,7 +4148,7 @@ STAGE PLANS:
                           expr: _col0
                           type: string
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                     tag: 1
                     value expressions:
                           expr: _col1
@@ -4214,6 +4214,8 @@ STAGE PLANS:
             1 {VALUE._col1}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col3
+          Statistics:
+              numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -4221,11 +4223,15 @@ STAGE PLANS:
                   expr: UDFToInteger((_col1 + _col3))
                   type: int
             outputColumnNames: _col0, _col1
+            Statistics:
+                numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4540,7 +4546,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1, _col2
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -4551,7 +4557,7 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1, _col2
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
@@ -4585,7 +4591,7 @@ STAGE PLANS:
                     expr: _col0
                     type: string
               Statistics:
-                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
               tag: 1
               value expressions:
                     expr: _col0
@@ -4617,7 +4623,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -4626,7 +4632,7 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Reduce Output Operator
                     key expressions:
                           expr: _col0
@@ -4636,7 +4642,7 @@ STAGE PLANS:
                           expr: _col0
                           type: string
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                     tag: 0
                     value expressions:
                           expr: _col0
@@ -4725,6 +4731,8 @@ STAGE PLANS:
             1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col2, _col3, _col4
+          Statistics:
+              numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -4738,11 +4746,15 @@ STAGE PLANS:
                   expr: _col4
                   type: bigint
             outputColumnNames: _col0, _col1, _col2, _col3, _col4
+            Statistics:
+                numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4995,7 +5007,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -5004,14 +5016,14 @@ STAGE PLANS:
                   type: int
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -5249,7 +5261,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -5262,14 +5274,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -5794,7 +5806,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -5809,14 +5821,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1, _col2, _col3, _col4
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -6278,7 +6290,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -6291,14 +6303,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -6820,7 +6832,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -6833,14 +6845,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 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/groupby_sort_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_sort_6.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_sort_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_sort_6.q.out Mon Nov 25 19:15:54 2013
@@ -487,7 +487,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 0 dataSize: 30 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 0 dataSize: 15 basicStatsState: PARTIAL colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -496,14 +496,14 @@ STAGE PLANS:
                   type: int
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 0 dataSize: 30 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 0 dataSize: 15 basicStatsState: PARTIAL colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 0 dataSize: 30 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 15 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out Mon Nov 25 19:15:54 2013
@@ -86,7 +86,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -95,14 +95,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -608,7 +608,7 @@ STAGE PLANS:
           mode: final
           outputColumnNames: _col0, _col1, _col2
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -619,14 +619,14 @@ STAGE PLANS:
                   type: int
             outputColumnNames: _col0, _col1, _col2
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -769,7 +769,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -778,14 +778,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1173,7 +1173,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -1182,14 +1182,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1603,7 +1603,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1, _col2
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -1614,14 +1614,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1, _col2
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2179,7 +2179,7 @@ STAGE PLANS:
           mode: final
           outputColumnNames: _col0, _col1, _col2, _col3
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -2192,14 +2192,14 @@ STAGE PLANS:
                   type: int
             outputColumnNames: _col0, _col1, _col2, _col3
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2537,7 +2537,7 @@ STAGE PLANS:
           mode: final
           outputColumnNames: _col0, _col1, _col2
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -2548,14 +2548,14 @@ STAGE PLANS:
                   type: int
             outputColumnNames: _col0, _col1, _col2
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2755,7 +2755,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -2764,7 +2764,7 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Group By Operator
                     aggregations:
                           expr: sum(_col1)
@@ -2775,7 +2775,7 @@ STAGE PLANS:
                     mode: hash
                     outputColumnNames: _col0, _col1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -2785,7 +2785,7 @@ STAGE PLANS:
                             expr: rand()
                             type: double
                       Statistics:
-                          numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col1
@@ -2853,7 +2853,7 @@ STAGE PLANS:
           mode: partials
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
@@ -2887,7 +2887,7 @@ STAGE PLANS:
                     expr: _col0
                     type: double
               Statistics:
-                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
               tag: -1
               value expressions:
                     expr: _col1
@@ -2929,7 +2929,7 @@ STAGE PLANS:
           mode: final
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -2938,14 +2938,14 @@ STAGE PLANS:
                   type: int
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3157,7 +3157,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -3166,10 +3166,10 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Union
                     Statistics:
-                        numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                     Select Operator
                       expressions:
                             expr: UDFToInteger(_col0)
@@ -3178,14 +3178,14 @@ STAGE PLANS:
                             type: int
                       outputColumnNames: _col0, _col1
                       Statistics:
-                          numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                       File Output Operator
                         compressed: false
                         GlobalTableId: 1
 #### A masked pattern was here ####
                         NumFilesPerFileSink: 1
                         Statistics:
-                            numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                            numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3233,7 +3233,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -3242,10 +3242,10 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Union
                     Statistics:
-                        numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                     Select Operator
                       expressions:
                             expr: UDFToInteger(_col0)
@@ -3254,14 +3254,14 @@ STAGE PLANS:
                             type: int
                       outputColumnNames: _col0, _col1
                       Statistics:
-                          numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                       File Output Operator
                         compressed: false
                         GlobalTableId: 1
 #### A masked pattern was here ####
                         NumFilesPerFileSink: 1
                         Statistics:
-                            numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                            numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3874,7 +3874,7 @@ STAGE PLANS:
           mode: final
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -3883,7 +3883,7 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
@@ -3910,7 +3910,7 @@ STAGE PLANS:
             GatherStats: false
             Union
               Statistics:
-                  numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: UDFToInteger(_col0)
@@ -3919,14 +3919,14 @@ STAGE PLANS:
                       type: int
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Statistics:
-                      numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3974,7 +3974,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToDouble(_col0)
@@ -3983,10 +3983,10 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Union
                     Statistics:
-                        numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                     Select Operator
                       expressions:
                             expr: UDFToInteger(_col0)
@@ -3995,14 +3995,14 @@ STAGE PLANS:
                             type: int
                       outputColumnNames: _col0, _col1
                       Statistics:
-                          numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
                       File Output Operator
                         compressed: false
                         GlobalTableId: 1
 #### A masked pattern was here ####
                         NumFilesPerFileSink: 1
                         Statistics:
-                            numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
+                            numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4481,7 +4481,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -4490,7 +4490,7 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Reduce Output Operator
                     key expressions:
                           expr: _col0
@@ -4500,7 +4500,7 @@ STAGE PLANS:
                           expr: _col0
                           type: string
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                     tag: 0
                     value expressions:
                           expr: _col0
@@ -4530,7 +4530,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -4539,7 +4539,7 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Reduce Output Operator
                     key expressions:
                           expr: _col0
@@ -4549,7 +4549,7 @@ STAGE PLANS:
                           expr: _col0
                           type: string
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                     tag: 1
                     value expressions:
                           expr: _col1
@@ -4615,6 +4615,8 @@ STAGE PLANS:
             1 {VALUE._col1}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col3
+          Statistics:
+              numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -4622,11 +4624,15 @@ STAGE PLANS:
                   expr: UDFToInteger((_col1 + _col3))
                   type: int
             outputColumnNames: _col0, _col1
+            Statistics:
+                numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -5022,7 +5028,7 @@ STAGE PLANS:
           mode: final
           outputColumnNames: _col0, _col1, _col2
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -5033,7 +5039,7 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1, _col2
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
@@ -5067,7 +5073,7 @@ STAGE PLANS:
                     expr: _col0
                     type: string
               Statistics:
-                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
               tag: 1
               value expressions:
                     expr: _col0
@@ -5099,7 +5105,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: _col0
@@ -5108,7 +5114,7 @@ STAGE PLANS:
                         type: bigint
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   Reduce Output Operator
                     key expressions:
                           expr: _col0
@@ -5118,7 +5124,7 @@ STAGE PLANS:
                           expr: _col0
                           type: string
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                     tag: 0
                     value expressions:
                           expr: _col0
@@ -5207,6 +5213,8 @@ STAGE PLANS:
             1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col2, _col3, _col4
+          Statistics:
+              numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -5220,11 +5228,15 @@ STAGE PLANS:
                   expr: _col4
                   type: bigint
             outputColumnNames: _col0, _col1, _col2, _col3, _col4
+            Statistics:
+                numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -5554,7 +5566,7 @@ STAGE PLANS:
           mode: final
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -5563,14 +5575,14 @@ STAGE PLANS:
                   type: int
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -5808,7 +5820,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -5821,14 +5833,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -6353,7 +6365,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -6368,14 +6380,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1, _col2, _col3, _col4
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -6837,7 +6849,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -6850,14 +6862,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -7379,7 +7391,7 @@ STAGE PLANS:
                 mode: final
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                 Select Operator
                   expressions:
                         expr: UDFToInteger(_col0)
@@ -7392,14 +7404,14 @@ STAGE PLANS:
                         type: int
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics:
-                      numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
                     Statistics:
-                        numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 3 dataSize: 12 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/input23.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input23.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input23.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input23.q.out Mon Nov 25 19:15:54 2013
@@ -119,6 +119,8 @@ STAGE PLANS:
             1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col2, _col3, _col6, _col7, _col8, _col9
+          Statistics:
+              numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -138,12 +140,18 @@ STAGE PLANS:
                   expr: _col9
                   type: string
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
             Limit
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
 #### A masked pattern was here ####
                 NumFilesPerFileSink: 1
+                Statistics:
+                    numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
 #### A masked pattern was here ####
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/trunk/ql/src/test/results/clientpositive/input42.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input42.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input42.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input42.q.out Mon Nov 25 19:15:54 2013
@@ -1217,7 +1217,7 @@ STAGE PLANS:
                   expr: (key < 200)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -1230,7 +1230,7 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -1239,7 +1239,7 @@ STAGE PLANS:
                         type: string
                   sort order: ++
                   Statistics:
-                      numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -1344,14 +1344,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 0 dataSize: 5812 basicStatsState: PARTIAL 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: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1792,7 +1792,7 @@ STAGE PLANS:
                   expr: (rand(100) < 0.1)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -1805,7 +1805,7 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -1814,7 +1814,7 @@ STAGE PLANS:
                         type: string
                   sort order: ++
                   Statistics:
-                      numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -1919,14 +1919,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 0 dataSize: 5812 basicStatsState: PARTIAL 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: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out Mon Nov 25 19:15:54 2013
@@ -40,7 +40,7 @@ STAGE PLANS:
                   expr: (key < 100)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: UDFToInteger(key)
@@ -53,14 +53,14 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Statistics:
-                      numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out Mon Nov 25 19:15:54 2013
@@ -54,7 +54,7 @@ STAGE PLANS:
                   expr: ((key < 100) and (ds = '2008-04-08'))
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: UDFToInteger(key)
@@ -67,14 +67,14 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Statistics:
-                      numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
@@ -100,7 +100,7 @@ STAGE PLANS:
                   expr: ((key < 100) and (ds = '2008-04-09'))
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: UDFToInteger(key)
@@ -113,14 +113,14 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 2
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Statistics:
-                      numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out Mon Nov 25 19:15:54 2013
@@ -37,7 +37,7 @@ STAGE PLANS:
                   expr: (key < 100)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -50,10 +50,10 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -66,7 +66,7 @@ STAGE PLANS:
                           type: string
                     outputColumnNames: _col0, _col1, _col2, _col3
                     Statistics:
-                        numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                        numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -79,7 +79,7 @@ STAGE PLANS:
                             type: string
                       sort order: ++++
                       Statistics:
-                          numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                          numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -102,7 +102,7 @@ STAGE PLANS:
                   expr: (key < 100)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -115,10 +115,10 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -131,7 +131,7 @@ STAGE PLANS:
                           type: string
                     outputColumnNames: _col0, _col1, _col2, _col3
                     Statistics:
-                        numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                        numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -144,7 +144,7 @@ STAGE PLANS:
                             type: string
                       sort order: ++++
                       Statistics:
-                          numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                          numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -249,14 +249,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
             Statistics:
-                numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat