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/05/30 19:37:15 UTC
svn commit: r1598678 [25/31] - in /hive/trunk:
cli/src/java/org/apache/hadoop/hive/cli/
common/src/java/org/apache/hadoop/hive/common/io/
itests/util/src/main/java/org/apache/hadoop/hive/ql/
ql/src/java/org/apache/hadoop/hive/ql/ ql/src/java/org/apache...
Modified: hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby.q.out Fri May 30 17:37:05 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: --HIVE-3699 Multiple insert overwrite into multiple tables query stores same results in all tables
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+--HIVE-3699 Multiple insert overwrite into multiple tables query stores same results in all tables
create table e1 (key string, count int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: --HIVE-3699 Multiple insert overwrite into multiple tables query stores same results in all tables
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+--HIVE-3699 Multiple insert overwrite into multiple tables query stores same results in all tables
create table e1 (key string, count int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -16,24 +20,22 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@e2
PREHOOK: query: explain FROM src
INSERT OVERWRITE TABLE e1
- SELECT key, COUNT(*) WHERE key>450 GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) WHERE key>450 GROUP BY key
INSERT OVERWRITE TABLE e2
- SELECT key, COUNT(*) WHERE key>500 GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) WHERE key>500 GROUP BY key
PREHOOK: type: QUERY
POSTHOOK: query: explain FROM src
INSERT OVERWRITE TABLE e1
- SELECT key, COUNT(*) WHERE key>450 GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) WHERE key>450 GROUP BY key
INSERT OVERWRITE TABLE e2
- SELECT key, COUNT(*) WHERE key>500 GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) WHERE key>500 GROUP BY key
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-2 is a root stage
- Stage-3 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-3
- Stage-4 depends on stages: Stage-0
- Stage-5 depends on stages: Stage-2
- Stage-1 depends on stages: Stage-5
- Stage-6 depends on stages: Stage-1
+ Stage-0 depends on stages: Stage-2
+ Stage-3 depends on stages: Stage-0
+ Stage-1 depends on stages: Stage-2
+ Stage-4 depends on stages: Stage-1
STAGE PLANS:
Stage: Stage-2
@@ -67,15 +69,17 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
+ expressions: _col0 (type: string), UDFToInteger(_col1) (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
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
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.e1
Filter Operator
predicate: (KEY._col0 > 500) (type: boolean)
Statistics: Num rows: 12 Data size: 1202 Basic stats: COMPLETE Column stats: NONE
@@ -86,40 +90,17 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
+ expressions: _col0 (type: string), UDFToInteger(_col1) (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
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-3
- Map Reduce
- Map Operator Tree:
- TableScan
- Reduce Output Operator
- key expressions: _col0 (type: string)
- sort order: +
- Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: bigint)
- Reduce Operator Tree:
- Extract
- Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), UDFToInteger(_col1) (type: int)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 6 Data size: 601 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
- name: default.e1
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.e2
Stage: Stage-0
Move Operator
@@ -131,34 +112,9 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.e1
- Stage: Stage-4
+ Stage: Stage-3
Stats-Aggr Operator
- Stage: Stage-5
- Map Reduce
- Map Operator Tree:
- TableScan
- Reduce Output Operator
- key expressions: _col0 (type: string)
- sort order: +
- Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: bigint)
- Reduce Operator Tree:
- Extract
- Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), UDFToInteger(_col1) (type: int)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 6 Data size: 601 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
- name: default.e2
-
Stage: Stage-1
Move Operator
tables:
@@ -169,23 +125,23 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.e2
- Stage: Stage-6
+ Stage: Stage-4
Stats-Aggr Operator
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE e1
- SELECT key, COUNT(*) WHERE key>450 GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) WHERE key>450 GROUP BY key
INSERT OVERWRITE TABLE e2
- SELECT key, COUNT(*) WHERE key>500 GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) WHERE key>500 GROUP BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@e1
PREHOOK: Output: default@e2
POSTHOOK: query: FROM src
INSERT OVERWRITE TABLE e1
- SELECT key, COUNT(*) WHERE key>450 GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) WHERE key>450 GROUP BY key
INSERT OVERWRITE TABLE e2
- SELECT key, COUNT(*) WHERE key>500 GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) WHERE key>500 GROUP BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@e1
@@ -247,24 +203,22 @@ POSTHOOK: Input: default@e2
#### A masked pattern was here ####
PREHOOK: query: explain FROM src
INSERT OVERWRITE TABLE e1
- SELECT key, COUNT(*) WHERE key>450 GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) WHERE key>450 GROUP BY key
INSERT OVERWRITE TABLE e2
- SELECT key, COUNT(*) GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) GROUP BY key
PREHOOK: type: QUERY
POSTHOOK: query: explain FROM src
INSERT OVERWRITE TABLE e1
- SELECT key, COUNT(*) WHERE key>450 GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) WHERE key>450 GROUP BY key
INSERT OVERWRITE TABLE e2
- SELECT key, COUNT(*) GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) GROUP BY key
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-2 is a root stage
- Stage-3 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-3
- Stage-4 depends on stages: Stage-0
- Stage-5 depends on stages: Stage-2
- Stage-1 depends on stages: Stage-5
- Stage-6 depends on stages: Stage-1
+ Stage-0 depends on stages: Stage-2
+ Stage-3 depends on stages: Stage-0
+ Stage-1 depends on stages: Stage-2
+ Stage-4 depends on stages: Stage-1
STAGE PLANS:
Stage: Stage-2
@@ -295,15 +249,17 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
+ expressions: _col0 (type: string), UDFToInteger(_col1) (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
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
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.e1
Group By Operator
aggregations: count()
keys: KEY._col0 (type: string)
@@ -311,40 +267,17 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
+ expressions: _col0 (type: string), UDFToInteger(_col1) (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
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-3
- Map Reduce
- Map Operator Tree:
- TableScan
- Reduce Output Operator
- key expressions: _col0 (type: string)
- sort order: +
- Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: bigint)
- Reduce Operator Tree:
- Extract
- Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), UDFToInteger(_col1) (type: int)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 9 Data size: 901 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
- name: default.e1
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.e2
Stage: Stage-0
Move Operator
@@ -356,34 +289,9 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.e1
- Stage: Stage-4
+ Stage: Stage-3
Stats-Aggr Operator
- Stage: Stage-5
- Map Reduce
- Map Operator Tree:
- TableScan
- Reduce Output Operator
- key expressions: _col0 (type: string)
- sort order: +
- Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: bigint)
- Reduce Operator Tree:
- Extract
- Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), UDFToInteger(_col1) (type: int)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 29 Data size: 2906 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
- name: default.e2
-
Stage: Stage-1
Move Operator
tables:
@@ -394,23 +302,23 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.e2
- Stage: Stage-6
+ Stage: Stage-4
Stats-Aggr Operator
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE e1
- SELECT key, COUNT(*) WHERE key>450 GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) WHERE key>450 GROUP BY key
INSERT OVERWRITE TABLE e2
- SELECT key, COUNT(*) GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) GROUP BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@e1
PREHOOK: Output: default@e2
POSTHOOK: query: FROM src
INSERT OVERWRITE TABLE e1
- SELECT key, COUNT(*) WHERE key>450 GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) WHERE key>450 GROUP BY key
INSERT OVERWRITE TABLE e2
- SELECT key, COUNT(*) GROUP BY key ORDER BY key
+ SELECT key, COUNT(*) GROUP BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@e1
Modified: hive/trunk/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: create table src_10 as select * from src limit 10
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table src_10 as select * from src limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
-POSTHOOK: query: create table src_10 as select * from src limit 10
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table src_10 as select * from src limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_10
@@ -279,11 +283,11 @@ POSTHOOK: Lineage: src_lv1.key SCRIPT [(
POSTHOOK: Lineage: src_lv1.value SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: src_lv2.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv2.value SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-PREHOOK: query: select * from src_lv1 order by key, value
+PREHOOK: query: select * from src_lv1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv1 order by key, value
+POSTHOOK: query: select * from src_lv1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv1
#### A masked pattern was here ####
@@ -307,11 +311,11 @@ POSTHOOK: Input: default@src_lv1
86 88.0
98 100.0
98 99.0
-PREHOOK: query: select * from src_lv2 order by key, value
+PREHOOK: query: select * from src_lv2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv2 order by key, value
+POSTHOOK: query: select * from src_lv2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv2
#### A masked pattern was here ####
@@ -566,11 +570,11 @@ POSTHOOK: Lineage: src_lv1.key SCRIPT [(
POSTHOOK: Lineage: src_lv1.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: src_lv2.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-PREHOOK: query: select * from src_lv1 order by key, value
+PREHOOK: query: select * from src_lv1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv1 order by key, value
+POSTHOOK: query: select * from src_lv1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv1
#### A masked pattern was here ####
@@ -584,11 +588,11 @@ POSTHOOK: Input: default@src_lv1
484 971.0
86 175.0
98 199.0
-PREHOOK: query: select * from src_lv2 order by key, value
+PREHOOK: query: select * from src_lv2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv2 order by key, value
+POSTHOOK: query: select * from src_lv2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv2
#### A masked pattern was here ####
@@ -844,11 +848,11 @@ POSTHOOK: Lineage: src_lv2.key SIMPLE [(
POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.null, ]
POSTHOOK: Lineage: src_lv3.key SIMPLE [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.null, ]
-PREHOOK: query: select * from src_lv1 order by key, value
+PREHOOK: query: select * from src_lv1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv1 order by key, value
+POSTHOOK: query: select * from src_lv1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv1
#### A masked pattern was here ####
@@ -862,11 +866,11 @@ POSTHOOK: Input: default@src_lv1
484 971.0
86 175.0
98 199.0
-PREHOOK: query: select * from src_lv2 order by key, value
+PREHOOK: query: select * from src_lv2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv2 order by key, value
+POSTHOOK: query: select * from src_lv2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv2
#### A masked pattern was here ####
@@ -876,11 +880,11 @@ POSTHOOK: Input: default@src_lv2
311 1
409 1
484 1
-PREHOOK: query: select * from src_lv3 order by key, value
+PREHOOK: query: select * from src_lv3
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv3
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv3 order by key, value
+POSTHOOK: query: select * from src_lv3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv3
#### A masked pattern was here ####
@@ -1189,11 +1193,11 @@ POSTHOOK: Lineage: src_lv2.key SIMPLE [(
POSTHOOK: Lineage: src_lv2.value SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv3.key SIMPLE [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
-PREHOOK: query: select * from src_lv1 order by key, value
+PREHOOK: query: select * from src_lv1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv1 order by key, value
+POSTHOOK: query: select * from src_lv1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv1
#### A masked pattern was here ####
@@ -1217,11 +1221,11 @@ POSTHOOK: Input: default@src_lv1
87.0 86.0
88.0 86.0
99.0 98.0
-PREHOOK: query: select * from src_lv2 order by key, value
+PREHOOK: query: select * from src_lv2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv2 order by key, value
+POSTHOOK: query: select * from src_lv2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv2
#### A masked pattern was here ####
@@ -1245,11 +1249,11 @@ POSTHOOK: Input: default@src_lv2
488.0 484.0
89.0 86.0
90.0 86.0
-PREHOOK: query: select * from src_lv3 order by key, value
+PREHOOK: query: select * from src_lv3
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv3
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv3 order by key, value
+POSTHOOK: query: select * from src_lv3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv3
#### A masked pattern was here ####
@@ -1603,11 +1607,11 @@ POSTHOOK: Lineage: src_lv2.key SCRIPT [(
POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: src_lv3.value EXPRESSION []
POSTHOOK: Lineage: src_lv4.value EXPRESSION []
-PREHOOK: query: select * from src_lv1 order by key, value
+PREHOOK: query: select * from src_lv1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv1 order by key, value
+POSTHOOK: query: select * from src_lv1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv1
#### A masked pattern was here ####
@@ -1621,11 +1625,11 @@ POSTHOOK: Input: default@src_lv1
484 971.0
86 175.0
98 199.0
-PREHOOK: query: select * from src_lv2 order by key, value
+PREHOOK: query: select * from src_lv2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv2 order by key, value
+POSTHOOK: query: select * from src_lv2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv2
#### A masked pattern was here ####
@@ -1639,11 +1643,11 @@ POSTHOOK: Input: default@src_lv2
484 975.0
86 179.0
98 203.0
-PREHOOK: query: select * from src_lv3 order by key, value
+PREHOOK: query: select * from src_lv3
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv3
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv3 order by key, value
+POSTHOOK: query: select * from src_lv3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv3
#### A masked pattern was here ####
@@ -1653,11 +1657,11 @@ val_278 278.0
val_311 311.0
val_409 409.0
val_484 484.0
-PREHOOK: query: select * from src_lv4 order by key, value
+PREHOOK: query: select * from src_lv4
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv4
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv4 order by key, value
+POSTHOOK: query: select * from src_lv4
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv4
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: create table src_multi1 like src
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table src_multi1 like src
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: create table src_multi1 like src
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table src_multi1 like src
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_multi1
@@ -115,11 +119,11 @@ POSTHOOK: Lineage: src_multi1.key SIMPLE
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -133,11 +137,11 @@ POSTHOOK: Input: default@src_multi1
5 val_5
8 val_8
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -341,11 +345,11 @@ POSTHOOK: Lineage: src_multi1.key SIMPLE
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -359,11 +363,11 @@ POSTHOOK: Input: default@src_multi1
5 val_5
8 val_8
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -479,11 +483,11 @@ POSTHOOK: Lineage: src_multi1.key SIMPLE
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -497,11 +501,11 @@ POSTHOOK: Input: default@src_multi1
5 val_5
8 val_8
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -705,11 +709,11 @@ POSTHOOK: Lineage: src_multi1.key SIMPLE
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -723,11 +727,11 @@ POSTHOOK: Input: default@src_multi1
5 val_5
8 val_8
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -864,11 +868,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_multi1
POSTHOOK: Output: default@src_multi2
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -878,11 +882,11 @@ POSTHOOK: Input: default@src_multi1
5 val_5
8 val_8
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -1104,11 +1108,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_multi1
POSTHOOK: Output: default@src_multi2
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -1118,11 +1122,11 @@ POSTHOOK: Input: default@src_multi1
5 val_5
8 val_8
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -1256,11 +1260,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_multi1
POSTHOOK: Output: default@src_multi2
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -1270,11 +1274,11 @@ POSTHOOK: Input: default@src_multi1
5 val_5
8 val_8
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -1496,11 +1500,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_multi1
POSTHOOK: Output: default@src_multi2
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -1510,11 +1514,11 @@ POSTHOOK: Input: default@src_multi1
5 val_5
8 val_8
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -1672,11 +1676,11 @@ POSTHOOK: Lineage: src_multi1.key EXPRES
POSTHOOK: Lineage: src_multi1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -1700,11 +1704,11 @@ POSTHOOK: Input: default@src_multi1
8 val_8
9 val_9
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -1962,11 +1966,11 @@ POSTHOOK: Lineage: src_multi1.key EXPRES
POSTHOOK: Lineage: src_multi1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -1990,11 +1994,11 @@ POSTHOOK: Input: default@src_multi1
8 val_8
9 val_9
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -2164,11 +2168,11 @@ POSTHOOK: Lineage: src_multi1.key EXPRES
POSTHOOK: Lineage: src_multi1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -2192,11 +2196,11 @@ POSTHOOK: Input: default@src_multi1
8 val_8
9 val_9
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -2454,11 +2458,11 @@ POSTHOOK: Lineage: src_multi1.key EXPRES
POSTHOOK: Lineage: src_multi1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -2482,11 +2486,11 @@ POSTHOOK: Input: default@src_multi1
8 val_8
9 val_9
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -3695,11 +3699,11 @@ POSTHOOK: Lineage: src_multi1.key SIMPLE
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -3713,11 +3717,11 @@ POSTHOOK: Input: default@src_multi1
5 val_5
8 val_8
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -3950,11 +3954,11 @@ POSTHOOK: Lineage: src_multi1.key SIMPLE
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -3968,11 +3972,11 @@ POSTHOOK: Input: default@src_multi1
5 val_5
8 val_8
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -4293,11 +4297,11 @@ POSTHOOK: Lineage: src_multi1.key SIMPLE
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -4311,11 +4315,11 @@ POSTHOOK: Input: default@src_multi1
5 val_5
8 val_8
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
@@ -4636,11 +4640,11 @@ POSTHOOK: Lineage: src_multi1.key SIMPLE
POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from src_multi1 order by key, value
+PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi1 order by key, value
+POSTHOOK: query: select * from src_multi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi1
#### A masked pattern was here ####
@@ -4654,11 +4658,11 @@ POSTHOOK: Input: default@src_multi1
5 val_5
8 val_8
9 val_9
-PREHOOK: query: select * from src_multi2 order by key, value
+PREHOOK: query: select * from src_multi2
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_multi2 order by key, value
+POSTHOOK: query: select * from src_multi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_multi2
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/newline.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/newline.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/newline.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/newline.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: create table tmp_tmp(key string, value string) stored as rcfile
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table tmp_tmp(key string, value string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: create table tmp_tmp(key string, value string) stored as rcfile
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table tmp_tmp(key string, value string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@tmp_tmp
@@ -19,23 +23,23 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@tmp_tmp
POSTHOOK: Lineage: tmp_tmp.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: tmp_tmp.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from tmp_tmp ORDER BY key ASC, value ASC
+PREHOOK: query: select * from tmp_tmp
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp_tmp
#### A masked pattern was here ####
-POSTHOOK: query: select * from tmp_tmp ORDER BY key ASC, value ASC
+POSTHOOK: query: select * from tmp_tmp
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp_tmp
#### A masked pattern was here ####
1 2 NULL
1 2 NULL
-1 NULL
+1
2 NULL
-1 NULL
+1
2 NULL
-1 NULL
+1
2 NULL
-1 NULL
+1
2 NULL
PREHOOK: query: drop table tmp_tmp
PREHOOK: type: DROPTABLE
@@ -66,11 +70,11 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@tmp_tmp
POSTHOOK: Lineage: tmp_tmp.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: tmp_tmp.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from tmp_tmp ORDER BY key ASC, value ASC
+PREHOOK: query: select * from tmp_tmp
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp_tmp
#### A masked pattern was here ####
-POSTHOOK: query: select * from tmp_tmp ORDER BY key ASC, value ASC
+POSTHOOK: query: select * from tmp_tmp
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp_tmp
#### A masked pattern was here ####
@@ -108,11 +112,11 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@tmp_tmp
POSTHOOK: Lineage: tmp_tmp.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: tmp_tmp.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from tmp_tmp ORDER BY key ASC, value ASC
+PREHOOK: query: select * from tmp_tmp
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp_tmp
#### A masked pattern was here ####
-POSTHOOK: query: select * from tmp_tmp ORDER BY key ASC, value ASC
+POSTHOOK: query: select * from tmp_tmp
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp_tmp
#### A masked pattern was here ####
@@ -150,11 +154,11 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@tmp_tmp
POSTHOOK: Lineage: tmp_tmp.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: tmp_tmp.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from tmp_tmp ORDER BY key ASC, value ASC
+PREHOOK: query: select * from tmp_tmp
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp_tmp
#### A masked pattern was here ####
-POSTHOOK: query: select * from tmp_tmp ORDER BY key ASC, value ASC
+POSTHOOK: query: select * from tmp_tmp
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp_tmp
#### A masked pattern was here ####
@@ -192,11 +196,11 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@tmp_tmp
POSTHOOK: Lineage: tmp_tmp.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: tmp_tmp.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from tmp_tmp ORDER BY key ASC, value ASC
+PREHOOK: query: select * from tmp_tmp
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp_tmp
#### A masked pattern was here ####
-POSTHOOK: query: select * from tmp_tmp ORDER BY key ASC, value ASC
+POSTHOOK: query: select * from tmp_tmp
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp_tmp
#### A masked pattern was here ####
@@ -216,10 +220,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp_tmp
#### A masked pattern was here ####
1\ 2 NULL
-1\\t2 NULL
1\ 2 NULL
-1\\t2 NULL
1\ 2 NULL
+1\\t2 NULL
+1\\t2 NULL
PREHOOK: query: SELECT key FROM (SELECT TRANSFORM ('a\tb', 'c') USING 'cat' AS (key, value) FROM src limit 1)a ORDER BY key ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: -- negative, references twice for result of funcion
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- negative, references twice for result of funcion
explain select nkey, nkey + 1 from (select key + 1 as nkey, value from src) a
PREHOOK: type: QUERY
-POSTHOOK: query: -- negative, references twice for result of funcion
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- negative, references twice for result of funcion
explain select nkey, nkey + 1 from (select key + 1 as nkey, value from src) a
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
@@ -48,7 +52,7 @@ FROM (SELECT tmp2.key as key, tmp2.value
FROM src1) tmp1 ) tmp2
JOIN (SELECT count(*) as count
FROM src1) tmp3
- ) tmp4 order by key, value, count
+ ) tmp4
PREHOOK: type: QUERY
POSTHOOK: query: -- This test query is introduced for HIVE-4968.
-- First, we do not convert the join to MapJoin.
@@ -60,13 +64,12 @@ FROM (SELECT tmp2.key as key, tmp2.value
FROM src1) tmp1 ) tmp2
JOIN (SELECT count(*) as count
FROM src1) tmp3
- ) tmp4 order by key, value, count
+ ) tmp4
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1
- Stage-3 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-3
+ Stage-0 depends on stages: Stage-2
STAGE PLANS:
Stage: Stage-1
@@ -137,30 +140,11 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 237 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-3
- Map Reduce
- Map Operator Tree:
- TableScan
- Reduce Output Operator
- key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint)
- sort order: +++
Statistics: Num rows: 1 Data size: 237 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint)
- Reduce Operator Tree:
- Extract
- Statistics: Num rows: 1 Data size: 237 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 237 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
@@ -176,7 +160,7 @@ FROM (SELECT tmp2.key as key, tmp2.value
FROM src1) tmp1 ) tmp2
JOIN (SELECT count(*) as count
FROM src1) tmp3
- ) tmp4 order by key, value, count
+ ) tmp4
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
@@ -187,7 +171,7 @@ FROM (SELECT tmp2.key as key, tmp2.value
FROM src1) tmp1 ) tmp2
JOIN (SELECT count(*) as count
FROM src1) tmp3
- ) tmp4 order by key, value, count
+ ) tmp4
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
@@ -216,7 +200,7 @@ POSTHOOK: Input: default@src1
406 val_406 25
66 val_66 25
98 val_98 25
-Warning: Map Join MAPJOIN[21][bigTable=?] in task 'Stage-3:MAPRED' is a cross product
+Warning: Map Join MAPJOIN[17][bigTable=?] in task 'Stage-4:MAPRED' is a cross product
PREHOOK: query: -- Then, we convert the join to MapJoin.
EXPLAIN
SELECT tmp4.key as key, tmp4.value as value, tmp4.count as count
@@ -226,7 +210,7 @@ FROM (SELECT tmp2.key as key, tmp2.value
FROM src1) tmp1 ) tmp2
JOIN (SELECT count(*) as count
FROM src1) tmp3
- ) tmp4 order by key, value, count
+ ) tmp4
PREHOOK: type: QUERY
POSTHOOK: query: -- Then, we convert the join to MapJoin.
EXPLAIN
@@ -237,13 +221,13 @@ FROM (SELECT tmp2.key as key, tmp2.value
FROM src1) tmp1 ) tmp2
JOIN (SELECT count(*) as count
FROM src1) tmp3
- ) tmp4 order by key, value, count
+ ) tmp4
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-6 depends on stages: Stage-1
- Stage-3 depends on stages: Stage-6
- Stage-0 depends on stages: Stage-3
+ Stage-5 depends on stages: Stage-1
+ Stage-4 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-4
STAGE PLANS:
Stage: Stage-1
@@ -280,7 +264,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
- Stage: Stage-6
+ Stage: Stage-5
Map Reduce Local Work
Alias -> Map Local Tables:
tmp4:tmp2:tmp1:src1
@@ -303,7 +287,7 @@ STAGE PLANS:
0
1
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Map Operator Tree:
TableScan
@@ -322,23 +306,15 @@ STAGE PLANS:
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 1 Data size: 237 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint)
- sort order: +++
+ File Output Operator
+ compressed: false
Statistics: Num rows: 1 Data size: 237 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint)
+ 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
Local Work:
Map Reduce Local Work
- Reduce Operator Tree:
- Extract
- Statistics: Num rows: 1 Data size: 237 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 237 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
@@ -346,7 +322,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Map Join MAPJOIN[21][bigTable=?] in task 'Stage-3:MAPRED' is a cross product
+Warning: Map Join MAPJOIN[17][bigTable=?] in task 'Stage-4:MAPRED' is a cross product
PREHOOK: query: SELECT tmp4.key as key, tmp4.value as value, tmp4.count as count
FROM (SELECT tmp2.key as key, tmp2.value as value, tmp3.count as count
FROM (SELECT *
@@ -354,7 +330,7 @@ FROM (SELECT tmp2.key as key, tmp2.value
FROM src1) tmp1 ) tmp2
JOIN (SELECT count(*) as count
FROM src1) tmp3
- ) tmp4 order by key, value, count
+ ) tmp4
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
@@ -365,7 +341,7 @@ FROM (SELECT tmp2.key as key, tmp2.value
FROM src1) tmp1 ) tmp2
JOIN (SELECT count(*) as count
FROM src1) tmp3
- ) tmp4 order by key, value, count
+ ) tmp4
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/orc_create.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/orc_create.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/orc_create.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/orc_create.q.out Fri May 30 17:37:05 2014
@@ -1,6 +1,10 @@
-PREHOOK: query: DROP TABLE orc_create
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE orc_create
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+DROP TABLE orc_create
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+DROP TABLE orc_create
POSTHOOK: type: DROPTABLE
PREHOOK: query: DROP TABLE orc_create_complex
PREHOOK: type: DROPTABLE
@@ -407,9 +411,9 @@ POSTHOOK: query: SELECT strct from orc_c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_complex
#### A masked pattern was here ####
+{"a":"five","b":"six"}
{"a":"one","b":"two"}
{"a":"three","b":"four"}
-{"a":"five","b":"six"}
PREHOOK: query: CREATE TABLE orc_create_people_staging (
id int,
first_name string,
@@ -650,7 +654,6 @@ POSTHOOK: Input: default@orc_create_peop
PREHOOK: query: -- test predicate push down with no column projection
SELECT id, first_name, last_name, address
FROM orc_create_people WHERE id > 90
- ORDER BY id, first_name, last_name
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
@@ -659,12 +662,12 @@ PREHOOK: Input: default@orc_create_peopl
POSTHOOK: query: -- test predicate push down with no column projection
SELECT id, first_name, last_name, address
FROM orc_create_people WHERE id > 90
- ORDER BY id, first_name, last_name
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
POSTHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
+100 Wang Mitchell 4023 Lacinia. Ave
91 Genevieve Wilkins 908 Turpis. Street
92 Thane Oneil 6766 Lectus St.
93 Mariko Cline P.O. Box 329, 5375 Ac St.
@@ -674,7 +677,6 @@ POSTHOOK: Input: default@orc_create_peop
97 Dana Carter 814-601 Purus. Av.
98 Juliet Battle Ap #535-1965 Cursus St.
99 Wynter Vincent 626-8492 Mollis Avenue
-100 Wang Mitchell 4023 Lacinia. Ave
PREHOOK: query: DROP TABLE orc_create
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@orc_create
Modified: hive/trunk/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out Fri May 30 17:37:05 2014
@@ -1,11 +1,15 @@
-PREHOOK: query: CREATE TABLE test_orc (key STRING)
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE test_orc (key STRING)
PARTITIONED BY (part STRING)
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE test_orc (key STRING)
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE test_orc (key STRING)
PARTITIONED BY (part STRING)
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
@@ -48,13 +52,13 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@test_orc@part=2
POSTHOOK: Lineage: test_orc PARTITION(part=2).cnt EXPRESSION [(src)src.null, ]
POSTHOOK: Lineage: test_orc PARTITION(part=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT * FROM test_orc ORDER BY key
+PREHOOK: query: SELECT * FROM test_orc
PREHOOK: type: QUERY
PREHOOK: Input: default@test_orc
PREHOOK: Input: default@test_orc@part=1
PREHOOK: Input: default@test_orc@part=2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM test_orc ORDER BY key
+POSTHOOK: query: SELECT * FROM test_orc
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_orc
POSTHOOK: Input: default@test_orc@part=1
Modified: hive/trunk/ql/src/test/results/clientpositive/orc_diff_part_cols2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/orc_diff_part_cols2.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/orc_diff_part_cols2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/orc_diff_part_cols2.q.out Fri May 30 17:37:05 2014
@@ -1,6 +1,8 @@
PREHOOK: query: -- Create a table with one column, write to it, then add an additional column
-- This can break reads
+-- SORT_QUERY_RESULTS
+
CREATE TABLE test_orc (key STRING)
STORED AS ORC
PREHOOK: type: CREATETABLE
@@ -8,6 +10,8 @@ PREHOOK: Output: database:default
POSTHOOK: query: -- Create a table with one column, write to it, then add an additional column
-- This can break reads
+-- SORT_QUERY_RESULTS
+
CREATE TABLE test_orc (key STRING)
STORED AS ORC
POSTHOOK: type: CREATETABLE
@@ -30,11 +34,11 @@ POSTHOOK: query: ALTER TABLE test_orc AD
POSTHOOK: type: ALTERTABLE_ADDCOLS
POSTHOOK: Input: default@test_orc
POSTHOOK: Output: default@test_orc
-PREHOOK: query: SELECT * FROM test_orc order by key
+PREHOOK: query: SELECT * FROM test_orc
PREHOOK: type: QUERY
PREHOOK: Input: default@test_orc
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM test_orc order by key
+POSTHOOK: query: SELECT * FROM test_orc
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_orc
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/orc_empty_strings.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/orc_empty_strings.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/orc_empty_strings.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/orc_empty_strings.q.out Fri May 30 17:37:05 2014
@@ -1,10 +1,14 @@
-PREHOOK: query: CREATE TABLE test_orc (key STRING)
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE test_orc (key STRING)
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE test_orc (key STRING)
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE test_orc (key STRING)
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
@@ -53,13 +57,13 @@ POSTHOOK: Output: default@test_orc
POSTHOOK: Lineage: test_orc.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: -- Test reading a column which has some empty strings
-SELECT * FROM test_orc ORDER BY key
+SELECT * FROM test_orc
PREHOOK: type: QUERY
PREHOOK: Input: default@test_orc
#### A masked pattern was here ####
POSTHOOK: query: -- Test reading a column which has some empty strings
-SELECT * FROM test_orc ORDER BY key
+SELECT * FROM test_orc
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_orc
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out Fri May 30 17:37:05 2014
@@ -1,4 +1,6 @@
-PREHOOK: query: CREATE TABLE orc_pred(t tinyint,
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE orc_pred(t tinyint,
si smallint,
i int,
b bigint,
@@ -12,7 +14,9 @@ PREHOOK: query: CREATE TABLE orc_pred(t
STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE orc_pred(t tinyint,
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE orc_pred(t tinyint,
si smallint,
i int,
b bigint,
@@ -420,7 +424,6 @@ PREHOOK: query: SELECT t, s FROM orc_pre
WHERE t <=> -1
AND s IS NOT NULL
AND s LIKE 'bob%'
- ORDER BY s
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_pred
#### A masked pattern was here ####
@@ -428,7 +431,6 @@ POSTHOOK: query: SELECT t, s FROM orc_pr
WHERE t <=> -1
AND s IS NOT NULL
AND s LIKE 'bob%'
- ORDER BY s
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_pred
#### A masked pattern was here ####
@@ -438,7 +440,6 @@ PREHOOK: query: SELECT t, s FROM orc_pre
WHERE t <=> -1
AND s IS NOT NULL
AND s LIKE 'bob%'
- ORDER BY s
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_pred
#### A masked pattern was here ####
@@ -446,7 +447,6 @@ POSTHOOK: query: SELECT t, s FROM orc_pr
WHERE t <=> -1
AND s IS NOT NULL
AND s LIKE 'bob%'
- ORDER BY s
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_pred
#### A masked pattern was here ####
@@ -456,13 +456,11 @@ PREHOOK: query: EXPLAIN SELECT t, s FROM
WHERE t <=> -1
AND s IS NOT NULL
AND s LIKE 'bob%'
- ORDER BY s
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT t, s FROM orc_pred
WHERE t <=> -1
AND s IS NOT NULL
AND s LIKE 'bob%'
- ORDER BY s
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -482,21 +480,13 @@ STAGE PLANS:
expressions: t (type: tinyint), s (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 131 Data size: 38859 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
+ File Output Operator
+ compressed: false
Statistics: Num rows: 131 Data size: 38859 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: tinyint), _col1 (type: string)
- Reduce Operator Tree:
- Extract
- Statistics: Num rows: 131 Data size: 38859 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 131 Data size: 38859 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
@@ -508,13 +498,11 @@ PREHOOK: query: EXPLAIN SELECT t, s FROM
WHERE t <=> -1
AND s IS NOT NULL
AND s LIKE 'bob%'
- ORDER BY s
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT t, s FROM orc_pred
WHERE t <=> -1
AND s IS NOT NULL
AND s LIKE 'bob%'
- ORDER BY s
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -535,21 +523,13 @@ STAGE PLANS:
expressions: t (type: tinyint), s (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 131 Data size: 38859 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
+ File Output Operator
+ compressed: false
Statistics: Num rows: 131 Data size: 38859 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: tinyint), _col1 (type: string)
- Reduce Operator Tree:
- Extract
- Statistics: Num rows: 131 Data size: 38859 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 131 Data size: 38859 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
@@ -734,8 +714,8 @@ 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
101 327 11.48 gabriella ellison
+15 334 11.12 jessica robinson
7 320 11.54 bob ellison
PREHOOK: query: SELECT t, si, d, s FROM orc_pred
WHERE d >= ROUND(9.99)
@@ -763,8 +743,8 @@ 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
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)