Return-Path: Delivered-To: apmail-hadoop-hive-commits-archive@minotaur.apache.org Received: (qmail 68668 invoked from network); 13 Jul 2009 22:47:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 13 Jul 2009 22:47:19 -0000 Received: (qmail 48026 invoked by uid 500); 13 Jul 2009 22:47:29 -0000 Delivered-To: apmail-hadoop-hive-commits-archive@hadoop.apache.org Received: (qmail 47990 invoked by uid 500); 13 Jul 2009 22:47:28 -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 47967 invoked by uid 99); 13 Jul 2009 22:47:28 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Jul 2009 22:47:28 +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; Mon, 13 Jul 2009 22:47:21 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id 2DBE62388905; Mon, 13 Jul 2009 22:47:00 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r793738 [4/12] - in /hadoop/hive/trunk: ./ ql/src/java/org/apache/hadoop/hive/ql/ ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/apache/hadoop/hive/ql/parse/ ql/src/java/org/apache/hadoop/hive/ql/plan/ ql/src/test/results/... Date: Mon, 13 Jul 2009 22:46:58 -0000 To: hive-commits@hadoop.apache.org From: zshao@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20090713224700.2DBE62388905@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=793738&r1=793737&r2=793738&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 Mon Jul 13 22:46:57 2009 @@ -8,7 +8,7 @@ - + Stage-1 @@ -22,7 +22,7 @@ - + @@ -30,7 +30,7 @@ true - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/10000 + file:/data/users/njain/hive3/hive3/build/ql/tmp/1877897368/10000 @@ -83,7 +83,7 @@ location - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/test/data/warehouse/dest1 + file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1 @@ -93,7 +93,7 @@ - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/10001 + file:/data/users/njain/hive3/hive3/build/ql/tmp/1877897368/10001 @@ -107,7 +107,7 @@ Stage-8 - + @@ -121,10 +121,10 @@ true - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10007 + file:/data/users/njain/hive3/hive3/build/ql/tmp/1177730582/10007 - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/10000 + file:/data/users/njain/hive3/hive3/build/ql/tmp/1877897368/10000 @@ -142,7 +142,7 @@ - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10007 + file:/data/users/njain/hive3/hive3/build/ql/tmp/1177730582/10007 @@ -338,10 +338,10 @@ - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10007 + file:/data/users/njain/hive3/hive3/build/ql/tmp/1177730582/10007 - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10007 + file:/data/users/njain/hive3/hive3/build/ql/tmp/1177730582/10007 @@ -350,7 +350,7 @@ - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10007 + file:/data/users/njain/hive3/hive3/build/ql/tmp/1177730582/10007 @@ -368,7 +368,7 @@ - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/10000 + file:/data/users/njain/hive3/hive3/build/ql/tmp/1877897368/10000 @@ -456,287 +456,412 @@ - - - - - - - - - - - - - - - - - - - - - - - - Stage-2 - - - - - - - - - - - - - - - - - true - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/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/zshao/tools/553-trunk-apache-hive/build/ql/test/data/warehouse/dest2 - - - - - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/10003 - - + + + + + + + + file:///data/users/njain/hive3/hive3/build/ql/test/test-udfs.jar - - - - - - Stage-11 - - - - - - - Stage-10 - - - - - - - true - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10008 - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/10002 - - - - + + src - - - - - - Stage-9 + + - - - - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10008 - + + + + + + - - - - - - - - - - org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe - - - org.apache.hadoop.mapred.SequenceFileInputFormat - - - org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - - - - - columns - + + + + + + + + + 1 - - serialization.sort.order - + + file:/data/users/njain/hive3/hive3/build/ql/tmp/1177730582/10007 - - columns.types - + + + + + + + + + + + + - - -1 + + + + + + _col1 + + + value + + + + + - - + + _col0 + + + key + + + + + - + + + + + - _col0 + - _col1 + - + - - - org.apache.hadoop.hive.ql.udf.UDFRand - - - - evaluate - - - - - - - - - - + _col0 + + + _col1 - - -1 + + true - - + + + + + + + + + + + + + - - - key + + + _col0 - + - - - value + + + _col1 - + - - - - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - - org.apache.hadoop.mapred.SequenceFileInputFormat + + + + + + + + + + + + org.apache.hadoop.hive.ql.udf.UDFOPLessThan + + + + evaluate + + + org.apache.hadoop.hive.serde2.io.DoubleWritable + + + org.apache.hadoop.hive.serde2.io.DoubleWritable + + + + + + + + + + org.apache.hadoop.hive.ql.udf.UDFToDouble - - org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + + + evaluate + + + org.apache.hadoop.io.Text + + + - - - - columns - _col0,_col1 + + + + + + key + + + + + - - columns.types - string,string + + + + + + + + + + + org.apache.hadoop.hive.ql.udf.UDFToDouble + + + + evaluate + + + org.apache.hadoop.io.IntWritable + + + + + + + + + + + + int + + + + + 100 + + + + + + + + + + + + + + + + boolean + + + + + + + + + + + + + + + + + + + + + + key + + + + + + + + + + value + + + + + + + + + + + + + + + + + + + + + + + + + + 2 + + + file:/data/users/njain/hive3/hive3/build/ql/tmp/1177730582/10008 + + + + + 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/hive3/hive3/build/ql/test/data/warehouse/dest2 + + + + + org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + + + + + + + + + + + + + + + + + + + key + + + + + + + + + + value + + + + + + + @@ -744,21 +869,71 @@ + + + + _col1 + + + value + + + + + + + + _col0 + + + key + + + + + + + + + + + + + + + + + + + + + + + + _col0 + + + _col1 + + + + + - + - + - key + _col0 @@ -768,7 +943,7 @@ - value + _col1 @@ -783,1277 +958,22 @@ - - - - - - - - - - - - -1 - - - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10008 - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10008 - - - - - - - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10008 - - - - - - - - - - - - - - - - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/10002 - - - - - - - - - - - - - - - - - - - - - - - - - - VALUE - - - - - - - - - - - - - - - - 0 - - - - - - - - - - 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Stage-3 - - - - - - - - - - - - - - - - ds - 2008-04-08 - - - hr - 12 - - - - - true - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/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/zshao/tools/553-trunk-apache-hive/build/ql/test/data/warehouse/dest3 - - - - - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/10005 - - - - - - - - - - - Stage-14 - - - - - - - Stage-13 - - - - - - - true - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10009 - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/10004 - - - - - - - - - - - Stage-12 - - - - - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10009 - - - - - - - - - - - - - - org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe - - - org.apache.hadoop.mapred.SequenceFileInputFormat - - - org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - - - - - columns - - - - serialization.sort.order - - - - columns.types - - - - - - - - -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/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10009 - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10009 - - - - - - - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10009 - - - - - - - - - - - - - - - - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/10004 - - - - - - - - - - - - - - - - - - - - - - - - - - VALUE - - - - - - - - - - - - - - - - 0 - - - - - - - - - - 1 - - - - - int - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Stage-4 - - - - - - - - - - - - - - string - - - src.value - - - true - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/10006 - - - ../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out - - - - - - - - - - - Stage-17 - - - - - - - Stage-16 - - - - - - - true - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10010 - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/10006 - - - - - - - - - - - Stage-15 - - - - - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10010 - - - - - - - - - - - - - - org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe - - - org.apache.hadoop.mapred.SequenceFileInputFormat - - - org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - - - - - columns - - - - serialization.sort.order - - - - columns.types - - - - - - - - -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 - - - - - - - - - - - - - - - - - - - - - - - - - - -1 - - - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10010 - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/10010 - - - - - - - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/437661166/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 - - - columns.types - string - - - - - - - - - - - - - - - - - - - file:/data/users/zshao/tools/553-trunk-apache-hive/build/ql/tmp/960279256/10006 - - - - - - - - - - - - - - - - - - - - - - - - - - VALUE - - - - - - - - - - - - - - - - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Stage-5 - - - - - - src - - - - - - - - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - [... 3419 lines stripped ...]