Load data command Quote character unexpected behavior.

Posted by Harmeet on Oct 21, 2016; 7:07am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Load-data-command-Quote-character-unexpected-behavior-tp2145.html

Hey Team,

I am using load data command with specific Quote character. But after loading the data, the behavior of quote character is not working. Below is my example:

create table one (name string, description string, salary double, age int, dob timestamp) stored by 'carbondata';

csf File >>

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;
+-------------------------------------------+--------------+-------+-----------+-------+--+
|                   name                    | description  |  dob  |  salary   |  age  |
+-------------------------------------------+--------------+-------+-----------+-------+--+
| tammy                                     |  $my name$   | NULL  | 900000.0  | 22    |
+-------------------------------------------+--------------+-------+-----------+-------+--+

I am assuming, in description column only "my name" data is loaded and dollars was exclude, but this is not working. The same behavior, if we are using ' (Single Quote) with data.