You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@carbondata.apache.org by "Jay (JIRA)" <ji...@apache.org> on 2016/08/30 03:37:21 UTC

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

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)