http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Load-data-command-Quote-character-unexpected-behavior-tp2145p2152.html
described. It returned the right result in my env.
> 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.
>
>
>
> --
> View this message in context:
http://apache-carbondata-> mailing-list-archive.1130556.n5.nabble.com/Load-data-
> command-Quote-character-unexpected-behavior-tp2145.html
> Sent from the Apache CarbonData Mailing List archive mailing list archive
> at Nabble.com.
>