You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/12/11 20:38:36 UTC
svn commit: r1644732 - in /hive/branches/branch-0.14:
itests/src/test/resources/ ql/src/java/org/apache/hadoop/hive/ql/optimizer/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
ql/src/test/results/clientpositive/tez/
Author: hashutosh
Date: Thu Dec 11 19:38:35 2014
New Revision: 1644732
URL: http://svn.apache.org/r1644732
Log:
HIVE-9025 : join38.q (without map join) produces incorrect result when testing with multiple reducers (Ted Xu via Ashutosh Chauhan)
Added:
hive/branches/branch-0.14/ql/src/test/queries/clientpositive/constprog_partitioner.q
hive/branches/branch-0.14/ql/src/test/results/clientpositive/constprog_partitioner.q.out
Modified:
hive/branches/branch-0.14/itests/src/test/resources/testconfiguration.properties
hive/branches/branch-0.14/ql/src/java/org/apache/hadoop/hive/ql/optimizer/ConstantPropagateProcFactory.java
hive/branches/branch-0.14/ql/src/test/results/clientpositive/cluster.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/constprog2.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/join_nullsafe.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd2.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_clusterby.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_join4.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_outer_join5.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/quotedid_basic.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/join_nullsafe.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_mapjoin.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out
hive/branches/branch-0.14/ql/src/test/results/clientpositive/union27.q.out
Modified: hive/branches/branch-0.14/itests/src/test/resources/testconfiguration.properties
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/itests/src/test/resources/testconfiguration.properties?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/itests/src/test/resources/testconfiguration.properties (original)
+++ hive/branches/branch-0.14/itests/src/test/resources/testconfiguration.properties Thu Dec 11 19:38:35 2014
@@ -8,6 +8,7 @@ minimr.query.files=auto_sortmerge_join_1
bucketizedhiveinputformat.q,\
bucketmapjoin6.q,\
bucketmapjoin7.q,\
+ constprog_partitioner.q,\
disable_merge_for_bucketing.q,\
empty_dir_in_table.q,\
external_table_with_space_in_location_path.q,\
Modified: hive/branches/branch-0.14/ql/src/java/org/apache/hadoop/hive/ql/optimizer/ConstantPropagateProcFactory.java
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/java/org/apache/hadoop/hive/ql/optimizer/ConstantPropagateProcFactory.java?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/java/org/apache/hadoop/hive/ql/optimizer/ConstantPropagateProcFactory.java (original)
+++ hive/branches/branch-0.14/ql/src/java/org/apache/hadoop/hive/ql/optimizer/ConstantPropagateProcFactory.java Thu Dec 11 19:38:35 2014
@@ -888,15 +888,22 @@ public final class ConstantPropagateProc
rsDesc.setKeyCols(newKeyEpxrs);
// partition columns
- ArrayList<ExprNodeDesc> newPartExprs = new ArrayList<ExprNodeDesc>();
- for (ExprNodeDesc desc : rsDesc.getPartitionCols()) {
- ExprNodeDesc expr = foldExpr(desc, constants, cppCtx, op, 0, false);
- if (expr instanceof ExprNodeConstantDesc || expr instanceof ExprNodeNullDesc) {
- continue;
+ if (!rsDesc.getPartitionCols().isEmpty()) {
+ ArrayList<ExprNodeDesc> newPartExprs = new ArrayList<ExprNodeDesc>();
+ for (ExprNodeDesc desc : rsDesc.getPartitionCols()) {
+ ExprNodeDesc expr = foldExpr(desc, constants, cppCtx, op, 0, false);
+ if (expr instanceof ExprNodeConstantDesc || expr instanceof ExprNodeNullDesc) {
+ continue;
+ }
+ newPartExprs.add(expr);
}
- newPartExprs.add(expr);
+ if (newPartExprs.isEmpty()) {
+ // If all partition columns are removed because of constant, insert an extra column to avoid
+ // random partitioning.
+ newPartExprs.add(new ExprNodeConstantDesc(""));
+ }
+ rsDesc.setPartitionCols(newPartExprs);
}
- rsDesc.setPartitionCols(newPartExprs);
// value columns
ArrayList<ExprNodeDesc> newValExprs = new ArrayList<ExprNodeDesc>();
Added: hive/branches/branch-0.14/ql/src/test/queries/clientpositive/constprog_partitioner.q
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/queries/clientpositive/constprog_partitioner.q?rev=1644732&view=auto
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/queries/clientpositive/constprog_partitioner.q (added)
+++ hive/branches/branch-0.14/ql/src/test/queries/clientpositive/constprog_partitioner.q Thu Dec 11 19:38:35 2014
@@ -0,0 +1,11 @@
+set hive.fetch.task.conversion=more;
+set hive.optimize.constant.propagation=true;
+
+set mapred.reduce.tasks=4;
+
+EXPLAIN
+SELECT src1.key, src1.key + 1, src2.value
+ FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 100;
+
+SELECT src1.key, src1.key + 1, src2.value
+ FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 100;
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/cluster.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/cluster.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/cluster.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/cluster.q.out Thu Dec 11 19:38:35 2014
@@ -25,6 +25,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '10' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
@@ -82,6 +83,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
@@ -139,6 +141,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
@@ -196,6 +199,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
@@ -253,6 +257,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
@@ -310,6 +315,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
@@ -424,6 +430,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
@@ -478,6 +485,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: x
@@ -488,6 +496,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
Reduce Operator Tree:
@@ -571,6 +580,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
@@ -582,6 +592,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
Reduce Operator Tree:
@@ -666,6 +677,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
@@ -677,6 +689,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
Reduce Operator Tree:
@@ -706,6 +719,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string), _col3 (type: string)
Reduce Operator Tree:
@@ -760,6 +774,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: x
@@ -770,6 +785,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
Reduce Operator Tree:
@@ -799,6 +815,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string), _col2 (type: string)
Reduce Operator Tree:
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/constprog2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/constprog2.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/constprog2.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/constprog2.q.out Thu Dec 11 19:38:35 2014
@@ -23,6 +23,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '86' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
@@ -34,6 +35,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '86' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
@@ -98,6 +100,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '86' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
@@ -109,6 +112,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '86' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
Added: hive/branches/branch-0.14/ql/src/test/results/clientpositive/constprog_partitioner.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/constprog_partitioner.q.out?rev=1644732&view=auto
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/constprog_partitioner.q.out (added)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/constprog_partitioner.q.out Thu Dec 11 19:38:35 2014
@@ -0,0 +1,80 @@
+PREHOOK: query: EXPLAIN
+SELECT src1.key, src1.key + 1, src2.value
+ FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 100
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT src1.key, src1.key + 1, src2.value
+ FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 100
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ 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: src2
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (key = 100) (type: boolean)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: '100' (type: string)
+ sort order: +
+ Map-reduce partition columns: '' (type: string)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ TableScan
+ alias: src1
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (key = 100) (type: boolean)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: '100' (type: string)
+ sort order: +
+ Map-reduce partition columns: '' (type: string)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0
+ 1 {VALUE._col0}
+ outputColumnNames: _col6
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: '100' (type: string), 101.0 (type: double), _col6 (type: string)
+ outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 275 Data size: 2921 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:
+ ListSink
+
+PREHOOK: query: SELECT src1.key, src1.key + 1, src2.value
+ FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT src1.key, src1.key + 1, src2.value
+ FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+100 101.0 val_100
+100 101.0 val_100
+100 101.0 val_100
+100 101.0 val_100
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/join_nullsafe.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/join_nullsafe.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/join_nullsafe.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/join_nullsafe.q.out Thu Dec 11 19:38:35 2014
@@ -1525,6 +1525,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: null (type: void)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: int)
TableScan
@@ -1536,6 +1537,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: null (type: void)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: int)
Reduce Operator Tree:
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd2.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd2.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd2.q.out Thu Dec 11 19:38:35 2014
@@ -355,6 +355,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: x
@@ -365,6 +366,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
Reduce Operator Tree:
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_clusterby.q.out Thu Dec 11 19:38:35 2014
@@ -25,6 +25,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '10' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
@@ -79,6 +80,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: x
@@ -89,6 +91,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
Reduce Operator Tree:
@@ -175,6 +178,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '10' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
@@ -229,6 +233,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: x
@@ -239,6 +244,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
Reduce Operator Tree:
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_join4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_join4.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_join4.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_join4.q.out Thu Dec 11 19:38:35 2014
@@ -87,11 +87,13 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 'a' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
TableScan
Reduce Output Operator
key expressions: 'a' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Operator Tree:
Join Operator
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_outer_join5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_outer_join5.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_outer_join5.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/ppd_outer_join5.q.out Thu Dec 11 19:38:35 2014
@@ -51,6 +51,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 20 (type: int)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: key (type: string), value (type: string)
TableScan
@@ -139,6 +140,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 20 (type: int)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: key (type: string), value (type: string)
TableScan
@@ -150,6 +152,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 20 (type: int)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: key (type: string), value (type: string)
Reduce Operator Tree:
@@ -214,6 +217,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 20 (type: int)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: key (type: string), value (type: string)
TableScan
@@ -225,6 +229,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 20 (type: int)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: key (type: string), value (type: string)
Reduce Operator Tree:
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/quotedid_basic.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/quotedid_basic.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/quotedid_basic.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/quotedid_basic.q.out Thu Dec 11 19:38:35 2014
@@ -193,6 +193,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '1' (type: string), _col1 (type: string)
sort order: ++
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string), '1' (type: string)
Reduce Operator Tree:
@@ -275,6 +276,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '1' (type: string), _col1 (type: string)
sort order: ++
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string), '1' (type: string)
Reduce Operator Tree:
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out Thu Dec 11 19:38:35 2014
@@ -71,6 +71,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 5 (type: int)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: a
@@ -81,6 +82,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 5 (type: int)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
@@ -152,6 +154,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 5 (type: int)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: c
@@ -162,6 +165,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 5 (type: int)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out Thu Dec 11 19:38:35 2014
@@ -2577,6 +2577,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '11' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: '11' (type: string)
@@ -2634,6 +2635,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '11' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
Reducer 3
Reduce Operator Tree:
@@ -2731,6 +2733,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '13' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 1 Data size: 5 Basic stats: COMPLETE Column stats: NONE
Map 6
Map Operator Tree:
@@ -2758,6 +2761,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '13' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 3
Reduce Operator Tree:
@@ -4789,6 +4793,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '11' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: '11' (type: string)
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out Thu Dec 11 19:38:35 2014
@@ -592,6 +592,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 1 (type: int)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 1 Data size: 5 Basic stats: COMPLETE Column stats: NONE
Map 2
Map Operator Tree:
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/join_nullsafe.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/join_nullsafe.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/join_nullsafe.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/join_nullsafe.q.out Thu Dec 11 19:38:35 2014
@@ -1578,6 +1578,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: null (type: void)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: int)
Map 3
@@ -1591,6 +1592,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: null (type: void)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: int)
Reducer 2
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_mapjoin.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_mapjoin.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_mapjoin.q.out Thu Dec 11 19:38:35 2014
@@ -52,6 +52,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 6981 (type: int)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 6144 Data size: 1082530 Basic stats: COMPLETE Column stats: NONE
value expressions: cdecimal2 (type: decimal(23,14))
Execution mode: vectorized
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out Thu Dec 11 19:38:35 2014
@@ -2607,6 +2607,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '11' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: '11' (type: string)
@@ -2665,6 +2666,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '11' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
Reducer 3
Reduce Operator Tree:
@@ -2763,6 +2765,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '13' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 1 Data size: 172 Basic stats: COMPLETE Column stats: NONE
Map 6
Map Operator Tree:
@@ -2791,6 +2794,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '13' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 3
Reduce Operator Tree:
@@ -4843,6 +4847,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '11' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: '11' (type: string)
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/union27.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/union27.q.out?rev=1644732&r1=1644731&r2=1644732&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/union27.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/union27.q.out Thu Dec 11 19:38:35 2014
@@ -51,6 +51,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '97' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: jackson_sev_add
@@ -67,6 +68,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '97' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
TableScan
@@ -84,6 +86,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '97' (type: string)
sort order: +
+ Map-reduce partition columns: '' (type: string)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree: