Return-Path: Delivered-To: apmail-hadoop-hive-commits-archive@minotaur.apache.org Received: (qmail 96470 invoked from network); 9 Mar 2009 07:59:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 9 Mar 2009 07:59:41 -0000 Received: (qmail 62761 invoked by uid 500); 9 Mar 2009 07:59:41 -0000 Delivered-To: apmail-hadoop-hive-commits-archive@hadoop.apache.org Received: (qmail 62738 invoked by uid 500); 9 Mar 2009 07:59:41 -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 Delivered-To: moderator for hive-commits@hadoop.apache.org Received: (qmail 53316 invoked by uid 99); 8 Mar 2009 10:40:42 -0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r751398 - in /hadoop/hive/trunk: CHANGES.txt ql/src/test/queries/clientpositive/udf7.q ql/src/test/results/clientpositive/udf7.q.out Date: Sun, 08 Mar 2009 10:40:21 -0000 To: hive-commits@hadoop.apache.org From: johan@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20090308104021.B99BA23888F4@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Author: johan Date: Sun Mar 8 10:40:21 2009 New Revision: 751398 URL: http://svn.apache.org/viewvc?rev=751398&view=rev Log: HIVE-286. Use round(xxx,12) to make sure there is no precision matching problem in testCliDriver_udf7. (zshao via johan) Modified: hadoop/hive/trunk/CHANGES.txt hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf7.q hadoop/hive/trunk/ql/src/test/results/clientpositive/udf7.q.out Modified: hadoop/hive/trunk/CHANGES.txt URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/CHANGES.txt?rev=751398&r1=751397&r2=751398&view=diff ============================================================================== --- hadoop/hive/trunk/CHANGES.txt (original) +++ hadoop/hive/trunk/CHANGES.txt Sun Mar 8 10:40:21 2009 @@ -19,6 +19,9 @@ HIVE-271. Move test-udfs creation to build-common in order to fix broken 0.17 build. (athusoo) + + HIVE-286. Use round(xxx,12) to make sure there is no precision + matching problem in testCliDriver_udf7. (zshao via johan) Release 0.2.0 - Unreleased Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf7.q URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf7.q?rev=751398&r1=751397&r2=751398&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf7.q (original) +++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf7.q Sun Mar 8 10:40:21 2009 @@ -3,15 +3,16 @@ FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86; EXPLAIN -SELECT LN(3.0), LN(0.0), LN(-1), LOG(3.0), LOG(0.0), LOG(-1), LOG2(3.0), - LOG2(0.0), LOG2(-1), LOG10(3.0), LOG10(0.0), LOG10(-1), LOG(2, 3.0), - LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), EXP(2.0), +SELECT ROUND(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0), + LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1), + ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12), + LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12), POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5), POWER(-1, 0.5), POWER(-1, 2) FROM dest1; -SELECT LN(3.0), LN(0.0), LN(-1), LOG(3.0), LOG(0.0), LOG(-1), LOG2(3.0), - LOG2(0.0), LOG2(-1), LOG10(3.0), LOG10(0.0), LOG10(-1), LOG(2, 3.0), - LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), EXP(2.0), +SELECT ROUND(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0), + LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1), + ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12), + LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12), POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5), POWER(-1, 0.5), POWER(-1, 2) FROM dest1; - Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf7.q.out URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf7.q.out?rev=751398&r1=751397&r2=751398&view=diff ============================================================================== --- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf7.q.out (original) +++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf7.q.out Sun Mar 8 10:40:21 2009 @@ -1,5 +1,5 @@ ABSTRACT SYNTAX TREE: - (TOK_QUERY (TOK_FROM (TOK_TABREF dest1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION LN 3.0)) (TOK_SELEXPR (TOK_FUNCTION LN 0.0)) (TOK_SELEXPR (TOK_FUNCTION LN (- 1))) (TOK_SELEXPR (TOK_FUNCTION LOG 3.0)) (TOK_SELEXPR (TOK_FUNCTION LOG 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG (- 1))) (TOK_SELEXPR (TOK_FUNCTION LOG2 3.0)) (TOK_SELEXPR (TOK_FUNCTION LOG2 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG2 (- 1))) (TOK_SELEXPR (TOK_FUNCTION LOG10 3.0)) (TOK_SELEXPR (TOK_FUNCTION LOG10 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG10 (- 1))) (TOK_SELEXPR (TOK_FUNCTION LOG 2 3.0)) (TOK_SELEXPR (TOK_FUNCTION LOG 2 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG 2 (- 1))) (TOK_SELEXPR (TOK_FUNCTION LOG 0.5 2)) (TOK_SELEXPR (TOK_FUNCTION LOG 2 0.5)) (TOK_SELEXPR (TOK_FUNCTION EXP 2.0)) (TOK_SELEXPR (TOK_FUNCTION POW 2 3)) (TOK_SELEXPR (TOK_FUNCTION POWER 2 3)) (TOK_SELEXPR (TOK_FUNCTION POWER 2 (- 3))) (TOK_SELEXPR (TOK_FUNCTION POWER 0.5 (- 3))) (TOK_SELEXPR (TOK_FUNCTIO N POWER 4 0.5)) (TOK_SELEXPR (TOK_FUNCTION POWER (- 1) 0.5)) (TOK_SELEXPR (TOK_FUNCTION POWER (- 1) 2))))) + (TOK_QUERY (TOK_FROM (TOK_TABREF dest1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION LN 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LN 0.0)) (TOK_SELEXPR (TOK_FUNCTION LN (- 1))) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION LOG 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LOG 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG (- 1))) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION LOG2 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LOG2 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG2 (- 1))) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION LOG10 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LOG10 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG10 (- 1))) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION LOG 2 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LOG 2 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG 2 (- 1))) (TOK_SELEXPR (TOK_FUNCTION LOG 0.5 2)) (TOK_SELEXPR (TOK_FUNCTION LOG 2 0.5)) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION EXP 2.0) 12)) (TOK_SELEXPR (TOK_FUNCTION POW 2 3)) (TOK_SEL EXPR (TOK_FUNCTION POWER 2 3)) (TOK_SELEXPR (TOK_FUNCTION POWER 2 (- 3))) (TOK_SELEXPR (TOK_FUNCTION POWER 0.5 (- 3))) (TOK_SELEXPR (TOK_FUNCTION POWER 4 0.5)) (TOK_SELEXPR (TOK_FUNCTION POWER (- 1) 0.5)) (TOK_SELEXPR (TOK_FUNCTION POWER (- 1) 2))))) STAGE DEPENDENCIES: Stage-1 is a root stage @@ -13,31 +13,31 @@ Select Operator Select Operator expressions: - expr: ln(3.0) + expr: round(ln(3.0), 12) type: double expr: ln(0.0) type: double expr: ln(UDFToDouble(- 1)) type: double - expr: log(3.0) + expr: round(log(3.0), 12) type: double expr: log(0.0) type: double expr: log(UDFToDouble(- 1)) type: double - expr: log2(3.0) + expr: round(log2(3.0), 12) type: double expr: log2(0.0) type: double expr: log2(UDFToDouble(- 1)) type: double - expr: log10(3.0) + expr: round(log10(3.0), 12) type: double expr: log10(0.0) type: double expr: log10(UDFToDouble(- 1)) type: double - expr: log(UDFToDouble(2), 3.0) + expr: round(log(UDFToDouble(2), 3.0), 12) type: double expr: log(UDFToDouble(2), 0.0) type: double @@ -47,7 +47,7 @@ type: double expr: log(UDFToDouble(2), 0.5) type: double - expr: exp(2.0) + expr: round(exp(2.0), 12) type: double expr: pow(UDFToDouble(2), UDFToDouble(3)) type: double @@ -75,4 +75,4 @@ limit: -1 -1.0986122886681098 NULL NULL 1.0986122886681098 NULL NULL 1.5849625007211563 NULL NULL 0.47712125471966244 NULL NULL 1.5849625007211563 NULL NULL NULL -1.0 7.38905609893065 8.0 8.0 0.125 8.0 2.0 NaN 1.0 +1.098612288668 NULL NULL 1.098612288668 NULL NULL 1.584962500721 NULL NULL 0.47712125472 NULL NULL 1.584962500721 NULL NULL NULL -1.0 7.389056098931 8.0 8.0 0.125 8.0 2.0 NaN 1.0