carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jatin (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (CARBONDATA-1220) Decimal values are not displayed correctly in presto
Date Fri, 23 Jun 2017 10:42:00 GMT

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

Jatin reassigned CARBONDATA-1220:
---------------------------------

    Assignee: Jatin

> 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
>
>
> 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)

Mime
View raw message