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 751F510152 for ; Tue, 5 Nov 2013 07:06:27 +0000 (UTC) Received: (qmail 97115 invoked by uid 500); 5 Nov 2013 07:04:55 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 96912 invoked by uid 500); 5 Nov 2013 07:04:49 -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 96759 invoked by uid 99); 5 Nov 2013 07:04:39 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Nov 2013 07:04:39 +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; Tue, 05 Nov 2013 07:04:33 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id 73DC52388CA2; Tue, 5 Nov 2013 07:03:03 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1538880 [32/46] - in /hive/branches/tez: ./ ant/ ant/src/org/apache/hadoop/hive/ant/ beeline/ beeline/src/java/org/apache/hive/beeline/ beeline/src/main/ beeline/src/test/org/apache/hive/beeline/src/test/ cli/ common/ common/src/java/conf/... Date: Tue, 05 Nov 2013 07:01:58 -0000 To: commits@hive.apache.org From: gunther@apache.org X-Mailer: svnmailer-1.0.9 Message-Id: <20131105070303.73DC52388CA2@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Modified: hive/branches/tez/ql/src/test/results/clientpositive/louter_join_ppr.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/louter_join_ppr.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/louter_join_ppr.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/louter_join_ppr.q.out Tue Nov 5 07:01:32 2013 @@ -88,7 +88,6 @@ STAGE PLANS: #### A masked pattern was here #### name default.src numFiles 1 - numPartitions 0 numRows 0 rawDataSize 0 serialization.ddl struct src { string key, string value} @@ -107,7 +106,6 @@ STAGE PLANS: #### A masked pattern was here #### name default.src numFiles 1 - numPartitions 0 numRows 0 rawDataSize 0 serialization.ddl struct src { string key, string value} @@ -151,15 +149,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.srcpart - numFiles 4 - numPartitions 4 - numRows 0 partition_columns ds/hr - rawDataSize 0 serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.srcpart @@ -197,15 +190,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.srcpart - numFiles 4 - numPartitions 4 - numRows 0 partition_columns ds/hr - rawDataSize 0 serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.srcpart @@ -396,7 +384,6 @@ STAGE PLANS: #### A masked pattern was here #### name default.src numFiles 1 - numPartitions 0 numRows 0 rawDataSize 0 serialization.ddl struct src { string key, string value} @@ -415,7 +402,6 @@ STAGE PLANS: #### A masked pattern was here #### name default.src numFiles 1 - numPartitions 0 numRows 0 rawDataSize 0 serialization.ddl struct src { string key, string value} @@ -459,15 +445,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.srcpart - numFiles 4 - numPartitions 4 - numRows 0 partition_columns ds/hr - rawDataSize 0 serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.srcpart @@ -505,15 +486,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.srcpart - numFiles 4 - numPartitions 4 - numRows 0 partition_columns ds/hr - rawDataSize 0 serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.srcpart @@ -551,15 +527,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.srcpart - numFiles 4 - numPartitions 4 - numRows 0 partition_columns ds/hr - rawDataSize 0 serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.srcpart @@ -597,15 +568,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.srcpart - numFiles 4 - numPartitions 4 - numRows 0 partition_columns ds/hr - rawDataSize 0 serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.srcpart @@ -807,7 +773,6 @@ STAGE PLANS: #### A masked pattern was here #### name default.src numFiles 1 - numPartitions 0 numRows 0 rawDataSize 0 serialization.ddl struct src { string key, string value} @@ -826,7 +791,6 @@ STAGE PLANS: #### A masked pattern was here #### name default.src numFiles 1 - numPartitions 0 numRows 0 rawDataSize 0 serialization.ddl struct src { string key, string value} @@ -870,15 +834,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.srcpart - numFiles 4 - numPartitions 4 - numRows 0 partition_columns ds/hr - rawDataSize 0 serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.srcpart @@ -916,15 +875,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.srcpart - numFiles 4 - numPartitions 4 - numRows 0 partition_columns ds/hr - rawDataSize 0 serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.srcpart @@ -962,15 +916,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.srcpart - numFiles 4 - numPartitions 4 - numRows 0 partition_columns ds/hr - rawDataSize 0 serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.srcpart @@ -1008,15 +957,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.srcpart - numFiles 4 - numPartitions 4 - numRows 0 partition_columns ds/hr - rawDataSize 0 serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.srcpart @@ -1211,7 +1155,6 @@ STAGE PLANS: #### A masked pattern was here #### name default.src numFiles 1 - numPartitions 0 numRows 0 rawDataSize 0 serialization.ddl struct src { string key, string value} @@ -1230,7 +1173,6 @@ STAGE PLANS: #### A masked pattern was here #### name default.src numFiles 1 - numPartitions 0 numRows 0 rawDataSize 0 serialization.ddl struct src { string key, string value} @@ -1274,15 +1216,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.srcpart - numFiles 4 - numPartitions 4 - numRows 0 partition_columns ds/hr - rawDataSize 0 serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.srcpart @@ -1320,15 +1257,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.srcpart - numFiles 4 - numPartitions 4 - numRows 0 partition_columns ds/hr - rawDataSize 0 serialization.ddl struct srcpart { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.srcpart Modified: hive/branches/tez/ql/src/test/results/clientpositive/macro.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/macro.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/macro.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/macro.q.out Tue Nov 5 07:01:32 2013 @@ -19,33 +19,22 @@ ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION SIGMOID 2))) (TOK_LIMIT 1))) STAGE DEPENDENCIES: - Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: - Stage: Stage-1 - Map Reduce - Alias -> Map Operator Tree: - src - TableScan - alias: src - Select Operator - expressions: - expr: SIGMOID(2) - type: double - outputColumnNames: _col0 - Limit - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - Stage: Stage-0 Fetch Operator limit: 1 + Processor Tree: + TableScan + alias: src + Select Operator + expressions: + expr: SIGMOID(2) + type: double + outputColumnNames: _col0 + Limit + ListSink PREHOOK: query: EXPLAIN EXTENDED SELECT SIGMOID(2) FROM src LIMIT 1 @@ -56,94 +45,23 @@ ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION SIGMOID 2))) (TOK_LIMIT 1))) STAGE DEPENDENCIES: - Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: - Stage: Stage-1 - Map Reduce - Alias -> Map Operator Tree: - src - TableScan - alias: src - GatherStats: false - Select Operator - expressions: - expr: SIGMOID(2) - type: double - outputColumnNames: _col0 - Limit - File Output Operator - compressed: false - GlobalTableId: 0 -#### A masked pattern was here #### - NumFilesPerFileSink: 1 -#### A masked pattern was here #### - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - columns _col0 - columns.types double - escape.delim \ - hive.serialization.extend.nesting.levels true - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - TotalFiles: 1 - GatherStats: false - MultiFileSpray: false - Path -> Alias: -#### A masked pattern was here #### - Path -> Partition: -#### A masked pattern was here #### - Partition - base file name: src - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - bucket_count -1 - columns key,value - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numPartitions 0 - numRows 0 - rawDataSize 0 - serialization.ddl struct src { string key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 5812 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - bucket_count -1 - columns key,value - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numPartitions 0 - numRows 0 - rawDataSize 0 - serialization.ddl struct src { string key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 5812 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.src - name: default.src - Truncated Path -> Alias: - /src [src] - Stage: Stage-0 Fetch Operator limit: 1 + Processor Tree: + TableScan + alias: src + GatherStats: false + Select Operator + expressions: + expr: SIGMOID(2) + type: double + outputColumnNames: _col0 + Limit + ListSink PREHOOK: query: DROP TEMPORARY MACRO SIGMOID @@ -171,33 +89,22 @@ ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (+ (TOK_FUNCTION FIXED_NUMBER) 1))) (TOK_LIMIT 1))) STAGE DEPENDENCIES: - Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: - Stage: Stage-1 - Map Reduce - Alias -> Map Operator Tree: - src - TableScan - alias: src - Select Operator - expressions: - expr: (FIXED_NUMBER() + 1) - type: int - outputColumnNames: _col0 - Limit - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - Stage: Stage-0 Fetch Operator limit: 1 + Processor Tree: + TableScan + alias: src + Select Operator + expressions: + expr: (FIXED_NUMBER() + 1) + type: int + outputColumnNames: _col0 + Limit + ListSink PREHOOK: query: EXPLAIN EXTENDED SELECT FIXED_NUMBER() + 1 FROM src LIMIT 1 @@ -208,94 +115,23 @@ ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (+ (TOK_FUNCTION FIXED_NUMBER) 1))) (TOK_LIMIT 1))) STAGE DEPENDENCIES: - Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: - Stage: Stage-1 - Map Reduce - Alias -> Map Operator Tree: - src - TableScan - alias: src - GatherStats: false - Select Operator - expressions: - expr: (FIXED_NUMBER() + 1) - type: int - outputColumnNames: _col0 - Limit - File Output Operator - compressed: false - GlobalTableId: 0 -#### A masked pattern was here #### - NumFilesPerFileSink: 1 -#### A masked pattern was here #### - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - columns _col0 - columns.types int - escape.delim \ - hive.serialization.extend.nesting.levels true - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - TotalFiles: 1 - GatherStats: false - MultiFileSpray: false - Path -> Alias: -#### A masked pattern was here #### - Path -> Partition: -#### A masked pattern was here #### - Partition - base file name: src - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - bucket_count -1 - columns key,value - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numPartitions 0 - numRows 0 - rawDataSize 0 - serialization.ddl struct src { string key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 5812 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - bucket_count -1 - columns key,value - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numPartitions 0 - numRows 0 - rawDataSize 0 - serialization.ddl struct src { string key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 5812 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.src - name: default.src - Truncated Path -> Alias: - /src [src] - Stage: Stage-0 Fetch Operator limit: 1 + Processor Tree: + TableScan + alias: src + GatherStats: false + Select Operator + expressions: + expr: (FIXED_NUMBER() + 1) + type: int + outputColumnNames: _col0 + Limit + ListSink PREHOOK: query: DROP TEMPORARY MACRO FIXED_NUMBER @@ -344,33 +180,22 @@ ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION SIMPLE_ADD 1 9))) (TOK_LIMIT 1))) STAGE DEPENDENCIES: - Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: - Stage: Stage-1 - Map Reduce - Alias -> Map Operator Tree: - src - TableScan - alias: src - Select Operator - expressions: - expr: SIMPLE_ADD(1, 9) - type: int - outputColumnNames: _col0 - Limit - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - Stage: Stage-0 Fetch Operator limit: 1 + Processor Tree: + TableScan + alias: src + Select Operator + expressions: + expr: SIMPLE_ADD(1, 9) + type: int + outputColumnNames: _col0 + Limit + ListSink PREHOOK: query: EXPLAIN EXTENDED SELECT SIMPLE_ADD(1, 9) FROM src LIMIT 1 @@ -381,94 +206,23 @@ ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION SIMPLE_ADD 1 9))) (TOK_LIMIT 1))) STAGE DEPENDENCIES: - Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: - Stage: Stage-1 - Map Reduce - Alias -> Map Operator Tree: - src - TableScan - alias: src - GatherStats: false - Select Operator - expressions: - expr: SIMPLE_ADD(1, 9) - type: int - outputColumnNames: _col0 - Limit - File Output Operator - compressed: false - GlobalTableId: 0 -#### A masked pattern was here #### - NumFilesPerFileSink: 1 -#### A masked pattern was here #### - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - columns _col0 - columns.types int - escape.delim \ - hive.serialization.extend.nesting.levels true - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - TotalFiles: 1 - GatherStats: false - MultiFileSpray: false - Path -> Alias: -#### A masked pattern was here #### - Path -> Partition: -#### A masked pattern was here #### - Partition - base file name: src - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - bucket_count -1 - columns key,value - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numPartitions 0 - numRows 0 - rawDataSize 0 - serialization.ddl struct src { string key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 5812 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - bucket_count -1 - columns key,value - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numPartitions 0 - numRows 0 - rawDataSize 0 - serialization.ddl struct src { string key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 5812 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.src - name: default.src - Truncated Path -> Alias: - /src [src] - Stage: Stage-0 Fetch Operator limit: 1 + Processor Tree: + TableScan + alias: src + GatherStats: false + Select Operator + expressions: + expr: SIMPLE_ADD(1, 9) + type: int + outputColumnNames: _col0 + Limit + ListSink PREHOOK: query: DROP TEMPORARY MACRO SIMPLE_ADD Modified: hive/branches/tez/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out Tue Nov 5 07:01:32 2013 @@ -31,22 +31,22 @@ POSTHOOK: query: CREATE TABLE z (id INT, ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@z -PREHOOK: query: load data local inpath '../data/files/x.txt' INTO TABLE x +PREHOOK: query: load data local inpath '../../data/files/x.txt' INTO TABLE x PREHOOK: type: LOAD PREHOOK: Output: default@x -POSTHOOK: query: load data local inpath '../data/files/x.txt' INTO TABLE x +POSTHOOK: query: load data local inpath '../../data/files/x.txt' INTO TABLE x POSTHOOK: type: LOAD POSTHOOK: Output: default@x -PREHOOK: query: load data local inpath '../data/files/y.txt' INTO TABLE y +PREHOOK: query: load data local inpath '../../data/files/y.txt' INTO TABLE y PREHOOK: type: LOAD PREHOOK: Output: default@y -POSTHOOK: query: load data local inpath '../data/files/y.txt' INTO TABLE y +POSTHOOK: query: load data local inpath '../../data/files/y.txt' INTO TABLE y POSTHOOK: type: LOAD POSTHOOK: Output: default@y -PREHOOK: query: load data local inpath '../data/files/z.txt' INTO TABLE z +PREHOOK: query: load data local inpath '../../data/files/z.txt' INTO TABLE z PREHOOK: type: LOAD PREHOOK: Output: default@z -POSTHOOK: query: load data local inpath '../data/files/z.txt' INTO TABLE z +POSTHOOK: query: load data local inpath '../../data/files/z.txt' INTO TABLE z POSTHOOK: type: LOAD POSTHOOK: Output: default@z PREHOOK: query: -- Since the inputs are small, it should be automatically converted to mapjoin Modified: hive/branches/tez/ql/src/test/results/clientpositive/merge3.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/merge3.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/merge3.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/merge3.q.out Tue Nov 5 07:01:32 2013 @@ -117,7 +117,6 @@ STAGE PLANS: #### A masked pattern was here #### name default.merge_src numFiles 4 - numPartitions 0 numRows 2000 rawDataSize 21248 serialization.ddl struct merge_src { string key, string value} @@ -136,7 +135,6 @@ STAGE PLANS: #### A masked pattern was here #### name default.merge_src numFiles 4 - numPartitions 0 numRows 2000 rawDataSize 21248 serialization.ddl struct merge_src { string key, string value} @@ -2344,7 +2342,6 @@ Retention: 0 Table Type: MANAGED_TABLE Table Parameters: numFiles 1 - numPartitions 0 numRows 2000 rawDataSize 21248 totalSize 23248 @@ -2473,15 +2470,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.merge_src_part - numFiles 4 - numPartitions 2 - numRows 2000 partition_columns ds - rawDataSize 21248 serialization.ddl struct merge_src_part { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.merge_src_part @@ -2518,15 +2510,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.merge_src_part - numFiles 4 - numPartitions 2 - numRows 2000 partition_columns ds - rawDataSize 21248 serialization.ddl struct merge_src_part { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.merge_src_part @@ -4904,15 +4891,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.merge_src_part - numFiles 4 - numPartitions 2 - numRows 2000 partition_columns ds - rawDataSize 21248 serialization.ddl struct merge_src_part { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.merge_src_part @@ -4949,15 +4931,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.merge_src_part - numFiles 4 - numPartitions 2 - numRows 2000 partition_columns ds - rawDataSize 21248 serialization.ddl struct merge_src_part { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 23248 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.merge_src_part Modified: hive/branches/tez/ql/src/test/results/clientpositive/merge4.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/merge4.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/merge4.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/merge4.q.out Tue Nov 5 07:01:32 2013 @@ -2994,14 +2994,14 @@ POSTHOOK: Output: default@nzhang_part@ds POSTHOOK: Output: default@nzhang_part@ds=2010-08-15/hr=file, POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=file,).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=file,).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: show partitions nzhang_part @@ -3010,14 +3010,14 @@ POSTHOOK: query: show partitions nzhang_ POSTHOOK: type: SHOWPARTITIONS POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=file,).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=file,).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] ds=2010-08-15/hr=11 @@ -3035,14 +3035,14 @@ POSTHOOK: Input: default@nzhang_part@ds= #### A masked pattern was here #### POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=file,).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=file,).value EXPRESSION [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] 1 1 2010-08-15 file, Modified: hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out Tue Nov 5 07:01:32 2013 @@ -8,29 +8,29 @@ PREHOOK: type: CREATETABLE POSTHOOK: query: create table merge_dynamic_part like srcpart POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@merge_dynamic_part -PREHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp -POSTHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 PREHOOK: query: explain Modified: hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out Tue Nov 5 07:01:32 2013 @@ -8,42 +8,42 @@ PREHOOK: type: CREATETABLE POSTHOOK: query: create table merge_dynamic_part like srcpart POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@merge_dynamic_part -PREHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp -POSTHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket0.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +PREHOOK: query: load data local inpath '../../data/files/srcbucket0.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp -POSTHOOK: query: load data local inpath '../data/files/srcbucket0.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket0.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -PREHOOK: query: load data local inpath '../data/files/srcbucket1.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +PREHOOK: query: load data local inpath '../../data/files/srcbucket1.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -POSTHOOK: query: load data local inpath '../data/files/srcbucket1.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket1.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 PREHOOK: query: explain Modified: hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out Tue Nov 5 07:01:32 2013 @@ -8,80 +8,80 @@ PREHOOK: type: CREATETABLE POSTHOOK: query: create table merge_dynamic_part like srcpart POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@merge_dynamic_part -PREHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp -POSTHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +PREHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp -POSTHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -PREHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +PREHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -POSTHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -PREHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +PREHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -POSTHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -PREHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +PREHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -POSTHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -PREHOOK: query: load data local inpath '../data/files/kv1.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=11) +PREHOOK: query: load data local inpath '../../data/files/kv1.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp -POSTHOOK: query: load data local inpath '../data/files/kv1.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/kv1.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-09/hr=11 -PREHOOK: query: load data local inpath '../data/files/kv2.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=11) +PREHOOK: query: load data local inpath '../../data/files/kv2.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-09/hr=11 -POSTHOOK: query: load data local inpath '../data/files/kv2.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/kv2.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-09/hr=11 -PREHOOK: query: load data local inpath '../data/files/kv1.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=12) +PREHOOK: query: load data local inpath '../../data/files/kv1.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=12) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp -POSTHOOK: query: load data local inpath '../data/files/kv1.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=12) +POSTHOOK: query: load data local inpath '../../data/files/kv1.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=12) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-09/hr=12 -PREHOOK: query: load data local inpath '../data/files/kv2.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=12) +PREHOOK: query: load data local inpath '../../data/files/kv2.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=12) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-09/hr=12 -POSTHOOK: query: load data local inpath '../data/files/kv2.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=12) +POSTHOOK: query: load data local inpath '../../data/files/kv2.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-09', hr=12) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-09/hr=12 PREHOOK: query: show partitions srcpart_merge_dp Modified: hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out Tue Nov 5 07:01:32 2013 @@ -35,54 +35,54 @@ POSTHOOK: query: alter table merge_dynam POSTHOOK: type: ALTERTABLE_FILEFORMAT POSTHOOK: Input: default@merge_dynamic_part POSTHOOK: Output: default@merge_dynamic_part -PREHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp -POSTHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +PREHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp -POSTHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -PREHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +PREHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -POSTHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -PREHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +PREHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -POSTHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -PREHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +PREHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 -POSTHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 PREHOOK: query: insert overwrite table srcpart_merge_dp_rc partition (ds = '2008-04-08', hr) Modified: hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out Tue Nov 5 07:01:32 2013 @@ -33,35 +33,35 @@ POSTHOOK: query: alter table merge_dynam POSTHOOK: type: ALTERTABLE_FILEFORMAT POSTHOOK: Input: default@merge_dynamic_part POSTHOOK: Output: default@merge_dynamic_part -PREHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp -POSTHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +PREHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -POSTHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=11) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=11 -PREHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +PREHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) PREHOOK: type: LOAD PREHOOK: Output: default@srcpart_merge_dp -POSTHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) +POSTHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_merge_dp partition(ds='2008-04-08', hr=12) POSTHOOK: type: LOAD POSTHOOK: Output: default@srcpart_merge_dp POSTHOOK: Output: default@srcpart_merge_dp@ds=2008-04-08/hr=12 Modified: hive/branches/tez/ql/src/test/results/clientpositive/nested_complex.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/nested_complex.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/nested_complex.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/nested_complex.q.out Tue Nov 5 07:01:32 2013 @@ -45,10 +45,10 @@ max_nested_struct array> outputColumnNames: _col0, _col1, _col2, _col3 - Limit - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + File Output Operator + compressed: false + GlobalTableId: 0 + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator - limit: 1 + limit: -1 PREHOOK: query: SELECT ARRAY(NULL, 0), ARRAY(NULL, ARRAY()), ARRAY(NULL, MAP()), ARRAY(NULL, STRUCT(0)) -FROM src LIMIT 1 +FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### @@ -61,7 +61,7 @@ POSTHOOK: query: SELECT ARRAY(NULL, 0), ARRAY(NULL, ARRAY()), ARRAY(NULL, MAP()), ARRAY(NULL, STRUCT(0)) -FROM src LIMIT 1 +FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### Modified: hive/branches/tez/ql/src/test/results/clientpositive/null_column.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/null_column.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/null_column.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/null_column.q.out Tue Nov 5 07:01:32 2013 @@ -3,10 +3,10 @@ PREHOOK: type: CREATETABLE POSTHOOK: query: create table temp_null(a int) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@temp_null -PREHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table temp_null +PREHOOK: query: load data local inpath '../../data/files/test.dat' overwrite into table temp_null PREHOOK: type: LOAD PREHOOK: Output: default@temp_null -POSTHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table temp_null +POSTHOOK: query: load data local inpath '../../data/files/test.dat' overwrite into table temp_null POSTHOOK: type: LOAD POSTHOOK: Output: default@temp_null PREHOOK: query: select null, null from temp_null @@ -91,14 +91,14 @@ NULL NULL NULL NULL NULL NULL NULL NULL -PREHOOK: query: insert overwrite directory "../build/ql/test/data/warehouse/null_columns.out" select null, null from temp_null +PREHOOK: query: insert overwrite directory "target/warehouse/null_columns.out" select null, null from temp_null PREHOOK: type: QUERY PREHOOK: Input: default@temp_null -PREHOOK: Output: ../build/ql/test/data/warehouse/null_columns.out -POSTHOOK: query: insert overwrite directory "../build/ql/test/data/warehouse/null_columns.out" select null, null from temp_null +PREHOOK: Output: target/warehouse/null_columns.out +POSTHOOK: query: insert overwrite directory "target/warehouse/null_columns.out" select null, null from temp_null POSTHOOK: type: QUERY POSTHOOK: Input: default@temp_null -POSTHOOK: Output: ../build/ql/test/data/warehouse/null_columns.out +POSTHOOK: Output: target/warehouse/null_columns.out POSTHOOK: Lineage: tt.a EXPRESSION [] POSTHOOK: Lineage: tt.b SIMPLE [] POSTHOOK: Lineage: tt_b.a EXPRESSION [] Modified: hive/branches/tez/ql/src/test/results/clientpositive/nullgroup3.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/nullgroup3.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/nullgroup3.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/nullgroup3.q.out Tue Nov 5 07:01:32 2013 @@ -3,17 +3,17 @@ PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@tstparttbl -PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-09') +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-09') PREHOOK: type: LOAD PREHOOK: Output: default@tstparttbl -POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-09') +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-09') POSTHOOK: type: LOAD POSTHOOK: Output: default@tstparttbl POSTHOOK: Output: default@tstparttbl@ds=2008-04-09 -PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-08') +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/nullfile.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-08') PREHOOK: type: LOAD PREHOOK: Output: default@tstparttbl -POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-08') +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/nullfile.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-08') POSTHOOK: type: LOAD POSTHOOK: Output: default@tstparttbl POSTHOOK: Output: default@tstparttbl@ds=2008-04-08 @@ -93,17 +93,17 @@ PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@tstparttbl2 -PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-09') +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-09') PREHOOK: type: LOAD PREHOOK: Output: default@tstparttbl2 -POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-09') +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-09') POSTHOOK: type: LOAD POSTHOOK: Output: default@tstparttbl2 POSTHOOK: Output: default@tstparttbl2@ds=2008-04-09 -PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-08') +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-08') PREHOOK: type: LOAD PREHOOK: Output: default@tstparttbl2 -POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-08') +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-08') POSTHOOK: type: LOAD POSTHOOK: Output: default@tstparttbl2 POSTHOOK: Output: default@tstparttbl2@ds=2008-04-08 @@ -191,17 +191,17 @@ PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@tstparttbl -PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-09') +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-09') PREHOOK: type: LOAD PREHOOK: Output: default@tstparttbl -POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-09') +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-09') POSTHOOK: type: LOAD POSTHOOK: Output: default@tstparttbl POSTHOOK: Output: default@tstparttbl@ds=2008-04-09 -PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-08') +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/nullfile.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-08') PREHOOK: type: LOAD PREHOOK: Output: default@tstparttbl -POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-08') +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/nullfile.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-08') POSTHOOK: type: LOAD POSTHOOK: Output: default@tstparttbl POSTHOOK: Output: default@tstparttbl@ds=2008-04-08 @@ -289,17 +289,17 @@ PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@tstparttbl2 -PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-09') +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-09') PREHOOK: type: LOAD PREHOOK: Output: default@tstparttbl2 -POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-09') +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-09') POSTHOOK: type: LOAD POSTHOOK: Output: default@tstparttbl2 POSTHOOK: Output: default@tstparttbl2@ds=2008-04-09 -PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-08') +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-08') PREHOOK: type: LOAD PREHOOK: Output: default@tstparttbl2 -POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-08') +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-08') POSTHOOK: type: LOAD POSTHOOK: Output: default@tstparttbl2 POSTHOOK: Output: default@tstparttbl2@ds=2008-04-08 Modified: hive/branches/tez/ql/src/test/results/clientpositive/nullgroup5.q.out URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/nullgroup5.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff ============================================================================== --- hive/branches/tez/ql/src/test/results/clientpositive/nullgroup5.q.out (original) +++ hive/branches/tez/ql/src/test/results/clientpositive/nullgroup5.q.out Tue Nov 5 07:01:32 2013 @@ -3,10 +3,10 @@ PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@tstparttbl -PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2009-04-09') +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2009-04-09') PREHOOK: type: LOAD PREHOOK: Output: default@tstparttbl -POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2009-04-09') +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2009-04-09') POSTHOOK: type: LOAD POSTHOOK: Output: default@tstparttbl POSTHOOK: Output: default@tstparttbl@ds=2009-04-09 @@ -15,10 +15,10 @@ PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@tstparttbl2 -PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE tstparttbl2 PARTITION (ds='2009-04-09') +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE tstparttbl2 PARTITION (ds='2009-04-09') PREHOOK: type: LOAD PREHOOK: Output: default@tstparttbl2 -POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE tstparttbl2 PARTITION (ds='2009-04-09') +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE tstparttbl2 PARTITION (ds='2009-04-09') POSTHOOK: type: LOAD POSTHOOK: Output: default@tstparttbl2 POSTHOOK: Output: default@tstparttbl2@ds=2009-04-09