You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "David Scarlatti (JIRA)" <ji...@apache.org> on 2017/10/06 10:32:00 UTC

[jira] [Created] (HIVE-17724) Cast from string to float gives strange result

David Scarlatti created HIVE-17724:
--------------------------------------

             Summary: Cast from string to float gives strange result
                 Key: HIVE-17724
                 URL: https://issues.apache.org/jira/browse/HIVE-17724
             Project: Hive
          Issue Type: Bug
    Affects Versions: 1.1.0
         Environment: Hive 1.1.0-cdh5.10.0
Subversion file:///data0/jenkins/workspace/generic-package-ubuntu64-14-04/CDH5.10.0-Packaging-Hive-2017-01-20_11-52-43/hive-1.1.0+cdh5.10.0+859-1.cdh5.10.0.p0.71~trusty -r Unknown

            Reporter: David Scarlatti


this query:"select CAST ('1507284611' as int), CAST ('1507284611' as bigint),  CAST ('1507284611' as float),   CAST ('1507284611' as double),   CAST ('1507284611' as decimal)"
returns
1507284611	1507284611	1507284608	1507284611	1507284611

cast as float is the only one changing the numeric value.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)