hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fred Desing (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-4523) round() function with specified decimal places not consistent with mysql
Date Wed, 08 May 2013 16:23:15 GMT
Fred Desing created HIVE-4523:
---------------------------------

             Summary: round() function with specified decimal places not consistent with mysql

                 Key: HIVE-4523
                 URL: https://issues.apache.org/jira/browse/HIVE-4523
             Project: Hive
          Issue Type: Improvement
          Components: UDF
    Affects Versions: 0.7.1
            Reporter: Fred Desing
            Priority: Minor


// hive
hive> select round(150.00, 2) from temp limit 1;
150.0

hive> select round(150, 2) from temp limit 1;
150.0

// mysql
mysql> select round(150.00, 2) from DUAL limit 1;
round(150.00, 2)
150.00

mysql> select round(150, 2) from DUAL limit 1;
round(150, 2)
150


--
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: http://www.atlassian.com/software/jira

Mime
View raw message