Return-Path: Delivered-To: apmail-hadoop-hive-commits-archive@minotaur.apache.org Received: (qmail 43885 invoked from network); 23 Jun 2009 04:36:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 23 Jun 2009 04:36:03 -0000 Received: (qmail 62690 invoked by uid 500); 23 Jun 2009 04:36:14 -0000 Delivered-To: apmail-hadoop-hive-commits-archive@hadoop.apache.org Received: (qmail 62659 invoked by uid 500); 23 Jun 2009 04:36:14 -0000 Mailing-List: contact hive-commits-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hadoop.apache.org Delivered-To: mailing list hive-commits@hadoop.apache.org Received: (qmail 62588 invoked by uid 99); 23 Jun 2009 04:36:14 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Jun 2009 04:36:14 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.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, 23 Jun 2009 04:36:07 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id 93BBD23889B8; Tue, 23 Jun 2009 04:35:19 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r787539 [11/20] - in /hadoop/hive/trunk: ./ common/src/java/org/apache/hadoop/hive/conf/ conf/ ql/src/java/org/apache/hadoop/hive/ql/ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/o... Date: Tue, 23 Jun 2009 04:35:07 -0000 To: hive-commits@hadoop.apache.org From: zshao@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20090623043519.93BBD23889B8@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Modified: hadoop/hive/trunk/ql/src/test/results/compiler/plan/input3.q.xml URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/compiler/plan/input3.q.xml?rev=787539&r1=787538&r2=787539&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/compiler/plan/input3.q.xml (original) +++ hadoop/hive/trunk/ql/src/test/results/compiler/plan/input3.q.xml Tue Jun 23 04:35:01 2009 @@ -1,12 +1,1401 @@ - + - + + + + + + + Stage-1 + + + + + + + + + + + + + + + + + true + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10000 + + + + + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + org.apache.hadoop.mapred.TextInputFormat + + + org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + + + + + name + dest1 + + + columns.types + string:string + + + serialization.ddl + struct dest1 { string key, string value} + + + serialization.format + 1 + + + columns + key,value + + + bucket_count + -1 + + + serialization.lib + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + file.inputformat + org.apache.hadoop.mapred.TextInputFormat + + + file.outputformat + org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + + + location + file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1 + + + + + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10001 + + + + + + + + + + + Stage-8 + + + + + + + Stage-7 + + + + + + + true + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10007 + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10000 + + + + + + + + + + + Stage-6 + + + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10007 + + + + + + + + + + + + + + org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe + + + org.apache.hadoop.mapred.SequenceFileInputFormat + + + org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + + + + + name + binary_sortable_table + + + serialization.sort.order + + + + serialization.ddl + struct binary_sortable_table { } + + + serialization.format + org.apache.hadoop.hive.serde2.thrift.TBinarySortableProtocol + + + + + + + -1 + + + + + + + + _col0 + + + _col1 + + + + + + + + + org.apache.hadoop.hive.ql.udf.UDFRand + + + + evaluate + + + + + + + + + + double + + + + + + + + + -1 + + + + + + + key + + + + + string + + + + + + + + + value + + + + + + + + + + + + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + org.apache.hadoop.mapred.SequenceFileInputFormat + + + org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + + + + + columns + _col0,_col1 + + + columns.types + string,string + + + + + + + + + + + + + + + + + + + + + + key + + + + + + + + + + value + + + + + + + + + + + + + + + + + + + + + + + + + + -1 + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10007 + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10007 + + + + + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10007 + + + + + + + + + + + + + + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10000 + + + + + + + + + + + + + + + + + + + + + + + + + + VALUE + + + + + + + + + + + + + + + + 0 + + + + + + + + + + 1 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Stage-2 + + + + + + + + + + + + + + + + + true + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10002 + + + + + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + org.apache.hadoop.mapred.TextInputFormat + + + org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + + + + + name + dest2 + + + columns.types + string:string + + + serialization.ddl + struct dest2 { string key, string value} + + + serialization.format + 1 + + + columns + key,value + + + bucket_count + -1 + + + serialization.lib + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + file.inputformat + org.apache.hadoop.mapred.TextInputFormat + + + file.outputformat + org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + + + location + file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest2 + + + + + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10003 + + + + + + + + + + + Stage-11 + + + + + + + Stage-10 + + + + + + + true + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10008 + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10002 + + + + + + + + + + + Stage-9 + + + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10008 + + + + + + + + + + + + + + org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe + + + org.apache.hadoop.mapred.SequenceFileInputFormat + + + org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + + + + + name + binary_sortable_table + + + serialization.sort.order + + + + serialization.ddl + struct binary_sortable_table { } + + + serialization.format + org.apache.hadoop.hive.serde2.thrift.TBinarySortableProtocol + + + + + + + -1 + + + + + + + + _col0 + + + _col1 + + + + + + + + + org.apache.hadoop.hive.ql.udf.UDFRand + + + + evaluate + + + + + + + + + + + + + + + -1 + + + + + + + key + + + + + + + + + + value + + + + + + + + + + + + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + org.apache.hadoop.mapred.SequenceFileInputFormat + + + org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + + + + + columns + _col0,_col1 + + + columns.types + string,string + + + + + + + + + + + + + + + + + + + + + + key + + + + + + + + + + value + + + + + + + + + + + + + + + + + + + + + + + + + + -1 + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10008 + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10008 + + + + + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10008 + + + + + + + + + + + + + + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10002 + + + + + + + + + + + + + + + + + + + + + + + + + + VALUE + + + + + + + + + + + + + + + + 0 + + + + + + + + + + 1 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Stage-3 + + + + + + + + + + + + + + + + ds + 2008-04-08 + + + hr + 12 + + + + + true + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10004 + + + + + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + org.apache.hadoop.mapred.TextInputFormat + + + org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + + + + + name + dest3 + + + columns.types + string:string + + + serialization.ddl + struct dest3 { string key, string value} + + + serialization.format + 1 + + + columns + key,value + + + partition_columns + ds/hr + + + bucket_count + -1 + + + serialization.lib + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + file.inputformat + org.apache.hadoop.mapred.TextInputFormat + + + file.outputformat + org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + + + location + file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest3 + + + + + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10005 + + + + + + + + + - Stage-1 + Stage-14 + + + + + + + Stage-13 + + + + + + + true + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10009 + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10004 + + + + + + + + + + + Stage-12 + + + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10009 + + + + + + + + + + + + + + org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe + + + org.apache.hadoop.mapred.SequenceFileInputFormat + + + org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + + + + + name + binary_sortable_table + + + serialization.sort.order + + + + serialization.ddl + struct binary_sortable_table { } + + + serialization.format + org.apache.hadoop.hive.serde2.thrift.TBinarySortableProtocol + + + + + + + -1 + + + + + + + + _col0 + + + _col1 + + + + + + + + + org.apache.hadoop.hive.ql.udf.UDFRand + + + + evaluate + + + + + + + + + + + + + + + -1 + + + + + + + key + + + + + + + + + + value + + + + + + + + + + + + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + org.apache.hadoop.mapred.SequenceFileInputFormat + + + org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + + + + + columns + _col0,_col1 + + + columns.types + string,string + + + + + + + + + + + + + + + + + + + + + + key + + + + + + + + + + value + + + + + + + + + + + + + + + + + + + + + + + + + + -1 + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10009 + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10009 + + + + + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10009 + + + + + + + + + + + + + + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10004 + + + + + + + + + + + + + + + + + + + + + + + + + + VALUE + + + + + + + + + + + + + + + + 0 + + + + + + + + + + 1 + + + + + int + + + + + + + + + + + + + + + + + + + + + + + @@ -15,268 +1404,386 @@ + + + - - + + - - - src.value - - - true - - - file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1724502019/10006 - - - ../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out - - + + + + - - - - - - - - - true - - - file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1724502019/10000 + + + + + + + + + + + + Stage-4 + + + + + - - - - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - - org.apache.hadoop.mapred.TextInputFormat + + + + + + + + src.value - - org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + + true - - - - name - dest1 - - - columns.types - string:string - - - serialization.ddl - struct dest1 { string key, string value} - - - serialization.format - 1 - - - columns - key,value - - - bucket_count - -1 - - - serialization.lib - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - - file.inputformat - org.apache.hadoop.mapred.TextInputFormat - - - file.outputformat - org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - - - location - file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1 - - + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10006 - - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + ../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out - - file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1724502019/10001 - - - - - - - - true - - - file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1724502019/10002 - - - - - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - - org.apache.hadoop.mapred.TextInputFormat - - - org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + + + + + + Stage-17 + + + + + + + Stage-16 + + + + + + + true - - - - name - dest2 - - - columns.types - string:string - - - serialization.ddl - struct dest2 { string key, string value} - - - serialization.format - 1 - - - columns - key,value - - - bucket_count - -1 - - - serialization.lib - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - - file.inputformat - org.apache.hadoop.mapred.TextInputFormat - - - file.outputformat - org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - - - location - file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest2 - - + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10010 - - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + file:/data/users/njain/hive4/hive4/build/ql/tmp/680808962/10006 - - file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1724502019/10003 - - - - + + + + + + Stage-15 + + + + - ds - 2008-04-08 - - - hr - 12 + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10010 + + + + + + + + + + + + + + org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe + + + org.apache.hadoop.mapred.SequenceFileInputFormat + + + org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + + + + + name + binary_sortable_table + + + serialization.sort.order + + + + serialization.ddl + struct binary_sortable_table { } + + + serialization.format + org.apache.hadoop.hive.serde2.thrift.TBinarySortableProtocol + + + + + + + -1 + + + + + + + + _col0 + + + + + + + + + org.apache.hadoop.hive.ql.udf.UDFRand + + + + evaluate + + + + + + + + + + + + + + + -1 + + + + + + + src.value + + + + + + + + + + + + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + org.apache.hadoop.mapred.SequenceFileInputFormat + + + org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + + + + + columns + _col0 + + + columns.types + string + + + + + + + + + + + + + + + + + + + + + + src.value + + + + + + + + + + + + + + + + + + - - true + + - - file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1724502019/10004 + + -1 - - - - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - - org.apache.hadoop.mapred.TextInputFormat - - - org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - - - - - name - dest3 - - - columns.types - string:string - - - serialization.ddl - struct dest3 { string key, string value} - - - serialization.format - 1 - - - columns - key,value - - - partition_columns - ds/hr - - - bucket_count - -1 - - - serialization.lib - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10010 + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10010 - - file.inputformat - org.apache.hadoop.mapred.TextInputFormat + + + + + + + + file:/data/users/njain/hive4/hive4/build/ql/tmp/965360746/10010 + + + + + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + org.apache.hadoop.mapred.TextInputFormat + + + org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + + + + + columns + src.value + + + serialization.format + 1 + + + + - - file.outputformat - org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + + + + + [... 785 lines stripped ...]