hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark Grover (JIRA)" <>
Subject [jira] [Created] (HIVE-4174) Round UDF converts BigInts to double
Date Thu, 14 Mar 2013 14:18:13 GMT
Mark Grover created HIVE-4174:

             Summary: Round UDF converts BigInts to double
                 Key: HIVE-4174
             Project: Hive
          Issue Type: Bug
          Components: UDF
    Affects Versions: 0.10.0
            Reporter: Mark Grover
            Assignee: Mark Grover
             Fix For: 0.11.0

Chen Chun pointed out on the hive-user mailing list that round() in Hive 0.10 returns
select round(cast(1234560 as BIGINT)), round(cast(12345670 as BIGINT)) from test limit 1;

//hive 0.10
1234560.0  1.234567E7

This is not consistent with MySQL(

which quotes
The return type is the same type as that of the first argument (assuming that it is integer,
double, or decimal). This means that for an integer argument, the result is an integer (no
decimal places)

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message