[jira] [Created] (CARBONDATA-653) Select query displays wrong data for Decimal(38,38)

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

[jira] [Created] (CARBONDATA-653) Select query displays wrong data for Decimal(38,38)

Akash R Nilugal (Jira)
Geetika Gupta created CARBONDATA-653:
----------------------------------------

             Summary: Select query displays wrong data for Decimal(38,38)
                 Key: CARBONDATA-653
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-653
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
    Affects Versions: 1.0.0-incubating
         Environment: spark 1.6
            Reporter: Geetika Gupta
         Attachments: Screenshot from 2017-01-17 18-48-43.png, testMaxDigitsAfterDecimal.csv

I tried to load data into a table having decimal(38,38) as a column. The data-load was successful, but when I displayed the data, there was some wrong data present in the table.

Below are the queries:

create table testDecimal(a decimal(38,38), b String) stored by 'carbondata';

LOAD DATA INPATH 'hdfs://localhost:54311/testFiles/testMaxDigitsAfterDecimal.csv' into table testDecimal OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','FILEHEADER'='a,b');

select * from testDecimal;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)