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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Akash R Nilugal (Jira)
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)