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

Posted by Akash R Nilugal (Jira) on Sep 01, 2016; 7:36am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Resolved-CARBONDATA-191-load-data-is-null-when-quote-char-is-single-and-no-n-being-end-tp638.html


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