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 B1B85E3BF for ; Tue, 26 Feb 2013 00:28:44 +0000 (UTC) Received: (qmail 53287 invoked by uid 500); 26 Feb 2013 00:28:44 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 53250 invoked by uid 500); 26 Feb 2013 00:28:44 -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 53139 invoked by uid 99); 26 Feb 2013 00:28:44 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 26 Feb 2013 00:28:44 +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, 26 Feb 2013 00:28:40 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id 3EDC02388BBD; Tue, 26 Feb 2013 00:27:51 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1449981 [10/19] - in /hive/trunk: contrib/src/test/results/clientpositive/ hbase-handler/src/test/results/positive/ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/apache/hadoop/... Date: Tue, 26 Feb 2013 00:27:37 -0000 To: commits@hive.apache.org From: hashutosh@apache.org X-Mailer: svnmailer-1.0.8-patched Message-Id: <20130226002751.3EDC02388BBD@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out Tue Feb 26 00:27:32 2013 @@ -185,44 +185,28 @@ STAGE PLANS: type: string expr: _offset type: bigint - expr: _bitmaps - type: array - outputColumnNames: _col1, _col2, _col3 - Select Operator - expressions: - expr: _col1 + outputColumnNames: _col0, _col1 + Group By Operator + aggregations: + expr: collect_set(_col1) + bucketGroup: false + keys: + expr: _col0 type: string - expr: _col2 - type: bigint + mode: hash outputColumnNames: _col0, _col1 - Select Operator - expressions: + Reduce Output Operator + key expressions: expr: _col0 type: string + sort order: + + Map-reduce partition columns: + expr: _col0 + type: string + tag: -1 + value expressions: expr: _col1 - type: bigint - outputColumnNames: _col0, _col1 - Group By Operator - aggregations: - expr: collect_set(_col1) - bucketGroup: false - keys: - expr: _col0 - type: string - mode: hash - outputColumnNames: _col0, _col1 - Reduce Output Operator - key expressions: - expr: _col0 - type: string - sort order: + - Map-reduce partition columns: - expr: _col0 - type: string - tag: -1 - value expressions: - expr: _col1 - type: array + type: array Reduce Operator Tree: Group By Operator aggregations: @@ -366,44 +350,28 @@ STAGE PLANS: type: string expr: _offset type: bigint - expr: _bitmaps - type: array - outputColumnNames: _col1, _col2, _col3 - Select Operator - expressions: - expr: _col1 + outputColumnNames: _col0, _col1 + Group By Operator + aggregations: + expr: collect_set(_col1) + bucketGroup: false + keys: + expr: _col0 type: string - expr: _col2 - type: bigint + mode: hash outputColumnNames: _col0, _col1 - Select Operator - expressions: + Reduce Output Operator + key expressions: + expr: _col0 + type: string + sort order: + + Map-reduce partition columns: expr: _col0 type: string + tag: -1 + value expressions: expr: _col1 - type: bigint - outputColumnNames: _col0, _col1 - Group By Operator - aggregations: - expr: collect_set(_col1) - bucketGroup: false - keys: - expr: _col0 - type: string - mode: hash - outputColumnNames: _col0, _col1 - Reduce Output Operator - key expressions: - expr: _col0 - type: string - sort order: + - Map-reduce partition columns: - expr: _col0 - type: string - tag: -1 - value expressions: - expr: _col1 - type: array + type: array Reduce Operator Tree: Group By Operator aggregations: Modified: hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out Tue Feb 26 00:27:32 2013 @@ -68,44 +68,28 @@ STAGE PLANS: type: string expr: _offset type: bigint - expr: _bitmaps - type: array - outputColumnNames: _col1, _col2, _col3 - Select Operator - expressions: - expr: _col1 + outputColumnNames: _col0, _col1 + Group By Operator + aggregations: + expr: collect_set(_col1) + bucketGroup: false + keys: + expr: _col0 type: string - expr: _col2 - type: bigint + mode: hash outputColumnNames: _col0, _col1 - Select Operator - expressions: + Reduce Output Operator + key expressions: + expr: _col0 + type: string + sort order: + + Map-reduce partition columns: expr: _col0 type: string + tag: -1 + value expressions: expr: _col1 - type: bigint - outputColumnNames: _col0, _col1 - Group By Operator - aggregations: - expr: collect_set(_col1) - bucketGroup: false - keys: - expr: _col0 - type: string - mode: hash - outputColumnNames: _col0, _col1 - Reduce Output Operator - key expressions: - expr: _col0 - type: string - sort order: + - Map-reduce partition columns: - expr: _col0 - type: string - tag: -1 - value expressions: - expr: _col1 - type: array + type: array Reduce Operator Tree: Group By Operator aggregations: Modified: hive/trunk/ql/src/test/results/clientpositive/index_bitmap_compression.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_bitmap_compression.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/index_bitmap_compression.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/index_bitmap_compression.q.out Tue Feb 26 00:27:32 2013 @@ -54,44 +54,28 @@ STAGE PLANS: type: string expr: _offset type: bigint - expr: _bitmaps - type: array - outputColumnNames: _col1, _col2, _col3 - Select Operator - expressions: - expr: _col1 + outputColumnNames: _col0, _col1 + Group By Operator + aggregations: + expr: collect_set(_col1) + bucketGroup: false + keys: + expr: _col0 type: string - expr: _col2 - type: bigint + mode: hash outputColumnNames: _col0, _col1 - Select Operator - expressions: + Reduce Output Operator + key expressions: + expr: _col0 + type: string + sort order: + + Map-reduce partition columns: expr: _col0 type: string + tag: -1 + value expressions: expr: _col1 - type: bigint - outputColumnNames: _col0, _col1 - Group By Operator - aggregations: - expr: collect_set(_col1) - bucketGroup: false - keys: - expr: _col0 - type: string - mode: hash - outputColumnNames: _col0, _col1 - Reduce Output Operator - key expressions: - expr: _col0 - type: string - sort order: + - Map-reduce partition columns: - expr: _col0 - type: string - tag: -1 - value expressions: - expr: _col1 - type: array + type: array Reduce Operator Tree: Group By Operator aggregations: Modified: hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out Tue Feb 26 00:27:32 2013 @@ -673,35 +673,19 @@ STAGE PLANS: expressions: expr: _col0 type: string - expr: _col1 - type: bigint - outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: _col0 - type: string - expr: _col1 - type: bigint - expr: if(((_col0 % 100) = 0), '11', '12') - type: string - outputColumnNames: _col0, _col1, _col2 - Select Operator - expressions: - expr: _col0 - type: string - expr: UDFToString(_col1) - type: string - expr: _col2 - type: string - outputColumnNames: _col0, _col1, _col2 - File Output Operator - compressed: false - GlobalTableId: 1 - table: - input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat - output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat - serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe - name: default.test_table + expr: UDFToString(_col1) + type: string + expr: if(((_col0 % 100) = 0), '11', '12') + type: string + outputColumnNames: _col0, _col1, _col2 + File Output Operator + compressed: false + GlobalTableId: 1 + table: + input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat + output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat + serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe + name: default.test_table Stage: Stage-7 Conditional Operator Modified: hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out Tue Feb 26 00:27:32 2013 @@ -492,22 +492,15 @@ STAGE PLANS: type: string expr: _col5 type: string - outputColumnNames: _col0, _col5 - Select Operator - expressions: - expr: _col0 - type: string - expr: _col5 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.test_table_out + outputColumnNames: _col0, _col1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.test_table_out Stage: Stage-7 Conditional Operator @@ -688,32 +681,27 @@ STAGE PLANS: expr: _col5 type: string outputColumnNames: _col5 - Select Operator - expressions: + Group By Operator + aggregations: + expr: count() + bucketGroup: false + keys: expr: _col5 type: string - outputColumnNames: _col5 - Group By Operator - aggregations: - expr: count() - bucketGroup: false - keys: - expr: _col5 + mode: hash + outputColumnNames: _col0, _col1 + Reduce Output Operator + key expressions: + expr: _col0 + type: string + sort order: + + Map-reduce partition columns: + expr: _col0 type: string - mode: hash - outputColumnNames: _col0, _col1 - Reduce Output Operator - key expressions: - expr: _col0 - type: string - sort order: + - Map-reduce partition columns: - expr: _col0 - type: string - tag: -1 - value expressions: - expr: _col1 - type: bigint + tag: -1 + value expressions: + expr: _col1 + type: bigint Reduce Operator Tree: Group By Operator aggregations: Modified: hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out Tue Feb 26 00:27:32 2013 @@ -66,31 +66,22 @@ STAGE PLANS: type: int expr: value type: string - expr: (key % 2) - type: double + expr: UDFToInteger((key % 2)) + type: int outputColumnNames: _col0, _col1, _col2 - Select Operator - expressions: + Reduce Output Operator + sort order: + Map-reduce partition columns: + expr: _col0 + type: int + tag: -1 + value expressions: expr: _col0 type: int expr: _col1 type: string - expr: UDFToInteger(_col2) + expr: _col2 type: int - outputColumnNames: _col0, _col1, _col2 - Reduce Output Operator - sort order: - Map-reduce partition columns: - expr: _col0 - type: int - tag: -1 - value expressions: - expr: _col0 - type: int - expr: _col1 - type: string - expr: _col2 - type: int Reduce Operator Tree: Extract File Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input11.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input11.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input11.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input11.q.out Tue Feb 26 00:27:32 2013 @@ -37,26 +37,19 @@ STAGE PLANS: type: boolean Select Operator expressions: - expr: key - type: string + expr: UDFToInteger(key) + type: int expr: value type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Stage: Stage-7 Conditional Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input12_hadoop20.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input12_hadoop20.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input12_hadoop20.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input12_hadoop20.q.out Tue Feb 26 00:27:32 2013 @@ -69,74 +69,55 @@ STAGE PLANS: type: boolean Select Operator expressions: - expr: key - type: string + expr: UDFToInteger(key) + type: int expr: value type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Filter Operator predicate: expr: ((key >= 100.0) and (key < 200.0)) type: boolean Select Operator expressions: - expr: key - type: string + expr: UDFToInteger(key) + type: int expr: value type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 2 - 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.dest2 + File Output Operator + compressed: false + GlobalTableId: 2 + 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.dest2 Filter Operator predicate: expr: (key >= 200.0) type: boolean Select Operator expressions: - expr: key - type: string + expr: UDFToInteger(key) + type: int outputColumnNames: _col0 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - outputColumnNames: _col0 - File Output Operator - compressed: false - GlobalTableId: 3 - 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.dest3 + File Output Operator + compressed: false + GlobalTableId: 3 + 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.dest3 Stage: Stage-9 Conditional Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input13.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input13.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input13.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input13.q.out Tue Feb 26 00:27:32 2013 @@ -73,74 +73,55 @@ STAGE PLANS: type: boolean Select Operator expressions: - expr: key - type: string + expr: UDFToInteger(key) + type: int expr: value type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Filter Operator predicate: expr: ((key >= 100.0) and (key < 200.0)) type: boolean Select Operator expressions: - expr: key - type: string + expr: UDFToInteger(key) + type: int expr: value type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 2 - 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.dest2 + File Output Operator + compressed: false + GlobalTableId: 2 + 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.dest2 Filter Operator predicate: expr: ((key >= 200.0) and (key < 300.0)) type: boolean Select Operator expressions: - expr: key - type: string + expr: UDFToInteger(key) + type: int outputColumnNames: _col0 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - outputColumnNames: _col0 - File Output Operator - compressed: false - GlobalTableId: 3 - 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.dest3 + File Output Operator + compressed: false + GlobalTableId: 3 + 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.dest3 Filter Operator predicate: expr: (key >= 300.0) Modified: hive/trunk/ql/src/test/results/clientpositive/input14.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input14.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input14.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input14.q.out Tue Feb 26 00:27:32 2013 @@ -70,26 +70,19 @@ STAGE PLANS: Extract Select Operator expressions: - expr: _col0 - type: string + expr: UDFToInteger(_col0) + type: int expr: _col1 type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Stage: Stage-0 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out Tue Feb 26 00:27:32 2013 @@ -100,26 +100,19 @@ STAGE PLANS: type: boolean Select Operator expressions: - expr: _col0 - type: string + expr: UDFToInteger(_col0) + type: int expr: _col1 type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Stage: Stage-0 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input17.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input17.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input17.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input17.q.out Tue Feb 26 00:27:32 2013 @@ -66,26 +66,19 @@ STAGE PLANS: Extract Select Operator expressions: - expr: _col0 - type: string + expr: UDFToInteger(_col0) + type: int expr: _col1 type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Stage: Stage-0 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input18.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input18.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input18.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input18.q.out Tue Feb 26 00:27:32 2013 @@ -74,26 +74,19 @@ STAGE PLANS: Extract Select Operator expressions: - expr: _col0 - type: string + expr: UDFToInteger(_col0) + type: int expr: regexp_replace(_col1, ' ', '+') type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Stage: Stage-0 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input22.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input22.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input22.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input22.q.out Tue Feb 26 00:27:32 2013 @@ -39,21 +39,16 @@ STAGE PLANS: expressions: expr: key type: string - outputColumnNames: _col2 - Select Operator - expressions: - expr: _col2 + outputColumnNames: _col0 + Reduce Output Operator + key expressions: + expr: _col0 + type: string + sort order: + + tag: -1 + value expressions: + expr: _col0 type: string - outputColumnNames: _col0 - Reduce Output Operator - key expressions: - expr: _col0 - type: string - sort order: + - tag: -1 - value expressions: - expr: _col0 - type: string Reduce Operator Tree: Extract Limit Modified: hive/trunk/ql/src/test/results/clientpositive/input30.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input30.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input30.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input30.q.out Tue Feb 26 00:27:32 2013 @@ -57,22 +57,17 @@ STAGE PLANS: outputColumnNames: _col0 Select Operator expressions: - expr: _col0 - type: bigint + expr: UDFToInteger(_col0) + type: int outputColumnNames: _col0 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - outputColumnNames: _col0 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.tst_dest30 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.tst_dest30 Stage: Stage-0 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input31.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input31.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input31.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input31.q.out Tue Feb 26 00:27:32 2013 @@ -57,22 +57,17 @@ STAGE PLANS: outputColumnNames: _col0 Select Operator expressions: - expr: _col0 - type: bigint + expr: UDFToInteger(_col0) + type: int outputColumnNames: _col0 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - outputColumnNames: _col0 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.tst_dest31 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.tst_dest31 Stage: Stage-0 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input32.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input32.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input32.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input32.q.out Tue Feb 26 00:27:32 2013 @@ -53,22 +53,17 @@ STAGE PLANS: outputColumnNames: _col0 Select Operator expressions: - expr: _col0 - type: bigint + expr: UDFToInteger(_col0) + type: int outputColumnNames: _col0 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - outputColumnNames: _col0 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.tst_dest32 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.tst_dest32 Stage: Stage-0 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input34.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input34.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input34.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input34.q.out Tue Feb 26 00:27:32 2013 @@ -55,26 +55,19 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Select Operator expressions: - expr: _col0 - type: string + expr: UDFToInteger(_col0) + type: int expr: _col1 type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Stage: Stage-7 Conditional Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input35.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input35.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input35.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input35.q.out Tue Feb 26 00:27:32 2013 @@ -55,26 +55,19 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Select Operator expressions: - expr: _col0 - type: string + expr: UDFToInteger(_col0) + type: int expr: _col1 type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Stage: Stage-7 Conditional Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input36.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input36.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input36.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input36.q.out Tue Feb 26 00:27:32 2013 @@ -55,26 +55,19 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Select Operator expressions: - expr: _col0 - type: string + expr: UDFToInteger(_col0) + type: int expr: _col1 type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Stage: Stage-7 Conditional Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input7.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input7.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input7.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input7.q.out Tue Feb 26 00:27:32 2013 @@ -33,26 +33,19 @@ STAGE PLANS: alias: src1 Select Operator expressions: - expr: null - type: string - expr: key - type: string + expr: UDFToDouble(null) + type: double + expr: UDFToInteger(key) + type: int outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToDouble(_col0) - type: double - expr: UDFToInteger(_col1) - type: int - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Stage: Stage-7 Conditional Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input8.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input8.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input8.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input8.q.out Tue Feb 26 00:27:32 2013 @@ -35,28 +35,19 @@ STAGE PLANS: expressions: expr: (4 + null) type: int - expr: (key - null) + expr: UDFToInteger((key - null)) + type: int + expr: UDFToDouble((null + null)) type: double - expr: (null + null) - type: tinyint outputColumnNames: _col0, _col1, _col2 - Select Operator - expressions: - expr: _col0 - type: int - expr: UDFToInteger(_col1) - type: int - expr: UDFToDouble(_col2) - type: double - outputColumnNames: _col0, _col1, _col2 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Stage: Stage-7 Conditional Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input9.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input9.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input9.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input9.q.out Tue Feb 26 00:27:32 2013 @@ -39,24 +39,17 @@ STAGE PLANS: expressions: expr: null type: string - expr: key - type: string + expr: UDFToInteger(key) + type: int outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: _col0 - type: void - expr: UDFToInteger(_col1) - type: int - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Stage: Stage-7 Conditional Operator Modified: hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out Tue Feb 26 00:27:32 2013 @@ -39,8 +39,8 @@ STAGE PLANS: type: boolean Select Operator expressions: - expr: key - type: string + expr: UDFToInteger(key) + type: int expr: value type: string expr: hr @@ -48,41 +48,30 @@ STAGE PLANS: expr: ds type: string outputColumnNames: _col0, _col1, _col2, _col3 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - expr: _col2 - type: string - expr: _col3 - type: string - outputColumnNames: _col0, _col1, _col2, _col3 - File Output Operator - compressed: false - GlobalTableId: 1 -#### 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: - bucket_count -1 - columns key,value,hr,ds - columns.types int:string:string:string -#### A masked pattern was here #### - name default.dest1 - serialization.ddl struct dest1 { i32 key, string value, string hr, string ds} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.dest1 - TotalFiles: 1 - GatherStats: true - MultiFileSpray: false + File Output Operator + compressed: false + GlobalTableId: 1 +#### 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: + bucket_count -1 + columns key,value,hr,ds + columns.types int:string:string:string +#### A masked pattern was here #### + name default.dest1 + serialization.ddl struct dest1 { i32 key, string value, string hr, string ds} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.dest1 + TotalFiles: 1 + GatherStats: true + MultiFileSpray: false Needs Tagging: false Path -> Alias: #### A masked pattern was here #### Modified: hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out Tue Feb 26 00:27:32 2013 @@ -53,8 +53,8 @@ STAGE PLANS: type: boolean Select Operator expressions: - expr: key - type: string + expr: UDFToInteger(key) + type: int expr: value type: string expr: hr @@ -62,41 +62,30 @@ STAGE PLANS: expr: ds type: string outputColumnNames: _col0, _col1, _col2, _col3 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - expr: _col2 - type: string - expr: _col3 - type: string - outputColumnNames: _col0, _col1, _col2, _col3 - File Output Operator - compressed: false - GlobalTableId: 1 -#### 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: - bucket_count -1 - columns key,value,hr,ds - columns.types int:string:string:string -#### A masked pattern was here #### - name default.dest1 - serialization.ddl struct dest1 { i32 key, string value, string hr, string ds} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.dest1 - TotalFiles: 1 - GatherStats: true - MultiFileSpray: false + File Output Operator + compressed: false + GlobalTableId: 1 +#### 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: + bucket_count -1 + columns key,value,hr,ds + columns.types int:string:string:string +#### A masked pattern was here #### + name default.dest1 + serialization.ddl struct dest1 { i32 key, string value, string hr, string ds} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.dest1 + TotalFiles: 1 + GatherStats: true + MultiFileSpray: false Filter Operator isSamplingPred: false predicate: @@ -104,8 +93,8 @@ STAGE PLANS: type: boolean Select Operator expressions: - expr: key - type: string + expr: UDFToInteger(key) + type: int expr: value type: string expr: hr @@ -113,41 +102,30 @@ STAGE PLANS: expr: ds type: string outputColumnNames: _col0, _col1, _col2, _col3 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - expr: _col2 - type: string - expr: _col3 - type: string - outputColumnNames: _col0, _col1, _col2, _col3 - File Output Operator - compressed: false - GlobalTableId: 2 -#### 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: - bucket_count -1 - columns key,value,hr,ds - columns.types int:string:string:string -#### A masked pattern was here #### - name default.dest2 - serialization.ddl struct dest2 { i32 key, string value, string hr, string ds} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.dest2 - TotalFiles: 1 - GatherStats: true - MultiFileSpray: false + File Output Operator + compressed: false + GlobalTableId: 2 +#### 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: + bucket_count -1 + columns key,value,hr,ds + columns.types int:string:string:string +#### A masked pattern was here #### + name default.dest2 + serialization.ddl struct dest2 { i32 key, string value, string hr, string ds} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.dest2 + TotalFiles: 1 + GatherStats: true + MultiFileSpray: false Needs Tagging: false Path -> Alias: #### A masked pattern was here #### Modified: hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out Tue Feb 26 00:27:32 2013 @@ -33,26 +33,19 @@ STAGE PLANS: alias: src Select Operator expressions: - expr: key - type: string + expr: UDFToInteger(key) + type: int expr: value type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.dest4_sequencefile + File Output Operator + compressed: false + GlobalTableId: 1 + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.dest4_sequencefile Stage: Stage-7 Conditional Operator Modified: hive/trunk/ql/src/test/results/clientpositive/join1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join1.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join1.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join1.q.out Tue Feb 26 00:27:32 2013 @@ -64,26 +64,19 @@ STAGE PLANS: outputColumnNames: _col0, _col5 Select Operator expressions: - expr: _col0 - type: string + expr: UDFToInteger(_col0) + type: int expr: _col5 type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest_j1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest_j1 Stage: Stage-0 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/join12.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join12.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join12.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join12.q.out Tue Feb 26 00:27:32 2013 @@ -36,7 +36,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: ((key < 100.0) and (key < 80.0)) + expr: ((key < 80.0) and (key < 100.0)) type: boolean Select Operator expressions: @@ -86,7 +86,7 @@ STAGE PLANS: alias: src Filter Operator predicate: - expr: ((key < 80.0) and (key < 100.0)) + expr: ((key < 100.0) and (key < 80.0)) type: boolean Select Operator expressions: Modified: hive/trunk/ql/src/test/results/clientpositive/join14_hadoop20.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join14_hadoop20.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join14_hadoop20.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join14_hadoop20.q.out Tue Feb 26 00:27:32 2013 @@ -76,26 +76,19 @@ STAGE PLANS: outputColumnNames: _col0, _col5 Select Operator expressions: - expr: _col0 - type: string + expr: UDFToInteger(_col0) + type: int expr: _col5 type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest1 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest1 Stage: Stage-0 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/join17.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join17.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join17.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join17.q.out Tue Feb 26 00:27:32 2013 @@ -116,50 +116,39 @@ STAGE PLANS: outputColumnNames: _col0, _col1, _col4, _col5 Select Operator expressions: - expr: _col0 - type: string + expr: UDFToInteger(_col0) + type: int expr: _col1 type: string - expr: _col4 - type: string + expr: UDFToInteger(_col4) + type: int expr: _col5 type: string outputColumnNames: _col0, _col1, _col2, _col3 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - expr: UDFToInteger(_col2) - type: int - expr: _col3 - type: string - outputColumnNames: _col0, _col1, _col2, _col3 - File Output Operator - compressed: false - GlobalTableId: 1 + File Output Operator + compressed: false + GlobalTableId: 1 #### A masked pattern was here #### - NumFilesPerFileSink: 1 + 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: - bucket_count -1 - columns key1,value1,key2,value2 - columns.types int:string:int:string + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + bucket_count -1 + columns key1,value1,key2,value2 + columns.types int:string:int:string #### A masked pattern was here #### - name default.dest1 - serialization.ddl struct dest1 { i32 key1, string value1, i32 key2, string value2} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name default.dest1 + serialization.ddl struct dest1 { i32 key1, string value1, i32 key2, string value2} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe #### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.dest1 - TotalFiles: 1 - GatherStats: true - MultiFileSpray: false + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.dest1 + TotalFiles: 1 + GatherStats: true + MultiFileSpray: false Truncated Path -> Alias: /src [src2, src1] Modified: hive/trunk/ql/src/test/results/clientpositive/join2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join2.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join2.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join2.q.out Tue Feb 26 00:27:32 2013 @@ -112,26 +112,19 @@ STAGE PLANS: outputColumnNames: _col4, _col9 Select Operator expressions: - expr: _col4 - type: string + expr: UDFToInteger(_col4) + type: int expr: _col9 type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest_j2 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest_j2 Stage: Stage-0 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/join20.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join20.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join20.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join20.q.out Tue Feb 26 00:27:32 2013 @@ -744,7 +744,7 @@ STAGE PLANS: alias: src1 Filter Operator predicate: - expr: ((key < 10.0) and (key < 15.0)) + expr: ((key < 15.0) and (key < 10.0)) type: boolean Reduce Output Operator key expressions: @@ -765,7 +765,7 @@ STAGE PLANS: alias: src2 Filter Operator predicate: - expr: ((key < 15.0) and (key < 10.0)) + expr: ((key < 10.0) and (key < 15.0)) type: boolean Reduce Output Operator key expressions: Modified: hive/trunk/ql/src/test/results/clientpositive/join22.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join22.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join22.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join22.q.out Tue Feb 26 00:27:32 2013 @@ -109,18 +109,13 @@ STAGE PLANS: expressions: expr: _col7 type: string - outputColumnNames: _col3 - Select Operator - expressions: - expr: _col3 - type: string - outputColumnNames: _col0 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + outputColumnNames: _col0 + File Output Operator + compressed: false + GlobalTableId: 0 + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Stage: Stage-0 Fetch Operator Modified: hive/trunk/ql/src/test/results/clientpositive/join25.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join25.q.out?rev=1449981&r1=1449980&r2=1449981&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join25.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join25.q.out Tue Feb 26 00:27:32 2013 @@ -68,39 +68,21 @@ STAGE PLANS: Position of Big Table: 1 Select Operator expressions: - expr: _col0 - type: string + expr: UDFToInteger(_col0) + type: int expr: _col1 type: string expr: _col5 type: string - outputColumnNames: _col0, _col1, _col5 - Select Operator - expressions: - expr: _col0 - type: string - expr: _col1 - type: string - expr: _col5 - type: string - outputColumnNames: _col0, _col1, _col2 - Select Operator - expressions: - expr: UDFToInteger(_col0) - type: int - expr: _col1 - type: string - expr: _col2 - type: string - outputColumnNames: _col0, _col1, _col2 - File Output Operator - compressed: false - GlobalTableId: 1 - 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.dest_j1 + outputColumnNames: _col0, _col1, _col2 + File Output Operator + compressed: false + GlobalTableId: 1 + 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.dest_j1 Local Work: Map Reduce Local Work