You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/10/06 05:44:26 UTC
svn commit: r1629562 [15/38] - in /hive/branches/spark: ./ accumulo-handler/
beeline/ beeline/src/java/org/apache/hive/beeline/ bin/ext/ common/
common/src/java/org/apache/hadoop/hive/conf/
common/src/test/org/apache/hadoop/hive/common/type/ contrib/sr...
Modified: hive/branches/spark/ql/src/test/results/clientpositive/input4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input4.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/input4.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/input4.q.out Mon Oct 6 03:44:13 2014
@@ -44,7 +44,7 @@ PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN FORMATTED
SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias
POSTHOOK: type: QUERY
-{"STAGE PLANS":{"Stage-0":{"Fetch Operator":{"limit:":"-1","Processor Tree:":{"TableScan":{"alias:":"input4alias","children":{"Select Operator":{"expressions:":"value (type: string), key (type: string)","outputColumnNames:":["_col0","_col1"],"children":{"ListSink":{}},"Statistics:":"Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE"}},"Statistics:":"Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE"}}}}},"STAGE DEPENDENCIES":{"Stage-0":{"ROOT STAGE":"TRUE"}}}
+{"STAGE PLANS":{"Stage-1":{"Map Reduce":{"Map Operator Tree:":[{"TableScan":{"alias:":"input4alias","children":{"Select Operator":{"expressions:":"value (type: string), key (type: string)","outputColumnNames:":["_col0","_col1"],"children":{"File Output Operator":{"Statistics:":"Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE","compressed:":"false","table:":{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}}},"Statistics:":"Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE"}},"Statistics:":"Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE"}}]}},"Stage-0":{"Fetch Operator":{"limit:":"-1","Processor Tree:":{"ListSink":{}}}}},"STAGE DEPENDENCIES":{"Stage-1":{"ROOT STAGE":"TRUE"},"Stage-0":{"DEPENDENT STAGES":"Stage-1"}}}
PREHOOK: query: SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias
PREHOOK: type: QUERY
PREHOOK: Input: default@input4
Modified: hive/branches/spark/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out Mon Oct 6 03:44:13 2014
@@ -8,15 +8,13 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_ivtt
PREHOOK: query: insert into table acid_ivtt values
(1, 109.23, 'mary had a little lamb'),
- (429496729, 0.14, 'its fleece was white as snow'),
- (-29496729, -0.14, 'negative values test')
+ (429496729, 0.14, 'its fleece was white as snow')
PREHOOK: type: QUERY
PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acid_ivtt
POSTHOOK: query: insert into table acid_ivtt values
(1, 109.23, 'mary had a little lamb'),
- (429496729, 0.14, 'its fleece was white as snow'),
- (-29496729, -0.14, 'negative values test')
+ (429496729, 0.14, 'its fleece was white as snow')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acid_ivtt
@@ -31,6 +29,5 @@ POSTHOOK: query: select i, de, vc from a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_ivtt
#### A masked pattern was here ####
--29496729 -0.14 negative values test
1 109.23 mary had a little lamb
429496729 0.14 its fleece was white as snow
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join8.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join8.q.out Mon Oct 6 03:44:13 2014
@@ -90,7 +90,7 @@ STAGE PLANS:
predicate: _col2 is null (type: boolean)
Statistics: Num rows: 15 Data size: 163 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), UDFToInteger(null) (type: int), _col3 (type: string)
+ expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), UDFToInteger(_col2) (type: int), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 15 Data size: 163 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join_view.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join_view.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join_view.q.out Mon Oct 6 03:44:13 2014
@@ -59,7 +59,7 @@ STAGE PLANS:
outputColumnNames: _col1, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col6 (type: int), '2011-09-01' (type: string)
+ expressions: _col1 (type: string), _col6 (type: int), _col8 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/keyword_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/keyword_1.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/keyword_1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/keyword_1.q.out Mon Oct 6 03:44:13 2014
@@ -21,21 +21,33 @@ PREHOOK: type: QUERY
POSTHOOK: query: explain select user from test_user
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-0 is a root stage
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ alias: test_user
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Select Operator
+ expressions: user (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
Stage: Stage-0
Fetch Operator
limit: -1
Processor Tree:
- TableScan
- alias: test_user
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- Select Operator
- expressions: user (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- ListSink
+ ListSink
PREHOOK: query: show grant user hive_test on table test_user
PREHOOK: type: SHOW_GRANT
@@ -69,21 +81,33 @@ PREHOOK: type: QUERY
POSTHOOK: query: explain select role from test_user
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-0 is a root stage
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ alias: test_user
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Select Operator
+ expressions: role (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
Stage: Stage-0
Fetch Operator
limit: -1
Processor Tree:
- TableScan
- alias: test_user
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- Select Operator
- expressions: role (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- ListSink
+ ListSink
PREHOOK: query: show grant user hive_test on table test_user
PREHOOK: type: SHOW_GRANT
Modified: hive/branches/spark/ql/src/test/results/clientpositive/lateral_view_ppd.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/lateral_view_ppd.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/lateral_view_ppd.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/lateral_view_ppd.q.out Mon Oct 6 03:44:13 2014
@@ -109,7 +109,7 @@ STAGE PLANS:
outputColumnNames: _col1, _col5
Statistics: Num rows: 375 Data size: 3984 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), 1 (type: int)
+ expressions: _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 375 Data size: 3984 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -133,7 +133,7 @@ STAGE PLANS:
outputColumnNames: _col1, _col5
Statistics: Num rows: 375 Data size: 3984 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), 1 (type: int)
+ expressions: _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 375 Data size: 3984 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/limit0.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/limit0.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/limit0.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/limit0.q.out Mon Oct 6 03:44:13 2014
@@ -42,25 +42,19 @@ STAGE PLANS:
PREHOOK: query: select * from src where key = '238' limit 0
PREHOOK: type: QUERY
-PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: select * from src where key = '238' limit 0
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
#### A masked pattern was here ####
PREHOOK: query: select src.key, count(src.value) from src group by src.key limit 0
PREHOOK: type: QUERY
-PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: select src.key, count(src.value) from src group by src.key limit 0
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
#### A masked pattern was here ####
PREHOOK: query: select * from ( select key from src limit 3) sq1 limit 0
PREHOOK: type: QUERY
-PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: select * from ( select key from src limit 3) sq1 limit 0
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/spark/ql/src/test/results/clientpositive/limit_partition_metadataonly.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/limit_partition_metadataonly.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/limit_partition_metadataonly.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/limit_partition_metadataonly.q.out Mon Oct 6 03:44:13 2014
@@ -3,21 +3,33 @@ PREHOOK: type: QUERY
POSTHOOK: query: explain select ds from srcpart where hr=11 and ds='2008-04-08'
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-0 is a root stage
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ alias: srcpart
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: COMPLETE
+ Select Operator
+ expressions: ds (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 500 Data size: 92000 Basic stats: COMPLETE Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 500 Data size: 92000 Basic stats: COMPLETE Column stats: COMPLETE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
Stage: Stage-0
Fetch Operator
limit: -1
Processor Tree:
- TableScan
- alias: srcpart
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: ds (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- ListSink
+ ListSink
PREHOOK: query: select ds from srcpart where hr=11 and ds='2008-04-08'
PREHOOK: type: QUERY
@@ -543,34 +555,34 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
- Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: hr (type: string)
outputColumnNames: hr
- Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
keys: hr (type: string)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2000 Data size: 368000 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2000 Data size: 368000 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 184000 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 184000 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 184000 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/branches/spark/ql/src/test/results/clientpositive/limit_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/limit_pushdown.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/limit_pushdown.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/limit_pushdown.q.out Mon Oct 6 03:44:13 2014
@@ -631,11 +631,9 @@ STAGE PLANS:
PREHOOK: query: select key,value from src order by key limit 0
PREHOOK: type: QUERY
-PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: select key,value from src order by key limit 0
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
#### A masked pattern was here ####
PREHOOK: query: -- 2MR (applied to last RS)
explain
Modified: hive/branches/spark/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out Mon Oct 6 03:44:13 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out Mon Oct 6 03:44:13 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/metadata_only_queries.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/metadata_only_queries.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/metadata_only_queries.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/metadata_only_queries.q.out Mon Oct 6 03:44:13 2014
@@ -340,11 +340,9 @@ STAGE PLANS:
PREHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl
PREHOOK: type: QUERY
-PREHOOK: Input: default@stats_tbl
#### A masked pattern was here ####
POSTHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@stats_tbl
#### A masked pattern was here ####
9999 9999 1999.8 9999 9999 9999 9999 9999
PREHOOK: query: explain
@@ -365,11 +363,9 @@ STAGE PLANS:
PREHOOK: query: select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl
PREHOOK: type: QUERY
-PREHOOK: Input: default@stats_tbl
#### A masked pattern was here ####
POSTHOOK: query: select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@stats_tbl
#### A masked pattern was here ####
65536 65791 4294967296 4294967551 0.009999999776482582 99.9800033569336 0.01 50.0
PREHOOK: query: explain
@@ -390,11 +386,9 @@ STAGE PLANS:
PREHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl_part
PREHOOK: type: QUERY
-PREHOOK: Input: default@stats_tbl_part
#### A masked pattern was here ####
POSTHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl_part
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@stats_tbl_part
#### A masked pattern was here ####
9489 9489 1897.8 9489 9489 9489 9489 9489
PREHOOK: query: explain
@@ -415,11 +409,9 @@ STAGE PLANS:
PREHOOK: query: select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl_part
PREHOOK: type: QUERY
-PREHOOK: Input: default@stats_tbl_part
#### A masked pattern was here ####
POSTHOOK: query: select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl_part
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@stats_tbl_part
#### A masked pattern was here ####
65536 65791 4294967296 4294967551 0.009999999776482582 99.9800033569336 0.01 50.0
PREHOOK: query: explain select count(ts) from stats_tbl_part
Modified: hive/branches/spark/ql/src/test/results/clientpositive/metadata_only_queries_with_filters.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/metadata_only_queries_with_filters.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/metadata_only_queries_with_filters.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/metadata_only_queries_with_filters.q.out Mon Oct 6 03:44:13 2014
@@ -160,11 +160,9 @@ STAGE PLANS:
PREHOOK: query: select count(*), count(1), sum(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part where dt = 2010
PREHOOK: type: QUERY
-PREHOOK: Input: default@stats_tbl_part
#### A masked pattern was here ####
POSTHOOK: query: select count(*), count(1), sum(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part where dt = 2010
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@stats_tbl_part
#### A masked pattern was here ####
2322 2322 2322 2322 2322 2322 2322 65791 4294967296 99.9800033569336 0.03
PREHOOK: query: explain
@@ -185,20 +183,16 @@ STAGE PLANS:
PREHOOK: query: select count(*), count(1), sum(1), sum(2), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part where dt > 2010
PREHOOK: type: QUERY
-PREHOOK: Input: default@stats_tbl_part
#### A masked pattern was here ####
POSTHOOK: query: select count(*), count(1), sum(1), sum(2), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part where dt > 2010
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@stats_tbl_part
#### A masked pattern was here ####
2219 2219 2219 4438 2219 2219 2219 2219 65791 4294967296 99.95999908447266 0.04
PREHOOK: query: select count(*) from stats_tbl_part
PREHOOK: type: QUERY
-PREHOOK: Input: default@stats_tbl_part
#### A masked pattern was here ####
POSTHOOK: query: select count(*) from stats_tbl_part
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@stats_tbl_part
#### A masked pattern was here ####
4541
PREHOOK: query: select count(*)/2 from stats_tbl_part
Modified: hive/branches/spark/ql/src/test/results/clientpositive/metadataonly1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/metadataonly1.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/metadataonly1.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/metadataonly1.q.out Mon Oct 6 03:44:13 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/nonmr_fetch.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/nonmr_fetch.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/nonmr_fetch.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/nonmr_fetch.q.out Mon Oct 6 03:44:13 2014
@@ -93,24 +93,36 @@ POSTHOOK: query: -- negative, select exp
explain select key from src limit 10
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-0 is a root stage
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ alias: src
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: key (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Limit
+ Number of rows: 10
+ Statistics: Num rows: 10 Data size: 100 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 10 Data size: 100 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
Stage: Stage-0
Fetch Operator
limit: 10
Processor Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Limit
- Number of rows: 10
- Statistics: Num rows: 10 Data size: 100 Basic stats: COMPLETE Column stats: NONE
- ListSink
+ ListSink
PREHOOK: query: select key from src limit 10
PREHOOK: type: QUERY
@@ -1036,21 +1048,33 @@ POSTHOOK: query: -- negative, subq
explain select a.* from (select * from src) a
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-0 is a root stage
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ alias: src
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
Stage: Stage-0
Fetch Operator
limit: -1
Processor Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- ListSink
+ ListSink
PREHOOK: query: -- negative, join
explain select * from src join src src2 on src.key=src2.key
Modified: hive/branches/spark/ql/src/test/results/clientpositive/nullgroup3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/nullgroup3.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/nullgroup3.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/nullgroup3.q.out Mon Oct 6 03:44:13 2014
@@ -40,31 +40,31 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tstparttbl
- Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE
Select Operator
- Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE
Group By Operator
aggregations: count(1)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: bigint)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -131,31 +131,31 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tstparttbl2
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
Select Operator
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
Group By Operator
aggregations: count(1)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: bigint)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -230,31 +230,31 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tstparttbl
- Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE
Select Operator
- Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE
Group By Operator
aggregations: count(1)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: bigint)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -329,31 +329,31 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tstparttbl2
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
Select Operator
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
Group By Operator
aggregations: count(1)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: bigint)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/branches/spark/ql/src/test/results/clientpositive/orc_analyze.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_analyze.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_analyze.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_analyze.q.out Mon Oct 6 03:44:13 2014
@@ -73,11 +73,9 @@ POSTHOOK: Lineage: orc_create_people.sta
POSTHOOK: Lineage: orc_create_people.state SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:state, type:string, comment:null), ]
PREHOOK: query: analyze table orc_create_people compute statistics partialscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_create_people
PREHOOK: Output: default@orc_create_people
POSTHOOK: query: analyze table orc_create_people compute statistics partialscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_create_people
POSTHOOK: Output: default@orc_create_people
PREHOOK: query: desc formatted orc_create_people
PREHOOK: type: DESCTABLE
@@ -107,7 +105,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3121
+ totalSize 3123
#### A masked pattern was here ####
# Storage Information
@@ -197,7 +195,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3121
+ totalSize 3123
#### A masked pattern was here ####
# Storage Information
@@ -271,13 +269,11 @@ POSTHOOK: Lineage: orc_create_people PAR
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).start_date SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:start_date, type:timestamp, comment:null), ]
PREHOOK: query: analyze table orc_create_people partition(state) compute statistics partialscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_create_people
PREHOOK: Output: default@orc_create_people
PREHOOK: Output: default@orc_create_people@state=Ca
PREHOOK: Output: default@orc_create_people@state=Or
POSTHOOK: query: analyze table orc_create_people partition(state) compute statistics partialscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_create_people
POSTHOOK: Output: default@orc_create_people
POSTHOOK: Output: default@orc_create_people@state=Ca
POSTHOOK: Output: default@orc_create_people@state=Or
@@ -585,13 +581,11 @@ POSTHOOK: Lineage: orc_create_people PAR
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).start_date SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:start_date, type:timestamp, comment:null), ]
PREHOOK: query: analyze table orc_create_people partition(state) compute statistics partialscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_create_people
PREHOOK: Output: default@orc_create_people
PREHOOK: Output: default@orc_create_people@state=Ca
PREHOOK: Output: default@orc_create_people@state=Or
POSTHOOK: query: analyze table orc_create_people partition(state) compute statistics partialscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_create_people
POSTHOOK: Output: default@orc_create_people
POSTHOOK: Output: default@orc_create_people@state=Ca
POSTHOOK: Output: default@orc_create_people@state=Or
@@ -627,7 +621,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 21980
- totalSize 4959
+ totalSize 4963
#### A masked pattern was here ####
# Storage Information
@@ -672,7 +666,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 22048
- totalSize 5044
+ totalSize 5051
#### A masked pattern was here ####
# Storage Information
@@ -780,7 +774,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 21980
- totalSize 4959
+ totalSize 4963
#### A masked pattern was here ####
# Storage Information
@@ -825,7 +819,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 22048
- totalSize 5044
+ totalSize 5051
#### A masked pattern was here ####
# Storage Information
@@ -948,14 +942,12 @@ POSTHOOK: Input: default@orc_create_peop
POSTHOOK: Output: default@orc_create_people
PREHOOK: query: analyze table orc_create_people partition(state) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_create_people
PREHOOK: Output: default@orc_create_people
PREHOOK: Output: default@orc_create_people@state=Ca
PREHOOK: Output: default@orc_create_people@state=OH
PREHOOK: Output: default@orc_create_people@state=Or
POSTHOOK: query: analyze table orc_create_people partition(state) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_create_people
POSTHOOK: Output: default@orc_create_people
POSTHOOK: Output: default@orc_create_people@state=Ca
POSTHOOK: Output: default@orc_create_people@state=OH
Modified: hive/branches/spark/ql/src/test/results/clientpositive/orc_create.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_create.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_create.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_create.q.out Mon Oct 6 03:44:13 2014
@@ -416,9 +416,9 @@ POSTHOOK: query: SELECT strct from orc_c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_complex
#### A masked pattern was here ####
-{"A":"five","B":"six"}
-{"A":"one","B":"two"}
-{"A":"three","B":"four"}
+{"a":"five","b":"six"}
+{"a":"one","b":"two"}
+{"a":"three","b":"four"}
PREHOOK: query: CREATE TABLE orc_create_people_staging (
id int,
first_name string,
Modified: hive/branches/spark/ql/src/test/results/clientpositive/orc_merge1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge1.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_merge1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge1.q.out Mon Oct 6 03:44:13 2014
@@ -139,7 +139,7 @@ Partition Parameters:
numFiles 2
numRows 242
rawDataSize 22748
- totalSize 1747
+ totalSize 1750
#### A masked pattern was here ####
# Storage Information
@@ -295,7 +295,7 @@ Partition Parameters:
numFiles 1
numRows 242
rawDataSize 22748
- totalSize 1332
+ totalSize 1335
#### A masked pattern was here ####
# Storage Information
@@ -441,7 +441,7 @@ Partition Parameters:
numFiles 1
numRows 242
rawDataSize 22748
- totalSize 1623
+ totalSize 1626
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/spark/ql/src/test/results/clientpositive/orc_merge5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge5.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_merge5.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge5.q.out Mon Oct 6 03:44:13 2014
@@ -90,12 +90,10 @@ POSTHOOK: Lineage: orc_merge5b.userid SI
PREHOOK: query: -- 3 files total
analyze table orc_merge5b compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5b
PREHOOK: Output: default@orc_merge5b
POSTHOOK: query: -- 3 files total
analyze table orc_merge5b compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
PREHOOK: query: desc formatted orc_merge5b
PREHOOK: type: DESCTABLE
@@ -123,7 +121,7 @@ Table Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1133
+ totalSize 1141
#### A masked pattern was here ####
# Storage Information
@@ -245,12 +243,10 @@ POSTHOOK: Lineage: orc_merge5b.userid SI
PREHOOK: query: -- 1 file after merging
analyze table orc_merge5b compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5b
PREHOOK: Output: default@orc_merge5b
POSTHOOK: query: -- 1 file after merging
analyze table orc_merge5b compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
PREHOOK: query: desc formatted orc_merge5b
PREHOOK: type: DESCTABLE
@@ -278,7 +274,7 @@ Table Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 899
+ totalSize 907
#### A masked pattern was here ####
# Storage Information
@@ -317,11 +313,9 @@ POSTHOOK: Lineage: orc_merge5b.ts SIMPLE
POSTHOOK: Lineage: orc_merge5b.userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid, type:bigint, comment:null), ]
PREHOOK: query: analyze table orc_merge5b compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5b
PREHOOK: Output: default@orc_merge5b
POSTHOOK: query: analyze table orc_merge5b compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
PREHOOK: query: desc formatted orc_merge5b
PREHOOK: type: DESCTABLE
@@ -349,7 +343,7 @@ Table Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1133
+ totalSize 1141
#### A masked pattern was here ####
# Storage Information
@@ -409,12 +403,10 @@ POSTHOOK: Output: default@orc_merge5b
PREHOOK: query: -- 1 file after merging
analyze table orc_merge5b compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5b
PREHOOK: Output: default@orc_merge5b
POSTHOOK: query: -- 1 file after merging
analyze table orc_merge5b compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
PREHOOK: query: desc formatted orc_merge5b
PREHOOK: type: DESCTABLE
@@ -442,7 +434,7 @@ Table Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 899
+ totalSize 907
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/spark/ql/src/test/results/clientpositive/orc_merge6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge6.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_merge6.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge6.q.out Mon Oct 6 03:44:13 2014
@@ -108,23 +108,19 @@ POSTHOOK: Lineage: orc_merge5a PARTITION
PREHOOK: query: -- 3 files total
analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@year=2000/hour=24
POSTHOOK: query: -- 3 files total
analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@year=2000/hour=24
PREHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@year=2001/hour=24
POSTHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
PREHOOK: query: desc formatted orc_merge5a partition(year="2000",hour=24)
@@ -159,7 +155,7 @@ Partition Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1133
+ totalSize 1141
#### A masked pattern was here ####
# Storage Information
@@ -204,7 +200,7 @@ Partition Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1133
+ totalSize 1141
#### A masked pattern was here ####
# Storage Information
@@ -357,23 +353,19 @@ POSTHOOK: Lineage: orc_merge5a PARTITION
PREHOOK: query: -- 1 file after merging
analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@year=2000/hour=24
POSTHOOK: query: -- 1 file after merging
analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@year=2000/hour=24
PREHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@year=2001/hour=24
POSTHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
PREHOOK: query: desc formatted orc_merge5a partition(year="2000",hour=24)
@@ -408,7 +400,7 @@ Partition Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 899
+ totalSize 907
#### A masked pattern was here ####
# Storage Information
@@ -453,7 +445,7 @@ Partition Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 899
+ totalSize 907
#### A masked pattern was here ####
# Storage Information
@@ -520,22 +512,18 @@ POSTHOOK: Lineage: orc_merge5a PARTITION
POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid, type:bigint, comment:null), ]
PREHOOK: query: analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@year=2000/hour=24
POSTHOOK: query: analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@year=2000/hour=24
PREHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@year=2001/hour=24
POSTHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
PREHOOK: query: desc formatted orc_merge5a partition(year="2000",hour=24)
@@ -570,7 +558,7 @@ Partition Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1133
+ totalSize 1141
#### A masked pattern was here ####
# Storage Information
@@ -615,7 +603,7 @@ Partition Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1133
+ totalSize 1141
#### A masked pattern was here ####
# Storage Information
@@ -701,23 +689,19 @@ POSTHOOK: Output: default@orc_merge5a@ye
PREHOOK: query: -- 1 file after merging
analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@year=2000/hour=24
POSTHOOK: query: -- 1 file after merging
analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@year=2000/hour=24
PREHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@year=2001/hour=24
POSTHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
PREHOOK: query: desc formatted orc_merge5a partition(year="2000",hour=24)
@@ -752,7 +736,7 @@ Partition Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 899
+ totalSize 907
#### A masked pattern was here ####
# Storage Information
@@ -797,7 +781,7 @@ Partition Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 899
+ totalSize 907
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/spark/ql/src/test/results/clientpositive/orc_merge7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge7.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_merge7.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge7.q.out Mon Oct 6 03:44:13 2014
@@ -141,23 +141,19 @@ POSTHOOK: Lineage: orc_merge5a PARTITION
PREHOOK: query: -- 3 files total
analyze table orc_merge5a partition(st=80.0) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@st=80.0
POSTHOOK: query: -- 3 files total
analyze table orc_merge5a partition(st=80.0) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=80.0
PREHOOK: query: analyze table orc_merge5a partition(st=0.8) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@st=0.8
POSTHOOK: query: analyze table orc_merge5a partition(st=0.8) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=0.8
PREHOOK: query: desc formatted orc_merge5a partition(st=80.0)
@@ -191,7 +187,7 @@ Partition Parameters:
numFiles 1
numRows 1
rawDataSize 255
- totalSize 513
+ totalSize 521
#### A masked pattern was here ####
# Storage Information
@@ -235,7 +231,7 @@ Partition Parameters:
numFiles 2
numRows 2
rawDataSize 510
- totalSize 1044
+ totalSize 1058
#### A masked pattern was here ####
# Storage Information
@@ -422,23 +418,19 @@ POSTHOOK: Lineage: orc_merge5a PARTITION
PREHOOK: query: -- 1 file after merging
analyze table orc_merge5a partition(st=80.0) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@st=80.0
POSTHOOK: query: -- 1 file after merging
analyze table orc_merge5a partition(st=80.0) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=80.0
PREHOOK: query: analyze table orc_merge5a partition(st=0.8) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@st=0.8
POSTHOOK: query: analyze table orc_merge5a partition(st=0.8) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=0.8
PREHOOK: query: desc formatted orc_merge5a partition(st=80.0)
@@ -472,7 +464,7 @@ Partition Parameters:
numFiles 1
numRows 1
rawDataSize 255
- totalSize 513
+ totalSize 521
#### A masked pattern was here ####
# Storage Information
@@ -516,7 +508,7 @@ Partition Parameters:
numFiles 1
numRows 2
rawDataSize 510
- totalSize 838
+ totalSize 852
#### A masked pattern was here ####
# Storage Information
@@ -622,22 +614,18 @@ POSTHOOK: Lineage: orc_merge5a PARTITION
POSTHOOK: Lineage: orc_merge5a PARTITION(st=80.0).userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid, type:bigint, comment:null), ]
PREHOOK: query: analyze table orc_merge5a partition(st=80.0) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@st=80.0
POSTHOOK: query: analyze table orc_merge5a partition(st=80.0) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=80.0
PREHOOK: query: analyze table orc_merge5a partition(st=0.8) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@st=0.8
POSTHOOK: query: analyze table orc_merge5a partition(st=0.8) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=0.8
PREHOOK: query: desc formatted orc_merge5a partition(st=80.0)
@@ -671,7 +659,7 @@ Partition Parameters:
numFiles 1
numRows 1
rawDataSize 255
- totalSize 513
+ totalSize 521
#### A masked pattern was here ####
# Storage Information
@@ -715,7 +703,7 @@ Partition Parameters:
numFiles 2
numRows 2
rawDataSize 510
- totalSize 1044
+ totalSize 1058
#### A masked pattern was here ####
# Storage Information
@@ -803,23 +791,19 @@ POSTHOOK: Output: default@orc_merge5a@st
PREHOOK: query: -- 1 file after merging
analyze table orc_merge5a partition(st=80.0) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@st=80.0
POSTHOOK: query: -- 1 file after merging
analyze table orc_merge5a partition(st=80.0) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=80.0
PREHOOK: query: analyze table orc_merge5a partition(st=0.8) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@st=0.8
POSTHOOK: query: analyze table orc_merge5a partition(st=0.8) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=0.8
PREHOOK: query: desc formatted orc_merge5a partition(st=80.0)
@@ -853,7 +837,7 @@ Partition Parameters:
numFiles 1
numRows 1
rawDataSize 255
- totalSize 513
+ totalSize 521
#### A masked pattern was here ####
# Storage Information
@@ -897,7 +881,7 @@ Partition Parameters:
numFiles 1
numRows 2
rawDataSize 510
- totalSize 838
+ totalSize 852
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out Mon Oct 6 03:44:13 2014
@@ -141,12 +141,10 @@ POSTHOOK: Lineage: orc_merge5b.userid SI
PREHOOK: query: -- 5 files total
analyze table orc_merge5b compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5b
PREHOOK: Output: default@orc_merge5b
POSTHOOK: query: -- 5 files total
analyze table orc_merge5b compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
PREHOOK: query: desc formatted orc_merge5b
PREHOOK: type: DESCTABLE
@@ -174,7 +172,7 @@ Table Parameters:
numFiles 5
numRows 15
rawDataSize 3825
- totalSize 2877
+ totalSize 2862
#### A masked pattern was here ####
# Storage Information
@@ -221,12 +219,10 @@ POSTHOOK: Output: default@orc_merge5b
PREHOOK: query: -- 3 file after merging - all 0.12 format files will be merged and 0.11 files will be left behind
analyze table orc_merge5b compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5b
PREHOOK: Output: default@orc_merge5b
POSTHOOK: query: -- 3 file after merging - all 0.12 format files will be merged and 0.11 files will be left behind
analyze table orc_merge5b compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
PREHOOK: query: desc formatted orc_merge5b
PREHOOK: type: DESCTABLE
@@ -254,7 +250,7 @@ Table Parameters:
numFiles 3
numRows 15
rawDataSize 3825
- totalSize 2340
+ totalSize 2325
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out Mon Oct 6 03:44:13 2014
@@ -200,22 +200,18 @@ POSTHOOK: Lineage: orc_merge5a PARTITION
POSTHOOK: Lineage: orc_merge5a PARTITION(st=80.0).userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid, type:bigint, comment:null), ]
PREHOOK: query: analyze table orc_merge5a partition(st=80.0) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@st=80.0
POSTHOOK: query: analyze table orc_merge5a partition(st=80.0) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=80.0
PREHOOK: query: analyze table orc_merge5a partition(st=0.8) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@st=0.8
POSTHOOK: query: analyze table orc_merge5a partition(st=0.8) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=0.8
PREHOOK: query: desc formatted orc_merge5a partition(st=80.0)
@@ -249,7 +245,7 @@ Partition Parameters:
numFiles 4
numRows 4
rawDataSize 1020
- totalSize 2060
+ totalSize 2092
#### A masked pattern was here ####
# Storage Information
@@ -293,7 +289,7 @@ Partition Parameters:
numFiles 4
numRows 8
rawDataSize 2040
- totalSize 2188
+ totalSize 2204
#### A masked pattern was here ####
# Storage Information
@@ -389,22 +385,18 @@ POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=0.8
PREHOOK: query: analyze table orc_merge5a partition(st=80.0) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@st=80.0
POSTHOOK: query: analyze table orc_merge5a partition(st=80.0) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=80.0
PREHOOK: query: analyze table orc_merge5a partition(st=0.8) compute statistics noscan
PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a
PREHOOK: Output: default@orc_merge5a@st=0.8
POSTHOOK: query: analyze table orc_merge5a partition(st=0.8) compute statistics noscan
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=0.8
PREHOOK: query: desc formatted orc_merge5a partition(st=80.0)
@@ -438,7 +430,7 @@ Partition Parameters:
numFiles 3
numRows 4
rawDataSize 1020
- totalSize 1819
+ totalSize 1851
#### A masked pattern was here ####
# Storage Information
@@ -482,7 +474,7 @@ Partition Parameters:
numFiles 3
numRows 8
rawDataSize 2040
- totalSize 1928
+ totalSize 1944
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/spark/ql/src/test/results/clientpositive/parquet_create.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/parquet_create.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/parquet_create.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/parquet_create.q.out Mon Oct 6 03:44:13 2014
@@ -181,6 +181,6 @@ POSTHOOK: query: SELECT strct from parqu
POSTHOOK: type: QUERY
POSTHOOK: Input: default@parquet_create
#### A masked pattern was here ####
-{"A":"one","B":"two"}
-{"A":"three","B":"four"}
-{"A":"five","B":"six"}
+{"a":"one","b":"two"}
+{"a":"three","b":"four"}
+{"a":"five","b":"six"}
Modified: hive/branches/spark/ql/src/test/results/clientpositive/parquet_types.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/parquet_types.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/parquet_types.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/parquet_types.q.out Mon Oct 6 03:44:13 2014
@@ -15,14 +15,9 @@ PREHOOK: query: CREATE TABLE parquet_typ
cstring1 string,
t timestamp,
cchar char(5),
- cvarchar varchar(10),
- m1 map<string, varchar(3)>,
- l1 array<int>,
- st1 struct<c1:int, c2:char(1)>
+ cvarchar varchar(10)
) ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|'
-COLLECTION ITEMS TERMINATED BY ','
-MAP KEYS TERMINATED BY ':'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@parquet_types_staging
@@ -35,14 +30,9 @@ POSTHOOK: query: CREATE TABLE parquet_ty
cstring1 string,
t timestamp,
cchar char(5),
- cvarchar varchar(10),
- m1 map<string, varchar(3)>,
- l1 array<int>,
- st1 struct<c1:int, c2:char(1)>
+ cvarchar varchar(10)
) ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|'
-COLLECTION ITEMS TERMINATED BY ','
-MAP KEYS TERMINATED BY ':'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@parquet_types_staging
@@ -55,10 +45,7 @@ PREHOOK: query: CREATE TABLE parquet_typ
cstring1 string,
t timestamp,
cchar char(5),
- cvarchar varchar(10),
- m1 map<string, varchar(3)>,
- l1 array<int>,
- st1 struct<c1:int, c2:char(1)>
+ cvarchar varchar(10)
) STORED AS PARQUET
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -72,10 +59,7 @@ POSTHOOK: query: CREATE TABLE parquet_ty
cstring1 string,
t timestamp,
cchar char(5),
- cvarchar varchar(10),
- m1 map<string, varchar(3)>,
- l1 array<int>,
- st1 struct<c1:int, c2:char(1)>
+ cvarchar varchar(10)
) STORED AS PARQUET
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -104,9 +88,6 @@ POSTHOOK: Lineage: parquet_types.csmalli
POSTHOOK: Lineage: parquet_types.cstring1 SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cstring1, type:string, comment:null), ]
POSTHOOK: Lineage: parquet_types.ctinyint SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:ctinyint, type:tinyint, comment:null), ]
POSTHOOK: Lineage: parquet_types.cvarchar SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cvarchar, type:varchar(10), comment:null), ]
-POSTHOOK: Lineage: parquet_types.l1 SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:l1, type:array<int>, comment:null), ]
-POSTHOOK: Lineage: parquet_types.m1 SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:m1, type:map<string,varchar(3)>, comment:null), ]
-POSTHOOK: Lineage: parquet_types.st1 SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:st1, type:struct<c1:int,c2:char(1)>, comment:null), ]
POSTHOOK: Lineage: parquet_types.t SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:t, type:timestamp, comment:null), ]
PREHOOK: query: SELECT * FROM parquet_types
PREHOOK: type: QUERY
@@ -116,56 +97,27 @@ POSTHOOK: query: SELECT * FROM parquet_t
POSTHOOK: type: QUERY
POSTHOOK: Input: default@parquet_types
#### A masked pattern was here ####
-100 1 1 1.0 0.0 abc 2011-01-01 01:01:01.111111111 a a {"k1":"v1"} [101,200] {"c1":10,"c2":"a"}
-101 2 2 1.1 0.3 def 2012-02-02 02:02:02.222222222 ab ab {"k2":"v2"} [102,200] {"c1":10,"c2":"d"}
-102 3 3 1.2 0.6 ghi 2013-03-03 03:03:03.333333333 abc abc {"k3":"v3"} [103,200] {"c1":10,"c2":"g"}
-103 1 4 1.3 0.9 jkl 2014-04-04 04:04:04.444444444 abcd abcd {"k4":"v4"} [104,200] {"c1":10,"c2":"j"}
-104 2 5 1.4 1.2 mno 2015-05-05 05:05:05.555555555 abcde abcde {"k5":"v5"} [105,200] {"c1":10,"c2":"m"}
-105 3 1 1.0 1.5 pqr 2016-06-06 06:06:06.666666666 abcde abcdef {"k6":"v6"} [106,200] {"c1":10,"c2":"p"}
-106 1 2 1.1 1.8 stu 2017-07-07 07:07:07.777777777 abcde abcdefg {"k7":"v7"} [107,200] {"c1":10,"c2":"s"}
-107 2 3 1.2 2.1 vwx 2018-08-08 08:08:08.888888888 bcdef abcdefgh {"k8":"v8"} [108,200] {"c1":10,"c2":"v"}
-108 3 4 1.3 2.4 yza 2019-09-09 09:09:09.999999999 cdefg abcdefghij {"k9":"v9"} [109,200] {"c1":10,"c2":"y"}
-109 1 5 1.4 2.7 bcd 2020-10-10 10:10:10.101010101 klmno abcdedef {"k10":"v10"} [110,200] {"c1":10,"c2":"b"}
-110 2 1 1.0 3.0 efg 2021-11-11 11:11:11.111111111 pqrst abcdede {"k11":"v11"} [111,200] {"c1":10,"c2":"e"}
-111 3 2 1.1 3.3 hij 2022-12-12 12:12:12.121212121 nopqr abcded {"k12":"v12"} [112,200] {"c1":10,"c2":"h"}
-112 1 3 1.2 3.6 klm 2023-01-02 13:13:13.131313131 opqrs abcdd {"k13":"v13"} [113,200] {"c1":10,"c2":"k"}
-113 2 4 1.3 3.9 nop 2024-02-02 14:14:14.141414141 pqrst abc {"k14":"v14"} [114,200] {"c1":10,"c2":"n"}
-114 3 5 1.4 4.2 qrs 2025-03-03 15:15:15.151515151 qrstu b {"k15":"v15"} [115,200] {"c1":10,"c2":"q"}
-115 1 1 1.0 4.5 qrs 2026-04-04 16:16:16.161616161 rstuv abcded {"k16":"v16"} [116,200] {"c1":10,"c2":"q"}
-116 2 2 1.1 4.8 wxy 2027-05-05 17:17:17.171717171 stuvw abcded {"k17":"v17"} [117,200] {"c1":10,"c2":"w"}
-117 3 3 1.2 5.1 zab 2028-06-06 18:18:18.181818181 tuvwx abcded {"k18":"v18"} [118,200] {"c1":10,"c2":"z"}
-118 1 4 1.3 5.4 cde 2029-07-07 19:19:19.191919191 uvwzy abcdede {"k19":"v19"} [119,200] {"c1":10,"c2":"c"}
-119 2 5 1.4 5.7 fgh 2030-08-08 20:20:20.202020202 vwxyz abcdede {"k20":"v20"} [120,200] {"c1":10,"c2":"f"}
-120 3 1 1.0 6.0 ijk 2031-09-09 21:21:21.212121212 wxyza abcde {"k21":"v21"} [121,200] {"c1":10,"c2":"i"}
-PREHOOK: query: SELECT cchar, LENGTH(cchar), cvarchar, LENGTH(cvarchar) FROM parquet_types
-PREHOOK: type: QUERY
-PREHOOK: Input: default@parquet_types
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT cchar, LENGTH(cchar), cvarchar, LENGTH(cvarchar) FROM parquet_types
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@parquet_types
-#### A masked pattern was here ####
-a 1 a 3
-ab 2 ab 3
-abc 3 abc 3
-abcd 4 abcd 4
-abcde 5 abcde 5
-abcde 5 abcdef 6
-abcde 5 abcdefg 7
-bcdef 5 abcdefgh 8
-cdefg 5 abcdefghij 10
-klmno 5 abcdedef 8
-pqrst 5 abcdede 7
-nopqr 5 abcded 6
-opqrs 5 abcdd 5
-pqrst 5 abc 3
-qrstu 5 b 1
-rstuv 5 abcded 6
-stuvw 5 abcded 6
-tuvwx 5 abcded 6
-uvwzy 5 abcdede 7
-vwxyz 5 abcdede 7
-wxyza 5 abcde 5
+100 1 1 1.0 0.0 abc 2011-01-01 01:01:01.111111111 a a
+101 2 2 1.1 0.3 def 2012-02-02 02:02:02.222222222 ab ab
+102 3 3 1.2 0.6 ghi 2013-03-03 03:03:03.333333333 abc abc
+103 1 4 1.3 0.9 jkl 2014-04-04 04:04:04.444444444 abcd abcd
+104 2 5 1.4 1.2 mno 2015-05-05 05:05:05.555555555 abcde abcde
+105 3 1 1.0 1.5 pqr 2016-06-06 06:06:06.666666666 abcde abcdef
+106 1 2 1.1 1.8 stu 2017-07-07 07:07:07.777777777 abcde abcdefg
+107 2 3 1.2 2.1 vwx 2018-08-08 08:08:08.888888888 bcdef abcdefgh
+108 3 4 1.3 2.4 yza 2019-09-09 09:09:09.999999999 cdefg abcdefghij
+109 1 5 1.4 2.7 bcd 2020-10-10 10:10:10.101010101 klmno abcdedef
+110 2 1 1.0 3.0 efg 2021-11-11 11:11:11.111111111 pqrst abcdede
+111 3 2 1.1 3.3 hij 2022-12-12 12:12:12.121212121 nopqr abcded
+112 1 3 1.2 3.6 klm 2023-01-02 13:13:13.131313131 opqrs abcdd
+113 2 4 1.3 3.9 nop 2024-02-02 14:14:14.141414141 pqrst abc
+114 3 5 1.4 4.2 qrs 2025-03-03 15:15:15.151515151 qrstu b
+115 1 1 1.0 4.5 tuv 2026-04-04 16:16:16.161616161 rstuv abcded
+116 2 2 1.1 4.8 wxy 2027-05-05 17:17:17.171717171 stuvw abcded
+117 3 3 1.2 5.1 zab 2028-06-06 18:18:18.181818181 tuvwx abcded
+118 1 4 1.3 5.4 cde 2029-07-07 19:19:19.191919191 uvwzy abcdede
+119 2 5 1.4 5.7 fgh 2030-08-08 20:20:20.202020202 vwxyz abcdede
+120 3 1 1.0 6.0 ijk 2031-09-09 21:21:21.212121212 wxyza abcde
PREHOOK: query: SELECT ctinyint,
MAX(cint),
MIN(csmallint),
Modified: hive/branches/spark/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out Mon Oct 6 03:44:13 2014
@@ -1,12 +1,8 @@
-PREHOOK: query: -- SORT_BEFORE_DIFF
-
-create table partition_test_partitioned(key string, value string) partitioned by (dt string)
+PREHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@partition_test_partitioned
-POSTHOOK: query: -- SORT_BEFORE_DIFF
-
-create table partition_test_partitioned(key string, value string) partitioned by (dt string)
+POSTHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@partition_test_partitioned
@@ -61,21 +57,33 @@ PREHOOK: type: QUERY
POSTHOOK: query: explain select *, BLOCK__OFFSET__INSIDE__FILE from partition_test_partitioned where dt >=100 and dt <= 102
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-0 is a root stage
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ alias: partition_test_partitioned
+ Statistics: Num rows: 75 Data size: 548 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: key (type: string), value (type: string), dt (type: string), BLOCK__OFFSET__INSIDE__FILE (type: bigint)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 75 Data size: 548 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 75 Data size: 548 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
Stage: Stage-0
Fetch Operator
limit: -1
Processor Tree:
- TableScan
- alias: partition_test_partitioned
- Statistics: Num rows: 75 Data size: 548 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string), dt (type: string), BLOCK__OFFSET__INSIDE__FILE (type: bigint)
- outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 75 Data size: 548 Basic stats: COMPLETE Column stats: NONE
- ListSink
+ ListSink
PREHOOK: query: select * from partition_test_partitioned where dt >=100 and dt <= 102
PREHOOK: type: QUERY
Modified: hive/branches/spark/ql/src/test/results/clientpositive/ppd_constant_where.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/ppd_constant_where.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/ppd_constant_where.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/ppd_constant_where.q.out Mon Oct 6 03:44:13 2014
@@ -16,31 +16,31 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: bigint)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/branches/spark/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out Mon Oct 6 03:44:13 2014
@@ -145,7 +145,7 @@ STAGE PLANS:
predicate: (_col7 = 3) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col6 (type: int), 3 (type: int)
+ expressions: _col0 (type: int), _col6 (type: int), _col7 (type: int)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator