carbondata-issues mailing list archives

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

             Summary: 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
            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