Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Fri, 15 Jun 2012 20:59:42 +0000 (UTC)
From: "Carl Steinbach (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <1676976855.20079.1339793982498.JavaMail.jiratomcat@issues-vm>
In-Reply-To: 
 <1003247859.13021.1328671150128.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Reopened] (HIVE-2790) Grouping on constant expressions is
 broken on 0.23
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/HIVE-2790?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:all-tabpanel ]

Carl Steinbach reopened HIVE-2790:
----------------------------------

   =20
> Grouping on constant expressions is broken on 0.23
> --------------------------------------------------
>
>                 Key: HIVE-2790
>                 URL: https://issues.apache.org/jira/browse/HIVE-2790
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Zhenxiao Luo
>            Assignee: Zhenxiao Luo
>
> Query result(-30.33) is missing in the running output:
> [junit] Begin query: groupby_neg_float.q
> [junit] 12/01/24 10:57:53 WARN conf.Configuration: mapred.system.dir is d=
eprecated. Instead, use mapreduce.jobtracker.system.dir
> [junit] 12/01/24 10:57:53 WARN conf.Configuration: mapred.local.dir is de=
precated. Instead, use mapreduce.cluster.local.dir
> [junit] 12/01/24 10:57:58 WARN conf.Configuration: mapred.system.dir is d=
eprecated. Instead, use mapreduce.jobtracker.system.dir
> [junit] 12/01/24 10:57:58 WARN conf.Configuration: mapred.local.dir is de=
precated. Instead, use mapreduce.cluster.local.dir
> [junit] diff -a -I file: -I pfile: -I hdfs: -I /tmp/ -I invalidscheme: -I=
 lastUpdateTime -I lastAccessTime -I [Oo]wner -I CreateTime -I LastAccessTi=
me -I Location -I LOCATION ' -I transient_lastDdlTime -I last_modified_ -I =
java.lang.RuntimeException -I at org -I at sun -I at java -I at junit -I Ca=
used by: -I LOCK_QUERYID: -I LOCK_TIME: -I grantTime -I [.][.][.] [0-9]* mo=
re -I job_[0-9]*_[0-9]* -I USING 'java -cp /home/cloudera/Code/hive/build/q=
l/test/logs/clientpositive/groupby_neg_float.q.out /home/cloudera/Code/hive=
/ql/src/test/results/clientpositive/groupby_neg_float.q.out
> [junit] 14c14,15
> [junit] < POSTHOOK: Output: file:/tmp/cloudera/hive_2012-01-24_10-57-51_6=
52_2049459353574360528/-mr-10000
> [junit] =E2=80=94
> [junit] > POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/t=
mp/815331462/10000
> [junit] > -30.33
> [junit] 28c29,30
> [junit] < POSTHOOK: Output: file:/tmp/cloudera/hive_2012-01-24_10-57-56_9=
09_7738265803221872068/-mr-10000
> [junit] =E2=80=94
> [junit] > POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/t=
mp/2082702070/10000
> [junit] junit.framework.AssertionFailedError: Client execution results fa=
iled with error code =3D 1
> [junit] See build/ql/tmp/hive.log, or try "ant test ... -Dtest.silent=3Df=
alse" to get more logs.
> [junit] at junit.framework.Assert.fail(Assert.java:50)
> [junit] at org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_groupby=
_neg_float(TestCliDriver.java:129)
> [junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [junit] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess=
orImpl.java:57)
> [junit] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth=
odAccessorImpl.java:43)
> [junit] at java.lang.reflect.Method.invoke(Method.java:616)
> [junit] at junit.framework.TestCase.runTest(TestCase.java:168)
> [junit] at junit.framework.TestCase.runBare(TestCase.java:134)
> [junit] at junit.framework.TestResult$1.protect(TestResult.java:110)
> [junit] at junit.framework.TestResult.runProtected(TestResult.java:128)
> [junit] at junit.framework.TestResult.run(TestResult.java:113)
> [junit] at junit.framework.TestCase.run(TestCase.java:124)
> [junit] at junit.framework.TestSuite.runTest(TestSuite.java:243)
> [junit] at junit.framework.TestSuite.run(TestSuite.java:238)
> [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.r=
un(JUnitTestRunner.java:420)
> [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.l=
aunch(JUnitTestRunner.java:911)
> [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.m=
ain(JUnitTestRunner.java:768)
> [junit] Exception: Client execution results failed with error code =3D 1
> [junit] See build/ql/tmp/hive.log, or try "ant test ... -Dtest.silent=3Df=
alse" to get more logs.
> [junit] > -30.33
> [junit] See build/ql/tmp/hive.log, or try "ant test ... -Dtest.silent=3Df=
alse" to get more logs.)
> When trying the following(GROUP BY on Floating Point type and string type=
):
> FROM src
> SELECT -30.33
> GROUP BY -30.33
> LIMIT 1;
> FROM src
> SELECT '-30.33'
> GROUP BY '-30.33'
> LIMIT 1;
> Get NULL in result

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrato=
rs: https://issues.apache.org/jira/secure/ContactAdministrators!default.jsp=
a
For more information on JIRA, see: http://www.atlassian.com/software/jira