Return-Path: X-Original-To: apmail-hive-commits-archive@www.apache.org Delivered-To: apmail-hive-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0AA5B10025 for ; Fri, 30 May 2014 17:47:07 +0000 (UTC) Received: (qmail 17814 invoked by uid 500); 30 May 2014 17:39:03 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 17740 invoked by uid 500); 30 May 2014 17:39:03 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 17618 invoked by uid 99); 30 May 2014 17:39:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 May 2014 17:39:03 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 May 2014 17:38:58 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id C2E492388C6C; Fri, 30 May 2014 17:37:38 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit 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 -0000 To: commits@hive.apache.org From: hashutosh@apache.org X-Mailer: svnmailer-1.0.9 Message-Id: <20140530173738.C2E492388C6C@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org 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)