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

Posted by Akash R Nilugal (Jira) on Jan 17, 2017; 1:20pm
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Created-CARBONDATA-653-Select-query-displays-wrong-data-for-Decimal-38-38-tp6539.html

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)