carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harmeet Singh (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CARBONDATA-335) Load data command options 'QUOTECHAR' perform unexpected behavior.
Date Fri, 21 Oct 2016 11:17:58 GMT
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)

Mime
View raw message