carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CARBONDATA-191) load data is null when quote char is single and no '\n' being end.
Date Thu, 01 Sep 2016 07:32:21 GMT

    [ https://issues.apache.org/jira/browse/CARBONDATA-191?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15454618#comment-15454618
] 

ASF GitHub Bot commented on CARBONDATA-191:
-------------------------------------------

Github user asfgit closed the pull request at:

    https://github.com/apache/incubator-carbondata/pull/107


> 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 new line 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"
> 2,"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)

Mime
View raw message