[jira] [Commented] (IMPALA-7884) double values not getting loaded correctly in impala

["prasad (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IMPALA-7884?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16697487#comment-16697487 ] 

prasad commented on IMPALA-7884:
--------------------------------

Hi tim,

 

when i insert 100.1 it is taking as it is .But if it is 158.17 the problem is 

 

May i know for one value why is taking as it is and why not for second?

> double values not getting loaded correctly in impala
> ----------------------------------------------------
>
>                 Key: IMPALA-7884
>                 URL: https://issues.apache.org/jira/browse/IMPALA-7884
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>         Environment: impala
>            Reporter: prasad
>            Priority: Major
>
>  
> I have created a simple table in impala like below
>  
> {{ CREATE TABLE IF NOT EXISTS my_db.employee (name STRING, salary double );}}
> And my insert statement is like below
>  
> {{insert into employee (name,salary) VALUES ("Prasad",158.17)}}
> But the problem is
> My values in impala is getting loaded as
> {{name,salary }}
> {{prasad,158.1666666666}}
> {{ I dont understand why this is happening. I have tried in other db's like hive but the value is getting loaded as 158.17 but in impala it is 158.1666666666}}
> Can you please help me why this is happening ...
> And how to load actual values...
> Please guide me
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org