You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2014/12/16 02:13:30 UTC
svn commit: r1645808 [49/49] - in /hive/trunk:
accumulo-handler/src/test/results/positive/
common/src/java/org/apache/hadoop/hive/conf/
contrib/src/test/results/clientpositive/
hbase-handler/src/test/results/positive/
itests/hive-unit/src/test/java/org...
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_nested_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_nested_mapjoin.q.out?rev=1645808&r1=1645807&r2=1645808&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_nested_mapjoin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_nested_mapjoin.q.out Tue Dec 16 01:13:24 2014
@@ -11,77 +11,90 @@ STAGE PLANS:
Stage: Stage-8
Map Reduce Local Work
Alias -> Map Local Tables:
- t1:v1
+ $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:v1
Fetch Operator
limit: -1
- v3
+ $hdt$_0:$hdt$_0:$hdt$_1:v1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- t1:v1
+ $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:v1
TableScan
alias: v1
Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (ctinyint is not null and csmallint is not null) (type: boolean)
Statistics: Num rows: 3072 Data size: 94309 Basic stats: COMPLETE Column stats: NONE
- HashTable Sink Operator
- keys:
- 0 ctinyint (type: tinyint)
- 1 ctinyint (type: tinyint)
- v3
+ Select Operator
+ expressions: ctinyint (type: tinyint), csmallint (type: smallint), cdouble (type: double)
+ outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 3072 Data size: 94309 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ keys:
+ 0 _col0 (type: tinyint)
+ 1 _col0 (type: tinyint)
+ $hdt$_0:$hdt$_0:$hdt$_1:v1
TableScan
- alias: v3
+ alias: v1
Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: csmallint is not null (type: boolean)
Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
- HashTable Sink Operator
- keys:
- 0 _col0 (type: smallint)
- 1 csmallint (type: smallint)
+ Select Operator
+ expressions: csmallint (type: smallint)
+ outputColumnNames: _col0
+ Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ keys:
+ 0 _col0 (type: smallint)
+ 1 _col0 (type: smallint)
Stage: Stage-3
Map Reduce
Map Operator Tree:
TableScan
- alias: v2
+ alias: v1
Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ctinyint is not null (type: boolean)
Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 ctinyint (type: tinyint)
- 1 ctinyint (type: tinyint)
- outputColumnNames: _col0, _col1, _col5, _col15
- Statistics: Num rows: 6758 Data size: 207479 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (_col0 = _col15) (type: boolean)
- Statistics: Num rows: 3379 Data size: 103739 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: ctinyint (type: tinyint)
+ outputColumnNames: _col0
+ Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ keys:
+ 0 _col0 (type: tinyint)
+ 1 _col0 (type: tinyint)
+ outputColumnNames: _col1, _col2
+ Statistics: Num rows: 6758 Data size: 207479 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: smallint), _col5 (type: double)
+ expressions: _col1 (type: smallint), _col2 (type: double)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3379 Data size: 103739 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6758 Data size: 207479 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
keys:
0 _col0 (type: smallint)
- 1 csmallint (type: smallint)
+ 1 _col0 (type: smallint)
outputColumnNames: _col1
- Statistics: Num rows: 6758 Data size: 207479 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: sum(_col1)
- mode: hash
+ Statistics: Num rows: 7433 Data size: 228226 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col1 (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- sort order:
+ Statistics: Num rows: 7433 Data size: 228226 Basic stats: COMPLETE Column stats: NONE
+ Group By Operator
+ aggregations: sum(_col0)
+ mode: hash
+ outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: double)
+ Reduce Output Operator
+ sort order:
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: double)
Local Work:
Map Reduce Local Work
Execution mode: vectorized
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_parquet.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_parquet.q.out?rev=1645808&r1=1645807&r2=1645808&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_parquet.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_parquet.q.out Tue Dec 16 01:13:24 2014
@@ -147,11 +147,11 @@ STAGE PLANS:
Statistics: Num rows: 12288 Data size: 73728 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: ctinyint (type: tinyint), cint (type: int), csmallint (type: smallint), cstring1 (type: string), cfloat (type: float), cdouble (type: double)
- outputColumnNames: ctinyint, cint, csmallint, cstring1, cfloat, cdouble
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 12288 Data size: 73728 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: max(cint), min(csmallint), count(cstring1), avg(cfloat), stddev_pop(cdouble)
- keys: ctinyint (type: tinyint)
+ aggregations: max(_col1), min(_col2), count(_col3), avg(_col4), stddev_pop(_col5)
+ keys: _col0 (type: tinyint)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 12288 Data size: 73728 Basic stats: COMPLETE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out?rev=1645808&r1=1645807&r2=1645808&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out Tue Dec 16 01:13:24 2014
@@ -21,43 +21,55 @@ STAGE PLANS:
Filter Operator
predicate: cint is not null (type: boolean)
Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: cint (type: int)
- sort order: +
- Map-reduce partition columns: cint (type: int)
+ Select Operator
+ expressions: cint (type: int)
+ outputColumnNames: _col0
Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: int)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: int)
+ Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
TableScan
- alias: t2
+ alias: t1
Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: cint is not null (type: boolean)
Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: cint (type: int)
- sort order: +
- Map-reduce partition columns: cint (type: int)
+ Select Operator
+ expressions: cint (type: int)
+ outputColumnNames: _col0
Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: int)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: int)
+ Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
Execution mode: vectorized
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
keys:
- 0 cint (type: int)
- 1 cint (type: int)
- outputColumnNames: _col2, _col17
+ 0 _col0 (type: int)
+ 1 _col0 (type: int)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 6758 Data size: 207479 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: count(_col2), max(_col17), min(_col2), avg((_col2 + _col17))
- mode: hash
- outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+ Select Operator
+ expressions: _col0 (type: int), _col1 (type: int), (_col0 + _col1) (type: int)
+ outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 6758 Data size: 207479 Basic stats: COMPLETE Column stats: NONE
+ Group By Operator
+ aggregations: count(_col0), max(_col1), min(_col0), avg(_col2)
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
Stage: Stage-2
Map Reduce
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out?rev=1645808&r1=1645807&r2=1645808&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out Tue Dec 16 01:13:24 2014
@@ -609,10 +609,10 @@ STAGE PLANS:
Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: ctimestamp1 (type: timestamp)
- outputColumnNames: ctimestamp1
+ outputColumnNames: _col0
Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: min(ctimestamp1), max(ctimestamp1), count(ctimestamp1), count()
+ aggregations: min(_col0), max(_col0), count(_col0), count()
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: NONE
@@ -687,10 +687,10 @@ STAGE PLANS:
Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: ctimestamp1 (type: timestamp)
- outputColumnNames: ctimestamp1
+ outputColumnNames: _col0
Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(ctimestamp1)
+ aggregations: sum(_col0)
mode: hash
outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
@@ -770,10 +770,10 @@ STAGE PLANS:
Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: ctimestamp1 (type: timestamp)
- outputColumnNames: ctimestamp1
+ outputColumnNames: _col0
Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: avg(ctimestamp1), variance(ctimestamp1), var_pop(ctimestamp1), var_samp(ctimestamp1), std(ctimestamp1), stddev(ctimestamp1), stddev_pop(ctimestamp1), stddev_samp(ctimestamp1)
+ aggregations: avg(_col0), variance(_col0), var_pop(_col0), var_samp(_col0), std(_col0), stddev(_col0), stddev_pop(_col0), stddev_samp(_col0)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_streaming.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_streaming.q.out?rev=1645808&r1=1645807&r2=1645808&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_streaming.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_streaming.q.out Tue Dec 16 01:13:24 2014
@@ -65,19 +65,23 @@ STAGE PLANS:
TableScan
alias: part
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: p_mfgr (type: string), p_name (type: string)
- sort order: ++
- Map-reduce partition columns: p_mfgr (type: string)
+ Select Operator
+ expressions: p_name (type: string), p_mfgr (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_name (type: string), p_mfgr (type: string)
+ Reduce Output Operator
+ key expressions: _col1 (type: string), _col0 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col1 (type: string)
+ Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string), _col1 (type: string)
Reduce Operator Tree:
Extract
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col2 (type: string), _wcol0 (type: int)
+ expressions: _col1 (type: string), _wcol0 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -115,13 +119,17 @@ STAGE PLANS:
TableScan
alias: part
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: p_mfgr (type: string), p_name (type: string)
- sort order: ++
- Map-reduce partition columns: p_mfgr (type: string)
+ Select Operator
+ expressions: p_name (type: string), p_mfgr (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
- TopN Hash Memory Usage: 0.8
- value expressions: p_name (type: string), p_mfgr (type: string)
+ Reduce Output Operator
+ key expressions: _col1 (type: string), _col0 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col1 (type: string)
+ Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
+ TopN Hash Memory Usage: 0.8
+ value expressions: _col0 (type: string), _col1 (type: string)
Reduce Operator Tree:
Extract
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
@@ -131,7 +139,7 @@ STAGE PLANS:
predicate: (_wcol0 < 4) (type: boolean)
Statistics: Num rows: 8 Data size: 968 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col2 (type: string), _wcol0 (type: int)
+ expressions: _col1 (type: string), _wcol0 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 8 Data size: 968 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -264,13 +272,17 @@ STAGE PLANS:
TableScan
alias: alltypesorc
Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: ctinyint (type: tinyint), cdouble (type: double)
- sort order: ++
- Map-reduce partition columns: ctinyint (type: tinyint)
+ Select Operator
+ expressions: ctinyint (type: tinyint), cdouble (type: double)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
- TopN Hash Memory Usage: 0.8
- value expressions: ctinyint (type: tinyint), cdouble (type: double)
+ Reduce Output Operator
+ key expressions: _col0 (type: tinyint), _col1 (type: double)
+ sort order: ++
+ Map-reduce partition columns: _col0 (type: tinyint)
+ Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
+ TopN Hash Memory Usage: 0.8
+ value expressions: _col0 (type: tinyint), _col1 (type: double)
Reduce Operator Tree:
Extract
Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
@@ -280,7 +292,7 @@ STAGE PLANS:
predicate: (_wcol0 < 5) (type: boolean)
Statistics: Num rows: 4096 Data size: 125745 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: tinyint), _col5 (type: double), _wcol0 (type: int)
+ expressions: _col0 (type: tinyint), _col1 (type: double), _wcol0 (type: int)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 4096 Data size: 125745 Basic stats: COMPLETE Column stats: NONE
File Output Operator