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)