You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@carbondata.apache.org by "Geetika Gupta (JIRA)" <ji...@apache.org> on 2017/01/17 13:20:26 UTC

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

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)