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)

Reply via email to