You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Mihir Kulkarni (JIRA)" <ji...@apache.org> on 2013/12/10 00:26:06 UTC
[jira] [Created] (HIVE-5990) round() function with large scale
chokes
Mihir Kulkarni created HIVE-5990:
------------------------------------
Summary: round() function with large scale chokes
Key: HIVE-5990
URL: https://issues.apache.org/jira/browse/HIVE-5990
Project: Hive
Issue Type: Bug
Components: Query Processor, UDF
Affects Versions: 0.9.0
Environment: CDH 4.2 running Hive 0.9
Reporter: Mihir Kulkarni
ROUND(4.42330604244772E-305, 2000000000) chokes with following error:
FAILED: SemanticException [Error 10014]: Line 1:7 Wrong arguments '2000000000': org.apache.hadoop.hive.ql.metadata.HiveException: Unable to execute method public org.apache.hadoop.hive.serde2.io.DoubleWritable org.apache.hadoop.hive.ql.udf.UDFRound.evaluate(org.apache.hadoop.hive.serde2.io.DoubleWritable,org.apache.hadoop.io.IntWritable) on object org.apache.hadoop.hive.ql.udf.UDFRound@51809ab7 of class org.apache.hadoop.hive.ql.udf.UDFRound with arguments {1.001:org.apache.hadoop.hive.serde2.io.DoubleWritable, 2000000000:org.apache.hadoop.io.IntWritable} of size 2
I think the problem might be in how Hive evaluates 2 arg ROUND(). The code uses
BigDecimal.valueOf(d).setScale(i, RoundingMode.HALF_UP)
which chokes by itself. I saw some changes in implementation of ROUND in hive trunk but this is still being used in RoundUtils.
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)