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 [5/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/pcr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/pcr.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/pcr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/pcr.q.out Mon Nov 25 19:15:54 2013
@@ -84,7 +84,7 @@ STAGE PLANS:
expr: (key < 5)
type: boolean
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -95,7 +95,7 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -104,7 +104,7 @@ STAGE PLANS:
type: string
sort order: ++
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -205,14 +205,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 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
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -295,7 +295,7 @@ STAGE PLANS:
expr: ((ds <= '2000-04-09') or (key < 5))
type: boolean
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -304,14 +304,14 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
type: int
sort order: +
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -452,14 +452,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 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
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -579,7 +579,7 @@ STAGE PLANS:
expr: ((key < 5) and (value <> 'val_2'))
type: boolean
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -590,7 +590,7 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -599,7 +599,7 @@ STAGE PLANS:
type: string
sort order: ++
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -700,14 +700,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 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
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -792,7 +792,7 @@ STAGE PLANS:
expr: (((ds < '2000-04-09') and (key < 5)) or ((ds > '2000-04-09') and (value = 'val_5')))
type: boolean
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -803,7 +803,7 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -812,7 +812,7 @@ STAGE PLANS:
type: string
sort order: ++
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -913,14 +913,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 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
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1007,7 +1007,7 @@ STAGE PLANS:
expr: (((ds < '2000-04-10') and (key < 5)) or ((ds > '2000-04-08') and (value = 'val_5')))
type: boolean
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -1018,7 +1018,7 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -1027,7 +1027,7 @@ STAGE PLANS:
type: string
sort order: ++
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -1170,14 +1170,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 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
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1274,7 +1274,7 @@ STAGE PLANS:
expr: (((ds < '2000-04-10') or (key < 5)) and ((ds > '2000-04-08') or (value = 'val_5')))
type: boolean
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -1285,7 +1285,7 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -1294,7 +1294,7 @@ STAGE PLANS:
type: string
sort order: ++
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -1437,14 +1437,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 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
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1549,7 +1549,7 @@ STAGE PLANS:
expr: (key = 14)
type: boolean
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -1558,7 +1558,7 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -1567,7 +1567,7 @@ STAGE PLANS:
type: string
sort order: ++
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -1666,14 +1666,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 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
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2270,7 +2270,7 @@ STAGE PLANS:
expr: (((ds = '2000-04-08') and (key = 1)) or ((ds = '2000-04-09') and (key = 2)))
type: boolean
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -2281,7 +2281,7 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -2292,7 +2292,7 @@ STAGE PLANS:
type: string
sort order: +++
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -2393,14 +2393,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 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
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2567,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
@@ -2582,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
@@ -2611,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
@@ -2653,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
@@ -2901,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
@@ -2916,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
@@ -2945,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
@@ -2987,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
@@ -3120,7 +3140,7 @@ STAGE PLANS:
expr: (((ds > '2000-04-08') and (ds < '2000-04-11')) or (key = 2))
type: boolean
Statistics:
- numRows: 80 dataSize: 640 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -3131,7 +3151,7 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2
Statistics:
- numRows: 80 dataSize: 640 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -3142,7 +3162,7 @@ STAGE PLANS:
type: string
sort order: +++
Statistics:
- numRows: 80 dataSize: 640 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -3327,14 +3347,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 80 dataSize: 640 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
Statistics:
- numRows: 80 dataSize: 640 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3457,7 +3477,7 @@ STAGE PLANS:
expr: ((ds > '2000-04-08') or ((ds <= '2000-04-09') and (key = 2)))
type: boolean
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -3468,7 +3488,7 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -3479,7 +3499,7 @@ STAGE PLANS:
type: string
sort order: +++
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -3622,14 +3642,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 60 dataSize: 480 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 30 dataSize: 240 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
+ numRows: 30 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4342,7 +4362,7 @@ STAGE PLANS:
expr: (key = 2)
type: boolean
Statistics:
- numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 10 dataSize: 80 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -4351,14 +4371,14 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1
Statistics:
- numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 10 dataSize: 80 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
+ numRows: 10 dataSize: 80 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4389,7 +4409,7 @@ STAGE PLANS:
expr: (key = 3)
type: boolean
Statistics:
- numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 10 dataSize: 80 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -4398,14 +4418,14 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1
Statistics:
- numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 10 dataSize: 80 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
+ numRows: 10 dataSize: 80 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -5139,7 +5159,7 @@ STAGE PLANS:
expr: (key = 11)
type: boolean
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -5152,7 +5172,7 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2, _col3
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -5163,7 +5183,7 @@ STAGE PLANS:
type: string
sort order: +++
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -5268,14 +5288,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -5370,7 +5390,7 @@ STAGE PLANS:
expr: (key = 11)
type: boolean
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -5383,7 +5403,7 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2, _col3
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -5394,7 +5414,7 @@ STAGE PLANS:
type: string
sort order: +++
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -5499,14 +5519,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_join_filter.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_join_filter.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_join_filter.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_join_filter.q.out Mon Nov 25 19:15:54 2013
@@ -133,7 +133,7 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -146,14 +146,14 @@ STAGE PLANS:
type: double
outputColumnNames: _col0, _col2, _col3, _col4
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: (_col2 < 5.0)
type: boolean
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 1453 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -187,7 +187,7 @@ STAGE PLANS:
expr: _col0
type: string
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 1453 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: _col3
@@ -292,6 +292,8 @@ STAGE PLANS:
1 {VALUE._col3} {VALUE._col4}
handleSkewJoin: false
outputColumnNames: _col0, _col7, _col8
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -301,11 +303,15 @@ STAGE PLANS:
expr: _col8
type: double
outputColumnNames: _col0, _col1, _col2
+ 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
@@ -496,7 +502,7 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -509,14 +515,14 @@ STAGE PLANS:
type: double
outputColumnNames: _col0, _col2, _col3, _col4
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: (_col2 < 5.0)
type: boolean
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 1453 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -550,7 +556,7 @@ STAGE PLANS:
expr: _col0
type: string
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 1453 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: _col3
@@ -655,6 +661,8 @@ STAGE PLANS:
1 {VALUE._col3} {VALUE._col4}
handleSkewJoin: false
outputColumnNames: _col0, _col7, _col8
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -664,11 +672,15 @@ STAGE PLANS:
expr: _col8
type: double
outputColumnNames: _col0, _col1, _col2
+ 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
@@ -859,7 +871,7 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -872,14 +884,14 @@ STAGE PLANS:
type: double
outputColumnNames: _col0, _col2, _col3, _col4
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: (_col2 < 5.0)
type: boolean
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 1453 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -913,7 +925,7 @@ STAGE PLANS:
expr: _col0
type: string
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 1453 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: _col3
@@ -1018,6 +1030,8 @@ STAGE PLANS:
1 {VALUE._col3} {VALUE._col4}
handleSkewJoin: false
outputColumnNames: _col0, _col7, _col8
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1027,11 +1041,15 @@ STAGE PLANS:
expr: _col8
type: double
outputColumnNames: _col0, _col1, _col2
+ 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
@@ -1222,7 +1240,7 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1235,14 +1253,14 @@ STAGE PLANS:
type: double
outputColumnNames: _col0, _col2, _col3, _col4
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: (_col2 < 5.0)
type: boolean
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 1453 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -1276,7 +1294,7 @@ STAGE PLANS:
expr: _col0
type: string
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 1453 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: _col3
@@ -1381,6 +1399,8 @@ STAGE PLANS:
1 {VALUE._col3} {VALUE._col4}
handleSkewJoin: false
outputColumnNames: _col0, _col7, _col8
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1390,11 +1410,15 @@ STAGE PLANS:
expr: _col8
type: double
outputColumnNames: _col0, _col1, _col2
+ 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/ppd_union_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out Mon Nov 25 19:15:54 2013
@@ -346,6 +346,8 @@ STAGE PLANS:
1 {VALUE._col0}
handleSkewJoin: false
outputColumnNames: _col1, _col2, _col5
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col5
@@ -355,6 +357,8 @@ STAGE PLANS:
expr: _col2
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -380,6 +384,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -389,11 +395,15 @@ STAGE PLANS:
expr: _col2
type: string
outputColumnNames: _col0, _col1, _col2
+ 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
@@ -434,6 +444,8 @@ STAGE PLANS:
Statistics:
numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Union
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -443,11 +455,15 @@ STAGE PLANS:
expr: _col2
type: string
outputColumnNames: _col0, _col1, _col2
+ 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
@@ -660,6 +676,8 @@ STAGE PLANS:
1 {VALUE._col0}
handleSkewJoin: false
outputColumnNames: _col1, _col2, _col5
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col5
@@ -669,6 +687,8 @@ STAGE PLANS:
expr: _col2
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -694,6 +714,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 1 dataSize: 11 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -703,11 +725,15 @@ STAGE PLANS:
expr: _col2
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 1 dataSize: 11 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 11 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -741,6 +767,8 @@ STAGE PLANS:
Statistics:
numRows: 1 dataSize: 11 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 1 dataSize: 11 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -750,11 +778,15 @@ STAGE PLANS:
expr: _col2
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 1 dataSize: 11 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 11 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/ppd_vc.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_vc.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_vc.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_vc.q.out Mon Nov 25 19:15:54 2013
@@ -31,7 +31,7 @@ STAGE PLANS:
expr: (BLOCK__OFFSET__INSIDE__FILE < 100)
type: boolean
Statistics:
- numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -44,14 +44,14 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2, _col3
Statistics:
- numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
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
@@ -352,7 +352,7 @@ STAGE PLANS:
expr: ((BLOCK__OFFSET__INSIDE__FILE < 100) and (BLOCK__OFFSET__INSIDE__FILE < 50))
type: boolean
Statistics:
- numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -367,7 +367,7 @@ STAGE PLANS:
type: bigint
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics:
- numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -377,7 +377,7 @@ STAGE PLANS:
expr: _col0
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
@@ -619,6 +619,8 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4}
handleSkewJoin: false
outputColumnNames: _col4, _col5, _col6, _col7, _col8
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col4
@@ -632,6 +634,8 @@ STAGE PLANS:
expr: _col8
type: bigint
outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -665,6 +669,8 @@ STAGE PLANS:
expr: _col4
type: bigint
sort order: +++
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -705,11 +711,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/ppr_allchildsarenull.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppr_allchildsarenull.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppr_allchildsarenull.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppr_allchildsarenull.q.out Mon Nov 25 19:15:54 2013
@@ -39,7 +39,7 @@ STAGE PLANS:
expr: (CASE WHEN (((value like 'aaa%') or (value like 'vvv%'))) THEN (1) ELSE (0) END > 0)
type: boolean
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(key)
@@ -48,14 +48,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
@@ -232,7 +232,7 @@ STAGE PLANS:
expr: ((ds = '2008-04-08') and (CASE WHEN (((value like 'aaa%') or (value like 'vvv%'))) THEN (1) ELSE (0) END > 0))
type: boolean
Statistics:
- numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(key)
@@ -241,14 +241,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/push_or.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/push_or.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/push_or.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/push_or.q.out Mon Nov 25 19:15:54 2013
@@ -60,7 +60,7 @@ STAGE PLANS:
expr: ((ds = '2000-04-09') or (key = 5))
type: boolean
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -71,7 +71,7 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -80,7 +80,7 @@ STAGE PLANS:
type: string
sort order: ++
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -181,14 +181,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 40 dataSize: 320 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 160 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
+ numRows: 20 dataSize: 160 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/rand_partitionpruner1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out Mon Nov 25 19:15:54 2013
@@ -27,7 +27,7 @@ STAGE PLANS:
expr: (rand(1) < 0.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
@@ -36,14 +36,14 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1
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/rand_partitionpruner2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out Mon Nov 25 19:15:54 2013
@@ -44,7 +44,7 @@ STAGE PLANS:
expr: (rand(1) < 0.1)
type: boolean
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -57,14 +57,14 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2, _col3
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out Mon Nov 25 19:15:54 2013
@@ -29,7 +29,7 @@ STAGE PLANS:
expr: ((rand(1) < 0.1) and (not ((key > 50) or (key < 10))))
type: boolean
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -42,14 +42,14 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2, _col3
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 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
@@ -162,7 +162,7 @@ STAGE PLANS:
expr: (not ((key > 50) or (key < 10)))
type: boolean
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -175,14 +175,14 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2, _col3
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 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/regexp_extract.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out Mon Nov 25 19:15:54 2013
@@ -67,7 +67,7 @@ STAGE PLANS:
expr: (_col0 < 100)
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: _col0
@@ -77,7 +77,7 @@ STAGE PLANS:
expr: _col0
type: string
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -135,7 +135,7 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -144,14 +144,14 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1
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
@@ -346,7 +346,7 @@ STAGE PLANS:
expr: (_col0 < 100)
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: _col0
@@ -356,7 +356,7 @@ STAGE PLANS:
expr: _col0
type: string
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -414,7 +414,7 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -423,14 +423,14 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1
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/router_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/router_join_ppr.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/router_join_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/router_join_ppr.q.out Mon Nov 25 19:15:54 2013
@@ -39,7 +39,7 @@ STAGE PLANS:
expr: ((key > 15) and (key < 25))
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
@@ -49,7 +49,7 @@ STAGE PLANS:
expr: key
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
@@ -68,7 +68,7 @@ STAGE PLANS:
expr: ((key > 15) and (key < 25))
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
@@ -78,7 +78,7 @@ STAGE PLANS:
expr: key
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
@@ -321,11 +321,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: ((_col0 > 10) and (_col0 < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -337,11 +341,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
@@ -446,7 +454,7 @@ STAGE PLANS:
expr: ((key > 15) and (key < 25))
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: key
@@ -456,7 +464,7 @@ STAGE PLANS:
expr: key
type: string
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -475,7 +483,7 @@ STAGE PLANS:
expr: ((key > 15) and (key < 25))
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
@@ -485,7 +493,7 @@ STAGE PLANS:
expr: key
type: string
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -635,11 +643,15 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col6, _col7
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: ((_col0 > 10) and (_col0 < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -651,11 +663,15 @@ STAGE PLANS:
expr: _col7
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
@@ -756,7 +772,7 @@ STAGE PLANS:
expr: ((key > 15) and (key < 25))
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
@@ -766,7 +782,7 @@ STAGE PLANS:
expr: key
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
@@ -785,7 +801,7 @@ STAGE PLANS:
expr: ((key > 15) and (key < 25))
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: key
@@ -795,7 +811,7 @@ STAGE PLANS:
expr: key
type: string
Statistics:
- numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -945,11 +961,15 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: ((_col0 > 10) and (_col0 < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -961,11 +981,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
@@ -1066,7 +1090,7 @@ STAGE PLANS:
expr: ((key > 15) and (key < 25))
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
@@ -1076,7 +1100,7 @@ STAGE PLANS:
expr: key
type: string
Statistics:
- numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -1097,7 +1121,7 @@ STAGE PLANS:
expr: ((key > 15) and (key < 25))
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
@@ -1107,7 +1131,7 @@ STAGE PLANS:
expr: key
type: string
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -1343,11 +1367,15 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col2, _col6, _col7
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: (((_col0 > 10) and (_col0 < 20)) and (_col2 = '2008-04-08'))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1359,11 +1387,15 @@ STAGE PLANS:
expr: _col7
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/trunk/ql/src/test/results/clientpositive/sample1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sample1.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sample1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sample1.q.out Mon Nov 25 19:15:54 2013
@@ -44,7 +44,7 @@ STAGE PLANS:
expr: (((hash(rand()) & 2147483647) % 1) = 0)
type: boolean
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(key)
@@ -57,14 +57,14 @@ STAGE PLANS:
type: string
outputColumnNames: _col0, _col1, _col2, _col3
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
Statistics:
- numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/sample10.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sample10.q.out?rev=1545372&r1=1545371&r2=1545372&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sample10.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sample10.q.out Mon Nov 25 19:15:54 2013
@@ -72,14 +72,14 @@ STAGE PLANS:
expr: (((hash(key) & 2147483647) % 4) = 0)
type: boolean
Statistics:
- numRows: 40 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 120 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: ds
type: string
outputColumnNames: ds
Statistics:
- numRows: 40 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 120 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -90,7 +90,7 @@ STAGE PLANS:
mode: hash
outputColumnNames: _col0, _col1
Statistics:
- numRows: 40 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 120 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -100,7 +100,7 @@ STAGE PLANS:
expr: _col0
type: string
Statistics:
- numRows: 40 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 20 dataSize: 120 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -301,7 +301,7 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1
Statistics:
- numRows: 40 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 10 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -310,7 +310,7 @@ STAGE PLANS:
type: bigint
outputColumnNames: _col0, _col1
Statistics:
- numRows: 40 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 10 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -341,7 +341,7 @@ STAGE PLANS:
type: string
sort order: +
Statistics:
- numRows: 40 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 10 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -377,14 +377,14 @@ STAGE PLANS:
Reduce Operator Tree:
Extract
Statistics:
- numRows: 40 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 10 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
Statistics:
- numRows: 40 dataSize: 240 basicStatsState: COMPLETE colStatsState: NONE
+ numRows: 10 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat