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] [Closed] (CARBONDATA-335) Load data command options 'QUOTECHAR' perform unexpected behavior.
Date Mon, 19 Dec 2016 06:25:58 GMT

     [ 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)

Mime
View raw message