hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gunt...@apache.org
Subject svn commit: r1545564 [13/22] - in /hive/branches/tez: ./ ant/ beeline/ bin/ cli/ common/ common/src/java/org/apache/hadoop/hive/common/ common/src/java/org/apache/hadoop/hive/common/type/ common/src/java/org/apache/hadoop/hive/conf/ common/src/test/org...
Date Tue, 26 Nov 2013 08:19:34 GMT
Modified: hive/branches/tez/ql/src/test/results/clientpositive/metadataonly1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/metadataonly1.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/metadataonly1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/metadataonly1.q.out Tue Nov 26 08:19:25 2013
@@ -21,20 +21,28 @@ STAGE PLANS:
         test1 
           TableScan
             alias: test1
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
                     expr: ds
                     type: string
               outputColumnNames: ds
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
               Group By Operator
                 aggregations:
                       expr: max(ds)
                 bucketGroup: false
                 mode: hash
                 outputColumnNames: _col0
+                Statistics:
+                    numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   sort order: 
+                  Statistics:
+                      numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -47,16 +55,22 @@ STAGE PLANS:
           bucketGroup: false
           mode: mergepartial
           outputColumnNames: _col0
+          Statistics:
+              numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
                   type: string
             outputColumnNames: _col0
+            Statistics:
+                numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -112,20 +126,28 @@ STAGE PLANS:
         test1 
           TableScan
             alias: test1
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
             GatherStats: false
             Select Operator
               expressions:
                     expr: ds
                     type: string
               outputColumnNames: ds
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
               Group By Operator
                 aggregations:
                       expr: max(ds)
                 bucketGroup: false
                 mode: hash
                 outputColumnNames: _col0
+                Statistics:
+                    numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
                 Reduce Output Operator
                   sort order: 
+                  Statistics:
+                      numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -179,16 +201,22 @@ STAGE PLANS:
           bucketGroup: false
           mode: mergepartial
           outputColumnNames: _col0
+          Statistics:
+              numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
                   type: string
             outputColumnNames: _col0
+            Statistics:
+                numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -239,12 +267,16 @@ STAGE PLANS:
         test1 
           TableScan
             alias: test1
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
             GatherStats: false
             Select Operator
               expressions:
                     expr: ds
                     type: string
               outputColumnNames: ds
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
               Group By Operator
                 aggregations:
                       expr: count(DISTINCT ds)
@@ -254,11 +286,15 @@ STAGE PLANS:
                       type: string
                 mode: hash
                 outputColumnNames: _col0, _col1
+                Statistics:
+                    numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
                         type: string
                   sort order: +
+                  Statistics:
+                      numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
                   tag: -1
                   value expressions:
                         expr: _col1
@@ -312,16 +348,22 @@ STAGE PLANS:
           bucketGroup: false
           mode: mergepartial
           outputColumnNames: _col0
+          Statistics:
+              numRows: 1 dataSize: 16 basicStatsState: COMPLETE colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
                   type: bigint
             outputColumnNames: _col0
+            Statistics:
+                numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -372,20 +414,28 @@ STAGE PLANS:
         test1 
           TableScan
             alias: test1
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
             GatherStats: false
             Select Operator
               expressions:
                     expr: ds
                     type: string
               outputColumnNames: ds
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
               Group By Operator
                 aggregations:
                       expr: count(ds)
                 bucketGroup: false
                 mode: hash
                 outputColumnNames: _col0
+                Statistics:
+                    numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE
                 Reduce Output Operator
                   sort order: 
+                  Statistics:
+                      numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -439,16 +489,22 @@ STAGE PLANS:
           bucketGroup: false
           mode: mergepartial
           outputColumnNames: _col0
+          Statistics:
+              numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
                   type: bigint
             outputColumnNames: _col0
+            Statistics:
+                numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -510,20 +566,28 @@ STAGE PLANS:
         b:test1 
           TableScan
             alias: test1
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
             GatherStats: false
             Select Operator
               expressions:
                     expr: ds
                     type: string
               outputColumnNames: ds
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
               Group By Operator
                 aggregations:
                       expr: max(ds)
                 bucketGroup: false
                 mode: hash
                 outputColumnNames: _col0
+                Statistics:
+                    numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
                 Reduce Output Operator
                   sort order: 
+                  Statistics:
+                      numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -615,11 +679,15 @@ STAGE PLANS:
           bucketGroup: false
           mode: mergepartial
           outputColumnNames: _col0
+          Statistics:
+              numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
                   type: string
             outputColumnNames: _col0
+            Statistics:
+                numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
@@ -652,10 +720,14 @@ STAGE PLANS:
               Map-reduce partition columns:
                     expr: _col0
                     type: string
+              Statistics:
+                  numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
               tag: 1
         a2 
           TableScan
             alias: a2
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
             GatherStats: false
             Reduce Output Operator
               key expressions:
@@ -665,6 +737,8 @@ STAGE PLANS:
               Map-reduce partition columns:
                     expr: ds
                     type: string
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
               tag: 0
       Path -> Alias:
 #### A masked pattern was here ####
@@ -774,13 +848,19 @@ STAGE PLANS:
             0 
             1 
           handleSkewJoin: false
+          Statistics:
+              numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
           Select Operator
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
             Group By Operator
               aggregations:
                     expr: count()
               bucketGroup: false
               mode: hash
               outputColumnNames: _col0
+              Statistics:
+                  numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
@@ -807,6 +887,8 @@ STAGE PLANS:
             GatherStats: false
             Reduce Output Operator
               sort order: 
+              Statistics:
+                  numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
               tag: -1
               value expressions:
                     expr: _col0
@@ -844,16 +926,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
@@ -932,6 +1020,8 @@ STAGE PLANS:
         test2 
           TableScan
             alias: test2
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
             GatherStats: false
             Select Operator
               expressions:
@@ -940,6 +1030,8 @@ STAGE PLANS:
                     expr: hr
                     type: string
               outputColumnNames: ds, hr
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
               Group By Operator
                 aggregations:
                       expr: count(DISTINCT hr)
@@ -951,6 +1043,8 @@ STAGE PLANS:
                       type: string
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2
+                Statistics:
+                    numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -961,6 +1055,8 @@ STAGE PLANS:
                   Map-reduce partition columns:
                         expr: _col0
                         type: string
+                  Statistics:
+                      numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
                   tag: -1
                   value expressions:
                         expr: _col2
@@ -1096,6 +1192,8 @@ STAGE PLANS:
                 type: string
           mode: mergepartial
           outputColumnNames: _col0, _col1
+          Statistics:
+              numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
@@ -1103,11 +1201,15 @@ STAGE PLANS:
                   expr: _col1
                   type: bigint
             outputColumnNames: _col0, _col1
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1162,6 +1264,8 @@ STAGE PLANS:
         test2 
           TableScan
             alias: test2
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
             GatherStats: false
             Select Operator
               expressions:
@@ -1170,6 +1274,8 @@ STAGE PLANS:
                     expr: hr
                     type: string
               outputColumnNames: ds, hr
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
               Group By Operator
                 aggregations:
                       expr: count(hr)
@@ -1179,6 +1285,8 @@ STAGE PLANS:
                       type: string
                 mode: hash
                 outputColumnNames: _col0, _col1
+                Statistics:
+                    numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -1187,6 +1295,8 @@ STAGE PLANS:
                   Map-reduce partition columns:
                         expr: _col0
                         type: string
+                  Statistics:
+                      numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
                   tag: -1
                   value expressions:
                         expr: _col1
@@ -1320,6 +1430,8 @@ STAGE PLANS:
                 type: string
           mode: mergepartial
           outputColumnNames: _col0, _col1
+          Statistics:
+              numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
@@ -1327,11 +1439,15 @@ STAGE PLANS:
                   expr: _col1
                   type: bigint
             outputColumnNames: _col0, _col1
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1385,20 +1501,28 @@ STAGE PLANS:
         test1 
           TableScan
             alias: test1
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
             GatherStats: false
             Select Operator
               expressions:
                     expr: ds
                     type: string
               outputColumnNames: ds
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
               Group By Operator
                 aggregations:
                       expr: max(ds)
                 bucketGroup: false
                 mode: hash
                 outputColumnNames: _col0
+                Statistics:
+                    numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
                 Reduce Output Operator
                   sort order: 
+                  Statistics:
+                      numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -1490,16 +1614,22 @@ STAGE PLANS:
           bucketGroup: false
           mode: mergepartial
           outputColumnNames: _col0
+          Statistics:
+              numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
                   type: string
             outputColumnNames: _col0
+            Statistics:
+                numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 1 dataSize: 84 basicStatsState: COMPLETE colStatsState: COMPLETE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1603,6 +1733,8 @@ STAGE PLANS:
         test2 
           TableScan
             alias: test2
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
             GatherStats: false
             Select Operator
               expressions:
@@ -1611,6 +1743,8 @@ STAGE PLANS:
                     expr: hr
                     type: string
               outputColumnNames: ds, hr
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
               Group By Operator
                 aggregations:
                       expr: count(DISTINCT hr)
@@ -1622,6 +1756,8 @@ STAGE PLANS:
                       type: string
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2
+                Statistics:
+                    numRows: 0 dataSize: 0 basicStatsState: PARTIAL colStatsState: COMPLETE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -1632,6 +1768,8 @@ STAGE PLANS:
                   Map-reduce partition columns:
                         expr: _col0
                         type: string
+                  Statistics:
+                      numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
                   tag: -1
                   value expressions:
                         expr: _col2
@@ -1845,6 +1983,8 @@ STAGE PLANS:
                 type: string
           mode: mergepartial
           outputColumnNames: _col0, _col1
+          Statistics:
+              numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
           Select Operator
             expressions:
                   expr: _col0
@@ -1852,11 +1992,15 @@ STAGE PLANS:
                   expr: _col1
                   type: bigint
             outputColumnNames: _col0, _col1
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/branches/tez/ql/src/test/results/clientpositive/num_op_type_conv.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/num_op_type_conv.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/num_op_type_conv.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/num_op_type_conv.q.out Tue Nov 26 08:19:25 2013
@@ -24,11 +24,11 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (null + 7)
-                  type: int
+                  type: double
                   expr: (1.0 - null)
                   type: double
                   expr: (null + null)
-                  type: tinyint
+                  type: double
                   expr: (UDFToLong(21) % UDFToByte(5))
                   type: bigint
                   expr: (UDFToLong(21) % UDFToLong(21))

Modified: hive/branches/tez/ql/src/test/results/clientpositive/orc_createas1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/orc_createas1.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/orc_createas1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/orc_createas1.q.out Tue Nov 26 08:19:25 2013
@@ -288,7 +288,7 @@ STAGE PLANS:
                     type: int
                     expr: value
                     type: string
-                    expr: pmod(hash(key), 50)
+                    expr: (hash(key) pmod 50)
                     type: int
               outputColumnNames: _col0, _col1, _col2
               File Output Operator

Modified: hive/branches/tez/ql/src/test/results/clientpositive/outer_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/outer_join_ppr.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/outer_join_ppr.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/outer_join_ppr.q.out Tue Nov 26 08:19:25 2013
@@ -30,6 +30,8 @@ STAGE PLANS:
         a 
           TableScan
             alias: a
+            Statistics:
+                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
             GatherStats: false
             Reduce Output Operator
               key expressions:
@@ -39,6 +41,8 @@ STAGE PLANS:
               Map-reduce partition columns:
                     expr: key
                     type: string
+              Statistics:
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
               tag: 0
               value expressions:
                     expr: key
@@ -48,6 +52,8 @@ STAGE PLANS:
         b 
           TableScan
             alias: b
+            Statistics:
+                numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
             GatherStats: false
             Reduce Output Operator
               key expressions:
@@ -57,6 +63,8 @@ STAGE PLANS:
               Map-reduce partition columns:
                     expr: key
                     type: string
+              Statistics:
+                  numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
               tag: 1
               value expressions:
                     expr: key
@@ -299,11 +307,15 @@ STAGE PLANS:
             1 {(VALUE._col2 = '2008-04-08')}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col4, _col5
+          Statistics:
+              numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
           Filter Operator
             isSamplingPred: false
             predicate:
                 expr: ((((_col4 > 15) and (_col4 < 25)) and (_col0 > 10)) and (_col0 < 20))
                 type: boolean
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
             Select Operator
               expressions:
                     expr: _col0
@@ -315,11 +327,15 @@ STAGE PLANS:
                     expr: _col5
                     type: string
               outputColumnNames: _col0, _col1, _col2, _col3
+              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
@@ -415,6 +431,8 @@ STAGE PLANS:
         a 
           TableScan
             alias: a
+            Statistics:
+                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
             GatherStats: false
             Reduce Output Operator
               key expressions:
@@ -424,6 +442,8 @@ STAGE PLANS:
               Map-reduce partition columns:
                     expr: key
                     type: string
+              Statistics:
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
               tag: 0
               value expressions:
                     expr: key
@@ -433,6 +453,8 @@ STAGE PLANS:
         b 
           TableScan
             alias: b
+            Statistics:
+                numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
             GatherStats: false
             Reduce Output Operator
               key expressions:
@@ -442,6 +464,8 @@ STAGE PLANS:
               Map-reduce partition columns:
                     expr: key
                     type: string
+              Statistics:
+                  numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
               tag: 1
               value expressions:
                     expr: key
@@ -679,11 +703,15 @@ STAGE PLANS:
             1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col4, _col5, _col6
+          Statistics:
+              numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
           Filter Operator
             isSamplingPred: false
             predicate:
                 expr: (((((_col4 > 15) and (_col4 < 25)) and (_col6 = '2008-04-08')) and (_col0 > 10)) and (_col0 < 20))
                 type: boolean
+            Statistics:
+                numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
             Select Operator
               expressions:
                     expr: _col0
@@ -695,11 +723,15 @@ STAGE PLANS:
                     expr: _col5
                     type: string
               outputColumnNames: _col0, _col1, _col2, _col3
+              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/branches/tez/ql/src/test/results/clientpositive/pcr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/pcr.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/pcr.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/pcr.q.out Tue Nov 26 08:19:25 2013
@@ -75,12 +75,16 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: (key < 5)
                   type: boolean
+              Statistics:
+                  numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -90,6 +94,8 @@ STAGE PLANS:
                       expr: ds
                       type: string
                 outputColumnNames: _col0, _col1, _col2
+                Statistics:
+                    numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -97,6 +103,8 @@ STAGE PLANS:
                         expr: _col2
                         type: string
                   sort order: ++
+                  Statistics:
+                      numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -196,11 +204,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -274,12 +286,16 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: ((ds <= '2000-04-09') or (key < 5))
                   type: boolean
+              Statistics:
+                  numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -287,11 +303,15 @@ STAGE PLANS:
                       expr: value
                       type: string
                 outputColumnNames: _col0, _col1
+                Statistics:
+                    numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
                         type: int
                   sort order: +
+                  Statistics:
+                      numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -431,11 +451,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -546,12 +570,16 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: ((key < 5) and (value <> 'val_2'))
                   type: boolean
+              Statistics:
+                  numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -561,6 +589,8 @@ STAGE PLANS:
                       expr: ds
                       type: string
                 outputColumnNames: _col0, _col1, _col2
+                Statistics:
+                    numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -568,6 +598,8 @@ STAGE PLANS:
                         expr: _col2
                         type: string
                   sort order: ++
+                  Statistics:
+                      numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -667,11 +699,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -747,12 +783,16 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: (((ds < '2000-04-09') and (key < 5)) or ((ds > '2000-04-09') and (value = 'val_5')))
                   type: boolean
+              Statistics:
+                  numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -762,6 +802,8 @@ STAGE PLANS:
                       expr: ds
                       type: string
                 outputColumnNames: _col0, _col1, _col2
+                Statistics:
+                    numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -769,6 +811,8 @@ STAGE PLANS:
                         expr: _col2
                         type: string
                   sort order: ++
+                  Statistics:
+                      numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -868,11 +912,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -950,12 +998,16 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: (((ds < '2000-04-10') and (key < 5)) or ((ds > '2000-04-08') and (value = 'val_5')))
                   type: boolean
+              Statistics:
+                  numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -965,6 +1017,8 @@ STAGE PLANS:
                       expr: ds
                       type: string
                 outputColumnNames: _col0, _col1, _col2
+                Statistics:
+                    numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -972,6 +1026,8 @@ STAGE PLANS:
                         expr: _col2
                         type: string
                   sort order: ++
+                  Statistics:
+                      numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -1113,11 +1169,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1205,12 +1265,16 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: (((ds < '2000-04-10') or (key < 5)) and ((ds > '2000-04-08') or (value = 'val_5')))
                   type: boolean
+              Statistics:
+                  numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -1220,6 +1284,8 @@ STAGE PLANS:
                       expr: ds
                       type: string
                 outputColumnNames: _col0, _col1, _col2
+                Statistics:
+                    numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -1227,6 +1293,8 @@ STAGE PLANS:
                         expr: _col2
                         type: string
                   sort order: ++
+                  Statistics:
+                      numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -1368,11 +1436,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1468,12 +1540,16 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: (key = 14)
                   type: boolean
+              Statistics:
+                  numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -1481,6 +1557,8 @@ STAGE PLANS:
                       expr: value
                       type: string
                 outputColumnNames: _col0, _col1
+                Statistics:
+                    numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -1488,6 +1566,8 @@ STAGE PLANS:
                         expr: _col1
                         type: string
                   sort order: ++
+                  Statistics:
+                      numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -1585,11 +1665,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1653,6 +1737,8 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
@@ -1661,6 +1747,8 @@ STAGE PLANS:
                     expr: value
                     type: string
               outputColumnNames: _col0, _col1
+              Statistics:
+                  numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: _col0
@@ -1668,6 +1756,8 @@ STAGE PLANS:
                       expr: _col1
                       type: string
                 sort order: ++
+                Statistics:
+                    numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
                 tag: -1
                 value expressions:
                       expr: _col0
@@ -1765,11 +1855,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1873,6 +1967,8 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
@@ -1881,6 +1977,8 @@ STAGE PLANS:
                     expr: value
                     type: string
               outputColumnNames: _col0, _col1
+              Statistics:
+                  numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: _col0
@@ -1888,6 +1986,8 @@ STAGE PLANS:
                       expr: _col1
                       type: string
                 sort order: ++
+                Statistics:
+                    numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
                 tag: -1
                 value expressions:
                       expr: _col0
@@ -2027,11 +2127,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2157,12 +2261,16 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: (((ds = '2000-04-08') and (key = 1)) or ((ds = '2000-04-09') and (key = 2)))
                   type: boolean
+              Statistics:
+                  numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -2172,6 +2280,8 @@ STAGE PLANS:
                       expr: ds
                       type: string
                 outputColumnNames: _col0, _col1, _col2
+                Statistics:
+                    numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -2181,6 +2291,8 @@ STAGE PLANS:
                         expr: _col2
                         type: string
                   sort order: +++
+                  Statistics:
+                      numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -2280,11 +2392,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2350,6 +2466,8 @@ STAGE PLANS:
         t1 
           TableScan
             alias: t1
+            Statistics:
+                numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Reduce Output Operator
               key expressions:
@@ -2359,6 +2477,8 @@ STAGE PLANS:
               Map-reduce partition columns:
                     expr: key
                     type: int
+              Statistics:
+                  numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
               tag: 0
               value expressions:
                     expr: key
@@ -2370,6 +2490,8 @@ STAGE PLANS:
         t2 
           TableScan
             alias: t2
+            Statistics:
+                numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Reduce Output Operator
               key expressions:
@@ -2379,6 +2501,8 @@ STAGE PLANS:
               Map-reduce partition columns:
                     expr: key
                     type: int
+              Statistics:
+                  numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
               tag: 1
               value expressions:
                     expr: key
@@ -2443,6 +2567,8 @@ STAGE PLANS:
             1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col2, _col5, _col6, _col7
+          Statistics:
+              numRows: 200 dataSize: 3200 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -2458,6 +2584,8 @@ STAGE PLANS:
                   expr: _col7
                   type: string
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+            Statistics:
+                numRows: 200 dataSize: 3200 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
@@ -2487,6 +2615,8 @@ STAGE PLANS:
                     expr: _col0
                     type: int
               sort order: +
+              Statistics:
+                  numRows: 200 dataSize: 3200 basicStatsState: COMPLETE colStatsState: NONE
               tag: -1
               value expressions:
                     expr: _col0
@@ -2529,11 +2659,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 200 dataSize: 3200 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 200 dataSize: 3200 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2634,6 +2768,8 @@ STAGE PLANS:
         t1 
           TableScan
             alias: t1
+            Statistics:
+                numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Reduce Output Operator
               key expressions:
@@ -2643,6 +2779,8 @@ STAGE PLANS:
               Map-reduce partition columns:
                     expr: key
                     type: int
+              Statistics:
+                  numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
               tag: 0
               value expressions:
                     expr: key
@@ -2654,6 +2792,8 @@ STAGE PLANS:
         t2 
           TableScan
             alias: t2
+            Statistics:
+                numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Reduce Output Operator
               key expressions:
@@ -2663,6 +2803,8 @@ STAGE PLANS:
               Map-reduce partition columns:
                     expr: key
                     type: int
+              Statistics:
+                  numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
               tag: 1
               value expressions:
                     expr: key
@@ -2769,6 +2911,8 @@ STAGE PLANS:
             1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
           handleSkewJoin: false
           outputColumnNames: _col0, _col1, _col2, _col5, _col6, _col7
+          Statistics:
+              numRows: 200 dataSize: 3200 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -2784,6 +2928,8 @@ STAGE PLANS:
                   expr: _col7
                   type: string
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+            Statistics:
+                numRows: 200 dataSize: 3200 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
@@ -2813,6 +2959,8 @@ STAGE PLANS:
                     expr: _col0
                     type: int
               sort order: +
+              Statistics:
+                  numRows: 200 dataSize: 3200 basicStatsState: COMPLETE colStatsState: NONE
               tag: -1
               value expressions:
                     expr: _col0
@@ -2855,11 +3003,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 200 dataSize: 3200 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 200 dataSize: 3200 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2979,12 +3131,16 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 80 dataSize: 640 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: (((ds > '2000-04-08') and (ds < '2000-04-11')) or (key = 2))
                   type: boolean
+              Statistics:
+                  numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -2994,6 +3150,8 @@ STAGE PLANS:
                       expr: ds
                       type: string
                 outputColumnNames: _col0, _col1, _col2
+                Statistics:
+                    numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -3003,6 +3161,8 @@ STAGE PLANS:
                         expr: _col2
                         type: string
                   sort order: +++
+                  Statistics:
+                      numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -3186,11 +3346,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3304,12 +3468,16 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: ((ds > '2000-04-08') or ((ds <= '2000-04-09') and (key = 2)))
                   type: boolean
+              Statistics:
+                  numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -3319,6 +3487,8 @@ STAGE PLANS:
                       expr: ds
                       type: string
                 outputColumnNames: _col0, _col1, _col2
+                Statistics:
+                    numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -3328,6 +3498,8 @@ STAGE PLANS:
                         expr: _col2
                         type: string
                   sort order: +++
+                  Statistics:
+                      numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -3469,11 +3641,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
 #### A masked pattern was here ####
             NumFilesPerFileSink: 1
+            Statistics:
+                numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3629,6 +3805,8 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
@@ -3637,11 +3815,15 @@ STAGE PLANS:
                     expr: value
                     type: string
               outputColumnNames: _col0, _col1
+              Statistics:
+                  numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
               File Output Operator
                 compressed: false
                 GlobalTableId: 1
 #### A masked pattern was here ####
                 NumFilesPerFileSink: 1
+                Statistics:
+                    numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3668,11 +3850,15 @@ STAGE PLANS:
                     expr: value
                     type: string
               outputColumnNames: _col0, _col1
+              Statistics:
+                  numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
               File Output Operator
                 compressed: false
                 GlobalTableId: 2
 #### A masked pattern was here ####
                 NumFilesPerFileSink: 1
+                Statistics:
+                    numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4167,12 +4353,16 @@ STAGE PLANS:
         pcr_t1 
           TableScan
             alias: pcr_t1
+            Statistics:
+                numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: (key = 2)
                   type: boolean
+              Statistics:
+                  numRows: 10 dataSize: 80 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -4180,11 +4370,15 @@ STAGE PLANS:
                       expr: value
                       type: string
                 outputColumnNames: _col0, _col1
+                Statistics:
+                    numRows: 10 dataSize: 80 basicStatsState: COMPLETE colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
+                  Statistics:
+                      numRows: 10 dataSize: 80 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4214,6 +4408,8 @@ STAGE PLANS:
               predicate:
                   expr: (key = 3)
                   type: boolean
+              Statistics:
+                  numRows: 10 dataSize: 80 basicStatsState: COMPLETE colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -4221,11 +4417,15 @@ STAGE PLANS:
                       expr: value
                       type: string
                 outputColumnNames: _col0, _col1
+                Statistics:
+                    numRows: 10 dataSize: 80 basicStatsState: COMPLETE colStatsState: NONE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 2
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
+                  Statistics:
+                      numRows: 10 dataSize: 80 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4784,6 +4984,8 @@ STAGE PLANS:
         srcpart 
           TableScan
             alias: srcpart
+            Statistics:
+                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
@@ -4792,11 +4994,15 @@ STAGE PLANS:
                     expr: value
                     type: string
               outputColumnNames: _col0, _col1
+              Statistics:
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: _col0
                       type: string
                 sort order: +
+                Statistics:
+                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                 tag: -1
                 value expressions:
                       expr: _col0
@@ -4853,12 +5059,18 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
           Limit
+            Statistics:
+                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: 5812 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4938,12 +5150,16 @@ STAGE PLANS:
         srcpart 
           TableScan
             alias: srcpart
+            Statistics:
+                numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: (key = 11)
                   type: boolean
+              Statistics:
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -4955,6 +5171,8 @@ STAGE PLANS:
                       expr: hr
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
+                Statistics:
+                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -4964,6 +5182,8 @@ STAGE PLANS:
                         expr: _col3
                         type: string
                   sort order: +++
+                  Statistics:
+                      numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -5067,11 +5287,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              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: 5812 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
@@ -5157,12 +5381,16 @@ STAGE PLANS:
         srcpart 
           TableScan
             alias: srcpart
+            Statistics:
+                numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: (key = 11)
                   type: boolean
+              Statistics:
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
               Select Operator
                 expressions:
                       expr: key
@@ -5174,6 +5402,8 @@ STAGE PLANS:
                       expr: hr
                       type: string
                 outputColumnNames: _col0, _col1, _col2, _col3
+                Statistics:
+                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -5183,6 +5413,8 @@ STAGE PLANS:
                         expr: _col3
                         type: string
                   sort order: +++
+                  Statistics:
+                      numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col0
@@ -5286,11 +5518,15 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              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: 5812 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/branches/tez/ql/src/test/results/clientpositive/ppd_constant_expr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/ppd_constant_expr.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/ppd_constant_expr.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/ppd_constant_expr.q.out Tue Nov 26 08:19:25 2013
@@ -34,10 +34,10 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (4 + null)
-                    type: int
+                    type: double
                     expr: UDFToInteger((key - null))
                     type: int
-                    expr: UDFToDouble((null + null))
+                    expr: (null + null)
                     type: double
               outputColumnNames: _col0, _col1, _col2
               File Output Operator
@@ -189,10 +189,10 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (4 + null)
-                    type: int
+                    type: double
                     expr: UDFToInteger((key - null))
                     type: int
-                    expr: UDFToDouble((null + null))
+                    expr: (null + null)
                     type: double
               outputColumnNames: _col0, _col1, _col2
               File Output Operator



Mime
View raw message