[jira] [Resolved] (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] [Resolved] (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:all-tabpanel ]

Venkata Ramana G resolved CARBONDATA-191.
-----------------------------------------
       Resolution: Fixed
         Assignee: Jay
    Fix Version/s: 0.2.0-incubating

> 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
>            Assignee: Jay
>            Priority: Minor
>             Fix For: 0.2.0-incubating
>
>
> 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)