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)