[jira] [Closed] (CARBONDATA-335) Load data command options 'QUOTECHAR' perform unexpected behavior.

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-335?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Harmeet Singh closed CARBONDATA-335.
------------------------------------
    Resolution: Fixed

FIXED

> Load data command options 'QUOTECHAR' perform unexpected behavior.
> -------------------------------------------------------------------
>
>                 Key: CARBONDATA-335
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-335
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: Harmeet Singh
>
> Hey Team,
> I am using load data command with specific 'QUOTECHAR' option. But after loading the data, the behavior of quote character is not working as expected. Below is my example:
> create table one (name string, description string, salary double, age int, dob timestamp) stored by 'carbondata';
> CSV File Content >>
> name, description, salary, age, dob
> tammy, $my name$, 900000, 22, 19/10/2019
> 0: jdbc:hive2://127.0.0.1:10000> load data local inpath 'hdfs://localhost:54310/home/harmeet/dollarquote.csv' into table one OPTIONS('QUOTECHAR'="$");
> Results >>
> 0: jdbc:hive2://127.0.0.1:10000> select * from one;
> Actual Output >>>
>  -------+-----------+-------+--+
> | tammy                                     |  $my name$   | NULL  | 900000.0  | 22    |
> -------------------------------------------+--------------+
>  
> Expected Output >>>
>  -------+-----------+-------+--+
> | tammy                                     |  my name   | NULL  | 900000.0  | 22    |
> -------------------------------------------+--------------+

--
This message was sent by Atlassian JIRA
(v6.3.4#6332)