[jira] [Closed] (CARBONDATA-1220) Decimal values are not displayed correctly in presto

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-1220?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Geetika Gupta closed CARBONDATA-1220.
-------------------------------------
    Resolution: Fixed

> Decimal values are not displayed correctly in presto
> ----------------------------------------------------
>
>                 Key: CARBONDATA-1220
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1220
>             Project: CarbonData
>          Issue Type: Bug
>          Components: presto-integration
>            Reporter: Geetika Gupta
>            Assignee: Jatin
>            Priority: Minor
>         Attachments: decimaldata.csv
>
>          Time Spent: 2h 40m
>  Remaining Estimate: 0h
>
> I created a table in carbondata having decimal values, when I tried to display all the rows in presto, the scale of the values gets changed.
> Below are the details of the query:
> Create table in carbondata:
> create table decimalOperatorCheck(name String, ids Decimal(10,2)) stored by 'carbondata';
> Load data:
> load data inpath 'hdfs://localhost:54311/testFiles/decimaldata.csv' into table decimalOperatorCheck options('delimiter'=',','fileheader'='name,ids');
> Output in Carbondata:
> 0: jdbc:hive2://localhost:10000> select * from decimaloperatorcheck;
> +---------+-----------+--+
> |  name   |    ids    |
> +---------+-----------+--+
> | Alex    | 123.45    |
> | Josh    | 233.34    |
> | Justin  | 11.90     |
> | Ryan    | 12345.56  |
> | name    | NULL      |
> +---------+-----------+--+
> 5 rows selected (21.983 seconds)
> Output in presto:
> presto:sparkdata> select * from decimaloperatorcheck;
>   name  |  ids  
> --------+--------
>  Alex   | 1.23  
>  Josh   | 2.33  
>  Justin | 0.12  
>  Ryan   | 123.46
>  name   | NULL  
> (5 rows)

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