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)