[jira] [Created] (CARBONDATA-191) load data is null when quote char is single and no '\n' being end.

Posted by Akash R Nilugal (Jira) on Aug 30, 2016; 3:37am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Created-CARBONDATA-191-load-data-is-null-when-quote-char-is-single-and-no-n-being-end-tp553.html

Jay created CARBONDATA-191:
------------------------------

             Summary: load data is null when quote char is single and no '\n' being end.
                 Key: CARBONDATA-191
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-191
             Project: CarbonData
          Issue Type: Bug
            Reporter: Jay
            Priority: Minor


when load data just like below,
CREATE TABLE Priyal11 (id int,name string) STORED BY 'org.apache.carbondata.format';

LOAD DATA inpath 'hdfs://hacluster/Priyal1/test34.csv' INTO table Priyal11  options ('DELIMITER'=',', 'QUOTECHAR'='\"', 'FILEHEADER'='id,name');

and test34.csv is like below(note: there is no '\n' in the end of file.):
1,"priyal\"
2,"hello\"

then query  name's result is null. Actually, because of the existence of quote char. the expected result should be
|prival"
6,"hello"|
and if we add new line in the end of file, then query is right.





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