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

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

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

Akash R Nilugal (Jira)
Harmeet Singh created CARBONDATA-335:
----------------------------------------

             Summary: 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)