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/18 20:29:27 UTC
svn commit: r1543120 [11/16] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/conf/ data/files/
ql/src/java/org/apache/hadoop/hive/ql/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/...
Modified: hive/trunk/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out Mon Nov 18 19:29:24 2013
@@ -67,17 +67,23 @@ STAGE PLANS:
dynamic_part_table
TableScan
alias: dynamic_part_table
+ Statistics:
+ numRows: 0 dataSize: 2 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: intcol
type: int
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 2 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 2 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -168,17 +174,23 @@ STAGE PLANS:
dynamic_part_table
TableScan
alias: dynamic_part_table
+ Statistics:
+ numRows: 0 dataSize: 2 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: intcol
type: int
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 2 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 2 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -269,17 +281,23 @@ STAGE PLANS:
dynamic_part_table
TableScan
alias: dynamic_part_table
+ Statistics:
+ numRows: 0 dataSize: 4 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: intcol
type: int
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 4 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 4 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/filter_join_breaktask.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out Mon Nov 18 19:29:24 2013
@@ -42,12 +42,16 @@ STAGE PLANS:
f
TableScan
alias: f
+ Statistics:
+ numRows: 25 dataSize: 211 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: key is not null
type: boolean
+ Statistics:
+ numRows: 25 dataSize: 211 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -56,6 +60,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 25 dataSize: 211 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -63,12 +69,16 @@ STAGE PLANS:
m
TableScan
alias: m
+ Statistics:
+ numRows: 25 dataSize: 211 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key is not null and value is not null) and (value <> ''))
type: boolean
+ Statistics:
+ numRows: 25 dataSize: 211 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -77,6 +87,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 25 dataSize: 211 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: value
@@ -176,12 +188,16 @@ STAGE PLANS:
g
TableScan
alias: g
+ Statistics:
+ numRows: 25 dataSize: 211 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value <> '')
type: boolean
+ Statistics:
+ numRows: 25 dataSize: 211 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: value
@@ -190,6 +206,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: value
type: string
+ Statistics:
+ numRows: 25 dataSize: 211 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: value
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out Mon Nov 18 19:29:24 2013
@@ -32,6 +32,8 @@ STAGE PLANS:
src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -40,6 +42,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: key, value
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Group By Operator
aggregations:
expr: count(DISTINCT substr(value, 5))
@@ -52,6 +56,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -62,6 +68,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col2
@@ -170,6 +178,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -179,11 +189,15 @@ STAGE PLANS:
expr: concat(_col0, _col2)
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 11624 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
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out Mon Nov 18 19:29:24 2013
@@ -32,6 +32,8 @@ STAGE PLANS:
src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -40,6 +42,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: key, value
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Group By Operator
aggregations:
expr: count(DISTINCT substr(value, 5))
@@ -56,6 +60,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -68,6 +74,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col3
@@ -182,6 +190,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -195,11 +205,15 @@ STAGE PLANS:
expr: UDFToInteger(_col4)
type: int
outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics:
+ numRows: 0 dataSize: 11624 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
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_ppr.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_ppr.q.out Mon Nov 18 19:29:24 2013
@@ -32,6 +32,8 @@ STAGE PLANS:
src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -40,6 +42,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: key, value
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: substr(key, 1, 1)
@@ -50,6 +54,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: substr(key, 1, 1)
type: string
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
Path -> Alias:
#### A masked pattern was here ####
@@ -153,6 +159,8 @@ STAGE PLANS:
type: string
mode: complete
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -162,11 +170,15 @@ STAGE PLANS:
expr: concat(_col0, _col2)
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 11624 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
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out Mon Nov 18 19:29:24 2013
@@ -32,6 +32,8 @@ STAGE PLANS:
src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -40,6 +42,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: key, value
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: substr(key, 1, 1)
@@ -52,6 +56,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: substr(key, 1, 1)
type: string
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
Path -> Alias:
#### A masked pattern was here ####
@@ -157,6 +163,8 @@ STAGE PLANS:
type: string
mode: complete
outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -170,11 +178,15 @@ STAGE PLANS:
expr: UDFToInteger(_col4)
type: int
outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics:
+ numRows: 0 dataSize: 11624 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
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_sort_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_sort_1.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_sort_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_sort_1.q.out Mon Nov 18 19:29:24 2013
@@ -66,12 +66,16 @@ STAGE PLANS:
t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -81,6 +85,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -88,11 +94,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -409,6 +419,8 @@ STAGE PLANS:
t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -417,6 +429,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: key, val
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -428,6 +442,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -440,6 +456,8 @@ STAGE PLANS:
type: string
expr: _col1
type: string
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col2
@@ -508,6 +526,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -517,11 +537,15 @@ STAGE PLANS:
expr: UDFToInteger(_col2)
type: int
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -644,12 +668,16 @@ STAGE PLANS:
subq1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: _col0
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -659,6 +687,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -666,11 +696,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1038,12 +1072,16 @@ STAGE PLANS:
subq1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: _col0
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -1053,6 +1091,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -1060,11 +1100,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1456,12 +1500,16 @@ STAGE PLANS:
t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -1473,6 +1521,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1482,11 +1532,15 @@ STAGE PLANS:
expr: UDFToInteger(_col2)
type: int
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1843,6 +1897,8 @@ STAGE PLANS:
t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -1851,6 +1907,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: key, val
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -1864,6 +1922,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -1880,6 +1940,8 @@ STAGE PLANS:
type: int
expr: _col2
type: string
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col3
@@ -1950,6 +2012,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -1961,11 +2025,15 @@ STAGE PLANS:
expr: UDFToInteger(_col3)
type: int
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2116,12 +2184,16 @@ STAGE PLANS:
t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -2133,6 +2205,8 @@ STAGE PLANS:
type: double
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -2145,6 +2219,8 @@ STAGE PLANS:
type: string
expr: _col1
type: double
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col2
@@ -2213,6 +2289,8 @@ STAGE PLANS:
type: double
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -2222,11 +2300,15 @@ STAGE PLANS:
expr: UDFToInteger(_col2)
type: int
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2405,12 +2487,16 @@ STAGE PLANS:
subq1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -2420,6 +2506,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -2427,6 +2515,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: sum(_col1)
@@ -2436,6 +2526,8 @@ STAGE PLANS:
type: double
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -2444,6 +2536,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: double
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -2510,6 +2604,8 @@ STAGE PLANS:
type: double
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -2517,11 +2613,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2713,12 +2813,16 @@ STAGE PLANS:
null-subquery1:subq1-subquery1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -2728,6 +2832,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -2735,7 +2841,11 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -2743,11 +2853,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2775,12 +2889,16 @@ STAGE PLANS:
null-subquery2:subq1-subquery2:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -2790,6 +2908,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -2797,7 +2917,11 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -2805,11 +2929,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3247,12 +3375,16 @@ STAGE PLANS:
null-subquery2:subq1-subquery2:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -3262,6 +3394,8 @@ STAGE PLANS:
type: double
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -3270,6 +3404,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: double
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -3336,6 +3472,8 @@ STAGE PLANS:
type: double
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -3343,6 +3481,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -3368,6 +3508,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -3375,11 +3517,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3407,12 +3553,16 @@ STAGE PLANS:
null-subquery1:subq1-subquery1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -3422,6 +3572,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToDouble(_col0)
@@ -3429,7 +3581,11 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -3437,11 +3593,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3900,12 +4060,16 @@ STAGE PLANS:
subq1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -3915,6 +4079,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -3922,6 +4088,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -3930,6 +4098,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: _col0
@@ -3939,12 +4109,16 @@ STAGE PLANS:
subq2:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -3954,6 +4128,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -3961,6 +4137,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -3969,6 +4147,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: _col1
@@ -4252,6 +4432,8 @@ STAGE PLANS:
subq2:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -4260,6 +4442,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: key, val
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -4271,6 +4455,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -4283,6 +4469,8 @@ STAGE PLANS:
type: string
expr: _col1
type: string
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col2
@@ -4351,6 +4539,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -4360,6 +4550,8 @@ STAGE PLANS:
expr: _col2
type: bigint
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -4392,6 +4584,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: _col0
@@ -4403,12 +4597,16 @@ STAGE PLANS:
subq1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -4418,6 +4616,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -4425,6 +4625,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -4433,6 +4635,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: _col0
@@ -4693,12 +4897,16 @@ STAGE PLANS:
t2
TableScan
alias: t2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -4708,6 +4916,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -4716,6 +4926,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -4782,6 +4994,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -4789,11 +5003,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -5005,6 +5223,8 @@ STAGE PLANS:
t2
TableScan
alias: t2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -5013,6 +5233,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: key, val
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -5026,6 +5248,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -5037,11 +5261,15 @@ STAGE PLANS:
expr: UDFToInteger(_col3)
type: int
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -5538,6 +5766,8 @@ STAGE PLANS:
t2
TableScan
alias: t2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -5546,6 +5776,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: key, val
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -5561,6 +5793,8 @@ STAGE PLANS:
type: int
mode: final
outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -5574,11 +5808,15 @@ STAGE PLANS:
expr: UDFToInteger(_col4)
type: int
outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -6012,6 +6250,8 @@ STAGE PLANS:
subq:t2
TableScan
alias: t2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -6022,6 +6262,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -6035,6 +6277,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -6046,11 +6290,15 @@ STAGE PLANS:
expr: UDFToInteger(_col3)
type: int
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -6544,6 +6792,8 @@ STAGE PLANS:
subq2:subq:t2
TableScan
alias: t2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -6554,6 +6804,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: _col0, _col3, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -6567,6 +6819,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -6578,11 +6832,15 @@ STAGE PLANS:
expr: UDFToInteger(_col3)
type: int
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_sort_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_sort_6.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_sort_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_sort_6.q.out Mon Nov 18 19:29:24 2013
@@ -33,17 +33,23 @@ STAGE PLANS:
t1
TableScan
alias: t1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (ds = '1')
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -53,6 +59,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -61,6 +69,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -76,6 +86,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -83,11 +95,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ 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
@@ -193,17 +209,23 @@ STAGE PLANS:
t1
TableScan
alias: t1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (ds = '1')
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -213,6 +235,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -221,6 +245,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -236,6 +262,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -243,11 +271,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ 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
@@ -362,12 +394,16 @@ STAGE PLANS:
t1
TableScan
alias: t1
+ Statistics:
+ numRows: 0 dataSize: 30 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 0 dataSize: 30 basicStatsState: PARTIAL colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -377,6 +413,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 30 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -385,6 +423,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 30 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -446,6 +486,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 30 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -453,11 +495,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 30 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 30 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat