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 3623C671F for ; Wed, 13 Jul 2011 16:51:22 +0000 (UTC) Received: (qmail 35048 invoked by uid 500); 13 Jul 2011 16:51:22 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 34960 invoked by uid 500); 13 Jul 2011 16:51:22 -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 34940 invoked by uid 99); 13 Jul 2011 16:51:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Jul 2011 16:51:21 +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; Wed, 13 Jul 2011 16:50:56 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id 1DCD52388C0E for ; Wed, 13 Jul 2011 16:49:48 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1146129 [17/41] - in /hive/trunk: common/src/java/org/apache/hadoop/hive/conf/ contrib/src/test/results/clientpositive/ hbase-handler/src/test/results/ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/ql/ppd/ ... Date: Wed, 13 Jul 2011 16:49:42 -0000 To: commits@hive.apache.org From: jvs@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20110713164948.1DCD52388C0E@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Modified: hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out Wed Jul 13 16:49:22 2011 @@ -517,33 +517,29 @@ STAGE PLANS: predicate: expr: (key < '15') type: boolean - Filter Operator - predicate: - expr: (key < '15') - type: boolean - Select Operator - expressions: + Select Operator + expressions: + expr: key + type: int + outputColumnNames: key + Group By Operator + bucketGroup: false + keys: expr: key type: int - outputColumnNames: key - Group By Operator - bucketGroup: false - keys: - expr: key + expr: key + type: int + mode: hash + outputColumnNames: _col0, _col1 + Reduce Output Operator + key expressions: + expr: _col1 type: int - expr: key + sort order: + + Map-reduce partition columns: + expr: _col1 type: int - mode: hash - outputColumnNames: _col0, _col1 - Reduce Output Operator - key expressions: - expr: _col1 - type: int - sort order: + - Map-reduce partition columns: - expr: _col1 - type: int - tag: 1 + tag: 1 Reduce Operator Tree: Join Operator condition map: @@ -653,35 +649,31 @@ STAGE PLANS: predicate: expr: (value < 'val_10') type: boolean - Filter Operator - predicate: - expr: (value < 'val_10') - type: boolean - Select Operator - expressions: + Select Operator + expressions: + expr: key + type: int + expr: value + type: string + outputColumnNames: key, value + Group By Operator + bucketGroup: false + keys: expr: key type: int expr: value type: string - outputColumnNames: key, value - Group By Operator - bucketGroup: false - keys: - expr: key + mode: hash + outputColumnNames: _col0, _col1 + Reduce Output Operator + key expressions: + expr: _col0 type: int - expr: value - type: string - mode: hash - outputColumnNames: _col0, _col1 - Reduce Output Operator - key expressions: - expr: _col0 - type: int - sort order: + - Map-reduce partition columns: - expr: _col0 - type: int - tag: 1 + sort order: + + Map-reduce partition columns: + expr: _col0 + type: int + tag: 1 Reduce Operator Tree: Join Operator condition map: @@ -787,36 +779,32 @@ STAGE PLANS: predicate: expr: (key > 5) type: boolean - Filter Operator - predicate: - expr: (key > 5) - type: boolean + Select Operator + expressions: + expr: key + type: int + outputColumnNames: _col0 Select Operator expressions: - expr: key + expr: _col0 type: int outputColumnNames: _col0 - Select Operator - expressions: + Group By Operator + bucketGroup: false + keys: expr: _col0 type: int + mode: hash outputColumnNames: _col0 - Group By Operator - bucketGroup: false - keys: + Reduce Output Operator + key expressions: expr: _col0 type: int - mode: hash - outputColumnNames: _col0 - Reduce Output Operator - key expressions: - expr: _col0 - type: int - sort order: + - Map-reduce partition columns: - expr: _col0 - type: int - tag: 1 + sort order: + + Map-reduce partition columns: + expr: _col0 + type: int + tag: 1 Reduce Operator Tree: Join Operator condition map: @@ -916,46 +904,38 @@ STAGE PLANS: predicate: expr: ((key > 5) and (value <= 'val_20')) type: boolean - Filter Operator - predicate: - expr: (key > 5) - type: boolean + Select Operator + expressions: + expr: key + type: int + expr: value + type: string + outputColumnNames: _col0, _col1 Select Operator expressions: - expr: key + expr: _col0 type: int - expr: value + expr: _col1 type: string outputColumnNames: _col0, _col1 - Filter Operator - predicate: - expr: (_col1 <= 'val_20') - type: boolean - Select Operator - expressions: + Group By Operator + bucketGroup: false + keys: + expr: _col0 + type: int + expr: _col1 + type: string + mode: hash + outputColumnNames: _col0, _col1 + Reduce Output Operator + key expressions: expr: _col0 type: int - expr: _col1 - type: string - outputColumnNames: _col0, _col1 - Group By Operator - bucketGroup: false - keys: - expr: _col0 - type: int - expr: _col1 - type: string - mode: hash - outputColumnNames: _col0, _col1 - Reduce Output Operator - key expressions: - expr: _col0 - type: int - sort order: + - Map-reduce partition columns: - expr: _col0 - type: int - tag: 1 + sort order: + + Map-reduce partition columns: + expr: _col0 + type: int + tag: 1 Reduce Operator Tree: Join Operator condition map: @@ -1054,36 +1034,32 @@ STAGE PLANS: predicate: expr: (key > 2) type: boolean - Filter Operator - predicate: - expr: (key > 2) - type: boolean + Select Operator + expressions: + expr: key + type: int + outputColumnNames: _col0 Select Operator expressions: - expr: key + expr: _col0 type: int outputColumnNames: _col0 - Select Operator - expressions: + Group By Operator + bucketGroup: false + keys: expr: _col0 type: int + mode: hash outputColumnNames: _col0 - Group By Operator - bucketGroup: false - keys: + Reduce Output Operator + key expressions: + expr: _col0 + type: int + sort order: + + Map-reduce partition columns: expr: _col0 type: int - mode: hash - outputColumnNames: _col0 - Reduce Output Operator - key expressions: - expr: _col0 - type: int - sort order: + - Map-reduce partition columns: - expr: _col0 - type: int - tag: 1 + tag: 1 Reduce Operator Tree: Join Operator condition map: Modified: hive/trunk/ql/src/test/results/clientpositive/set_processor_namespaces.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/set_processor_namespaces.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/set_processor_namespaces.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/set_processor_namespaces.q.out Wed Jul 13 16:49:22 2011 @@ -25,23 +25,19 @@ STAGE PLANS: predicate: expr: (key = 5) type: boolean - Filter Operator - predicate: - expr: (key = 5) - type: boolean - Select Operator - expressions: - expr: key - type: string - expr: value - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + Select Operator + expressions: + expr: key + type: string + expr: value + type: string + outputColumnNames: _col0, _col1 + 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/skewjoin.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoin.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/skewjoin.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/skewjoin.q.out Wed Jul 13 16:49:22 2011 @@ -1198,22 +1198,18 @@ STAGE PLANS: expr: key type: string outputColumnNames: _col0 - Filter Operator - predicate: - expr: (_col0 < 100) - type: boolean - Reduce Output Operator - key expressions: - expr: _col0 - type: string - sort order: + - Map-reduce partition columns: - expr: _col0 - type: string - tag: 0 - value expressions: - expr: _col0 - type: string + Reduce Output Operator + key expressions: + expr: _col0 + type: string + sort order: + + Map-reduce partition columns: + expr: _col0 + type: string + tag: 0 + value expressions: + expr: _col0 + type: string src2:src TableScan alias: src @@ -1248,19 +1244,15 @@ STAGE PLANS: expr: key type: string outputColumnNames: _col0 - Filter Operator - predicate: - expr: (_col0 < 80) - type: boolean - Reduce Output Operator - key expressions: - expr: _col0 - type: string - sort order: + - Map-reduce partition columns: - expr: _col0 - type: string - tag: 2 + Reduce Output Operator + key expressions: + expr: _col0 + type: string + sort order: + + Map-reduce partition columns: + expr: _col0 + type: string + tag: 2 Reduce Operator Tree: Join Operator condition map: Modified: hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out Wed Jul 13 16:49:22 2011 @@ -88,27 +88,23 @@ STAGE PLANS: expr: _col7 type: string outputColumnNames: _col0, _col2, _col5, _col6, _col7 - Filter Operator - predicate: - expr: (((_col2 = '2010-10-15') and (_col7 = '2010-10-15')) and _col5 is not null) - type: boolean - Select Operator - expressions: - expr: _col5 - type: int - expr: _col6 - type: string - expr: _col7 - type: string - expr: _col0 - type: int - outputColumnNames: _col0, _col1, _col2, _col3 - File Output Operator - compressed: false - GlobalTableId: 1 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + Select Operator + expressions: + expr: _col5 + type: int + expr: _col6 + type: string + expr: _col7 + type: string + expr: _col0 + type: int + outputColumnNames: _col0, _col1, _col2, _col3 + File Output Operator + compressed: false + GlobalTableId: 1 + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Stage: Stage-0 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out Wed Jul 13 16:49:22 2011 @@ -2634,29 +2634,25 @@ STAGE PLANS: expr: _col5 type: string outputColumnNames: _col0, _col1, _col4, _col5 - Filter Operator - predicate: - expr: (_col0 > 1000) - type: boolean - Select Operator - expressions: - expr: _col0 - type: int - expr: _col1 - type: string - expr: _col4 - type: int - expr: _col5 - type: string - outputColumnNames: _col0, _col1, _col2, _col3 - 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.smb_join_results + Select Operator + expressions: + expr: _col0 + type: int + expr: _col1 + type: string + expr: _col4 + type: int + expr: _col5 + type: string + outputColumnNames: _col0, _col1, _col2, _col3 + 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.smb_join_results Stage: Stage-0 Move Operator @@ -2790,29 +2786,25 @@ STAGE PLANS: expr: _col5 type: string outputColumnNames: _col0, _col1, _col4, _col5 - Filter Operator - predicate: - expr: (_col0 > 1000) - type: boolean - Select Operator - expressions: - expr: _col0 - type: int - expr: _col1 - type: string - expr: _col4 - type: int - expr: _col5 - type: string - outputColumnNames: _col0, _col1, _col2, _col3 - 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.smb_join_results + Select Operator + expressions: + expr: _col0 + type: int + expr: _col1 + type: string + expr: _col4 + type: int + expr: _col5 + type: string + outputColumnNames: _col0, _col1, _col2, _col3 + 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.smb_join_results Stage: Stage-0 Move Operator @@ -2958,31 +2950,27 @@ STAGE PLANS: expr: _col9 type: string outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 - Filter Operator - predicate: - expr: (_col0 > 1000) - type: boolean - Select Operator - expressions: - expr: _col0 - type: int - expr: _col1 - type: string - expr: _col4 - type: int - expr: _col5 - type: string - expr: _col8 - type: int - expr: _col9 - type: string - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + Select Operator + expressions: + expr: _col0 + type: int + expr: _col1 + type: string + expr: _col4 + type: int + expr: _col5 + type: string + expr: _col8 + type: int + expr: _col9 + type: string + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 + 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/split_sample.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/split_sample.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/split_sample.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/split_sample.q.out Wed Jul 13 16:49:22 2011 @@ -4111,17 +4111,17 @@ STAGE PLANS: 1 {VALUE._col0} handleSkewJoin: false outputColumnNames: _col0, _col4 - Select Operator - expressions: - expr: _col0 - type: int - expr: _col4 - type: int - outputColumnNames: _col0, _col1 - Filter Operator - predicate: - expr: ((_col1) IN (199, 10199, 20199) or (_col0) IN (199, 10199, 20199)) - type: boolean + Filter Operator + predicate: + expr: ((_col4) IN (199, 10199, 20199) or (_col0) IN (199, 10199, 20199)) + type: boolean + Select Operator + expressions: + expr: _col0 + type: int + expr: _col4 + type: int + outputColumnNames: _col0, _col1 Select Operator expressions: expr: _col0 Modified: hive/trunk/ql/src/test/results/clientpositive/stats11.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats11.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/stats11.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/stats11.q.out Wed Jul 13 16:49:22 2011 @@ -162,46 +162,41 @@ STAGE PLANS: expr: _col6 type: string outputColumnNames: _col0, _col1, _col5, _col6 - Filter Operator - isSamplingPred: false - predicate: - expr: (_col6 = '2008-04-08') - type: boolean - Select Operator - expressions: - expr: _col0 - type: int - expr: _col1 - type: string - expr: _col5 - type: string - outputColumnNames: _col0, _col1, _col2 - File Output Operator - compressed: false - GlobalTableId: 1 - directory: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-41-18_163_6560883492277571896/-ext-10002 - NumFilesPerFileSink: 1 - Stats Publishing Key Prefix: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-41-18_163_6560883492277571896/-ext-10000/ - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - bucket_count -1 - columns key,value1,value2 - columns.types string:string:string - file.inputformat org.apache.hadoop.mapred.TextInputFormat - file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/bucketmapjoin_tmp_result - name default.bucketmapjoin_tmp_result - serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - transient_lastDdlTime 1306986078 - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.bucketmapjoin_tmp_result - TotalFiles: 1 - GatherStats: true - MultiFileSpray: false + Select Operator + expressions: + expr: _col0 + type: int + expr: _col1 + type: string + expr: _col5 + type: string + outputColumnNames: _col0, _col1, _col2 + File Output Operator + compressed: false + GlobalTableId: 1 + directory: pfile:/home/amarsri/workspace/hive/build/ql/scratchdir/hive_2011-07-11_03-10-59_585_1038860316679520823/-ext-10002 + NumFilesPerFileSink: 1 + Stats Publishing Key Prefix: pfile:/home/amarsri/workspace/hive/build/ql/scratchdir/hive_2011-07-11_03-10-59_585_1038860316679520823/-ext-10000/ + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + bucket_count -1 + columns key,value1,value2 + columns.types string:string:string + file.inputformat org.apache.hadoop.mapred.TextInputFormat + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/bucketmapjoin_tmp_result + name default.bucketmapjoin_tmp_result + serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + transient_lastDdlTime 1310379059 + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.bucketmapjoin_tmp_result + TotalFiles: 1 + GatherStats: true + MultiFileSpray: false Local Work: Map Reduce Local Work Needs Tagging: false @@ -593,51 +588,46 @@ STAGE PLANS: expr: _col6 type: string outputColumnNames: _col0, _col1, _col5, _col6 - Filter Operator - isSamplingPred: false - predicate: - expr: (_col6 = '2008-04-08') - type: boolean - Select Operator - expressions: - expr: _col0 - type: int - expr: _col1 - type: string - expr: _col5 - type: string - outputColumnNames: _col0, _col1, _col2 - File Output Operator - compressed: false - GlobalTableId: 1 - directory: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-41-49_304_6102645690321346948/-ext-10002 - NumFilesPerFileSink: 1 - Stats Publishing Key Prefix: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-41-49_304_6102645690321346948/-ext-10000/ - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - bucket_count -1 - columns key,value1,value2 - columns.types string:string:string - file.inputformat org.apache.hadoop.mapred.TextInputFormat - file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/bucketmapjoin_tmp_result - name default.bucketmapjoin_tmp_result - numFiles 1 - numPartitions 0 - numRows 464 - rawDataSize 8519 - serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 8983 - transient_lastDdlTime 1306986098 - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.bucketmapjoin_tmp_result - TotalFiles: 1 - GatherStats: true - MultiFileSpray: false + Select Operator + expressions: + expr: _col0 + type: int + expr: _col1 + type: string + expr: _col5 + type: string + outputColumnNames: _col0, _col1, _col2 + File Output Operator + compressed: false + GlobalTableId: 1 + directory: pfile:/home/amarsri/workspace/hive/build/ql/scratchdir/hive_2011-07-11_03-11-25_827_1887525539038984243/-ext-10002 + NumFilesPerFileSink: 1 + Stats Publishing Key Prefix: pfile:/home/amarsri/workspace/hive/build/ql/scratchdir/hive_2011-07-11_03-11-25_827_1887525539038984243/-ext-10000/ + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + bucket_count -1 + columns key,value1,value2 + columns.types string:string:string + file.inputformat org.apache.hadoop.mapred.TextInputFormat + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/bucketmapjoin_tmp_result + name default.bucketmapjoin_tmp_result + numFiles 1 + numPartitions 0 + numRows 464 + rawDataSize 8519 + serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 8983 + transient_lastDdlTime 1310379076 + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.bucketmapjoin_tmp_result + TotalFiles: 1 + GatherStats: true + MultiFileSpray: false Local Work: Map Reduce Local Work Needs Tagging: false Modified: hive/trunk/ql/src/test/results/clientpositive/stats2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats2.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/stats2.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/stats2.q.out Wed Jul 13 16:49:22 2011 @@ -23,29 +23,25 @@ STAGE PLANS: srcpart TableScan alias: srcpart - Filter Operator - predicate: - expr: ds is not null - type: boolean - Select Operator - expressions: - expr: key - type: string - expr: value - type: string - expr: ds - type: string - expr: hr - type: string - outputColumnNames: _col0, _col1, _col2, _col3 - 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.analyze_t1 + Select Operator + expressions: + expr: key + type: string + expr: value + type: string + expr: ds + type: string + expr: hr + type: string + outputColumnNames: _col0, _col1, _col2, _col3 + 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.analyze_t1 Stage: Stage-0 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/subq.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subq.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/subq.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/subq.q.out Wed Jul 13 16:49:22 2011 @@ -31,30 +31,26 @@ STAGE PLANS: predicate: expr: (key < 100) type: boolean - Filter Operator - predicate: - expr: (key < 100) - type: boolean + Select Operator + expressions: + expr: key + type: string + expr: value + type: string + outputColumnNames: _col0, _col1 Select Operator expressions: - expr: key + expr: _col0 type: string - expr: value + expr: _col1 type: string outputColumnNames: _col0, _col1 - Select Operator - expressions: - expr: _col0 - type: string - 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 + File Output Operator + compressed: false + GlobalTableId: 1 + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Stage: Stage-4 Conditional Operator Modified: hive/trunk/ql/src/test/results/clientpositive/subq2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subq2.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/subq2.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/subq2.q.out Wed Jul 13 16:49:22 2011 @@ -69,23 +69,19 @@ STAGE PLANS: expr: _col1 type: bigint outputColumnNames: _col0, _col1 - Filter Operator - predicate: - expr: (_col0 >= 90) - type: boolean - Select Operator - expressions: - expr: _col0 - type: string - expr: _col1 - type: bigint - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + Select Operator + expressions: + expr: _col0 + type: string + expr: _col1 + type: bigint + outputColumnNames: _col0, _col1 + 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/transform_ppr1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/transform_ppr1.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/transform_ppr1.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/transform_ppr1.q.out Wed Jul 13 16:49:22 2011 @@ -50,22 +50,27 @@ STAGE PLANS: columns.types string,string,string field.delim 9 serialization.format 9 - Reduce Output Operator - key expressions: - expr: _col1 - type: string - sort order: + - Map-reduce partition columns: - expr: _col1 - type: string - tag: -1 - value expressions: - expr: _col0 - type: string - expr: _col1 - type: string - expr: _col2 - type: string + Filter Operator + isSamplingPred: false + predicate: + expr: ((_col1 < 100) and (_col0 = '2008-04-08')) + type: boolean + Reduce Output Operator + key expressions: + expr: _col1 + type: string + sort order: + + Map-reduce partition columns: + expr: _col1 + type: string + tag: -1 + value expressions: + expr: _col0 + type: string + expr: _col1 + type: string + expr: _col2 + type: string Needs Tagging: false Path -> Alias: pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [tmap:src] @@ -239,34 +244,29 @@ STAGE PLANS: name: default.srcpart Reduce Operator Tree: Extract - Filter Operator - isSamplingPred: false - predicate: - expr: ((_col1 < 100) and (_col0 = '2008-04-08')) - type: boolean - Select Operator - expressions: - expr: _col1 - type: string - expr: _col2 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 0 - directory: file:/tmp/sdong/hive_2011-02-10_17-24-54_583_8987862490121410836/-ext-10001 - NumFilesPerFileSink: 1 - Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-24-54_583_8987862490121410836/-ext-10001/ - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - columns _col0,_col1 - columns.types string:string - serialization.format 1 - TotalFiles: 1 - GatherStats: false - MultiFileSpray: false + Select Operator + expressions: + expr: _col1 + type: string + expr: _col2 + type: string + outputColumnNames: _col0, _col1 + File Output Operator + compressed: false + GlobalTableId: 0 + directory: file:/tmp/amarsri/hive_2011-03-19_01-46-48_559_8291501891794719709/-ext-10001 + NumFilesPerFileSink: 1 + Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-03-19_01-46-48_559_8291501891794719709/-ext-10001/ + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + columns _col0,_col1 + columns.types string:string + serialization.format 1 + TotalFiles: 1 + GatherStats: false + MultiFileSpray: false Stage: Stage-0 Fetch Operator Modified: hive/trunk/ql/src/test/results/clientpositive/transform_ppr2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/transform_ppr2.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/transform_ppr2.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/transform_ppr2.q.out Wed Jul 13 16:49:22 2011 @@ -33,30 +33,30 @@ STAGE PLANS: TableScan alias: src GatherStats: false - Filter Operator - isSamplingPred: false - predicate: - expr: (ds = '2008-04-08') - type: boolean - Select Operator - expressions: - expr: ds - type: string - expr: key - type: string - expr: value - type: string - outputColumnNames: _col0, _col1, _col2 - Transform Operator - command: /bin/cat - output info: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - columns _col0,_col1,_col2 - columns.types string,string,string - field.delim 9 - serialization.format 9 + Select Operator + expressions: + expr: ds + type: string + expr: key + type: string + expr: value + type: string + outputColumnNames: _col0, _col1, _col2 + Transform Operator + command: /bin/cat + output info: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + columns _col0,_col1,_col2 + columns.types string,string,string + field.delim 9 + serialization.format 9 + Filter Operator + isSamplingPred: false + predicate: + expr: (_col1 < 100) + type: boolean Reduce Output Operator key expressions: expr: _col1 @@ -162,34 +162,29 @@ STAGE PLANS: name: default.srcpart Reduce Operator Tree: Extract - Filter Operator - isSamplingPred: false - predicate: - expr: (_col1 < 100) - type: boolean - Select Operator - expressions: - expr: _col1 - type: string - expr: _col2 - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 0 - directory: file:/tmp/sdong/hive_2011-02-10_17-24-59_315_262991000601799738/-ext-10001 - NumFilesPerFileSink: 1 - Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-24-59_315_262991000601799738/-ext-10001/ - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - columns _col0,_col1 - columns.types string:string - serialization.format 1 - TotalFiles: 1 - GatherStats: false - MultiFileSpray: false + Select Operator + expressions: + expr: _col1 + type: string + expr: _col2 + type: string + outputColumnNames: _col0, _col1 + File Output Operator + compressed: false + GlobalTableId: 0 + directory: file:/tmp/amarsri/hive_2011-03-19_01-46-51_820_4418676794321891468/-ext-10001 + NumFilesPerFileSink: 1 + Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-03-19_01-46-51_820_4418676794321891468/-ext-10001/ + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + columns _col0,_col1 + columns.types string:string + serialization.format 1 + TotalFiles: 1 + GatherStats: false + MultiFileSpray: false Stage: Stage-0 Fetch Operator Modified: hive/trunk/ql/src/test/results/clientpositive/udf1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf1.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/udf1.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/udf1.q.out Wed Jul 13 16:49:22 2011 @@ -51,61 +51,57 @@ STAGE PLANS: predicate: expr: (key = 86) type: boolean - Filter Operator - predicate: - expr: (key = 86) - type: boolean - Select Operator - expressions: - expr: ('a' like '%a%') - type: boolean - expr: ('b' like '%a%') - type: boolean - expr: ('ab' like '%a%') - type: boolean - expr: ('ab' like '%a_') - type: boolean - expr: ('%_' like '\%\_') - type: boolean - expr: ('ab' like '\%\_') - type: boolean - expr: ('ab' like '_a%') - type: boolean - expr: ('ab' like 'a') - type: boolean - expr: ('' rlike '.*') - type: boolean - expr: ('a' rlike '[ab]') - type: boolean - expr: ('' rlike '[ab]') - type: boolean - expr: ('hadoop' rlike '[a-z]*') - type: boolean - expr: ('hadoop' rlike 'o*') - type: boolean - expr: regexp_replace('abc', 'b', 'c') - type: string - expr: regexp_replace('abc', 'z', 'a') - type: string - expr: regexp_replace('abbbb', 'bb', 'b') - type: string - expr: regexp_replace('hadoop', '(.)[a-z]*', '$1ive') - type: string - expr: regexp_replace('hadoopAAA', 'A.*', '') - type: string - expr: regexp_replace('abc', '', 'A') - type: string - expr: ('abc' rlike '') - type: boolean - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19 - 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 + Select Operator + expressions: + expr: ('a' like '%a%') + type: boolean + expr: ('b' like '%a%') + type: boolean + expr: ('ab' like '%a%') + type: boolean + expr: ('ab' like '%a_') + type: boolean + expr: ('%_' like '\%\_') + type: boolean + expr: ('ab' like '\%\_') + type: boolean + expr: ('ab' like '_a%') + type: boolean + expr: ('ab' like 'a') + type: boolean + expr: ('' rlike '.*') + type: boolean + expr: ('a' rlike '[ab]') + type: boolean + expr: ('' rlike '[ab]') + type: boolean + expr: ('hadoop' rlike '[a-z]*') + type: boolean + expr: ('hadoop' rlike 'o*') + type: boolean + expr: regexp_replace('abc', 'b', 'c') + type: string + expr: regexp_replace('abc', 'z', 'a') + type: string + expr: regexp_replace('abbbb', 'bb', 'b') + type: string + expr: regexp_replace('hadoop', '(.)[a-z]*', '$1ive') + type: string + expr: regexp_replace('hadoopAAA', 'A.*', '') + type: string + expr: regexp_replace('abc', '', 'A') + type: string + expr: ('abc' rlike '') + type: boolean + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19 + 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-5 Conditional Operator Modified: hive/trunk/ql/src/test/results/clientpositive/udf9.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf9.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/udf9.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/udf9.q.out Wed Jul 13 16:49:22 2011 @@ -38,51 +38,47 @@ STAGE PLANS: predicate: expr: (key = 86) type: boolean - Filter Operator - predicate: - expr: (key = 86) - type: boolean - Select Operator - expressions: - expr: datediff('2008-12-31', '2009-01-01') - type: int - expr: datediff('2008-03-01', '2008-02-28') - type: int - expr: datediff('2007-03-01', '2007-01-28') - type: int - expr: datediff('2008-03-01 23:59:59', '2008-03-02 00:00:00') - type: int - expr: date_add('2008-12-31', 1) - type: string - expr: date_add('2008-12-31', 365) - type: string - expr: date_add('2008-02-28', 2) - type: string - expr: date_add('2009-02-28', 2) - type: string - expr: date_add('2007-02-28', 365) - type: string - expr: date_add('2007-02-28 23:59:59', 730) - type: string - expr: date_sub('2009-01-01', 1) - type: string - expr: date_sub('2009-01-01', 365) - type: string - expr: date_sub('2008-02-28', 2) - type: string - expr: date_sub('2009-02-28', 2) - type: string - expr: date_sub('2007-02-28', 365) - type: string - expr: date_sub('2007-02-28 01:12:34', 730) - type: string - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + Select Operator + expressions: + expr: datediff('2008-12-31', '2009-01-01') + type: int + expr: datediff('2008-03-01', '2008-02-28') + type: int + expr: datediff('2007-03-01', '2007-01-28') + type: int + expr: datediff('2008-03-01 23:59:59', '2008-03-02 00:00:00') + type: int + expr: date_add('2008-12-31', 1) + type: string + expr: date_add('2008-12-31', 365) + type: string + expr: date_add('2008-02-28', 2) + type: string + expr: date_add('2009-02-28', 2) + type: string + expr: date_add('2007-02-28', 365) + type: string + expr: date_add('2007-02-28 23:59:59', 730) + type: string + expr: date_sub('2009-01-01', 1) + type: string + expr: date_sub('2009-01-01', 365) + type: string + expr: date_sub('2008-02-28', 2) + type: string + expr: date_sub('2009-02-28', 2) + type: string + expr: date_sub('2007-02-28', 365) + type: string + expr: date_sub('2007-02-28 01:12:34', 730) + type: string + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15 + 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/udf_10_trims.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_10_trims.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/udf_10_trims.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/udf_10_trims.q.out Wed Jul 13 16:49:22 2011 @@ -37,23 +37,19 @@ STAGE PLANS: predicate: expr: (key = 86) type: boolean - Filter Operator - predicate: - expr: (key = 86) - type: boolean - Select Operator - expressions: - expr: trim(trim(trim(trim(trim(trim(trim(trim(trim(trim(' abc ')))))))))) - type: string - 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.dest1 + Select Operator + expressions: + expr: trim(trim(trim(trim(trim(trim(trim(trim(trim(trim(' abc ')))))))))) + type: string + 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.dest1 Stage: Stage-5 Conditional Operator Modified: hive/trunk/ql/src/test/results/clientpositive/udf_hour.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_hour.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/udf_hour.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/udf_hour.q.out Wed Jul 13 16:49:22 2011 @@ -40,25 +40,21 @@ STAGE PLANS: predicate: expr: (key = 86) type: boolean - Filter Operator - predicate: - expr: (key = 86) - type: boolean - Select Operator - expressions: - expr: hour('2009-08-07 13:14:15') - type: int - expr: hour('13:14:15') - type: int - expr: hour('2009-08-07') - type: int - outputColumnNames: _col0, _col1, _col2 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + Select Operator + expressions: + expr: hour('2009-08-07 13:14:15') + type: int + expr: hour('13:14:15') + type: int + expr: hour('2009-08-07') + type: int + outputColumnNames: _col0, _col1, _col2 + 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/udf_isnull_isnotnull.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out Wed Jul 13 16:49:22 2011 @@ -50,26 +50,22 @@ STAGE PLANS: predicate: expr: true is not null type: boolean - Filter Operator - predicate: - expr: true is not null - type: boolean - Select Operator - expressions: - expr: null is null - type: boolean - expr: 1 is not null - type: boolean - expr: 'my string' is not null - type: boolean - outputColumnNames: _col0, _col1, _col2 - 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 + Select Operator + expressions: + expr: null is null + type: boolean + expr: 1 is not null + type: boolean + expr: 'my string' is not null + type: boolean + outputColumnNames: _col0, _col1, _col2 + 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 Stage: Stage-0 Fetch Operator @@ -127,26 +123,22 @@ STAGE PLANS: predicate: expr: (lint is not null and (not mstringstring is null)) type: boolean - Filter Operator - predicate: - expr: (lint is not null and (not mstringstring is null)) - type: boolean - Select Operator - expressions: - expr: lint is not null - type: boolean - expr: lintstring is not null - type: boolean - expr: mstringstring is not null - type: boolean - outputColumnNames: _col0, _col1, _col2 - 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 + Select Operator + expressions: + expr: lint is not null + type: boolean + expr: lintstring is not null + type: boolean + expr: mstringstring is not null + type: boolean + outputColumnNames: _col0, _col1, _col2 + 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 Stage: Stage-0 Fetch Operator Modified: hive/trunk/ql/src/test/results/clientpositive/udf_like.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_like.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/udf_like.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/udf_like.q.out Wed Jul 13 16:49:22 2011 @@ -41,43 +41,39 @@ STAGE PLANS: predicate: expr: (key = 86) type: boolean - Filter Operator - predicate: - expr: (key = 86) - type: boolean - Select Operator - expressions: - expr: ('_%_' like '%\_\%\_%') - type: boolean - expr: ('__' like '%\_\%\_%') - type: boolean - expr: ('%%_%_' like '%\_\%\_%') - type: boolean - expr: ('%_%_%' like '%\%\_\%') - type: boolean - expr: ('_%_' like '\%\_%') - type: boolean - expr: ('%__' like '__\%%') - type: boolean - expr: ('_%' like '\_\%\_\%%') - type: boolean - expr: ('_%' like '\_\%_%') - type: boolean - expr: ('%_' like '\%\_') - type: boolean - expr: ('ab' like '\%\_') - type: boolean - expr: ('ab' like '_a%') - type: boolean - expr: ('ab' like 'a') - type: boolean - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + Select Operator + expressions: + expr: ('_%_' like '%\_\%\_%') + type: boolean + expr: ('__' like '%\_\%\_%') + type: boolean + expr: ('%%_%_' like '%\_\%\_%') + type: boolean + expr: ('%_%_%' like '%\%\_\%') + type: boolean + expr: ('_%_' like '\%\_%') + type: boolean + expr: ('%__' like '__\%%') + type: boolean + expr: ('_%' like '\_\%\_\%%') + type: boolean + expr: ('_%' like '\_\%_%') + type: boolean + expr: ('%_' like '\%\_') + type: boolean + expr: ('ab' like '\%\_') + type: boolean + expr: ('ab' like '_a%') + type: boolean + expr: ('ab' like 'a') + type: boolean + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11 + 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/udf_lower.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_lower.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/udf_lower.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/udf_lower.q.out Wed Jul 13 16:49:22 2011 @@ -36,23 +36,19 @@ STAGE PLANS: predicate: expr: (key = 86) type: boolean - Filter Operator - predicate: - expr: (key = 86) - type: boolean - Select Operator - expressions: - expr: lower('AbC 123') - type: string - expr: upper('AbC 123') - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + Select Operator + expressions: + expr: lower('AbC 123') + type: string + expr: upper('AbC 123') + type: string + outputColumnNames: _col0, _col1 + 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/udf_minute.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_minute.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/udf_minute.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/udf_minute.q.out Wed Jul 13 16:49:22 2011 @@ -40,25 +40,21 @@ STAGE PLANS: predicate: expr: (key = 86) type: boolean - Filter Operator - predicate: - expr: (key = 86) - type: boolean - Select Operator - expressions: - expr: minute('2009-08-07 13:14:15') - type: int - expr: minute('13:14:15') - type: int - expr: minute('2009-08-07') - type: int - outputColumnNames: _col0, _col1, _col2 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + Select Operator + expressions: + expr: minute('2009-08-07 13:14:15') + type: int + expr: minute('13:14:15') + type: int + expr: minute('2009-08-07') + type: int + outputColumnNames: _col0, _col1, _col2 + 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/udf_notequal.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_notequal.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/udf_notequal.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/udf_notequal.q.out Wed Jul 13 16:49:22 2011 @@ -48,23 +48,19 @@ STAGE PLANS: predicate: expr: (key <> '302') type: boolean - Filter Operator - predicate: - expr: (key <> '302') - type: boolean - Select Operator - expressions: - expr: key - type: string - expr: value - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + Select Operator + expressions: + expr: key + type: string + expr: value + type: string + outputColumnNames: _col0, _col1 + 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 @@ -610,23 +606,19 @@ STAGE PLANS: predicate: expr: (key <> '302') type: boolean - Filter Operator - predicate: - expr: (key <> '302') - type: boolean - Select Operator - expressions: - expr: key - type: string - expr: value - type: string - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + Select Operator + expressions: + expr: key + type: string + expr: value + type: string + outputColumnNames: _col0, _col1 + 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/udf_parse_url.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_parse_url.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/udf_parse_url.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/udf_parse_url.q.out Wed Jul 13 16:49:22 2011 @@ -63,41 +63,37 @@ STAGE PLANS: predicate: expr: (key = 86) type: boolean - Filter Operator - predicate: - expr: (key = 86) - type: boolean - Select Operator - expressions: - expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'HOST') - type: string - expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'PATH') - type: string - expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'QUERY') - type: string - expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'REF') - type: string - expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'QUERY', 'k2') - type: string - expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'QUERY', 'k1') - type: string - expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'QUERY', 'k3') - type: string - expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'FILE') - type: string - expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'PROTOCOL') - type: string - expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'USERINFO') - type: string - expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'AUTHORITY') - type: string - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 - File Output Operator - compressed: false - GlobalTableId: 0 - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + Select Operator + expressions: + expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'HOST') + type: string + expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'PATH') + type: string + expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'QUERY') + type: string + expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'REF') + type: string + expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'QUERY', 'k2') + type: string + expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'QUERY', 'k1') + type: string + expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'QUERY', 'k3') + type: string + expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'FILE') + type: string + expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'PROTOCOL') + type: string + expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'USERINFO') + type: string + expr: parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'AUTHORITY') + type: string + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 + 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