You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2013/11/26 09:19:34 UTC
svn commit: r1545564 [15/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...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/sample6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/sample6.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/sample6.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/sample6.q.out Tue Nov 26 08:19:25 2013
@@ -33,12 +33,16 @@ STAGE PLANS:
s
TableScan
alias: s
+ Statistics:
+ numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: true
predicate:
expr: (((hash(key) & 2147483647) % 4) = 0)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -46,11 +50,15 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -589,12 +597,16 @@ STAGE PLANS:
s
TableScan
alias: s
+ Statistics:
+ numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: true
predicate:
expr: (((hash(key) & 2147483647) % 4) = 3)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -602,6 +614,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -609,6 +623,8 @@ STAGE PLANS:
expr: _col1
type: string
sort order: ++
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -667,11 +683,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -966,12 +986,16 @@ STAGE PLANS:
s
TableScan
alias: s
+ Statistics:
+ numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: true
predicate:
expr: (((hash(key) & 2147483647) % 2) = 0)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -979,6 +1003,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -986,6 +1012,8 @@ STAGE PLANS:
expr: _col1
type: string
sort order: ++
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -1044,11 +1072,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1597,12 +1629,16 @@ STAGE PLANS:
s
TableScan
alias: s
+ Statistics:
+ numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: true
predicate:
expr: (((hash(key) & 2147483647) % 3) = 0)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -1610,6 +1646,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -1617,6 +1655,8 @@ STAGE PLANS:
expr: _col1
type: string
sort order: ++
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -1675,11 +1715,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2071,12 +2115,16 @@ STAGE PLANS:
s
TableScan
alias: s
+ Statistics:
+ numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: true
predicate:
expr: (((hash(key) & 2147483647) % 3) = 1)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -2084,6 +2132,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -2091,6 +2141,8 @@ STAGE PLANS:
expr: _col1
type: string
sort order: ++
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -2149,11 +2201,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2531,12 +2587,16 @@ STAGE PLANS:
s
TableScan
alias: s
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: true
predicate:
expr: (((hash(key) & 2147483647) % 2) = 0)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -2544,6 +2604,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -2551,6 +2613,8 @@ STAGE PLANS:
expr: _col1
type: string
sort order: ++
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -2654,11 +2718,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ 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: 2906 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2836,12 +2904,16 @@ STAGE PLANS:
s
TableScan
alias: s
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: true
predicate:
expr: (((hash(key) & 2147483647) % 4) = 1)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -2849,6 +2921,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -2856,6 +2930,8 @@ STAGE PLANS:
expr: _col1
type: string
sort order: ++
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -2914,11 +2990,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ 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: 2906 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3019,12 +3099,16 @@ STAGE PLANS:
s
TableScan
alias: s
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: true
predicate:
expr: (((hash(key) & 2147483647) % 2) = 0)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -3032,6 +3116,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -3039,6 +3125,8 @@ STAGE PLANS:
expr: _col1
type: string
sort order: ++
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -3048,11 +3136,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/branches/tez/ql/src/test/results/clientpositive/sample7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/sample7.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/sample7.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/sample7.q.out Tue Nov 26 08:19:25 2013
@@ -35,12 +35,16 @@ STAGE PLANS:
s
TableScan
alias: s
+ Statistics:
+ numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((((hash(key) & 2147483647) % 4) = 0) and (key > 100))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -48,11 +52,15 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5801 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/sample8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/sample8.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/sample8.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/sample8.q.out Tue Nov 26 08:19:25 2013
@@ -31,12 +31,16 @@ STAGE PLANS:
s
TableScan
alias: s
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: true
predicate:
expr: ((((hash(key) & 2147483647) % 10) = 0) and (((hash(key) & 2147483647) % 1) = 0))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -49,6 +53,8 @@ STAGE PLANS:
type: string
expr: value
type: string
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -62,12 +68,16 @@ STAGE PLANS:
t
TableScan
alias: t
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: true
predicate:
expr: ((((hash(key) & 2147483647) % 1) = 0) and (((hash(key) & 2147483647) % 10) = 0))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -80,6 +90,8 @@ STAGE PLANS:
type: string
expr: value
type: string
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -272,11 +284,15 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col2, _col3, _col6, _col7
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: ((((((_col6 = _col0) and (_col7 = _col1)) and (_col2 = '2008-04-08')) and (_col3 = '11')) and (_col2 = '2008-04-08')) and (_col3 = '11'))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -288,6 +304,8 @@ STAGE PLANS:
expr: _col3
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -324,6 +342,8 @@ STAGE PLANS:
type: string
expr: _col1
type: string
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -362,11 +382,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/sample9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/sample9.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/sample9.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/sample9.q.out Tue Nov 26 08:19:25 2013
@@ -20,12 +20,16 @@ STAGE PLANS:
s:a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 11603 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: true
predicate:
expr: (((hash(key) & 2147483647) % 2) = 0)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -33,11 +37,15 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5801 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5801 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/serde_regex.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/serde_regex.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/serde_regex.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/serde_regex.q.out Tue Nov 26 08:19:25 2013
@@ -129,7 +129,7 @@ POSTHOOK: Input: default@serde_regex
POSTHOOK: Output: default@serde_regex
PREHOOK: query: EXPLAIN
CREATE TABLE serde_regex1(
- key decimal(65,30),
+ key decimal(38,18),
value int)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
WITH SERDEPROPERTIES (
@@ -139,7 +139,7 @@ STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: EXPLAIN
CREATE TABLE serde_regex1(
- key decimal(65,30),
+ key decimal(38,18),
value int)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
WITH SERDEPROPERTIES (
@@ -148,7 +148,7 @@ WITH SERDEPROPERTIES (
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
ABSTRACT SYNTAX TREE:
- (TOK_CREATETABLE (TOK_TABNAME serde_regex1) TOK_LIKETABLE (TOK_TABCOLLIST (TOK_TABCOL key (TOK_DECIMAL 65 30)) (TOK_TABCOL value TOK_INT)) (TOK_TABLESERIALIZER (TOK_SERDENAME 'org.apache.hadoop.hive.serde2.RegexSerDe' (TOK_TABLEPROPERTIES (TOK_TABLEPROPLIST (TOK_TABLEPROPERTY "input.regex" "([^ ]*) ([^ ]*)"))))) TOK_TBLTEXTFILE)
+ (TOK_CREATETABLE (TOK_TABNAME serde_regex1) TOK_LIKETABLE (TOK_TABCOLLIST (TOK_TABCOL key (TOK_DECIMAL 38 18)) (TOK_TABCOL value TOK_INT)) (TOK_TABLESERIALIZER (TOK_SERDENAME 'org.apache.hadoop.hive.serde2.RegexSerDe' (TOK_TABLEPROPERTIES (TOK_TABLEPROPLIST (TOK_TABLEPROPERTY "input.regex" "([^ ]*) ([^ ]*)"))))) TOK_TBLTEXTFILE)
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -157,7 +157,7 @@ STAGE PLANS:
Stage: Stage-0
Create Table Operator:
Create Table
- columns: key decimal(65,30), value int
+ columns: key decimal(38,18), value int
if not exists: false
input format: org.apache.hadoop.mapred.TextInputFormat
# buckets: -1
@@ -170,7 +170,7 @@ STAGE PLANS:
PREHOOK: query: CREATE TABLE serde_regex1(
- key decimal(65,30),
+ key decimal(38,18),
value int)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
WITH SERDEPROPERTIES (
@@ -179,7 +179,7 @@ WITH SERDEPROPERTIES (
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE serde_regex1(
- key decimal(65,30),
+ key decimal(38,18),
value int)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
WITH SERDEPROPERTIES (
@@ -222,7 +222,7 @@ NULL 0
0.3 0
0.33 0
0.333 0
-0.9999999999999999999999999 1
+1 1
1 1
1 1
1.12 1
Modified: hive/branches/tez/ql/src/test/results/clientpositive/serde_user_properties.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/serde_user_properties.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/serde_user_properties.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/serde_user_properties.q.out Tue Nov 26 08:19:25 2013
@@ -20,17 +20,23 @@ STAGE PLANS:
src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: _col0
+ 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
@@ -117,17 +123,23 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: _col0
+ 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
@@ -214,17 +226,23 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: _col0
+ 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
@@ -296,6 +314,7 @@ STAGE PLANS:
Fetch Operator
limit: -1
+
PREHOOK: query: explain extended select key from src ('user.defined.key'='some.value')
PREHOOK: type: QUERY
POSTHOOK: query: explain extended select key from src ('user.defined.key'='some.value')
@@ -314,17 +333,23 @@ STAGE PLANS:
src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: _col0
+ 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
@@ -413,17 +438,23 @@ STAGE PLANS:
src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: _col0
+ 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
@@ -516,17 +547,23 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: _col0
+ 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
@@ -615,17 +652,23 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: _col0
+ 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/skewjoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/skewjoin.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/skewjoin.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/skewjoin.q.out Tue Nov 26 08:19:25 2013
@@ -1560,8 +1560,8 @@ STAGE PLANS:
1 {val}
handleSkewJoin: false
keys:
- 0 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key], Const int 1()]
- 1 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
+ 0 [GenericUDFOPPlus(Column[key], Const int 1)]
+ 1 [GenericUDFBridge(Column[key])]
Position of Big Table: 0
Stage: Stage-1
@@ -1578,8 +1578,8 @@ STAGE PLANS:
1 {val}
handleSkewJoin: false
keys:
- 0 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key], Const int 1()]
- 1 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
+ 0 [GenericUDFOPPlus(Column[key], Const int 1)]
+ 1 [GenericUDFBridge(Column[key])]
outputColumnNames: _col0, _col5
Position of Big Table: 0
Select Operator
Modified: hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin9.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin9.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin9.q.out Tue Nov 26 08:19:25 2013
@@ -36,12 +36,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((ds = '2010-10-15') and key is not null)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Inner Join 0 to 1
@@ -133,12 +137,16 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((ds = '2010-10-15') and key is not null)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Inner Join 0 to 1
Modified: hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_11.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_11.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_11.q.out Tue Nov 26 08:19:25 2013
@@ -70,6 +70,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Sorted Merge Bucket Map Join Operator
condition map:
Modified: hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_12.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_12.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_12.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_12.q.out Tue Nov 26 08:19:25 2013
@@ -90,6 +90,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Sorted Merge Bucket Map Join Operator
condition map:
@@ -310,6 +312,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 3084 dataSize: 32904 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Sorted Merge Bucket Map Join Operator
condition map:
Modified: hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_13.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_13.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_13.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_13.q.out Tue Nov 26 08:19:25 2013
@@ -86,6 +86,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Sorted Merge Bucket Map Join Operator
condition map:
@@ -271,6 +273,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -278,8 +282,8 @@ STAGE PLANS:
1 {key} {value}
handleSkewJoin: false
keys:
- 0 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
- 1 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[value]()]
+ 0 [GenericUDFBridge(Column[key])]
+ 1 [GenericUDFBridge(Column[value])]
Position of Big Table: 0
Stage: Stage-1
@@ -288,6 +292,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -297,10 +303,12 @@ STAGE PLANS:
1 {key} {value}
handleSkewJoin: false
keys:
- 0 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
- 1 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[value]()]
+ 0 [GenericUDFBridge(Column[key])]
+ 1 [GenericUDFBridge(Column[value])]
outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -312,11 +320,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
type: int
sort order: +
+ Statistics:
+ numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -383,12 +395,18 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
Limit
+ Statistics:
+ numRows: 10 dataSize: 200 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 10 dataSize: 200 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out Tue Nov 26 08:19:25 2013
@@ -60,6 +60,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Sorted Merge Bucket Map Join Operator
condition map:
@@ -304,6 +306,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 7218 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Sorted Merge Bucket Map Join Operator
condition map:
@@ -496,6 +500,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 7218 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Sorted Merge Bucket Map Join Operator
condition map:
@@ -693,6 +699,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 500 dataSize: 7218 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -717,6 +725,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 7218 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -730,6 +740,8 @@ STAGE PLANS:
1 [Column[key], Column[value]]
outputColumnNames: _col0, _col1, _col2, _col5, _col6, _col7
Position of Big Table: 0
+ Statistics:
+ numRows: 125000 dataSize: 3500000 basicStatsState: COMPLETE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -746,11 +758,15 @@ STAGE PLANS:
expr: _col7
type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Statistics:
+ numRows: 125000 dataSize: 3500000 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
type: int
sort order: +
+ Statistics:
+ numRows: 125000 dataSize: 3500000 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -821,12 +837,18 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 125000 dataSize: 3500000 basicStatsState: COMPLETE colStatsState: NONE
Limit
+ Statistics:
+ numRows: 10 dataSize: 280 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 10 dataSize: 280 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out Tue Nov 26 08:19:25 2013
@@ -80,6 +80,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Sorted Merge Bucket Map Join Operator
condition map:
Modified: hive/branches/tez/ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out Tue Nov 26 08:19:25 2013
@@ -127,6 +127,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -151,6 +153,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -163,16 +167,24 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
BucketMapJoin: true
Select Operator
+ Statistics:
+ numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -236,16 +248,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out Tue Nov 26 08:19:25 2013
@@ -232,6 +232,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 1000 dataSize: 10624 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -249,6 +251,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 1000 dataSize: 10624 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -261,15 +265,23 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 500000 dataSize: 10000000 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
+ Statistics:
+ numRows: 500000 dataSize: 10000000 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -376,16 +388,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/stats0.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/stats0.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/stats0.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/stats0.q.out Tue Nov 26 08:19:25 2013
@@ -26,6 +26,8 @@ STAGE PLANS:
src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -34,11 +36,15 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ 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: 5812 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1367,6 +1373,8 @@ STAGE PLANS:
src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -1375,11 +1383,15 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ 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: 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/stats11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/stats11.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/stats11.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/stats11.q.out Tue Nov 26 08:19:25 2013
@@ -348,6 +348,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -372,6 +374,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -385,6 +389,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col1, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -395,11 +401,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -839,6 +849,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -863,6 +875,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -876,6 +890,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col1, _col5
Position of Big Table: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -886,11 +902,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/stats12.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/stats12.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/stats12.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/stats12.q.out Tue Nov 26 08:19:25 2013
@@ -58,6 +58,8 @@ STAGE PLANS:
analyze_srcpart
TableScan
alias: analyze_srcpart
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: COMPLETE
Statistics Aggregation Key Prefix: analyze_srcpart/
GatherStats: true
Path -> Alias:
Modified: hive/branches/tez/ql/src/test/results/clientpositive/stats13.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/stats13.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/stats13.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/stats13.q.out Tue Nov 26 08:19:25 2013
@@ -58,6 +58,8 @@ STAGE PLANS:
analyze_srcpart
TableScan
alias: analyze_srcpart
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: COMPLETE
Statistics Aggregation Key Prefix: analyze_srcpart/
GatherStats: true
Path -> Alias:
Modified: hive/branches/tez/ql/src/test/results/clientpositive/stats_aggregator_error_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/stats_aggregator_error_1.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/stats_aggregator_error_1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/stats_aggregator_error_1.q.out Tue Nov 26 08:19:25 2013
@@ -1,5 +1,5 @@
PREHOOK: query: -- In this test, there is a dummy stats aggregator which throws an error when various
--- methods are called (as indicated by the parameter hive.test.dummystats.agregator)
+-- methods are called (as indicated by the parameter hive.test.dummystats.aggregator)
-- Since stats need not be reliable (by setting hive.stats.reliable to false), the
-- insert statements succeed. The insert statement succeeds even if the stats aggregator
-- is set to null, since stats need not be reliable.
@@ -7,7 +7,7 @@ PREHOOK: query: -- In this test, there i
create table tmptable(key string, value string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: -- In this test, there is a dummy stats aggregator which throws an error when various
--- methods are called (as indicated by the parameter hive.test.dummystats.agregator)
+-- methods are called (as indicated by the parameter hive.test.dummystats.aggregator)
-- Since stats need not be reliable (by setting hive.stats.reliable to false), the
-- insert statements succeed. The insert statement succeeds even if the stats aggregator
-- is set to null, since stats need not be reliable.
Modified: hive/branches/tez/ql/src/test/results/clientpositive/stats_only_null.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/stats_only_null.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/stats_only_null.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/stats_only_null.q.out Tue Nov 26 08:19:25 2013
@@ -377,8 +377,8 @@ Protect Mode: None
Partition Parameters:
COLUMN_STATS_ACCURATE true
numFiles 1
- numRows 5
- rawDataSize 70
+ numRows 6
+ rawDataSize 71
totalSize 77
#### A masked pattern was here ####
@@ -430,8 +430,8 @@ Protect Mode: None
Partition Parameters:
COLUMN_STATS_ACCURATE true
numFiles 1
- numRows 3
- rawDataSize 48
+ numRows 4
+ rawDataSize 49
totalSize 53
#### A masked pattern was here ####
@@ -542,7 +542,7 @@ POSTHOOK: Lineage: stats_null_part PARTI
POSTHOOK: Lineage: stats_null_part PARTITION(dt=2011).b SIMPLE [(temps_null)temps_null.FieldSchema(name:b, type:int, comment:null), ]
POSTHOOK: Lineage: stats_null_part PARTITION(dt=2011).c SIMPLE [(temps_null)temps_null.FieldSchema(name:c, type:string, comment:null), ]
POSTHOOK: Lineage: stats_null_part PARTITION(dt=2011).d SIMPLE [(temps_null)temps_null.FieldSchema(name:d, type:smallint, comment:null), ]
-8 6 6 8 8
+10 8 8 10 10
PREHOOK: query: drop table stats_null
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@stats_null
Modified: hive/branches/tez/ql/src/test/results/clientpositive/subquery_multiinsert.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/subquery_multiinsert.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/subquery_multiinsert.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/subquery_multiinsert.q.out Tue Nov 26 08:19:25 2013
@@ -189,7 +189,7 @@ STAGE PLANS:
type: string
expr: value
type: string
- sq_1:s1
+ sq_2:s1
TableScan
alias: s1
Filter Operator
Modified: hive/branches/tez/ql/src/test/results/clientpositive/transform_ppr1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/transform_ppr1.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/transform_ppr1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/transform_ppr1.q.out Tue Nov 26 08:19:25 2013
@@ -30,6 +30,8 @@ STAGE PLANS:
tmap:src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -40,6 +42,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
Transform Operator
command: cat
output info:
@@ -52,11 +56,15 @@ STAGE PLANS:
serialization.format 9
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: ((_col1 < 100) and (_col0 = '2008-04-08'))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col1
@@ -65,6 +73,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col1
type: string
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -252,6 +262,8 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col1
@@ -259,11 +271,15 @@ STAGE PLANS:
expr: _col2
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ 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: 11624 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/transform_ppr2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/transform_ppr2.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/transform_ppr2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/transform_ppr2.q.out Tue Nov 26 08:19:25 2013
@@ -32,6 +32,8 @@ STAGE PLANS:
tmap:src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -42,6 +44,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Transform Operator
command: cat
output info:
@@ -54,11 +58,15 @@ STAGE PLANS:
serialization.format 9
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: (_col1 < 100)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col1
@@ -67,6 +75,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col1
type: string
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -168,6 +178,8 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col1
@@ -175,11 +187,15 @@ STAGE PLANS:
expr: _col2
type: string
outputColumnNames: _col0, _col1
+ 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/udf7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf7.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf7.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf7.q.out Tue Nov 26 08:19:25 2013
@@ -100,11 +100,11 @@ STAGE PLANS:
expr: power((- 1), 2)
type: double
expr: power(CAST( 1 AS decimal(10,0)), 0)
- type: decimal(65,30)
+ type: decimal(38,18)
expr: power(CAST( 2 AS decimal(10,0)), 3)
- type: decimal(65,30)
+ type: decimal(38,18)
expr: pow(CAST( 2 AS decimal(10,0)), 3)
- type: decimal(65,30)
+ type: decimal(38,18)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26, _col27
File Output Operator
compressed: false
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_case.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_case.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_case.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_case.q.out Tue Nov 26 08:19:25 2013
@@ -172,3 +172,42 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
yo
+PREHOOK: query: -- Allow compatible types in when/return type
+SELECT CASE 1
+ WHEN 1 THEN 123.0BD
+ ELSE 0.0BD
+ END,
+ CASE 1
+ WHEN 1.0 THEN 123
+ WHEN 2 THEN 1.0
+ ELSE 222.02BD
+ END,
+ CASE 'abc'
+ WHEN cast('abc' as varchar(3)) THEN 'abcd'
+ WHEN 'efg' THEN cast('efgh' as varchar(10))
+ ELSE cast('ijkl' as char(4))
+ END
+FROM src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- Allow compatible types in when/return type
+SELECT CASE 1
+ WHEN 1 THEN 123.0BD
+ ELSE 0.0BD
+ END,
+ CASE 1
+ WHEN 1.0 THEN 123
+ WHEN 2 THEN 1.0
+ ELSE 222.02BD
+ END,
+ CASE 'abc'
+ WHEN cast('abc' as varchar(3)) THEN 'abcd'
+ WHEN 'efg' THEN cast('efgh' as varchar(10))
+ ELSE cast('ijkl' as char(4))
+ END
+FROM src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+123 123.0 abcd
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_explode.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_explode.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_explode.q.out Tue Nov 26 08:19:25 2013
@@ -27,19 +27,27 @@ STAGE PLANS:
TableScan
alias: src
Row Limit Per Split: 1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: array(1,2,3)
type: array<int>
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
UDTF Operator
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
function name: explode
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -127,19 +135,27 @@ STAGE PLANS:
TableScan
alias: src
Row Limit Per Split: 1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: array(1,2,3)
type: array<int>
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
UDTF Operator
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
function name: explode
Select Operator
expressions:
expr: col
type: int
outputColumnNames: col
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Group By Operator
aggregations:
expr: count(1)
@@ -149,6 +165,8 @@ STAGE PLANS:
type: int
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Reduce Output Operator
key expressions:
expr: _col0
@@ -157,6 +175,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: int
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
tag: -1
value expressions:
expr: _col1
@@ -219,6 +239,8 @@ STAGE PLANS:
type: int
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
@@ -226,11 +248,15 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -304,19 +330,27 @@ STAGE PLANS:
TableScan
alias: src
Row Limit Per Split: 1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: map(1:'one',2:'two',3:'three')
type: map<int,string>
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
UDTF Operator
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
function name: explode
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -404,13 +438,19 @@ STAGE PLANS:
TableScan
alias: src
Row Limit Per Split: 1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: map(1:'one',2:'two',3:'three')
type: map<int,string>
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
UDTF Operator
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
function name: explode
Select Operator
expressions:
@@ -419,6 +459,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: key, value
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Group By Operator
aggregations:
expr: count(1)
@@ -430,6 +472,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Reduce Output Operator
key expressions:
expr: _col0
@@ -442,6 +486,8 @@ STAGE PLANS:
type: int
expr: _col1
type: string
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
tag: -1
value expressions:
expr: _col2
@@ -506,6 +552,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
@@ -515,11 +563,15 @@ STAGE PLANS:
expr: _col2
type: bigint
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_java_method.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_java_method.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_java_method.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_java_method.q.out Tue Nov 26 08:19:25 2013
@@ -49,6 +49,8 @@ STAGE PLANS:
TableScan
alias: src
Row Limit Per Split: 1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
@@ -67,6 +69,8 @@ STAGE PLANS:
expr: reflect('java.lang.Math','floor',1.9)
type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
ListSink
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_pmod.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_pmod.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_pmod.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_pmod.q.out Tue Nov 26 08:19:25 2013
@@ -76,7 +76,7 @@ POSTHOOK: query: SELECT pmod(CAST(-100.9
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-6.8899984 51.700005 18.089996
+6.889998435974121 51.70000457763672 18.089996337890625
PREHOOK: query: SELECT pmod(CAST(-100.91 AS DOUBLE),CAST(9.8 AS DOUBLE)), pmod(CAST(-50.1 AS DOUBLE),CAST(101.8 AS DOUBLE)), pmod(CAST(-100.91 AS DOUBLE),CAST(29.75 AS DOUBLE)) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_reflect.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_reflect.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_reflect.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_reflect.q.out Tue Nov 26 08:19:25 2013
@@ -47,6 +47,8 @@ STAGE PLANS:
TableScan
alias: src
Row Limit Per Split: 1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -67,6 +69,8 @@ STAGE PLANS:
expr: reflect('java.lang.Integer','valueOf',key,16)
type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
ListSink