Return-Path: Delivered-To: apmail-hadoop-hive-commits-archive@minotaur.apache.org Received: (qmail 99029 invoked from network); 11 Aug 2009 02:07:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 11 Aug 2009 02:07:16 -0000 Received: (qmail 72624 invoked by uid 500); 11 Aug 2009 02:07:23 -0000 Delivered-To: apmail-hadoop-hive-commits-archive@hadoop.apache.org Received: (qmail 72588 invoked by uid 500); 11 Aug 2009 02:07:23 -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 72578 invoked by uid 99); 11 Aug 2009 02:07:23 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Aug 2009 02:07:22 +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, 11 Aug 2009 02:07:10 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id 4C37B2388997; Tue, 11 Aug 2009 02:06:49 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r802976 [4/17] - in /hadoop/hive/trunk: ./ common/src/java/org/apache/hadoop/hive/conf/ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/ql/lib/ ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/... Date: Tue, 11 Aug 2009 02:06:32 -0000 To: hive-commits@hadoop.apache.org From: namit@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20090811020649.4C37B2388997@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out Tue Aug 11 02:06:23 2009 @@ -23,6 +23,8 @@ Map Reduce Alias -> Map Operator Tree: tmap:src + TableScan + alias: src Select Operator expressions: expr: key @@ -107,7 +109,7 @@ Output: default/dest1 query: SELECT * FROM dest1 SORT BY key, value Input: default/dest1 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/895109430/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/660141896/10000 1 105_105 1 10_10 1 111_111 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out Tue Aug 11 02:06:23 2009 @@ -14,6 +14,8 @@ Map Reduce Alias -> Map Operator Tree: src_null + TableScan + alias: src_null Select Operator expressions: expr: a @@ -59,7 +61,7 @@ query: SELECT * FROM src_null DISTRIBUTE BY c SORT BY d Input: default/src_null -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/125046373/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/497061078/10000 1.0 1 same 0 1.0 1 same 1 1.0 1 same 2 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out Tue Aug 11 02:06:23 2009 @@ -17,6 +17,8 @@ Map Reduce Alias -> Map Operator Tree: a:input4 + TableScan + alias: input4 Select Operator expressions: expr: key @@ -56,7 +58,7 @@ FROM INPUT4) a ORDER BY KEY2 LIMIT 10 Input: default/input4 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/945658600/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1382133902/10000 0 0 0 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input23.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input23.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input23.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input23.q.out Tue Aug 11 02:06:23 2009 @@ -12,7 +12,10 @@ Map Reduce Alias -> Map Operator Tree: b + TableScan + alias: b Filter Operator + isSamplingPred: false predicate: expr: ((ds = '2008-04-08') and (hr = '14')) type: boolean @@ -29,7 +32,10 @@ expr: hr type: string a + TableScan + alias: a Filter Operator + isSamplingPred: false predicate: expr: ((ds = '2008-04-08') and (hr = '11')) type: boolean @@ -47,9 +53,9 @@ type: string Needs Tagging: true Path -> Alias: - file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 Path -> Partition: - file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 Partition partition values: ds 2008-04-08 @@ -68,7 +74,7 @@ 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/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: srcpart Reduce Operator Tree: @@ -80,6 +86,7 @@ 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Filter Operator + isSamplingPred: false predicate: expr: ((((_col2 = '2008-04-08') and (_col3 = '11')) and (_col6 = '2008-04-08')) and (_col7 = '14')) type: boolean @@ -106,7 +113,7 @@ File Output Operator compressed: false GlobalTableId: 0 - directory: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/1797615685/10001 + directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1962615553/10001 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -122,4 +129,4 @@ query: select * from srcpart a join srcpart b where a.ds = '2008-04-08' and a.hr = '11' and b.ds = '2008-04-08' and b.hr = '14' limit 5 Input: default/srcpart/ds=2008-04-08/hr=11 -Output: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/1293686104/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/107545677/10000 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input24.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input24.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input24.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input24.q.out Tue Aug 11 02:06:23 2009 @@ -15,6 +15,8 @@ Map Reduce Alias -> Map Operator Tree: x + TableScan + alias: x Filter Operator predicate: expr: (d = '2009-01-01') @@ -60,6 +62,6 @@ query: select count(1) from tst x where x.d='2009-01-01' Input: default/tst/d=2009-01-01 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/914060511/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1878605126/10000 0 query: drop table tst Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out Tue Aug 11 02:06:23 2009 @@ -23,6 +23,8 @@ Map Reduce Alias -> Map Operator Tree: null-subquery1:subq-subquery1:x + TableScan + alias: x Filter Operator predicate: expr: (d = '2009-01-01') @@ -64,7 +66,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1648055539/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/197206999/10002 Union Select Operator expressions: @@ -81,7 +83,7 @@ table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1648055539/10003 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/197206999/10003 Union Select Operator expressions: @@ -103,6 +105,8 @@ Map Reduce Alias -> Map Operator Tree: null-subquery2:subq-subquery2:x + TableScan + alias: x Filter Operator predicate: expr: (d = '2009-02-02') @@ -153,5 +157,5 @@ ) subq Input: default/tst/d=2009-01-01 Input: default/tst/d=2009-02-02 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/297483633/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1412410730/10000 query: drop table tst Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out Tue Aug 11 02:06:23 2009 @@ -19,6 +19,8 @@ Map Reduce Alias -> Map Operator Tree: null-subquery1:subq-subquery1:a + TableScan + alias: a Filter Operator predicate: expr: ((ds = '2008-04-08') and (hr = '11')) @@ -66,7 +68,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/136969549/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1082108429/10002 Union Select Operator expressions: @@ -85,7 +87,7 @@ table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/136969549/10003 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1082108429/10003 Union Select Operator expressions: @@ -109,6 +111,8 @@ Map Reduce Alias -> Map Operator Tree: null-subquery2:subq-subquery2:b + TableScan + alias: b Filter Operator predicate: expr: ((ds = '2008-04-08') and (hr = '14')) @@ -162,7 +166,7 @@ select * from srcpart b where b.ds = '2008-04-08' and b.hr = '14' limit 5 )subq Input: default/srcpart/ds=2008-04-08/hr=11 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/116487966/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/168463886/10000 0 val_0 2008-04-08 11 0 val_0 2008-04-08 11 0 val_0 2008-04-08 11 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out Tue Aug 11 02:06:23 2009 @@ -12,6 +12,8 @@ Map Reduce Alias -> Map Operator Tree: x + TableScan + alias: x Filter Operator predicate: expr: (UDFToDouble(key) < UDFToDouble(300)) @@ -42,7 +44,7 @@ query: SELECT x.* FROM SRC x WHERE x.key < 300 LIMIT 5 Input: default/src -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/689430698/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/515715119/10000 238 val_238 86 val_86 27 val_27 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input30.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input30.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input30.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input30.q.out Tue Aug 11 02:06:23 2009 @@ -17,6 +17,8 @@ Map Reduce Alias -> Map Operator Tree: src + TableScan + alias: src Filter Operator predicate: expr: (((hash(rand(UDFToLong(460476415))) & 2147483647) % 32) = 0) @@ -75,7 +77,7 @@ Output: default/tst_dest30 query: select * from tst_dest30 Input: default/tst_dest30 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1981954297/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1316741609/10000 18 query: drop table tst_dest30 query: drop table dest30 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input31.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input31.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input31.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input31.q.out Tue Aug 11 02:06:23 2009 @@ -17,6 +17,8 @@ Map Reduce Alias -> Map Operator Tree: srcbucket + TableScan + alias: srcbucket Select Operator Group By Operator aggregations: @@ -71,7 +73,7 @@ Output: default/tst_dest31 query: select * from tst_dest31 Input: default/tst_dest31 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1184857393/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2034201146/10000 493 query: drop table tst_dest31 query: drop table dest31 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input32.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input32.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input32.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input32.q.out Tue Aug 11 02:06:23 2009 @@ -17,6 +17,8 @@ Map Reduce Alias -> Map Operator Tree: srcbucket + TableScan + alias: srcbucket Select Operator Group By Operator aggregations: @@ -71,7 +73,7 @@ Output: default/tst_dest32 query: select * from tst_dest32 Input: default/tst_dest32 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/54515043/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1142748652/10000 1000 query: drop table tst_dest32 query: drop table dest32 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out Tue Aug 11 02:06:23 2009 @@ -19,6 +19,8 @@ Map Reduce Alias -> Map Operator Tree: t:t1 + TableScan + alias: t1 Select Operator expressions: expr: key @@ -62,7 +64,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1988545079/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1953025922/10002 Reduce Output Operator sort order: tag: -1 @@ -99,7 +101,7 @@ Output: default/t2 query: SELECT * FROM T2 SORT BY key, value Input: default/t2 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1233838218/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/741107383/10000 0 val_0 0 val_0 0 val_0 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out Tue Aug 11 02:06:23 2009 @@ -13,6 +13,8 @@ Map Reduce Alias -> Map Operator Tree: src + TableScan + alias: src Select Operator expressions: expr: key @@ -44,7 +46,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1809793683/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1741200337/10002 Reduce Output Operator key expressions: expr: _col0 @@ -73,7 +75,7 @@ query: select * from src sort by key limit 10 Input: default/src -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1717158908/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/385052408/10000 0 val_0 0 val_0 0 val_0 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input5.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input5.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input5.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input5.q.out Tue Aug 11 02:06:23 2009 @@ -19,6 +19,8 @@ Map Reduce Alias -> Map Operator Tree: tmap:src_thrift + TableScan + alias: src_thrift Select Operator expressions: expr: lint @@ -85,7 +87,7 @@ Output: default/dest1 query: SELECT dest1.* FROM dest1 Input: default/dest1 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/915690046/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/120418612/10000 [0,0,0] [{"myint":0,"mystring":"0","underscore_int":0}] [1,2,3] [{"myint":1,"mystring":"1","underscore_int":1}] [2,4,6] [{"myint":4,"mystring":"8","underscore_int":2}] Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input6.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input6.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input6.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input6.q.out Tue Aug 11 02:06:23 2009 @@ -15,6 +15,8 @@ Map Reduce Alias -> Map Operator Tree: src1 + TableScan + alias: src1 Filter Operator predicate: expr: key is null @@ -45,10 +47,10 @@ Move Operator files: hdfs directory: true - destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/514038565/10000 + destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2028160907/10000 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1369456847/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/886482304/10002 Reduce Output Operator sort order: Map-reduce partition columns: @@ -88,4 +90,4 @@ Output: default/dest1 query: SELECT dest1.* FROM dest1 Input: default/dest1 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/439706537/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2074725714/10000 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out Tue Aug 11 02:06:23 2009 @@ -15,6 +15,8 @@ Map Reduce Alias -> Map Operator Tree: src1 + TableScan + alias: src1 Select Operator expressions: expr: null @@ -44,10 +46,10 @@ Move Operator files: hdfs directory: true - destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1246196954/10000 + destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1105502435/10000 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/2070937236/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1662408362/10002 Reduce Output Operator sort order: Map-reduce partition columns: @@ -87,7 +89,7 @@ Output: default/dest1 query: SELECT dest1.* FROM dest1 Input: default/dest1 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1350143879/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/136163075/10000 NULL 238 NULL NULL NULL 311 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out Tue Aug 11 02:06:23 2009 @@ -15,6 +15,8 @@ Map Reduce Alias -> Map Operator Tree: src1 + TableScan + alias: src1 Select Operator expressions: expr: (UDFToDouble(4) + null) @@ -48,10 +50,10 @@ Move Operator files: hdfs directory: true - destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/2001020819/10000 + destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1626829975/10000 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/546572245/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2078440366/10002 Reduce Output Operator sort order: Map-reduce partition columns: @@ -93,7 +95,7 @@ Output: default/dest1 query: SELECT dest1.* FROM dest1 Input: default/dest1 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/290179113/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/60632490/10000 NULL NULL NULL NULL NULL NULL NULL NULL NULL Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out Tue Aug 11 02:06:23 2009 @@ -15,6 +15,8 @@ Map Reduce Alias -> Map Operator Tree: src1 + TableScan + alias: src1 Filter Operator predicate: expr: (null = null) @@ -52,10 +54,10 @@ Move Operator files: hdfs directory: true - destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/2053307008/10000 + destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1618745236/10000 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/694414280/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1286113627/10002 Reduce Output Operator sort order: Map-reduce partition columns: @@ -95,4 +97,4 @@ Output: default/dest1 query: SELECT dest1.* FROM dest1 Input: default/dest1 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1570451077/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1674136764/10000 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out Tue Aug 11 02:06:23 2009 @@ -20,6 +20,8 @@ Map Reduce Alias -> Map Operator Tree: src_thrift + TableScan + alias: src_thrift Select Operator expressions: expr: lint @@ -78,7 +80,7 @@ Output: default/input_columnarserde query: SELECT input_columnarserde.* FROM input_columnarserde DISTRIBUTE BY 1 Input: default/input_columnarserde -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/2034641093/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1695989715/10000 [0,0,0] ["0","0","0"] {"key_0":"value_0"} 1712634731 record_0 [1,2,3] ["10","100","1000"] {"key_1":"value_1"} 465985200 record_1 [2,4,6] ["20","200","2000"] {"key_2":"value_2"} -751827638 record_2 @@ -92,7 +94,7 @@ null null {} 0 NULL query: SELECT input_columnarserde.a[0], input_columnarserde.b[0], input_columnarserde.c['key2'], input_columnarserde.d, input_columnarserde.e FROM input_columnarserde DISTRIBUTE BY 1 Input: default/input_columnarserde -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/334887658/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1755799278/10000 0 0 NULL 1712634731 record_0 1 10 NULL 465985200 record_1 2 20 NULL -751827638 record_2 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out Tue Aug 11 02:06:23 2009 @@ -21,6 +21,8 @@ Map Reduce Alias -> Map Operator Tree: src_thrift + TableScan + alias: src_thrift Select Operator expressions: expr: lint @@ -49,10 +51,10 @@ Move Operator files: hdfs directory: true - destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/517762331/10000 + destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1925142463/10000 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1867126986/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1140895264/10002 Reduce Output Operator sort order: Map-reduce partition columns: @@ -98,7 +100,7 @@ Output: default/dest1 query: SELECT dest1.* FROM dest1 Input: default/dest1 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/683760130/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/842958925/10000 [0,0,0] ["0","0","0"] {"key_0":"value_0"} 1712634731 record_0 [1,2,3] ["10","100","1000"] {"key_1":"value_1"} 465985200 record_1 [2,4,6] ["20","200","2000"] {"key_2":"value_2"} -751827638 record_2 @@ -112,7 +114,7 @@ null null null 0 NULL query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1 Input: default/dest1 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/189330657/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1145493551/10000 0 0 NULL 1712634731 record_0 1 10 NULL 465985200 record_1 2 20 NULL -751827638 record_2 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out Tue Aug 11 02:06:23 2009 @@ -20,6 +20,8 @@ Map Reduce Alias -> Map Operator Tree: src_thrift + TableScan + alias: src_thrift Select Operator expressions: expr: lint @@ -78,7 +80,7 @@ Output: default/dest1 query: SELECT dest1.* FROM dest1 DISTRIBUTE BY 1 Input: default/dest1 -Output: file:/data/users/zshao/tools/deploy-trunk-apache-hive/build/ql/tmp/604433188/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/54447048/10000 [0,0,0] ["0","0","0"] {"key_0":"value_0"} 1712634731 record_0 [1,2,3] ["10","100","1000"] {"key_1":"value_1"} 465985200 record_1 [2,4,6] ["20","200","2000"] {"key_2":"value_2"} -751827638 record_2 @@ -92,7 +94,7 @@ null null null 0 NULL query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1 DISTRIBUTE BY 1 Input: default/dest1 -Output: file:/data/users/zshao/tools/deploy-trunk-apache-hive/build/ql/tmp/848270212/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1845091515/10000 0 0 NULL 1712634731 record_0 1 10 NULL 465985200 record_1 2 20 NULL -751827638 record_2 @@ -111,7 +113,7 @@ Output: default/dest1 query: SELECT * from dest1 Input: default/dest1 -Output: file:/data/users/zshao/tools/deploy-trunk-apache-hive/build/ql/tmp/1928951519/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/482165346/10000 [0,0,0] [1,2,3] [2,4,6] @@ -130,7 +132,7 @@ Output: default/dest1 query: SELECT * from dest1 Input: default/dest1 -Output: file:/data/users/zshao/tools/deploy-trunk-apache-hive/build/ql/tmp/1672243759/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/244883137/10000 {"key_0":"value_0"} {"key_1":"value_1"} {"key_2":"value_2"} Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out Tue Aug 11 02:06:23 2009 @@ -15,11 +15,15 @@ Map Reduce Alias -> Map Operator Tree: srcpart + TableScan + alias: srcpart Filter Operator + isSamplingPred: false predicate: expr: (((UDFToDouble(key) < UDFToDouble(100)) and (ds = '2008-04-08')) and (hr = '12')) type: boolean Filter Operator + isSamplingPred: false predicate: expr: (((UDFToDouble(key) < UDFToDouble(100)) and (ds = '2008-04-08')) and (hr = '12')) type: boolean @@ -48,7 +52,7 @@ File Output Operator compressed: false GlobalTableId: 1 - directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/297808158/10002 + directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/430187082/10002 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -62,14 +66,14 @@ 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/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/dest1 + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 Path -> Partition: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 Partition partition values: ds 2008-04-08 @@ -88,7 +92,7 @@ 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/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: srcpart @@ -98,11 +102,11 @@ Move Operator files: hdfs directory: true - source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/297808158/10002 - destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/880173234/10000 + source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/430187082/10002 + destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1548094656/10000 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/297808158/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/430187082/10002 Reduce Output Operator sort order: Map-reduce partition columns: @@ -120,9 +124,9 @@ type: string Needs Tagging: false Path -> Alias: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/297808158/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/430187082/10002 Path -> Partition: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/297808158/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/430187082/10002 Partition input format: org.apache.hadoop.mapred.TextInputFormat @@ -137,7 +141,7 @@ 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/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/dest1 + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest1 Reduce Operator Tree: @@ -145,7 +149,7 @@ File Output Operator compressed: false GlobalTableId: 0 - directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/880173234/10000 + directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1548094656/10000 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -158,7 +162,7 @@ bucket_count -1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat - location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/dest1 + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest1 @@ -167,7 +171,7 @@ Move Operator tables: replace: true - source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/880173234/10000 + source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1548094656/10000 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -181,10 +185,10 @@ 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/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/dest1 + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest1 - tmp directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/880173234/10001 + tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1548094656/10001 query: FROM srcpart @@ -193,7 +197,7 @@ Output: default/dest1 query: SELECT dest1.* FROM dest1 Input: default/dest1 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/583441670/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1182712706/10000 86 val_86 12 2008-04-08 27 val_27 12 2008-04-08 98 val_98 12 2008-04-08 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out Tue Aug 11 02:06:23 2009 @@ -19,7 +19,10 @@ Map Reduce Alias -> Map Operator Tree: srcpart + TableScan + alias: srcpart Filter Operator + isSamplingPred: false predicate: expr: (((UDFToDouble(key) < UDFToDouble(100)) and (ds = '2008-04-08')) and (hr = '12')) type: boolean @@ -48,7 +51,7 @@ File Output Operator compressed: false GlobalTableId: 1 - directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10004 + directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10004 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -62,10 +65,11 @@ 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/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest1 + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest1 Filter Operator + isSamplingPred: false predicate: expr: (((UDFToDouble(key) < UDFToDouble(100)) and (ds = '2008-04-09')) and (hr = '12')) type: boolean @@ -94,7 +98,7 @@ File Output Operator compressed: false GlobalTableId: 2 - directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10005 + directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10005 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -108,15 +112,15 @@ 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/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest2 + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest2 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest2 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 Path -> Partition: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 Partition partition values: ds 2008-04-08 @@ -135,10 +139,10 @@ 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/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: srcpart - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 Partition partition values: ds 2008-04-09 @@ -157,7 +161,7 @@ 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/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: srcpart @@ -167,11 +171,11 @@ Move Operator files: hdfs directory: true - source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10004 - destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10000 + source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10004 + destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10000 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10004 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10004 Reduce Output Operator sort order: Map-reduce partition columns: @@ -189,9 +193,9 @@ type: string Needs Tagging: false Path -> Alias: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10004 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10004 Path -> Partition: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10004 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10004 Partition input format: org.apache.hadoop.mapred.TextInputFormat @@ -206,7 +210,7 @@ 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/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest1 + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest1 Reduce Operator Tree: @@ -214,7 +218,7 @@ File Output Operator compressed: false GlobalTableId: 0 - directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10000 + directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10000 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -227,7 +231,7 @@ bucket_count -1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat - location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest1 + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest1 @@ -236,7 +240,7 @@ Move Operator tables: replace: true - source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10000 + source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10000 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -250,10 +254,10 @@ 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/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest1 + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest1 - tmp directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10001 + tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10001 Stage: Stage-8 Conditional Operator @@ -261,11 +265,11 @@ Move Operator files: hdfs directory: true - source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10005 - destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10002 + source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10005 + destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10002 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10005 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10005 Reduce Output Operator sort order: Map-reduce partition columns: @@ -283,9 +287,9 @@ type: string Needs Tagging: false Path -> Alias: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10005 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10005 Path -> Partition: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10005 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10005 Partition input format: org.apache.hadoop.mapred.TextInputFormat @@ -300,7 +304,7 @@ 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/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest2 + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest2 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest2 Reduce Operator Tree: @@ -308,7 +312,7 @@ File Output Operator compressed: false GlobalTableId: 0 - directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10002 + directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10002 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -321,7 +325,7 @@ bucket_count -1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat - location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest2 + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest2 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest2 @@ -330,7 +334,7 @@ Move Operator tables: replace: true - source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10002 + source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10002 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -344,10 +348,10 @@ 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/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest2 + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest2 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest2 - tmp directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10003 + tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10003 query: FROM srcpart @@ -359,7 +363,7 @@ Output: default/dest2 query: SELECT dest1.* FROM dest1 sort by key,value,ds,hr Input: default/dest1 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/305007713/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1367548594/10000 0 val_0 12 2008-04-08 0 val_0 12 2008-04-08 0 val_0 12 2008-04-08 @@ -446,7 +450,7 @@ 98 val_98 12 2008-04-08 query: SELECT dest2.* FROM dest2 sort by key,value,ds,hr Input: default/dest2 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1696118746/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1502320344/10000 0 val_0 12 2008-04-09 0 val_0 12 2008-04-09 0 val_0 12 2008-04-09 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out Tue Aug 11 02:06:23 2009 @@ -16,6 +16,8 @@ Map Reduce Alias -> Map Operator Tree: x + TableScan + alias: x Filter Operator predicate: expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100))) @@ -50,10 +52,10 @@ Move Operator files: hdfs directory: true - destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1070846773/10000 + destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1321538842/10000 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1822724007/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/378526421/10002 Reduce Output Operator sort order: Map-reduce partition columns: @@ -98,7 +100,7 @@ Output: default/tmptable query: select * from tmptable x sort by x.key,x.value,x.ds,x.hr Input: default/tmptable -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/994747882/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1919037456/10000 0 val_0 2008-04-08 11 0 val_0 2008-04-08 11 0 val_0 2008-04-08 11 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out Tue Aug 11 02:06:23 2009 @@ -12,6 +12,8 @@ Map Reduce Alias -> Map Operator Tree: x + TableScan + alias: x Filter Operator predicate: expr: (UDFToDouble(ds) = UDFToDouble(((2008 - 4) - 8))) @@ -49,4 +51,4 @@ Input: default/srcpart/ds=2008-04-08/hr=12 Input: default/srcpart/ds=2008-04-09/hr=11 Input: default/srcpart/ds=2008-04-09/hr=12 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/447936279/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/758866598/10000 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out Tue Aug 11 02:06:23 2009 @@ -17,11 +17,15 @@ Map Reduce Alias -> Map Operator Tree: null-subquery1:a-subquery1:x + TableScan + alias: x Filter Operator + isSamplingPred: false predicate: expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100))) type: boolean Filter Operator + isSamplingPred: false predicate: expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100))) type: boolean @@ -64,11 +68,15 @@ expr: _col3 type: string null-subquery2:a-subquery2:y + TableScan + alias: y Filter Operator + isSamplingPred: false predicate: expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100))) type: boolean Filter Operator + isSamplingPred: false predicate: expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100))) type: boolean @@ -112,10 +120,10 @@ type: string Needs Tagging: false Path -> Alias: - file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 - file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 Path -> Partition: - file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 Partition partition values: ds 2008-04-08 @@ -134,10 +142,10 @@ 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/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: srcpart - file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 Partition partition values: ds 2008-04-08 @@ -156,7 +164,7 @@ 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/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: srcpart Reduce Operator Tree: @@ -164,7 +172,7 @@ File Output Operator compressed: false GlobalTableId: 0 - directory: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/tmp/526431721/10001 + directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/260684261/10001 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -186,7 +194,7 @@ SORT BY A.key Input: default/srcpart/ds=2008-04-08/hr=11 Input: default/srcpart/ds=2008-04-08/hr=12 -Output: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/tmp/891014726/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1095258770/10000 0 val_0 2008-04-08 11 0 val_0 2008-04-08 11 0 val_0 2008-04-08 11 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out Tue Aug 11 02:06:23 2009 @@ -12,11 +12,15 @@ Map Reduce Alias -> Map Operator Tree: x + TableScan + alias: x Filter Operator + isSamplingPred: false predicate: expr: (key is not null and (ds = '2008-04-08')) type: boolean Filter Operator + isSamplingPred: false predicate: expr: (key is not null and (ds = '2008-04-08')) type: boolean @@ -34,7 +38,7 @@ File Output Operator compressed: false GlobalTableId: 0 - directory: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/741456423/10001 + directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1563301845/10001 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -44,10 +48,10 @@ columns.types string:string:string:string Needs Tagging: false Path -> Alias: - file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 - file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 Path -> Partition: - file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 Partition partition values: ds 2008-04-08 @@ -66,10 +70,10 @@ 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/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: srcpart - file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 Partition partition values: ds 2008-04-08 @@ -88,7 +92,7 @@ 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/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart + location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: srcpart @@ -96,11 +100,10 @@ Fetch Operator limit: -1 - query: SELECT x.* FROM SRCPART x WHERE key IS NOT NULL AND ds = '2008-04-08' Input: default/srcpart/ds=2008-04-08/hr=11 Input: default/srcpart/ds=2008-04-08/hr=12 -Output: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/675875634/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/261570775/10000 238 val_238 2008-04-08 11 86 val_86 2008-04-08 11 311 val_311 2008-04-08 11 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out Tue Aug 11 02:06:23 2009 @@ -15,6 +15,8 @@ Map Reduce Alias -> Map Operator Tree: src + TableScan + alias: src Select Operator expressions: expr: key @@ -44,10 +46,10 @@ Move Operator files: hdfs directory: true - destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1551879808/10000 + destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/66296780/10000 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/333825755/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/696386493/10002 Reduce Output Operator sort order: Map-reduce partition columns: @@ -87,7 +89,7 @@ Output: default/dest4_sequencefile query: SELECT dest4_sequencefile.* FROM dest4_sequencefile Input: default/dest4_sequencefile -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1330571265/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1740018571/10000 238 val_238 86 val_86 311 val_311 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath.q.out Tue Aug 11 02:06:23 2009 @@ -15,6 +15,8 @@ Map Reduce Alias -> Map Operator Tree: src_thrift + TableScan + alias: src_thrift Select Operator expressions: expr: lint[1] @@ -39,10 +41,10 @@ Move Operator files: hdfs directory: true - destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/893288498/10000 + destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/794454681/10000 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/647174747/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/492458082/10002 Reduce Output Operator sort order: Map-reduce partition columns: @@ -84,7 +86,7 @@ Output: default/dest1 query: SELECT dest1.* FROM dest1 Input: default/dest1 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/761702774/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/264689843/10000 0 0 NULL 2 1 NULL 4 8 value_2 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out Tue Aug 11 02:06:23 2009 @@ -15,6 +15,8 @@ Map Reduce Alias -> Map Operator Tree: src_thrift + TableScan + alias: src_thrift Filter Operator predicate: expr: (lint is not null and not mstringstring is null) @@ -47,10 +49,10 @@ Move Operator files: hdfs directory: true - destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1379940084/10000 + destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/630839318/10000 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/476600317/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/284782500/10002 Reduce Output Operator sort order: Map-reduce partition columns: @@ -92,7 +94,7 @@ Output: default/dest1 query: SELECT dest1.* FROM dest1 Input: default/dest1 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1955798918/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/413755901/10000 3 1 1 3 1 1 3 1 1 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath3.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath3.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath3.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath3.q.out Tue Aug 11 02:06:23 2009 @@ -13,6 +13,8 @@ Map Reduce Alias -> Map Operator Tree: src_thrift + TableScan + alias: src_thrift Select Operator expressions: expr: mstringstring['key_9'] @@ -35,7 +37,7 @@ query: FROM src_thrift SELECT src_thrift.mstringstring['key_9'], src_thrift.lintstring.myint Input: default/src_thrift -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1386485192/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1059185497/10000 NULL [0] NULL [1] NULL [4] Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath4.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath4.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath4.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath4.q.out Tue Aug 11 02:06:23 2009 @@ -16,6 +16,8 @@ Map Reduce Alias -> Map Operator Tree: src_thrift + TableScan + alias: src_thrift Filter Operator predicate: expr: ((mstringstring['key_9'] is not null and lintstring.myint is not null) and lintstring is not null) @@ -45,7 +47,7 @@ OR lintstring.myint IS NOT NULL OR lintstring IS NOT NULL Input: default/src_thrift -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/533384116/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/607559356/10000 NULL [0] NULL [1] NULL [4] @@ -74,6 +76,8 @@ Map Reduce Alias -> Map Operator Tree: src_thrift + TableScan + alias: src_thrift Filter Operator predicate: expr: ((mstringstring['key_9'] is not null and lintstring.myint is not null) and lintstring is not null) @@ -107,7 +111,7 @@ OR lintstring.myint IS NOT NULL OR lintstring IS NOT NULL Input: default/src_thrift -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1269187205/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/364349054/10000 NULL [0] NULL [1] NULL [4] Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out Tue Aug 11 02:06:23 2009 @@ -18,6 +18,8 @@ Map Reduce Alias -> Map Operator Tree: src2:src + TableScan + alias: src Filter Operator predicate: expr: (UDFToDouble(key) < UDFToDouble(10)) @@ -42,6 +44,8 @@ expr: _col1 type: string src1:src + TableScan + alias: src Filter Operator predicate: expr: (UDFToDouble(key) < UDFToDouble(10)) @@ -94,7 +98,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/63021860/10002 + file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1266394522/10002 Reduce Output Operator key expressions: expr: _col0 @@ -137,7 +141,7 @@ (SELECT * FROM src WHERE src.key < 10) src2 SORT BY k1, v1, k2, v2 Input: default/src -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/2035203874/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1838206361/10000 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join1.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join1.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/join1.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join1.q.out Tue Aug 11 02:06:23 2009 @@ -14,6 +14,8 @@ Map Reduce Alias -> Map Operator Tree: src2 + TableScan + alias: src2 Reduce Output Operator key expressions: expr: key @@ -27,6 +29,8 @@ expr: value type: string src1 + TableScan + alias: src1 Reduce Output Operator key expressions: expr: key @@ -87,7 +91,7 @@ Output: default/dest_j1 query: SELECT dest_j1.* FROM dest_j1 Input: default/dest_j1 -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_3/build/ql/tmp/1786745892/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/862388733/10000 0 val_0 0 val_0 0 val_0 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join10.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join10.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/join10.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join10.q.out Tue Aug 11 02:06:23 2009 @@ -16,6 +16,8 @@ Map Reduce Alias -> Map Operator Tree: x:src + TableScan + alias: src Select Operator expressions: expr: key @@ -31,6 +33,8 @@ type: string tag: 0 y:src + TableScan + alias: src Select Operator expressions: expr: key @@ -86,7 +90,7 @@ ON (x.key = Y.key) SELECT Y.* Input: default/src -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1524530660/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1608637001/10000 0 val_0 0 val_0 0 val_0 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join11.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join11.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/join11.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join11.q.out Tue Aug 11 02:06:23 2009 @@ -17,6 +17,8 @@ Map Reduce Alias -> Map Operator Tree: src2:src + TableScan + alias: src Select Operator expressions: expr: key @@ -37,6 +39,8 @@ expr: _col1 type: string src1:src + TableScan + alias: src Filter Operator predicate: expr: (UDFToDouble(key) < UDFToDouble(100)) @@ -96,7 +100,7 @@ (SELECT src.key as c3, src.value as c4 from src) src2 ON src1.c1 = src2.c3 AND src1.c1 < 100 Input: default/src -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/542706340/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1302752228/10000 0 val_0 0 val_0 0 val_0 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join12.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join12.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/join12.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join12.q.out Tue Aug 11 02:06:23 2009 @@ -20,6 +20,8 @@ Map Reduce Alias -> Map Operator Tree: src2:src + TableScan + alias: src Select Operator expressions: expr: key @@ -40,6 +42,8 @@ expr: _col1 type: string src1:src + TableScan + alias: src Filter Operator predicate: expr: (UDFToDouble(key) < UDFToDouble(100)) @@ -66,6 +70,8 @@ expr: _col0 type: string src3:src + TableScan + alias: src Filter Operator predicate: expr: (UDFToDouble(key) < UDFToDouble(80)) @@ -127,7 +133,7 @@ (SELECT src.key as c5, src.value as c6 from src) src3 ON src1.c1 = src3.c5 AND src3.c5 < 80 Input: default/src -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/23536302/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1418897079/10000 0 val_0 0 val_0 0 val_0 Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out?rev=802976&r1=802975&r2=802976&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out Tue Aug 11 02:06:23 2009 @@ -21,6 +21,8 @@ Map Reduce Alias -> Map Operator Tree: src2:src + TableScan + alias: src Select Operator expressions: expr: key @@ -43,6 +45,8 @@ expr: _col1 type: string src1:src + TableScan + alias: src Filter Operator predicate: expr: (UDFToDouble(key) < UDFToDouble(100)) @@ -102,6 +106,8 @@ expr: _col0 type: string src3:src + TableScan + alias: src Filter Operator predicate: expr: (UDFToDouble(key) < UDFToDouble(200)) @@ -161,7 +167,7 @@ (SELECT src.key as c5, src.value as c6 from src) src3 ON src1.c1 + src2.c3 = src3.c5 AND src3.c5 < 200 Input: default/src -Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/259098425/10000 +Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1605427587/10000 0 val_0 0 val_0 0 val_0