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 [6/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/sample2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sample2.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sample2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sample2.q.out Mon Nov 25 19:15:54 2013
@@ -44,7 +44,7 @@ STAGE PLANS:
                   expr: (((hash(key) & 2147483647) % 2) = 0)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -53,14 +53,14 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Statistics:
-                      numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5801 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/sample4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sample4.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sample4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sample4.q.out Mon Nov 25 19:15:54 2013
@@ -44,7 +44,7 @@ STAGE PLANS:
                   expr: (((hash(key) & 2147483647) % 2) = 0)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -53,14 +53,14 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Statistics:
-                      numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5801 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/sample5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sample5.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sample5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sample5.q.out Mon Nov 25 19:15:54 2013
@@ -42,7 +42,7 @@ STAGE PLANS:
                   expr: (((hash(key) & 2147483647) % 5) = 0)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -51,14 +51,14 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Statistics:
-                      numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5801 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/sample6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sample6.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sample6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sample6.q.out Mon Nov 25 19:15:54 2013
@@ -42,7 +42,7 @@ STAGE PLANS:
                   expr: (((hash(key) & 2147483647) % 4) = 0)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -51,14 +51,14 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Statistics:
-                      numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
@@ -606,7 +606,7 @@ STAGE PLANS:
                   expr: (((hash(key) & 2147483647) % 4) = 3)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -615,7 +615,7 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -624,7 +624,7 @@ STAGE PLANS:
                         type: string
                   sort order: ++
                   Statistics:
-                      numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -684,14 +684,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
             Statistics:
-                numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -995,7 +995,7 @@ STAGE PLANS:
                   expr: (((hash(key) & 2147483647) % 2) = 0)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -1004,7 +1004,7 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -1013,7 +1013,7 @@ STAGE PLANS:
                         type: string
                   sort order: ++
                   Statistics:
-                      numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -1073,14 +1073,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
             Statistics:
-                numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1638,7 +1638,7 @@ STAGE PLANS:
                   expr: (((hash(key) & 2147483647) % 3) = 0)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -1647,7 +1647,7 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -1656,7 +1656,7 @@ STAGE PLANS:
                         type: string
                   sort order: ++
                   Statistics:
-                      numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -1716,14 +1716,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
             Statistics:
-                numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2124,7 +2124,7 @@ STAGE PLANS:
                   expr: (((hash(key) & 2147483647) % 3) = 1)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -2133,7 +2133,7 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -2142,7 +2142,7 @@ STAGE PLANS:
                         type: string
                   sort order: ++
                   Statistics:
-                      numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -2202,14 +2202,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
             Statistics:
-                numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2596,7 +2596,7 @@ STAGE PLANS:
                   expr: (((hash(key) & 2147483647) % 2) = 0)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -2605,7 +2605,7 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -2614,7 +2614,7 @@ STAGE PLANS:
                         type: string
                   sort order: ++
                   Statistics:
-                      numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -2719,14 +2719,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 0 dataSize: 2906 basicStatsState: PARTIAL 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: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2913,7 +2913,7 @@ STAGE PLANS:
                   expr: (((hash(key) & 2147483647) % 4) = 1)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -2922,7 +2922,7 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -2931,7 +2931,7 @@ STAGE PLANS:
                         type: string
                   sort order: ++
                   Statistics:
-                      numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -2991,14 +2991,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 0 dataSize: 2906 basicStatsState: PARTIAL 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: 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/sample7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sample7.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sample7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sample7.q.out Mon Nov 25 19:15:54 2013
@@ -44,7 +44,7 @@ STAGE PLANS:
                   expr: ((((hash(key) & 2147483647) % 4) = 0) and (key > 100))
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -53,14 +53,14 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Statistics:
-                      numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5801 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/sample8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sample8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sample8.q.out Mon Nov 25 19:15:54 2013
@@ -40,7 +40,7 @@ STAGE PLANS:
                   expr: ((((hash(key) & 2147483647) % 10) = 0) and (((hash(key) & 2147483647) % 1) = 0))
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: key
@@ -54,7 +54,7 @@ STAGE PLANS:
                       expr: value
                       type: string
                 Statistics:
-                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
                 tag: 0
                 value expressions:
                       expr: key
@@ -77,7 +77,7 @@ STAGE PLANS:
                   expr: ((((hash(key) & 2147483647) % 1) = 0) and (((hash(key) & 2147483647) % 10) = 0))
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: key
@@ -91,7 +91,7 @@ STAGE PLANS:
                       expr: value
                       type: string
                 Statistics:
-                    numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
                 tag: 1
                 value expressions:
                       expr: key
@@ -284,11 +284,15 @@ STAGE PLANS:
             1 {VALUE._col0} {VALUE._col1}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col2, _col3, _col6, _col7
+          Statistics:
+              numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
           Filter Operator
             isSamplingPred: false
             predicate:
                 expr: ((((((_col6 = _col0) and (_col7 = _col1)) and (_col2 = '2008-04-08')) and (_col3 = '11')) and (_col2 = '2008-04-08')) and (_col3 = '11'))
                 type: boolean
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
             Select Operator
               expressions:
                     expr: _col0
@@ -300,6 +304,8 @@ STAGE PLANS:
                     expr: _col3
                     type: string
               outputColumnNames: _col0, _col1, _col2, _col3
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
@@ -336,6 +342,8 @@ STAGE PLANS:
                     type: string
                     expr: _col1
                     type: string
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
               tag: -1
               value expressions:
                     expr: _col0
@@ -374,11 +382,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          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/sample9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sample9.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sample9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sample9.q.out Mon Nov 25 19:15:54 2013
@@ -29,7 +29,7 @@ STAGE PLANS:
                   expr: (((hash(key) & 2147483647) % 2) = 0)
                   type: boolean
               Statistics:
-                  numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                  numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -38,14 +38,14 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                    numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Statistics:
-                      numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5801 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/smb_mapjoin_13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_13.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_13.q.out Mon Nov 25 19:15:54 2013
@@ -307,6 +307,8 @@ STAGE PLANS:
                 1 [GenericUDFBridge(Column[value])]
               outputColumnNames: _col0, _col1, _col4, _col5
               Position of Big Table: 0
+              Statistics:
+                  numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: _col0
@@ -318,11 +320,15 @@ STAGE PLANS:
                       expr: _col5
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
+                Statistics:
+                    numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
                         type: int
                   sort order: +
+                  Statistics:
+                      numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -389,12 +395,18 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
           Limit
+            Statistics:
+                numRows: 10 dataSize: 200 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 10 dataSize: 200 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/smb_mapjoin_15.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out Mon Nov 25 19:15:54 2013
@@ -740,6 +740,8 @@ STAGE PLANS:
                 1 [Column[key], Column[value]]
               outputColumnNames: _col0, _col1, _col2, _col5, _col6, _col7
               Position of Big Table: 0
+              Statistics:
+                  numRows: 125000 dataSize: 3500000 basicStatsState: COMPLETE colStatsState: NONE
               BucketMapJoin: true
               Select Operator
                 expressions:
@@ -756,11 +758,15 @@ STAGE PLANS:
                       expr: _col7
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+                Statistics:
+                    numRows: 125000 dataSize: 3500000 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
                         type: int
                   sort order: +
+                  Statistics:
+                      numRows: 125000 dataSize: 3500000 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -831,12 +837,18 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 125000 dataSize: 3500000 basicStatsState: COMPLETE colStatsState: NONE
           Limit
+            Statistics:
+                numRows: 10 dataSize: 280 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 10 dataSize: 280 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/sort_merge_join_desc_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out Mon Nov 25 19:15:54 2013
@@ -167,16 +167,24 @@ STAGE PLANS:
                 0 [Column[key]]
                 1 [Column[key]]
               Position of Big Table: 0
+              Statistics:
+                  numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
               BucketMapJoin: true
               Select Operator
+                Statistics:
+                    numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
                 Group By Operator
                   aggregations:
                         expr: count()
                   bucketGroup: false
                   mode: hash
                   outputColumnNames: _col0
+                  Statistics:
+                      numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
                   Reduce Output Operator
                     sort order: 
+                    Statistics:
+                        numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
                     tag: -1
                     value expressions:
                           expr: _col0
@@ -240,16 +248,22 @@ STAGE PLANS:
           bucketGroup: false
           mode: mergepartial
           outputColumnNames: _col0
+          Statistics:
+              numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
                   type: bigint
             outputColumnNames: _col0
+            Statistics:
+                numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 1 dataSize: 8 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/sort_merge_join_desc_7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out Mon Nov 25 19:15:54 2013
@@ -265,15 +265,23 @@ STAGE PLANS:
                 0 [Column[key]]
                 1 [Column[key]]
               Position of Big Table: 0
+              Statistics:
+                  numRows: 500000 dataSize: 10000000 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
+                Statistics:
+                    numRows: 500000 dataSize: 10000000 basicStatsState: COMPLETE colStatsState: NONE
                 Group By Operator
                   aggregations:
                         expr: count()
                   bucketGroup: false
                   mode: hash
                   outputColumnNames: _col0
+                  Statistics:
+                      numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
                   Reduce Output Operator
                     sort order: 
+                    Statistics:
+                        numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
                     tag: -1
                     value expressions:
                           expr: _col0
@@ -380,16 +388,22 @@ STAGE PLANS:
           bucketGroup: false
           mode: mergepartial
           outputColumnNames: _col0
+          Statistics:
+              numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
                   type: bigint
             outputColumnNames: _col0
+            Statistics:
+                numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 1 dataSize: 8 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/stats11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats11.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats11.q.out Mon Nov 25 19:15:54 2013
@@ -389,6 +389,8 @@ STAGE PLANS:
                 1 [Column[key]]
               outputColumnNames: _col0, _col1, _col5
               Position of Big Table: 0
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
               BucketMapJoin: true
               Select Operator
                 expressions:
@@ -399,11 +401,15 @@ STAGE PLANS:
                       expr: _col5
                       type: string
                 outputColumnNames: _col0, _col1, _col2
+                Statistics:
+                    numRows: 0 dataSize: 0 basicStatsState: NONE 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
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
@@ -884,6 +890,8 @@ STAGE PLANS:
                 1 [Column[key]]
               outputColumnNames: _col0, _col1, _col5
               Position of Big Table: 1
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
               BucketMapJoin: true
               Select Operator
                 expressions:
@@ -894,11 +902,15 @@ STAGE PLANS:
                       expr: _col5
                       type: string
                 outputColumnNames: _col0, _col1, _col2
+                Statistics:
+                    numRows: 0 dataSize: 0 basicStatsState: NONE 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
 #### 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=1545372&r1=1545371&r2=1545372&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 Mon Nov 25 19:15:54 2013
@@ -64,7 +64,7 @@ STAGE PLANS:
                       expr: ((_col1 < 100) and (_col0 = '2008-04-08'))
                       type: boolean
                   Statistics:
-                      numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
                   Reduce Output Operator
                     key expressions:
                           expr: _col1
@@ -74,7 +74,7 @@ STAGE PLANS:
                           expr: _col1
                           type: string
                     Statistics:
-                        numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+                        numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
                     tag: -1
                     value expressions:
                           expr: _col0
@@ -263,7 +263,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col1
@@ -272,14 +272,14 @@ STAGE PLANS:
                   type: string
             outputColumnNames: _col0, _col1
             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

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=1545372&r1=1545371&r2=1545372&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 Mon Nov 25 19:15:54 2013
@@ -66,7 +66,7 @@ STAGE PLANS:
                       expr: (_col1 < 100)
                       type: boolean
                   Statistics:
-                      numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                      numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                   Reduce Output Operator
                     key expressions:
                           expr: _col1
@@ -76,7 +76,7 @@ STAGE PLANS:
                           expr: _col1
                           type: string
                     Statistics:
-                        numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+                        numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                     tag: -1
                     value expressions:
                           expr: _col0
@@ -179,7 +179,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+              numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col1
@@ -188,14 +188,14 @@ STAGE PLANS:
                   type: string
             outputColumnNames: _col0, _col1
             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/udf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out?rev=1545372&r1=1545371&r2=1545372&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 Mon Nov 25 19:15:54 2013
@@ -240,7 +240,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
+              numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
@@ -249,14 +249,14 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
+                numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
+                  numRows: 0 dataSize: 2906 basicStatsState: PARTIAL 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: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
+              numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
@@ -564,14 +564,14 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1, _col2
             Statistics:
-                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
+                numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
+                  numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
 #### 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=1545372&r1=1545371&r2=1545372&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 Mon Nov 25 19:15:54 2013
@@ -310,7 +310,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
+              numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
@@ -319,14 +319,14 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
+                numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
+                  numRows: 0 dataSize: 2906 basicStatsState: PARTIAL 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: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
+              numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
@@ -635,14 +635,14 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1, _col2
             Statistics:
-                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
+                numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
               Statistics:
-                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
+                  numRows: 0 dataSize: 2906 basicStatsState: PARTIAL 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=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union22.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union22.q.out Mon Nov 25 19:15:54 2013
@@ -333,6 +333,8 @@ STAGE PLANS:
           TableScan
             GatherStats: false
             Union
+              Statistics:
+                  numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: _col0
@@ -344,12 +346,16 @@ STAGE PLANS:
                       expr: _col3
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
+                Statistics:
+                    numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
                   Static Partition Specification: ds=2/
+                  Statistics:
+                      numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
@@ -382,7 +388,7 @@ STAGE PLANS:
                   expr: (k0 <= 50)
                   type: boolean
               Statistics:
-                  numRows: 500 dataSize: 16936 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: k1
@@ -395,8 +401,10 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics:
-                    numRows: 500 dataSize: 16936 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
                 Union
+                  Statistics:
+                      numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -408,12 +416,16 @@ STAGE PLANS:
                           expr: _col3
                           type: string
                     outputColumnNames: _col0, _col1, _col2, _col3
+                    Statistics:
+                        numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
                     File Output Operator
                       compressed: false
                       GlobalTableId: 1
 #### A masked pattern was here ####
                       NumFilesPerFileSink: 1
                       Static Partition Specification: ds=2/
+                      Statistics:
+                          numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
@@ -546,7 +558,7 @@ STAGE PLANS:
                   expr: (k1 > 20)
                   type: boolean
               Statistics:
-                  numRows: 500 dataSize: 11124 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 250 dataSize: 5500 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: k1
@@ -556,7 +568,7 @@ STAGE PLANS:
                       expr: k1
                       type: string
                 Statistics:
-                    numRows: 500 dataSize: 11124 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 250 dataSize: 5500 basicStatsState: COMPLETE colStatsState: NONE
                 tag: 0
                 value expressions:
                       expr: k1
@@ -577,7 +589,7 @@ STAGE PLANS:
                   expr: ((k0 > 50) and (k1 > 20))
                   type: boolean
               Statistics:
-                  numRows: 500 dataSize: 16936 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: k1
@@ -588,7 +600,7 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: _col1, _col3, _col4
                 Statistics:
-                    numRows: 500 dataSize: 16936 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col1
@@ -598,7 +610,7 @@ STAGE PLANS:
                         expr: _col1
                         type: string
                   Statistics:
-                      numRows: 500 dataSize: 16936 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
                   tag: 1
                   value expressions:
                         expr: _col3
@@ -708,6 +720,8 @@ STAGE PLANS:
             1 
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col10, _col11
+          Statistics:
+              numRows: 31250 dataSize: 1718750 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -719,6 +733,8 @@ STAGE PLANS:
                   expr: _col11
                   type: string
             outputColumnNames: _col0, _col1, _col2, _col3
+            Statistics:
+                numRows: 31250 dataSize: 1718750 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=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union24.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union24.q.out Mon Nov 25 19:15:54 2013
@@ -74,14 +74,14 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
                       type: string
                 outputColumnNames: key
                 Statistics:
-                    numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                 Group By Operator
                   aggregations:
                         expr: count(1)
@@ -92,7 +92,7 @@ STAGE PLANS:
                   mode: hash
                   outputColumnNames: _col0, _col1
                   Statistics:
-                      numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                   Reduce Output Operator
                     key expressions:
                           expr: _col0
@@ -102,7 +102,7 @@ STAGE PLANS:
                           expr: _col0
                           type: string
                     Statistics:
-                        numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                     tag: -1
                     value expressions:
                           expr: _col1
@@ -166,7 +166,7 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1
           Statistics:
-              numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 77 dataSize: 308 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -175,7 +175,7 @@ STAGE PLANS:
                   type: bigint
             outputColumnNames: _col0, _col1
             Statistics:
-                numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 77 dataSize: 308 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
@@ -202,7 +202,7 @@ STAGE PLANS:
             GatherStats: false
             Union
               Statistics:
-                  numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: _col0
@@ -211,7 +211,7 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -220,7 +220,7 @@ STAGE PLANS:
                         type: bigint
                   sort order: ++
                   Statistics:
-                      numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -239,7 +239,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -248,10 +248,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -260,7 +260,7 @@ STAGE PLANS:
                           type: bigint
                     outputColumnNames: _col0, _col1
                     Statistics:
-                        numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -269,7 +269,7 @@ STAGE PLANS:
                             type: bigint
                       sort order: ++
                       Statistics:
-                          numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -288,7 +288,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -297,10 +297,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -309,7 +309,7 @@ STAGE PLANS:
                           type: bigint
                     outputColumnNames: _col0, _col1
                     Statistics:
-                        numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -318,7 +318,7 @@ STAGE PLANS:
                             type: bigint
                       sort order: ++
                       Statistics:
-                          numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -337,7 +337,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -346,10 +346,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                 Union
                   Statistics:
-                      numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+                      numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -358,7 +358,7 @@ STAGE PLANS:
                           type: bigint
                     outputColumnNames: _col0, _col1
                     Statistics:
-                        numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+                        numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -367,7 +367,7 @@ STAGE PLANS:
                             type: bigint
                       sort order: ++
                       Statistics:
-                          numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+                          numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -532,14 +532,14 @@ STAGE PLANS:
       Reduce Operator Tree:
         Extract
           Statistics:
-              numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+              numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
             Statistics:
-                numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
+                numRows: 539 dataSize: 2156 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: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: key
@@ -671,7 +671,7 @@ STAGE PLANS:
                       expr: key
                       type: string
                 Statistics:
-                    numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                 tag: 0
                 value expressions:
                       expr: key
@@ -688,7 +688,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: key
@@ -698,7 +698,7 @@ STAGE PLANS:
                       expr: key
                       type: string
                 Statistics:
-                    numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                 tag: 1
                 value expressions:
                       expr: count
@@ -803,6 +803,8 @@ STAGE PLANS:
             1 {VALUE._col1}
           handleSkewJoin: false
           outputColumnNames: _col0, _col5
+          Statistics:
+              numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -810,6 +812,8 @@ STAGE PLANS:
                   expr: _col5
                   type: bigint
             outputColumnNames: _col0, _col1
+            Statistics:
+                numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
@@ -835,6 +839,8 @@ STAGE PLANS:
           TableScan
             GatherStats: false
             Union
+              Statistics:
+                  numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: _col0
@@ -842,6 +848,8 @@ STAGE PLANS:
                       expr: _col1
                       type: bigint
                 outputColumnNames: _col0, _col1
+                Statistics:
+                    numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -849,6 +857,8 @@ STAGE PLANS:
                         expr: _col1
                         type: bigint
                   sort order: ++
+                  Statistics:
+                      numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -867,7 +877,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -876,8 +886,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                 Union
+                  Statistics:
+                      numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -885,6 +897,8 @@ STAGE PLANS:
                           expr: _col1
                           type: bigint
                     outputColumnNames: _col0, _col1
+                    Statistics:
+                        numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -892,6 +906,8 @@ STAGE PLANS:
                             expr: _col1
                             type: bigint
                       sort order: ++
+                      Statistics:
+                          numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -910,7 +926,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -919,8 +935,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                 Union
+                  Statistics:
+                      numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -928,6 +946,8 @@ STAGE PLANS:
                           expr: _col1
                           type: bigint
                     outputColumnNames: _col0, _col1
+                    Statistics:
+                        numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -935,6 +955,8 @@ STAGE PLANS:
                             expr: _col1
                             type: bigint
                       sort order: ++
+                      Statistics:
+                          numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -1055,11 +1077,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 12166 dataSize: 96096 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
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1172,7 +1198,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: key
@@ -1182,7 +1208,7 @@ STAGE PLANS:
                       expr: key
                       type: string
                 Statistics:
-                    numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                 tag: 0
                 value expressions:
                       expr: key
@@ -1199,7 +1225,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: key
@@ -1209,7 +1235,7 @@ STAGE PLANS:
                       expr: key
                       type: string
                 Statistics:
-                    numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                 tag: 1
       Path -> Alias:
 #### A masked pattern was here ####
@@ -1311,11 +1337,15 @@ STAGE PLANS:
             1 
           handleSkewJoin: false
           outputColumnNames: _col0
+          Statistics:
+              numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
                   type: string
             outputColumnNames: _col0
+            Statistics:
+                numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
             Group By Operator
               aggregations:
                     expr: count(1)
@@ -1325,6 +1355,8 @@ STAGE PLANS:
                     type: string
               mode: hash
               outputColumnNames: _col0, _col1
+              Statistics:
+                  numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
@@ -1357,6 +1389,8 @@ STAGE PLANS:
               Map-reduce partition columns:
                     expr: _col0
                     type: string
+              Statistics:
+                  numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
               tag: -1
               value expressions:
                     expr: _col1
@@ -1397,6 +1431,8 @@ STAGE PLANS:
                 type: string
           mode: mergepartial
           outputColumnNames: _col0, _col1
+          Statistics:
+              numRows: 5929 dataSize: 47432 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -1404,6 +1440,8 @@ STAGE PLANS:
                   expr: _col1
                   type: bigint
             outputColumnNames: _col0, _col1
+            Statistics:
+                numRows: 5929 dataSize: 47432 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
@@ -1429,6 +1467,8 @@ STAGE PLANS:
           TableScan
             GatherStats: false
             Union
+              Statistics:
+                  numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: _col0
@@ -1436,6 +1476,8 @@ STAGE PLANS:
                       expr: _col1
                       type: bigint
                 outputColumnNames: _col0, _col1
+                Statistics:
+                    numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -1443,6 +1485,8 @@ STAGE PLANS:
                         expr: _col1
                         type: bigint
                   sort order: ++
+                  Statistics:
+                      numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -1461,7 +1505,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -1470,8 +1514,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                 Union
+                  Statistics:
+                      numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -1479,6 +1525,8 @@ STAGE PLANS:
                           expr: _col1
                           type: bigint
                     outputColumnNames: _col0, _col1
+                    Statistics:
+                        numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -1486,6 +1534,8 @@ STAGE PLANS:
                             expr: _col1
                             type: bigint
                       sort order: ++
+                      Statistics:
+                          numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -1504,7 +1554,7 @@ STAGE PLANS:
                   expr: (key < 10)
                   type: boolean
               Statistics:
-                  numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                  numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -1513,8 +1563,10 @@ STAGE PLANS:
                       type: bigint
                 outputColumnNames: _col0, _col1
                 Statistics:
-                    numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
+                    numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
                 Union
+                  Statistics:
+                      numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
                   Select Operator
                     expressions:
                           expr: _col0
@@ -1522,6 +1574,8 @@ STAGE PLANS:
                           expr: _col1
                           type: bigint
                     outputColumnNames: _col0, _col1
+                    Statistics:
+                        numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
                     Reduce Output Operator
                       key expressions:
                             expr: _col0
@@ -1529,6 +1583,8 @@ STAGE PLANS:
                             expr: _col1
                             type: bigint
                       sort order: ++
+                      Statistics:
+                          numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
                       tag: -1
                       value expressions:
                             expr: _col0
@@ -1649,11 +1705,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 6237 dataSize: 48664 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
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat