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)

Reply via email to