hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject 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...
Date Fri, 30 May 2014 17:37:15 GMT
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)



Mime
View raw message