Posted by
Akash R Nilugal (Jira) on
Oct 21, 2016; 11:17am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Created-CARBONDATA-335-Load-data-command-options-QUOTECHAR-perform-unexpected-behavior-tp2167.html
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)