You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2015/01/23 20:59:24 UTC
svn commit: r1654355 [22/27] - in /hive/branches/llap: ./
beeline/src/java/org/apache/hive/beeline/
cli/src/java/org/apache/hadoop/hive/cli/
common/src/java/org/apache/hadoop/hive/common/
common/src/java/org/apache/hadoop/hive/conf/ data/conf/ data/con...
Modified: hive/branches/llap/ql/src/test/results/clientpositive/infer_bucket_sort_grouping_operators.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/infer_bucket_sort_grouping_operators.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/infer_bucket_sort_grouping_operators.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/infer_bucket_sort_grouping_operators.q.out Fri Jan 23 19:59:11 2015
@@ -44,11 +44,11 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
- outputColumnNames: key, value
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(1)
- keys: key (type: string), value (type: string), '0' (type: string)
+ keys: _col0 (type: string), _col1 (type: string), '0' (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 1500 Data size: 15936 Basic stats: COMPLETE Column stats: NONE
@@ -63,8 +63,9 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: string)
mode: mergepartial
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col3
Statistics: Num rows: 750 Data size: 7968 Basic stats: COMPLETE Column stats: NONE
+ pruneGroupingSetId: true
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col3 (type: bigint)
outputColumnNames: _col0, _col1, _col2
@@ -143,9 +144,9 @@ SerDe Library: org.apache.hadoop.h
InputFormat: org.apache.hadoop.mapred.TextInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
+Num Buckets: 1
+Bucket Columns: [key, value]
+Sort Columns: [Order(col:key, order:1), Order(col:value, order:1)]
Storage Desc Params:
serialization.format 1
PREHOOK: query: -- Test rollup, should be bucketed and sorted on key, value, grouping_key
@@ -231,11 +232,11 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
- outputColumnNames: key, value
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(1)
- keys: key (type: string), value (type: string), '0' (type: string)
+ keys: _col0 (type: string), _col1 (type: string), '0' (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
@@ -250,8 +251,9 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: string)
mode: mergepartial
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col3
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ pruneGroupingSetId: true
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col3 (type: bigint)
outputColumnNames: _col0, _col1, _col2
@@ -330,9 +332,9 @@ SerDe Library: org.apache.hadoop.h
InputFormat: org.apache.hadoop.mapred.TextInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
+Num Buckets: 1
+Bucket Columns: [key, value]
+Sort Columns: [Order(col:key, order:1), Order(col:value, order:1)]
Storage Desc Params:
serialization.format 1
PREHOOK: query: -- Test cube, should be bucketed and sorted on key, value, grouping_key
@@ -418,11 +420,11 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
- outputColumnNames: key, value
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(1)
- keys: key (type: string), value (type: string), '0' (type: string)
+ keys: _col0 (type: string), _col1 (type: string), '0' (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
@@ -437,8 +439,9 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: string)
mode: mergepartial
- outputColumnNames: _col0, _col1, _col2, _col3
+ outputColumnNames: _col0, _col1, _col3
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ pruneGroupingSetId: true
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col3 (type: bigint)
outputColumnNames: _col0, _col1, _col2
@@ -517,9 +520,9 @@ SerDe Library: org.apache.hadoop.h
InputFormat: org.apache.hadoop.mapred.TextInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
+Num Buckets: 1
+Bucket Columns: [key, value]
+Sort Columns: [Order(col:key, order:1), Order(col:value, order:1)]
Storage Desc Params:
serialization.format 1
PREHOOK: query: -- Test grouping sets, should be bucketed and sorted on key, value, grouping_key
Modified: hive/branches/llap/ql/src/test/results/clientpositive/input14.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/input14.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/input14.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/input14.q.out Fri Jan 23 19:59:11 2015
@@ -105,11 +105,15 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/branches/llap/ql/src/test/results/clientpositive/input17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/input17.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/input17.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/input17.q.out Fri Jan 23 19:59:11 2015
@@ -102,15 +102,18 @@ POSTHOOK: Input: default@src_thrift
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.key SCRIPT [(src_thrift)src_thrift.FieldSchema(name:aint, type:int, comment:from deserializer), (src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), (src_thrift)src_thrift.FieldSchema(name:lintstring, type:array<struct<myint:int,mystring:string,underscore_int:int>>, comment:from deserializer), ]
POSTHOOK: Lineage: dest1.value SCRIPT [(src_thrift)src_thrift.FieldSchema(name:aint, type:int, comment:from deserializer), (src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), (src_thrift)src_thrift.FieldSchema(name:lintstring, type:array<struct<myint:int,mystring:string,underscore_int:int>>, comment:from deserializer), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
-NULL NULL
-1461153966 {"myint":49,"mystring":"343","underscore_int":7}
-1952710705 {"myint":25,"mystring":"125","underscore_int":5}
-734328905 {"myint":16,"mystring":"64","underscore_int":4}
@@ -121,3 +124,4 @@ NULL NULL
336964422 {"myint":81,"mystring":"729","underscore_int":9}
465985201 {"myint":1,"mystring":"1","underscore_int":1}
477111225 {"myint":9,"mystring":"27","underscore_int":3}
+NULL NULL
Modified: hive/branches/llap/ql/src/test/results/clientpositive/input18.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/input18.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/input18.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/input18.q.out Fri Jan 23 19:59:11 2015
@@ -105,11 +105,15 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/branches/llap/ql/src/test/results/clientpositive/input23.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/input23.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/input23.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/input23.q.out Fri Jan 23 19:59:11 2015
@@ -129,7 +129,7 @@ STAGE PLANS:
name: default.srcpart
name: default.srcpart
Truncated Path -> Alias:
- /srcpart/ds=2008-04-08/hr=11 [$hdt$_0:$hdt$_0:a]
+ /srcpart/ds=2008-04-08/hr=11 [$hdt$_0:a]
Needs Tagging: true
Reduce Operator Tree:
Join Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/input_part2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/input_part2.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/input_part2.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/input_part2.q.out Fri Jan 23 19:59:11 2015
@@ -14,12 +14,16 @@ POSTHOOK: query: CREATE TABLE dest2(key
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest2
-PREHOOK: query: EXPLAIN EXTENDED
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN EXTENDED
FROM srcpart
INSERT OVERWRITE TABLE dest1 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'
INSERT OVERWRITE TABLE dest2 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-09' and srcpart.hr = '12'
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN EXTENDED
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN EXTENDED
FROM srcpart
INSERT OVERWRITE TABLE dest1 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'
INSERT OVERWRITE TABLE dest2 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-09' and srcpart.hr = '12'
@@ -714,13 +718,6 @@ POSTHOOK: Input: default@dest1
0 val_0 12 2008-04-08
0 val_0 12 2008-04-08
0 val_0 12 2008-04-08
-2 val_2 12 2008-04-08
-4 val_4 12 2008-04-08
-5 val_5 12 2008-04-08
-5 val_5 12 2008-04-08
-5 val_5 12 2008-04-08
-8 val_8 12 2008-04-08
-9 val_9 12 2008-04-08
10 val_10 12 2008-04-08
11 val_11 12 2008-04-08
12 val_12 12 2008-04-08
@@ -731,6 +728,7 @@ POSTHOOK: Input: default@dest1
18 val_18 12 2008-04-08
18 val_18 12 2008-04-08
19 val_19 12 2008-04-08
+2 val_2 12 2008-04-08
20 val_20 12 2008-04-08
24 val_24 12 2008-04-08
24 val_24 12 2008-04-08
@@ -746,12 +744,16 @@ POSTHOOK: Input: default@dest1
35 val_35 12 2008-04-08
37 val_37 12 2008-04-08
37 val_37 12 2008-04-08
+4 val_4 12 2008-04-08
41 val_41 12 2008-04-08
42 val_42 12 2008-04-08
42 val_42 12 2008-04-08
43 val_43 12 2008-04-08
44 val_44 12 2008-04-08
47 val_47 12 2008-04-08
+5 val_5 12 2008-04-08
+5 val_5 12 2008-04-08
+5 val_5 12 2008-04-08
51 val_51 12 2008-04-08
51 val_51 12 2008-04-08
53 val_53 12 2008-04-08
@@ -775,6 +777,7 @@ POSTHOOK: Input: default@dest1
76 val_76 12 2008-04-08
77 val_77 12 2008-04-08
78 val_78 12 2008-04-08
+8 val_8 12 2008-04-08
80 val_80 12 2008-04-08
82 val_82 12 2008-04-08
83 val_83 12 2008-04-08
@@ -784,6 +787,7 @@ POSTHOOK: Input: default@dest1
85 val_85 12 2008-04-08
86 val_86 12 2008-04-08
87 val_87 12 2008-04-08
+9 val_9 12 2008-04-08
90 val_90 12 2008-04-08
90 val_90 12 2008-04-08
90 val_90 12 2008-04-08
@@ -806,13 +810,6 @@ POSTHOOK: Input: default@dest2
0 val_0 12 2008-04-09
0 val_0 12 2008-04-09
0 val_0 12 2008-04-09
-2 val_2 12 2008-04-09
-4 val_4 12 2008-04-09
-5 val_5 12 2008-04-09
-5 val_5 12 2008-04-09
-5 val_5 12 2008-04-09
-8 val_8 12 2008-04-09
-9 val_9 12 2008-04-09
10 val_10 12 2008-04-09
11 val_11 12 2008-04-09
12 val_12 12 2008-04-09
@@ -823,6 +820,7 @@ POSTHOOK: Input: default@dest2
18 val_18 12 2008-04-09
18 val_18 12 2008-04-09
19 val_19 12 2008-04-09
+2 val_2 12 2008-04-09
20 val_20 12 2008-04-09
24 val_24 12 2008-04-09
24 val_24 12 2008-04-09
@@ -838,12 +836,16 @@ POSTHOOK: Input: default@dest2
35 val_35 12 2008-04-09
37 val_37 12 2008-04-09
37 val_37 12 2008-04-09
+4 val_4 12 2008-04-09
41 val_41 12 2008-04-09
42 val_42 12 2008-04-09
42 val_42 12 2008-04-09
43 val_43 12 2008-04-09
44 val_44 12 2008-04-09
47 val_47 12 2008-04-09
+5 val_5 12 2008-04-09
+5 val_5 12 2008-04-09
+5 val_5 12 2008-04-09
51 val_51 12 2008-04-09
51 val_51 12 2008-04-09
53 val_53 12 2008-04-09
@@ -867,6 +869,7 @@ POSTHOOK: Input: default@dest2
76 val_76 12 2008-04-09
77 val_77 12 2008-04-09
78 val_78 12 2008-04-09
+8 val_8 12 2008-04-09
80 val_80 12 2008-04-09
82 val_82 12 2008-04-09
83 val_83 12 2008-04-09
@@ -876,6 +879,7 @@ POSTHOOK: Input: default@dest2
85 val_85 12 2008-04-09
86 val_86 12 2008-04-09
87 val_87 12 2008-04-09
+9 val_9 12 2008-04-09
90 val_90 12 2008-04-09
90 val_90 12 2008-04-09
90 val_90 12 2008-04-09
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join0.q.java1.7.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join0.q.java1.7.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join0.q.java1.7.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join0.q.java1.7.out Fri Jan 23 19:59:11 2015
@@ -1,5 +1,6 @@
Warning: Shuffle Join JOIN[8][tables = [src1, src2]] in Stage 'Stage-1:MAPRED' is a cross product
PREHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT
+-- SORT_QUERY_RESULTS
EXPLAIN
SELECT src1.key as k1, src1.value as v1,
@@ -10,6 +11,7 @@ SELECT src1.key as k1, src1.value as v1,
SORT BY k1, v1, k2, v2
PREHOOK: type: QUERY
POSTHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT
+-- SORT_QUERY_RESULTS
EXPLAIN
SELECT src1.key as k1, src1.value as v1,
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join15.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join15.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join15.q.out Fri Jan 23 19:59:11 2015
@@ -1,7 +1,11 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key) SORT BY src1.key, src1.value, src2.key, src2.value
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key) SORT BY src1.key, src1.value, src2.key, src2.value
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join17.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join17.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join17.q.out Fri Jan 23 19:59:11 2015
@@ -153,7 +153,7 @@ STAGE PLANS:
name: default.src
name: default.src
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_0:src1, $hdt$_0:$hdt$_1:src1]
+ /src [$hdt$_0:src1, $hdt$_1:src1]
Needs Tagging: true
Reduce Operator Tree:
Join Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join18.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join18.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join18.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join18.q.out Fri Jan 23 19:59:11 2015
@@ -1,4 +1,6 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT a.key, a.value, b.key, b.value
FROM
(
@@ -11,7 +13,9 @@ PREHOOK: query: EXPLAIN
) b
ON (a.key = b.key)
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT a.key, a.value, b.key, b.value
FROM
(
@@ -176,7 +180,6 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
-NULL NULL 7
0 3 NULL NULL
10 1 NULL NULL
100 2 NULL NULL
@@ -486,3 +489,4 @@ NULL NULL 7
96 1 NULL NULL
97 2 NULL NULL
98 2 98 1
+NULL NULL 7
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join20.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join20.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join20.q.out Fri Jan 23 19:59:11 2015
@@ -1,8 +1,12 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
POSTHOOK: type: QUERY
@@ -111,6 +115,64 @@ SORT BY src1.key, src1.value, src2.key,
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+2 val_2 2 val_2 2 val_2
+4 val_4 4 val_4 4 val_4
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+8 val_8 8 val_8 8 val_8
+9 val_9 9 val_9 9 val_9
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 100 val_100
NULL NULL NULL NULL 100 val_100
@@ -601,64 +663,6 @@ NULL NULL NULL NULL 97 val_97
NULL NULL NULL NULL 97 val_97
NULL NULL NULL NULL 98 val_98
NULL NULL NULL NULL 98 val_98
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-2 val_2 2 val_2 2 val_2
-4 val_4 4 val_4 4 val_4
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-8 val_8 8 val_8 8 val_8
-9 val_9 9 val_9 9 val_9
PREHOOK: query: EXPLAIN
SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key < 15) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
@@ -772,6 +776,64 @@ SORT BY src1.key, src1.value, src2.key,
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+0 val_0 0 val_0 0 val_0
+2 val_2 2 val_2 2 val_2
+4 val_4 4 val_4 4 val_4
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+5 val_5 5 val_5 5 val_5
+8 val_8 8 val_8 8 val_8
+9 val_9 9 val_9 9 val_9
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 100 val_100
NULL NULL NULL NULL 100 val_100
@@ -1262,61 +1324,3 @@ NULL NULL NULL NULL 97 val_97
NULL NULL NULL NULL 97 val_97
NULL NULL NULL NULL 98 val_98
NULL NULL NULL NULL 98 val_98
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-0 val_0 0 val_0 0 val_0
-2 val_2 2 val_2 2 val_2
-4 val_4 4 val_4 4 val_4
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-5 val_5 5 val_5 5 val_5
-8 val_8 8 val_8 8 val_8
-9 val_9 9 val_9 9 val_9
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join21.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join21.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join21.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join21.q.out Fri Jan 23 19:59:11 2015
@@ -1,7 +1,11 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join23.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join23.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join23.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join23.q.out Fri Jan 23 19:59:11 2015
@@ -1,8 +1,12 @@
Warning: Shuffle Join JOIN[4][tables = [src1, src2]] in Stage 'Stage-1:MAPRED' is a cross product
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join32_lessSize.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join32_lessSize.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join32_lessSize.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join32_lessSize.q.out Fri Jan 23 19:59:11 2015
@@ -1931,11 +1931,11 @@ STAGE PLANS:
Stage: Stage-9
Map Reduce Local Work
Alias -> Map Local Tables:
- $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:y
+ $hdt$_0:$hdt$_0:$hdt$_0:y
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:y
+ $hdt$_0:$hdt$_0:$hdt$_0:y
TableScan
alias: y
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -2089,12 +2089,12 @@ STAGE PLANS:
name: default.src1
name: default.src1
Truncated Path -> Alias:
- /src1 [$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:x]
+ /src1 [$hdt$_0:$hdt$_0:$hdt$_1:x]
Stage: Stage-8
Map Reduce Local Work
Alias -> Map Local Tables:
- $hdt$_0:$hdt$_1:z
+ $hdt$_1:z
Fetch Operator
limit: -1
Partition Description:
@@ -2144,7 +2144,7 @@ STAGE PLANS:
name: default.srcpart
name: default.srcpart
Alias -> Map Local Operator Tree:
- $hdt$_0:$hdt$_1:z
+ $hdt$_1:z
TableScan
alias: z
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join34.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join34.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join34.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join34.q.out Fri Jan 23 19:59:11 2015
@@ -148,11 +148,11 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce Local Work
Alias -> Map Local Tables:
- $hdt$_0:$hdt$_1:x
+ $hdt$_1:x
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $hdt$_0:$hdt$_1:x
+ $hdt$_1:x
TableScan
alias: x
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
@@ -374,7 +374,7 @@ STAGE PLANS:
name: default.src1
name: default.src1
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_0-subquery1:$hdt$_0-subquery1:x, $hdt$_0:$hdt$_0-subquery2:$hdt$_0-subquery2:x]
+ /src [$hdt$_0-subquery1:$hdt$_0-subquery1:x, $hdt$_0-subquery2:$hdt$_0-subquery2:x]
Stage: Stage-0
Move Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join35.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join35.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join35.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join35.q.out Fri Jan 23 19:59:11 2015
@@ -232,7 +232,7 @@ STAGE PLANS:
name: default.src
name: default.src
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_0-subquery1:$hdt$_0-subquery1:$hdt$_0:$hdt$_0:x]
+ /src [$hdt$_0-subquery1:$hdt$_0-subquery1:$hdt$_0:$hdt$_0:x]
Needs Tagging: false
Reduce Operator Tree:
Group By Operator
@@ -262,11 +262,11 @@ STAGE PLANS:
Stage: Stage-7
Map Reduce Local Work
Alias -> Map Local Tables:
- $hdt$_0:$hdt$_1:x
+ $hdt$_1:x
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $hdt$_0:$hdt$_1:x
+ $hdt$_1:x
TableScan
alias: x
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
@@ -569,7 +569,7 @@ STAGE PLANS:
name: default.src
name: default.src
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_0-subquery2:$hdt$_0-subquery2:$hdt$_0:$hdt$_0:x]
+ /src [$hdt$_0-subquery2:$hdt$_0-subquery2:$hdt$_0:$hdt$_0:x]
Needs Tagging: false
Reduce Operator Tree:
Group By Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join6.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join6.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join6.q.out Fri Jan 23 19:59:11 2015
@@ -6,7 +6,9 @@ POSTHOOK: query: CREATE TABLE dest1(c1 I
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
FROM (
FROM
(
@@ -21,7 +23,9 @@ FROM (
) c
INSERT OVERWRITE TABLE dest1 SELECT c.c1, c.c2, c.c3, c.c4
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
FROM (
FROM
(
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join7.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join7.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join7.q.out Fri Jan 23 19:59:11 2015
@@ -6,7 +6,9 @@ POSTHOOK: query: CREATE TABLE dest1(c1 I
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
FROM (
FROM
(
@@ -26,7 +28,9 @@ FROM (
) c
INSERT OVERWRITE TABLE dest1 SELECT c.c1, c.c2, c.c3, c.c4, c.c5, c.c6
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
FROM (
FROM
(
@@ -48,9 +52,8 @@ INSERT OVERWRITE TABLE dest1 SELECT c.c1
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
- Stage-3 depends on stages: Stage-0
+ Stage-0 depends on stages: Stage-1
+ Stage-2 depends on stages: Stage-0
STAGE PLANS:
Stage: Stage-1
@@ -88,32 +91,6 @@ STAGE PLANS:
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
- Reduce Operator Tree:
- Join Operator
- condition map:
- Outer Join 0 to 1
- keys:
- 0 _col0 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
- Stage: Stage-2
- Map Reduce
- Map Operator Tree:
- TableScan
- Reduce Output Operator
- key expressions: _col0 (type: string)
- sort order: +
- Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string), _col2 (type: string), _col3 (type: string)
TableScan
alias: src1
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -133,19 +110,21 @@ STAGE PLANS:
Reduce Operator Tree:
Join Operator
condition map:
- Left Outer Join0 to 1
+ Outer Join 0 to 1
+ Left Outer Join0 to 2
keys:
0 _col0 (type: string)
1 _col0 (type: string)
+ 2 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 66 Data size: 706 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 121 Data size: 1284 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), UDFToInteger(_col2) (type: int), _col3 (type: string), UDFToInteger(_col4) (type: int), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 66 Data size: 706 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 121 Data size: 1284 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 66 Data size: 706 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 121 Data size: 1284 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -162,7 +141,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dest1
- Stage: Stage-3
+ Stage: Stage-2
Stats-Aggr Operator
PREHOOK: query: FROM (
@@ -208,7 +187,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src1.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src1.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c2 SIMPLE [(src)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c4 SIMPLE [(src)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c5 EXPRESSION [(src)src1.FieldSchema(name:key, type:string, comment:default), ]
@@ -221,9 +200,6 @@ POSTHOOK: query: SELECT dest1.* FROM des
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
-NULL NULL 24 val_24 NULL NULL
-NULL NULL 24 val_24 NULL NULL
-NULL NULL 20 val_20 NULL NULL
11 val_11 NULL NULL NULL NULL
12 val_12 NULL NULL NULL NULL
12 val_12 NULL NULL NULL NULL
@@ -235,3 +211,6 @@ NULL NULL 20 val_20 NULL NULL
18 val_18 18 val_18 NULL NULL
18 val_18 18 val_18 NULL NULL
19 val_19 19 val_19 NULL NULL
+NULL NULL 20 val_20 NULL NULL
+NULL NULL 24 val_24 NULL NULL
+NULL NULL 24 val_24 NULL NULL
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join9.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join9.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join9.q.out Fri Jan 23 19:59:11 2015
@@ -214,8 +214,8 @@ STAGE PLANS:
name: default.srcpart
name: default.srcpart
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_1:src2]
- /srcpart/ds=2008-04-08/hr=12 [$hdt$_0:$hdt$_0:src1]
+ /src [$hdt$_1:src2]
+ /srcpart/ds=2008-04-08/hr=12 [$hdt$_0:src1]
Needs Tagging: true
Reduce Operator Tree:
Join Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join_array.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join_array.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join_array.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join_array.q.out Fri Jan 23 19:59:11 2015
@@ -30,11 +30,15 @@ POSTHOOK: query: load data local inpath
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@tinyb
-PREHOOK: query: select * from tinyA
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+select * from tinyA
PREHOOK: type: QUERY
PREHOOK: Input: default@tinya
#### A masked pattern was here ####
-POSTHOOK: query: select * from tinyA
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+select * from tinyA
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tinya
#### A masked pattern was here ####
Modified: hive/branches/llap/ql/src/test/results/clientpositive/join_nullsafe.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/join_nullsafe.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/join_nullsafe.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/join_nullsafe.q.out Fri Jan 23 19:59:11 2015
@@ -1525,7 +1525,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: null (type: void)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: null (type: void)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: int)
TableScan
@@ -1537,7 +1537,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: null (type: void)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: null (type: void)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: int)
Reduce Operator Tree:
Modified: hive/branches/llap/ql/src/test/results/clientpositive/limit_partition_metadataonly.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/limit_partition_metadataonly.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/limit_partition_metadataonly.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/limit_partition_metadataonly.q.out Fri Jan 23 19:59:11 2015
@@ -1,6 +1,10 @@
-PREHOOK: query: explain select ds from srcpart where hr=11 and ds='2008-04-08'
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+explain select ds from srcpart where hr=11 and ds='2008-04-08'
PREHOOK: type: QUERY
-POSTHOOK: query: explain select ds from srcpart where hr=11 and ds='2008-04-08'
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+explain select ds from srcpart where hr=11 and ds='2008-04-08'
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
Modified: hive/branches/llap/ql/src/test/results/clientpositive/limit_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/limit_pushdown.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/limit_pushdown.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/limit_pushdown.q.out Fri Jan 23 19:59:11 2015
@@ -344,11 +344,11 @@ val_129 130.0
val_131 132.0
PREHOOK: query: -- distincts
explain
-select distinct(cdouble) from alltypesorc limit 20
+select distinct(cdouble) as dis from alltypesorc order by dis limit 20
PREHOOK: type: QUERY
POSTHOOK: query: -- distincts
explain
-select distinct(cdouble) from alltypesorc limit 20
+select distinct(cdouble) as dis from alltypesorc order by dis limit 20
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -403,11 +403,11 @@ STAGE PLANS:
Processor Tree:
ListSink
-PREHOOK: query: select distinct(cdouble) from alltypesorc limit 20
+PREHOOK: query: select distinct(cdouble) as dis from alltypesorc order by dis limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-POSTHOOK: query: select distinct(cdouble) from alltypesorc limit 20
+POSTHOOK: query: select distinct(cdouble) as dis from alltypesorc order by dis limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
@@ -1175,15 +1175,16 @@ POSTHOOK: Input: default@src
187 val_187 val_187 val_187 val_187 val_187 val_187 val_187 val_187
PREHOOK: query: -- flush for group-by
explain
-select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) limit 100
+select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) order by sum limit 100
PREHOOK: type: QUERY
POSTHOOK: query: -- flush for group-by
explain
-select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) limit 100
+select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) order by sum limit 100
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
+ Stage-2 depends on stages: Stage-1
+ Stage-0 depends on stages: Stage-2
STAGE PLANS:
Stage: Stage-1
@@ -1201,7 +1202,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- TopN Hash Memory Usage: 2.0E-5
value expressions: _col1 (type: string)
Reduce Operator Tree:
Group By Operator
@@ -1214,16 +1214,37 @@ STAGE PLANS:
expressions: _col1 (type: double)
outputColumnNames: _col0
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Limit
- Number of rows: 100
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+
+ Stage: Stage-2
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ Reduce Output Operator
+ key expressions: _col0 (type: double)
+ sort order: +
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ TopN Hash Memory Usage: 2.0E-5
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: double)
+ outputColumnNames: _col0
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Limit
+ Number of rows: 100
+ Statistics: Num rows: 100 Data size: 1000 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
Statistics: Num rows: 100 Data size: 1000 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 100 Data size: 1000 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
+ 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
@@ -1231,29 +1252,35 @@ STAGE PLANS:
Processor Tree:
ListSink
-PREHOOK: query: select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) limit 100
+PREHOOK: query: select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) order by sum limit 100
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) limit 100
+POSTHOOK: query: select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) order by sum limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0.0
10.0
+102.0
+105.0
105.0
11.0
111.0
114.0
-1150.0
+116.0
116.0
126.0
131.0
133.0
+134.0
136.0
143.0
+144.0
145.0
+15.0
150.0
+152.0
153.0
155.0
156.0
@@ -1263,6 +1290,8 @@ POSTHOOK: Input: default@src
162.0
163.0
166.0
+166.0
+168.0
168.0
17.0
170.0
@@ -1275,67 +1304,59 @@ POSTHOOK: Input: default@src
189.0
19.0
190.0
+190.0
192.0
194.0
+194.0
196.0
+196.0
+2.0
20.0
200.0
201.0
202.0
206.0
208.0
+210.0
214.0
218.0
222.0
226.0
226.0
228.0
-235.0
-236.0
24.0
-240.0
-250.0
-258.0
-268.0
-274.0
-292.0
-298.0
+27.0
+28.0
+30.0
30.0
-304.0
-328.0
-330.0
-344.0
-348.0
-350.0
-352.0
-357.0
-358.0
+33.0
+34.0
36.0
-382.0
-384.0
-390.0
-394.0
-400.0
-406.0
-410.0
-414.0
-418.0
-426.0
-432.0
-434.0
-438.0
-442.0
-446.0
-448.0
-458.0
-466.0
-474.0
-476.0
-478.0
-501.0
-552.0
-561.0
-579.0
-597.0
-624.0
-676.0
+4.0
+41.0
+43.0
+44.0
+47.0
+48.0
+52.0
+53.0
+54.0
+57.0
+64.0
+65.0
+66.0
+69.0
+74.0
+74.0
+77.0
+78.0
+8.0
+80.0
+82.0
+84.0
+85.0
+86.0
+87.0
+9.0
+92.0
+96.0
Modified: hive/branches/llap/ql/src/test/results/clientpositive/louter_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/louter_join_ppr.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/louter_join_ppr.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/louter_join_ppr.q.out Fri Jan 23 19:59:11 2015
@@ -761,11 +761,11 @@ STAGE PLANS:
name: default.srcpart
name: default.srcpart
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_1:b]
- /srcpart/ds=2008-04-08/hr=11 [$hdt$_0:$hdt$_0:a]
- /srcpart/ds=2008-04-08/hr=12 [$hdt$_0:$hdt$_0:a]
- /srcpart/ds=2008-04-09/hr=11 [$hdt$_0:$hdt$_0:a]
- /srcpart/ds=2008-04-09/hr=12 [$hdt$_0:$hdt$_0:a]
+ /src [$hdt$_1:b]
+ /srcpart/ds=2008-04-08/hr=11 [$hdt$_0:a]
+ /srcpart/ds=2008-04-08/hr=12 [$hdt$_0:a]
+ /srcpart/ds=2008-04-09/hr=11 [$hdt$_0:a]
+ /srcpart/ds=2008-04-09/hr=12 [$hdt$_0:a]
Needs Tagging: true
Reduce Operator Tree:
Join Operator
@@ -1522,9 +1522,9 @@ STAGE PLANS:
name: default.srcpart
name: default.srcpart
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_1:b]
- /srcpart/ds=2008-04-08/hr=11 [$hdt$_0:$hdt$_0:a]
- /srcpart/ds=2008-04-08/hr=12 [$hdt$_0:$hdt$_0:a]
+ /src [$hdt$_1:b]
+ /srcpart/ds=2008-04-08/hr=11 [$hdt$_0:a]
+ /srcpart/ds=2008-04-08/hr=12 [$hdt$_0:a]
Needs Tagging: true
Reduce Operator Tree:
Join Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out Fri Jan 23 19:59:11 2015
@@ -1,4 +1,6 @@
-PREHOOK: query: --HIVE-2101 mapjoin sometimes gives wrong results if there is a filter in the on condition
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+--HIVE-2101 mapjoin sometimes gives wrong results if there is a filter in the on condition
SELECT * FROM src1
RIGHT OUTER JOIN src1 src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10)
@@ -8,7 +10,9 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@src1
#### A masked pattern was here ####
-POSTHOOK: query: --HIVE-2101 mapjoin sometimes gives wrong results if there is a filter in the on condition
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+--HIVE-2101 mapjoin sometimes gives wrong results if there is a filter in the on condition
SELECT * FROM src1
RIGHT OUTER JOIN src1 src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10)
Modified: hive/branches/llap/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out Fri Jan 23 19:59:11 2015
@@ -574,11 +574,11 @@ STAGE PLANS:
Stage: Stage-9
Map Reduce Local Work
Alias -> Map Local Tables:
- $hdt$_0:$hdt$_0:$hdt$_1:src
+ $hdt$_0:$hdt$_1:src
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $hdt$_0:$hdt$_0:$hdt$_1:src
+ $hdt$_0:$hdt$_1:src
TableScan
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -627,11 +627,11 @@ STAGE PLANS:
Stage: Stage-8
Map Reduce Local Work
Alias -> Map Local Tables:
- $hdt$_0:$hdt$_0:$hdt$_2:src
+ $hdt$_0:$hdt$_2:src
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $hdt$_0:$hdt$_0:$hdt$_2:src
+ $hdt$_0:$hdt$_2:src
TableScan
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Modified: hive/branches/llap/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out Fri Jan 23 19:59:11 2015
@@ -1,10 +1,14 @@
-PREHOOK: query: --HIVE-2101 mapjoin sometimes gives wrong results if there is a filter in the on condition
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+--HIVE-2101 mapjoin sometimes gives wrong results if there is a filter in the on condition
create table dest_1 (key STRING, value STRING) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest_1
-POSTHOOK: query: --HIVE-2101 mapjoin sometimes gives wrong results if there is a filter in the on condition
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+--HIVE-2101 mapjoin sometimes gives wrong results if there is a filter in the on condition
create table dest_1 (key STRING, value STRING) stored as textfile
POSTHOOK: type: CREATETABLE
@@ -66,7 +70,6 @@ POSTHOOK: Input: default@dest_1
POSTHOOK: Input: default@dest_2
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
-NULL NULL 333444 555666 333444 555666
@@ -231,6 +234,7 @@ NULL NULL 333444 555666 333444 555666
146 val_146 146 val_146 146 val_146
224 224 224
369 369 369
+NULL NULL 333444 555666 333444 555666
PREHOOK: query: explain
SELECT /*+ mapjoin(src1, src2) */ * FROM src1
RIGHT OUTER JOIN dest_1 src2 ON (src1.key = src2.key)
@@ -341,7 +345,6 @@ POSTHOOK: Input: default@dest_1
POSTHOOK: Input: default@dest_2
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
-NULL NULL 333444 555666 333444 555666
@@ -506,6 +509,7 @@ NULL NULL 333444 555666 333444 555666
146 val_146 146 val_146 146 val_146
224 224 224
369 369 369
+NULL NULL 333444 555666 333444 555666
PREHOOK: query: SELECT /*+ mapjoin(src1, src2) */ * FROM src1
RIGHT OUTER JOIN dest_1 src2 ON (src1.key = src2.key)
JOIN dest_2 src3 ON (src1.key = src3.key)
@@ -1162,7 +1166,6 @@ POSTHOOK: Input: default@dest_1
POSTHOOK: Input: default@dest_2
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
-NULL NULL 333444 555666 333444 555666
@@ -1327,3 +1330,4 @@ NULL NULL 333444 555666 333444 555666
146 val_146 146 val_146 146 val_146
224 224 224
369 369 369
+NULL NULL 333444 555666 333444 555666
Modified: hive/branches/llap/ql/src/test/results/clientpositive/metadataonly1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/metadataonly1.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/metadataonly1.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/metadataonly1.q.out Fri Jan 23 19:59:11 2015
@@ -614,8 +614,8 @@ STAGE PLANS:
value expressions: _col0 (type: string)
auto parallelism: false
Path -> Alias:
- -mr-10005default.test1{ds=1} [$hdt$_0:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a2]
- -mr-10006default.test1{ds=2} [$hdt$_0:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a2]
+ -mr-10005default.test1{ds=1} [$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a2]
+ -mr-10006default.test1{ds=2} [$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a2]
Path -> Partition:
-mr-10005default.test1{ds=1}
Partition
@@ -696,8 +696,8 @@ STAGE PLANS:
name: default.test1
name: default.test1
Truncated Path -> Alias:
- -mr-10005default.test1{ds=1} [$hdt$_0:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a2]
- -mr-10006default.test1{ds=2} [$hdt$_0:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a2]
+ -mr-10005default.test1{ds=1} [$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a2]
+ -mr-10006default.test1{ds=2} [$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a2]
Needs Tagging: false
Reduce Operator Tree:
Group By Operator
@@ -858,8 +858,8 @@ STAGE PLANS:
name: default.test1
name: default.test1
Truncated Path -> Alias:
- /test1/ds=1 [$hdt$_0:$hdt$_0:$hdt$_0:a2]
- /test1/ds=2 [$hdt$_0:$hdt$_0:$hdt$_0:a2]
+ /test1/ds=1 [$hdt$_0:$hdt$_0:a2]
+ /test1/ds=2 [$hdt$_0:$hdt$_0:a2]
#### A masked pattern was here ####
Needs Tagging: true
Reduce Operator Tree:
Modified: hive/branches/llap/ql/src/test/results/clientpositive/multiMapJoin2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/multiMapJoin2.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/multiMapJoin2.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/multiMapJoin2.q.out Fri Jan 23 19:59:11 2015
@@ -23,14 +23,14 @@ STAGE PLANS:
Stage: Stage-8
Map Reduce Local Work
Alias -> Map Local Tables:
- null-subquery1:$hdt$_0-subquery1:$hdt$_0:$hdt$_1:y1
+ null-subquery1:$hdt$_0-subquery1:$hdt$_1:y1
Fetch Operator
limit: -1
- null-subquery2:$hdt$_0-subquery2:$hdt$_0:$hdt$_1:y1
+ null-subquery2:$hdt$_0-subquery2:$hdt$_1:y1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- null-subquery1:$hdt$_0-subquery1:$hdt$_0:$hdt$_1:y1
+ null-subquery1:$hdt$_0-subquery1:$hdt$_1:y1
TableScan
alias: y1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
@@ -45,7 +45,7 @@ STAGE PLANS:
keys:
0 _col0 (type: string)
1 _col0 (type: string)
- null-subquery2:$hdt$_0-subquery2:$hdt$_0:$hdt$_1:y1
+ null-subquery2:$hdt$_0-subquery2:$hdt$_1:y1
TableScan
alias: y1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
@@ -266,11 +266,11 @@ STAGE PLANS:
Stage: Stage-9
Map Reduce Local Work
Alias -> Map Local Tables:
- null-subquery2:$hdt$_0-subquery2:$hdt$_0:$hdt$_1:y1
+ null-subquery2:$hdt$_0-subquery2:$hdt$_1:y1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- null-subquery2:$hdt$_0-subquery2:$hdt$_0:$hdt$_1:y1
+ null-subquery2:$hdt$_0-subquery2:$hdt$_1:y1
TableScan
alias: y1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
@@ -319,11 +319,11 @@ STAGE PLANS:
Stage: Stage-8
Map Reduce Local Work
Alias -> Map Local Tables:
- null-subquery1:$hdt$_0-subquery1:$hdt$_0:$hdt$_1:y1
+ null-subquery1:$hdt$_0-subquery1:$hdt$_1:y1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- null-subquery1:$hdt$_0-subquery1:$hdt$_0:$hdt$_1:y1
+ null-subquery1:$hdt$_0-subquery1:$hdt$_1:y1
TableScan
alias: y1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
@@ -555,11 +555,11 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce Local Work
Alias -> Map Local Tables:
- null-subquery2:$hdt$_0-subquery2:$hdt$_0:$hdt$_1:x1
+ null-subquery2:$hdt$_0-subquery2:$hdt$_1:x1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- null-subquery2:$hdt$_0-subquery2:$hdt$_0:$hdt$_1:x1
+ null-subquery2:$hdt$_0-subquery2:$hdt$_1:x1
TableScan
alias: x1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
@@ -761,11 +761,11 @@ STAGE PLANS:
Stage: Stage-17
Map Reduce Local Work
Alias -> Map Local Tables:
- $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:y1
+ $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:y1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:y1
+ $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:y1
TableScan
alias: y1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
@@ -993,11 +993,11 @@ STAGE PLANS:
Stage: Stage-18
Map Reduce Local Work
Alias -> Map Local Tables:
- $hdt$_0:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:$hdt$_2:y1
+ $hdt$_0:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_2:y1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $hdt$_0:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:$hdt$_2:y1
+ $hdt$_0:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_2:y1
TableScan
alias: y1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
@@ -1159,14 +1159,14 @@ STAGE PLANS:
Stage: Stage-9
Map Reduce Local Work
Alias -> Map Local Tables:
- $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:y1
+ $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:y1
Fetch Operator
limit: -1
- $hdt$_0:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:$hdt$_2:y1
+ $hdt$_0:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_2:y1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:y1
+ $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:y1
TableScan
alias: y1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
@@ -1181,7 +1181,7 @@ STAGE PLANS:
keys:
0 _col0 (type: string)
1 _col0 (type: string)
- $hdt$_0:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:$hdt$_2:y1
+ $hdt$_0:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_2:y1
TableScan
alias: y1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
@@ -1658,11 +1658,11 @@ STAGE PLANS:
Stage: Stage-14
Map Reduce Local Work
Alias -> Map Local Tables:
- $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:x1
+ $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:x1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:x1
+ $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:x1
TableScan
alias: x1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
@@ -1823,11 +1823,11 @@ STAGE PLANS:
Stage: Stage-7
Map Reduce Local Work
Alias -> Map Local Tables:
- $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:x1
+ $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:x1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:x1
+ $hdt$_0:$hdt$_0:$hdt$_0:$hdt$_0:$hdt$_1:x1
TableScan
alias: x1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
@@ -2222,11 +2222,11 @@ STAGE PLANS:
Stage: Stage-15
Map Reduce Local Work
Alias -> Map Local Tables:
- null-subquery1:$hdt$_0-subquery1:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:$hdt$_1:a
+ null-subquery1:$hdt$_0-subquery1:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- null-subquery1:$hdt$_0-subquery1:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:$hdt$_1:a
+ null-subquery1:$hdt$_0-subquery1:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a
TableScan
alias: a
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -2382,11 +2382,11 @@ STAGE PLANS:
Stage: Stage-16
Map Reduce Local Work
Alias -> Map Local Tables:
- null-subquery2:$hdt$_0-subquery2:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:$hdt$_1:a
+ null-subquery2:$hdt$_0-subquery2:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- null-subquery2:$hdt$_0-subquery2:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:$hdt$_1:a
+ null-subquery2:$hdt$_0-subquery2:$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a
TableScan
alias: a
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Modified: hive/branches/llap/ql/src/test/results/clientpositive/nonmr_fetch_threshold.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/nonmr_fetch_threshold.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/nonmr_fetch_threshold.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/nonmr_fetch_threshold.q.out Fri Jan 23 19:59:11 2015
@@ -94,6 +94,29 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 100 Basic stats: COMPLETE Column stats: NONE
ListSink
+PREHOOK: query: -- Scans without limit (should be Fetch task now)
+explain select concat(key, value) from src
+PREHOOK: type: QUERY
+POSTHOOK: query: -- Scans without limit (should be Fetch task now)
+explain select concat(key, value) from src
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ 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: concat(key, value) (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ ListSink
+
PREHOOK: query: -- from HIVE-7397, limit + partition pruning filter
explain select * from srcpart where ds='2008-04-08' AND hr='11' limit 10
PREHOOK: type: QUERY
@@ -125,6 +148,32 @@ PREHOOK: type: QUERY
POSTHOOK: query: explain select cast(key as int) * 10, upper(value) from src limit 10
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ 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: (UDFToInteger(key) * 10) (type: int), upper(value) (type: string)
+ outputColumnNames: _col0, _col1
+ 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
+
+PREHOOK: query: -- Scans without limit (should not be Fetch task now)
+explain select concat(key, value) from src
+PREHOOK: type: QUERY
+POSTHOOK: query: -- Scans without limit (should not be Fetch task now)
+explain select concat(key, value) from src
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -136,23 +185,20 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: (UDFToInteger(key) * 10) (type: int), upper(value) (type: string)
- outputColumnNames: _col0, _col1
+ expressions: concat(key, value) (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
+ 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: 10
+ limit: -1
Processor Tree:
ListSink
Modified: hive/branches/llap/ql/src/test/results/clientpositive/optimize_nullscan.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/optimize_nullscan.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/optimize_nullscan.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/optimize_nullscan.q.out Fri Jan 23 19:59:11 2015
@@ -1,4 +1,4 @@
-PREHOOK: query: -- SORT_BEFORE_DIFF
+PREHOOK: query: -- SORT_QUERY_RESULTS
-- Disable CBO here, because it messes with the cases specifically crafted for the optimizer.
-- Instead, we could improve the optimizer to recognize more cases, e.g. filter before join.
@@ -6,7 +6,7 @@ PREHOOK: query: -- SORT_BEFORE_DIFF
explain extended
select key from src where false
PREHOOK: type: QUERY
-POSTHOOK: query: -- SORT_BEFORE_DIFF
+POSTHOOK: query: -- SORT_QUERY_RESULTS
-- Disable CBO here, because it messes with the cases specifically crafted for the optimizer.
-- Instead, we could improve the optimizer to recognize more cases, e.g. filter before join.
@@ -1218,8 +1218,8 @@ POSTHOOK: Input: default@srcpart@ds=2008
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
#### A masked pattern was here ####
-2000
0
+2000
Warning: Shuffle Join JOIN[11][tables = [a, b]] in Stage 'Stage-1:MAPRED' is a cross product
PREHOOK: query: explain extended
select * from (select key from src where false) a left outer join (select value from srcpart limit 0) b
Modified: hive/branches/llap/ql/src/test/results/clientpositive/orc_analyze.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/orc_analyze.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/orc_analyze.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/orc_analyze.q.out Fri Jan 23 19:59:11 2015
@@ -107,7 +107,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3123
+ totalSize 3158
#### A masked pattern was here ####
# Storage Information
@@ -197,7 +197,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3123
+ totalSize 3158
#### A masked pattern was here ####
# Storage Information
@@ -313,7 +313,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 2026
+ totalSize 2055
#### A masked pattern was here ####
# Storage Information
@@ -358,7 +358,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 2045
+ totalSize 2071
#### A masked pattern was here ####
# Storage Information
@@ -460,7 +460,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 2026
+ totalSize 2055
#### A masked pattern was here ####
# Storage Information
@@ -505,7 +505,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 2045
+ totalSize 2071
#### A masked pattern was here ####
# Storage Information
@@ -627,7 +627,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 2026
+ totalSize 2055
#### A masked pattern was here ####
# Storage Information
@@ -672,7 +672,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 2045
+ totalSize 2071
#### A masked pattern was here ####
# Storage Information
@@ -780,7 +780,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 2026
+ totalSize 2055
#### A masked pattern was here ####
# Storage Information
@@ -825,7 +825,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 2045
+ totalSize 2071
#### A masked pattern was here ####
# Storage Information
@@ -992,7 +992,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 2026
+ totalSize 2055
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/llap/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out Fri Jan 23 19:59:11 2015
@@ -747,9 +747,6 @@ POSTHOOK: query: SELECT t, si, d, s FROM
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_pred
#### A masked pattern was here ####
-101 327 11.48 gabriella ellison
-15 334 11.12 jessica robinson
-7 320 11.54 bob ellison
PREHOOK: query: EXPLAIN SELECT t, si, d, s FROM orc_pred
WHERE d >= ROUND(9.99)
AND d < 12
@@ -946,7 +943,6 @@ POSTHOOK: query: SELECT t, si, d, s FROM
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_pred
#### A masked pattern was here ####
-15 334 11.12 jessica robinson
PREHOOK: query: EXPLAIN SELECT t, si, d, s FROM orc_pred
WHERE t > 10
AND t <> 101
Modified: hive/branches/llap/ql/src/test/results/clientpositive/ppd2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/ppd2.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/ppd2.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/ppd2.q.out Fri Jan 23 19:59:11 2015
@@ -347,7 +347,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: '20' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
@@ -359,7 +359,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: '20' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/ppd_clusterby.q.out Fri Jan 23 19:59:11 2015
@@ -25,7 +25,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '10' (type: string)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: '10' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
@@ -80,7 +80,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: '20' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
@@ -92,7 +92,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: '20' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
@@ -174,7 +174,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '10' (type: string)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: '10' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
@@ -229,7 +229,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: '20' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
@@ -241,7 +241,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '20' (type: string)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: '20' (type: string)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/ppd_gby_join.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/ppd_gby_join.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/ppd_gby_join.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/ppd_gby_join.q.out Fri Jan 23 19:59:11 2015
@@ -1,4 +1,6 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT src1.c1, count(1)
FROM
(SELECT src.key AS c1, src.value AS c2 from src where src.key > '1' ) src1
@@ -8,7 +10,9 @@ ON src1.c1 = src2.c3 AND src1.c1 < '400'
WHERE src1.c1 > '20' AND (src1.c2 < 'val_50' OR src1.c1 > '2') AND (src2.c3 > '50' OR src1.c1 < '50') AND (src2.c3 <> '4')
GROUP BY src1.c1
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT src1.c1, count(1)
FROM
(SELECT src.key AS c1, src.value AS c2 from src where src.key > '1' ) src1