Return-Path: Delivered-To: apmail-hive-commits-archive@www.apache.org Received: (qmail 8924 invoked from network); 22 Mar 2011 23:06:20 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 22 Mar 2011 23:06:20 -0000 Received: (qmail 20317 invoked by uid 500); 22 Mar 2011 23:06:20 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 20244 invoked by uid 500); 22 Mar 2011 23:06:20 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 20236 invoked by uid 99); 22 Mar 2011 23:06:20 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Mar 2011 23:06:20 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Mar 2011 23:06:16 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id 7874E2388962; Tue, 22 Mar 2011 23:05:56 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1084403 [3/26] - in /hive/trunk: contrib/src/test/results/clientpositive/ ql/src/java/org/apache/hadoop/hive/ql/parse/ ql/src/test/org/apache/hadoop/hive/ql/ ql/src/test/org/apache/hadoop/hive/ql/hooks/ ql/src/test/queries/clientnegative/ ... Date: Tue, 22 Mar 2011 23:05:53 -0000 To: commits@hive.apache.org From: namit@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20110322230556.7874E2388962@eris.apache.org> Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join_filters.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join_filters.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/auto_join_filters.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/auto_join_filters.q.out Tue Mar 22 23:05:48 2011 @@ -5,242 +5,243 @@ POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@myinput1 PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in3.txt' INTO TABLE myinput1 PREHOOK: type: LOAD +PREHOOK: Output: default@myinput1 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in3.txt' INTO TABLE myinput1 POSTHOOK: type: LOAD POSTHOOK: Output: default@myinput1 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-54-58_117_4655002105750219/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-43-26_402_3823352626755127393/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-54-58_117_4655002105750219/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-43-26_402_3823352626755127393/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-02_366_6992699161975993053/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-43-52_028_8706487155749908015/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-02_366_6992699161975993053/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-43-52_028_8706487155749908015/-mr-10000 4937935 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-06_634_6445437890696840782/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-44-15_384_7630765881378065886/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-06_634_6445437890696840782/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-44-15_384_7630765881378065886/-mr-10000 3080335 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-11_343_4548102731373306036/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-44-40_605_1752452305040710923/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-11_343_4548102731373306036/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-44-40_605_1752452305040710923/-mr-10000 19749880 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-16_548_5347533565842262214/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-44-59_445_4642971180521797028/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-16_548_5347533565842262214/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-44-59_445_4642971180521797028/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-20_995_7002425294061259326/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-45-27_268_7424128323625706680/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-20_995_7002425294061259326/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-45-27_268_7424128323625706680/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-25_522_7223107408677755461/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-45-53_438_5455268342289132617/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-25_522_7223107408677755461/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-45-53_438_5455268342289132617/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-29_880_4549706398893829025/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-46-19_041_1658519087154188345/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-29_880_4549706398893829025/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-46-19_041_1658519087154188345/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-34_424_169089929568714471/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-46-43_030_2565898147068052104/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-34_424_169089929568714471/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-46-43_030_2565898147068052104/-mr-10000 4937935 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-38_712_4712108057879519702/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-47-09_808_4731735217090783486/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-38_712_4712108057879519702/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-47-09_808_4731735217090783486/-mr-10000 4937935 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-44_225_1720576234903554068/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-47-35_330_660052387827024366/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-44_225_1720576234903554068/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-47-35_330_660052387827024366/-mr-10000 4937935 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-49_018_1771521729720905137/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-48-01_449_2746186983619756410/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-49_018_1771521729720905137/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-48-01_449_2746186983619756410/-mr-10000 4937935 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-53_798_4683803195318455359/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-48-23_415_3777243223874172404/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-53_798_4683803195318455359/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-48-23_415_3777243223874172404/-mr-10000 3080335 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-58_327_8236566722650852723/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-48-48_532_2975081205778014987/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-55-58_327_8236566722650852723/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-48-48_532_2975081205778014987/-mr-10000 3080335 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-03_065_2996745104714988105/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-49-09_116_2139323123882151994/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-03_065_2996745104714988105/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-49-09_116_2139323123882151994/-mr-10000 3080335 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-07_973_4625804318414132050/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-49-37_363_5538326473648016432/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-07_973_4625804318414132050/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-49-37_363_5538326473648016432/-mr-10000 3080335 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-12_356_8298086109390383704/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-50-08_348_1739295993169272822/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-12_356_8298086109390383704/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-50-08_348_1739295993169272822/-mr-10000 4939870 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-17_229_5664599811337231023/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-50-28_297_6653250308158592143/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-17_229_5664599811337231023/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-50-28_297_6653250308158592143/-mr-10000 4939870 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-21_523_7285750866206869237/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-50-50_179_5942362811596789686/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-21_523_7285750866206869237/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-50-50_179_5942362811596789686/-mr-10000 4939870 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-26_625_2655349310089115439/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-51-10_719_3484816377261611832/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-26_625_2655349310089115439/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-51-10_719_3484816377261611832/-mr-10000 4939870 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-32_045_6195138915928486369/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-51-31_843_8401704888614403266/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-32_045_6195138915928486369/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-51-31_843_8401704888614403266/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-36_424_3499869040206387595/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-51-58_538_3143256476531542592/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-36_424_3499869040206387595/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-51-58_538_3143256476531542592/-mr-10000 3080335 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-40_774_9079581832077075239/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-52-22_081_8217099592801202885/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-40_774_9079581832077075239/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-52-22_081_8217099592801202885/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-47_855_6954543840613097127/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-53-03_986_482889532515566149/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-47_855_6954543840613097127/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-53-03_986_482889532515566149/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-54_495_8347295964623851135/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-53-57_291_454472657691522006/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-56-54_495_8347295964623851135/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-53-57_291_454472657691522006/-mr-10000 3080335 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.key = c.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-02_103_2472217444100405726/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-54-39_412_4673599665189630461/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.key = c.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-02_103_2472217444100405726/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-54-39_412_4673599665189630461/-mr-10000 3078400 PREHOOK: query: CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE @@ -254,255 +255,259 @@ POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@smb_input2 PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' into table smb_input1 PREHOOK: type: LOAD +PREHOOK: Output: default@smb_input1 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' into table smb_input1 POSTHOOK: type: LOAD POSTHOOK: Output: default@smb_input1 PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in2.txt' into table smb_input1 PREHOOK: type: LOAD +PREHOOK: Output: default@smb_input1 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in2.txt' into table smb_input1 POSTHOOK: type: LOAD POSTHOOK: Output: default@smb_input1 PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' into table smb_input2 PREHOOK: type: LOAD +PREHOOK: Output: default@smb_input2 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' into table smb_input2 POSTHOOK: type: LOAD POSTHOOK: Output: default@smb_input2 PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in2.txt' into table smb_input2 PREHOOK: type: LOAD +PREHOOK: Output: default@smb_input2 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in2.txt' into table smb_input2 POSTHOOK: type: LOAD POSTHOOK: Output: default@smb_input2 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-14_989_3018079175573168618/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-55-24_447_5469544437889646559/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-14_989_3018079175573168618/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-55-24_447_5469544437889646559/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-20_236_1394320099184495685/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-55-40_966_973295811030201820/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-20_236_1394320099184495685/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-55-40_966_973295811030201820/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-24_621_5150978026396273270/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-56-08_972_932565580644340452/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-24_621_5150978026396273270/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-56-08_972_932565580644340452/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-28_867_297793229671774013/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-56-31_729_418525013205566139/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-28_867_297793229671774013/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-56-31_729_418525013205566139/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-33_384_4213543405474846039/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-56-52_106_1490347429184683880/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-33_384_4213543405474846039/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-56-52_106_1490347429184683880/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-39_211_3398396582126586587/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-57-18_133_7765386315514147981/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-39_211_3398396582126586587/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-57-18_133_7765386315514147981/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-43_619_5340976824563811251/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-57-41_146_1769743362095419837/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-43_619_5340976824563811251/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-57-41_146_1769743362095419837/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-48_456_7729606752684080265/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-58-08_434_6054246195001135826/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-48_456_7729606752684080265/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-58-08_434_6054246195001135826/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-53_321_4161401378864306240/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-58-35_516_8483762425905902610/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-53_321_4161401378864306240/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-58-35_516_8483762425905902610/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-58_185_6149588741729351812/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-59-00_626_3515028495152341907/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-57-58_185_6149588741729351812/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-59-00_626_3515028495152341907/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-03_957_1701501074902739227/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-59-28_857_2154623661230075623/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-03_957_1701501074902739227/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-59-28_857_2154623661230075623/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-08_779_8730807341859621811/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-59-55_944_5642068037079481424/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-08_779_8730807341859621811/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_21-59-55_944_5642068037079481424/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-14_365_6978393466194392157/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-00-23_878_6455050007791854101/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-14_365_6978393466194392157/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-00-23_878_6455050007791854101/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-19_195_6596525098045181032/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-00-46_709_7255968092481297374/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-19_195_6596525098045181032/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-00-46_709_7255968092481297374/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-23_944_767168653859149753/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-01-12_142_524896643821823083/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-23_944_767168653859149753/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-01-12_142_524896643821823083/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-28_382_1684228097795355116/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-01-35_983_4900962005248543136/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-28_382_1684228097795355116/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-01-35_983_4900962005248543136/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-33_122_626333363788741642/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-01-59_910_2244929418956550745/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-33_122_626333363788741642/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-01-59_910_2244929418956550745/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-37_662_749514132507506514/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-02-20_552_3894780493710426734/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-37_662_749514132507506514/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-02-20_552_3894780493710426734/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-43_069_1206846342850380139/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-02-38_060_3839444712455705985/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-43_069_1206846342850380139/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-02-38_060_3839444712455705985/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-47_842_61082551066774054/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-02-55_256_3159219885766043246/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-47_842_61082551066774054/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-02-55_256_3159219885766043246/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-52_552_2495832598945335366/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-03-16_892_7848669688204506254/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-52_552_2495832598945335366/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-03-16_892_7848669688204506254/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-57_562_5897053800333413408/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-03-43_326_621044105579976119/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-58-57_562_5897053800333413408/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-03-43_326_621044105579976119/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-02_213_6341773528378956115/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-04-14_522_147767947746739879/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-02_213_6341773528378956115/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-04-14_522_147767947746739879/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-10_007_6693537617189622123/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-04-53_293_3049831450878975040/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-10_007_6693537617189622123/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-04-53_293_3049831450878975040/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-18_342_340633536253451649/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-05-33_309_8255863402885570657/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-18_342_340633536253451649/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-05-33_309_8255863402885570657/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.key = c.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-26_006_4411101160964366136/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-06-17_439_1087061435501905232/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.key = c.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-26_006_4411101160964366136/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-06-17_439_1087061435501905232/-mr-10000 3078400 Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join_nulls.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join_nulls.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/auto_join_nulls.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/auto_join_nulls.q.out Tue Mar 22 23:05:48 2011 @@ -5,204 +5,205 @@ POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@myinput1 PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' INTO TABLE myinput1 PREHOOK: type: LOAD +PREHOOK: Output: default@myinput1 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' INTO TABLE myinput1 POSTHOOK: type: LOAD POSTHOOK: Output: default@myinput1 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-38_128_5721983744421015511/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-07-01_851_7082567203668819492/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-38_128_5721983744421015511/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-07-01_851_7082567203668819492/-mr-10000 13630578 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-42_458_3857336078300862994/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-07-21_111_5411241559769120068/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-42_458_3857336078300862994/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-07-21_111_5411241559769120068/-mr-10000 13630578 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-46_795_3295843614724111648/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-07-47_275_7275344927699111568/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-46_795_3295843614724111648/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-07-47_275_7275344927699111568/-mr-10000 13630578 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-51_810_8495116173420785144/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-08-10_909_3227344547923921228/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-51_810_8495116173420785144/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-08-10_909_3227344547923921228/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.key = b.key PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-56_866_676999079349671986/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-08-34_872_3617520772240164804/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.key = b.key POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_17-59-56_866_676999079349671986/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-08-34_872_3617520772240164804/-mr-10000 4509856 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.value = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-01_985_6481162350367357952/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-09-03_145_7033968100754366551/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.value = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-01_985_6481162350367357952/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-09-03_145_7033968100754366551/-mr-10000 3112070 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-07_433_5697822947001003360/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-09-27_628_3074815019668358857/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-07_433_5697822947001003360/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-09-27_628_3074815019668358857/-mr-10000 3078400 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-11_860_7663380874040287741/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-09-53_823_5728508667772781350/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-11_860_7663380874040287741/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-09-53_823_5728508667772781350/-mr-10000 4542003 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-17_087_5570220930038430711/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-10-19_775_7915491781451339345/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-17_087_5570220930038430711/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-10-19_775_7915491781451339345/-mr-10000 4542038 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-21_730_7068579215030025497/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-10-47_541_8808024107270850552/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-21_730_7068579215030025497/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-10-47_541_8808024107270850552/-mr-10000 4543491 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-26_763_7077135887434220096/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-11-11_368_1746073498914919375/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-26_763_7077135887434220096/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-11-11_368_1746073498914919375/-mr-10000 4542003 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-31_723_2846348272261226572/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-11-39_087_7473462017142022272/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-31_723_2846348272261226572/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-11-39_087_7473462017142022272/-mr-10000 3079923 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-37_879_1948558748358099991/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-12-05_148_477406129143645464/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-37_879_1948558748358099991/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-12-05_148_477406129143645464/-mr-10000 4509891 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-42_711_8448804775949567435/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-12-32_683_2157132275098105119/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-42_711_8448804775949567435/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-12-32_683_2157132275098105119/-mr-10000 3113558 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-48_016_2711326187485329520/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-13-02_678_8171913422832379699/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-48_016_2711326187485329520/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-13-02_678_8171913422832379699/-mr-10000 3079923 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-52_763_9087751756999134388/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-13-34_225_6938406449328774862/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-52_763_9087751756999134388/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-13-34_225_6938406449328774862/-mr-10000 4543526 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-58_006_5983144248451158873/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-13-57_968_8817780174135372579/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-00-58_006_5983144248451158873/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-13-57_968_8817780174135372579/-mr-10000 4543526 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-01-03_223_3881722054830137933/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-14-18_146_6362327733801140739/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-01-03_223_3881722054830137933/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-14-18_146_6362327733801140739/-mr-10000 4543526 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-01-07_938_7263469664808317293/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-14-39_847_6806889542524913797/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-01-07_938_7263469664808317293/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-14-39_847_6806889542524913797/-mr-10000 4543526 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value) PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-01-12_851_3735155037354765439/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-15-00_268_6911778605293508625/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value) POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-01-12_851_3735155037354765439/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-15-00_268_6911778605293508625/-mr-10000 3112070 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value) PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-01-17_734_3064013262164657326/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-15-28_615_4230032186292712118/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value) POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-01-17_734_3064013262164657326/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-15-28_615_4230032186292712118/-mr-10000 3113558 PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value PREHOOK: type: QUERY PREHOOK: Input: default@myinput1 -PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-01-22_200_5772028834197460678/-mr-10000 +PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-15-57_777_4849204673611787129/-mr-10000 POSTHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value POSTHOOK: type: QUERY POSTHOOK: Input: default@myinput1 -POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-11_18-01-22_200_5772028834197460678/-mr-10000 +POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-15-57_777_4849204673611787129/-mr-10000 3112070 Modified: hive/trunk/ql/src/test/results/clientpositive/binarysortable_1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/binarysortable_1.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff ============================================================================== Files hive/trunk/ql/src/test/results/clientpositive/binarysortable_1.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/binarysortable_1.q.out Tue Mar 22 23:05:48 2011 differ Modified: hive/trunk/ql/src/test/results/clientpositive/bucketizedhiveinputformat.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketizedhiveinputformat.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/bucketizedhiveinputformat.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/bucketizedhiveinputformat.q.out Tue Mar 22 23:05:48 2011 @@ -5,6 +5,7 @@ POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@T1 PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE T1 PREHOOK: type: LOAD +PREHOOK: Output: default@t1 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE T1 POSTHOOK: type: LOAD POSTHOOK: Output: default@t1 @@ -156,7 +157,7 @@ STAGE PLANS: Stage: Stage-3 Map Reduce Alias -> Map Operator Tree: - hdfs://localhost.localdomain:38821/data/users/sdong/www/open-source-hive3/build/ql/scratchdir/hive_2011-02-16_23-11-25_094_4321921681840377407/-mr-10003 + hdfs://localhost.localdomain:48956/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-51-27_066_7206620542416882466/-mr-10003 Reduce Output Operator sort order: tag: -1 @@ -267,11 +268,11 @@ STAGE PLANS: PREHOOK: query: SELECT COUNT(1) FROM T2 PREHOOK: type: QUERY PREHOOK: Input: default@t2 -PREHOOK: Output: hdfs://localhost.localdomain:38821/data/users/sdong/www/open-source-hive3/build/ql/scratchdir/hive_2011-02-16_23-13-39_139_7485731441142242061/-mr-10000 +PREHOOK: Output: hdfs://localhost.localdomain:48956/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-53-59_669_30214837486178245/-mr-10000 POSTHOOK: query: SELECT COUNT(1) FROM T2 POSTHOOK: type: QUERY POSTHOOK: Input: default@t2 -POSTHOOK: Output: hdfs://localhost.localdomain:38821/data/users/sdong/www/open-source-hive3/build/ql/scratchdir/hive_2011-02-16_23-13-39_139_7485731441142242061/-mr-10000 +POSTHOOK: Output: hdfs://localhost.localdomain:48956/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-53-59_669_30214837486178245/-mr-10000 POSTHOOK: Lineage: t2.name SIMPLE [(t1)t1.FieldSchema(name:name, type:string, comment:null), ] 5000000 PREHOOK: query: CREATE TABLE T3(name STRING) STORED AS TEXTFILE @@ -282,12 +283,14 @@ POSTHOOK: Output: default@T3 POSTHOOK: Lineage: t2.name SIMPLE [(t1)t1.FieldSchema(name:name, type:string, comment:null), ] PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE T3 PREHOOK: type: LOAD +PREHOOK: Output: default@t3 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE T3 POSTHOOK: type: LOAD POSTHOOK: Output: default@t3 POSTHOOK: Lineage: t2.name SIMPLE [(t1)t1.FieldSchema(name:name, type:string, comment:null), ] PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv2.txt' INTO TABLE T3 PREHOOK: type: LOAD +PREHOOK: Output: default@t3 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv2.txt' INTO TABLE T3 POSTHOOK: type: LOAD POSTHOOK: Output: default@t3 @@ -351,10 +354,10 @@ STAGE PLANS: PREHOOK: query: SELECT COUNT(1) FROM T3 PREHOOK: type: QUERY PREHOOK: Input: default@t3 -PREHOOK: Output: hdfs://localhost.localdomain:38821/data/users/sdong/www/open-source-hive3/build/ql/scratchdir/hive_2011-02-16_23-14-20_069_6368911954239576439/-mr-10000 +PREHOOK: Output: hdfs://localhost.localdomain:48956/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-54-45_062_3900492877877354624/-mr-10000 POSTHOOK: query: SELECT COUNT(1) FROM T3 POSTHOOK: type: QUERY POSTHOOK: Input: default@t3 -POSTHOOK: Output: hdfs://localhost.localdomain:38821/data/users/sdong/www/open-source-hive3/build/ql/scratchdir/hive_2011-02-16_23-14-20_069_6368911954239576439/-mr-10000 +POSTHOOK: Output: hdfs://localhost.localdomain:48956/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-54-45_062_3900492877877354624/-mr-10000 POSTHOOK: Lineage: t2.name SIMPLE [(t1)t1.FieldSchema(name:name, type:string, comment:null), ] 1000