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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Akash R Nilugal (Jira)

    [ 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)