hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: Escaped Quotes
Date Wed, 30 Mar 2016 20:44:06 GMT
Curious to know why use JDBC and beeline to insert into Hive table rather
than using Hive sql through beeline

create table testme(col1 varchar(30));
INSERT INTO testme VALUES ("Dougs' Diner");
0: jdbc:hive2://rhes564:10010/default> select * from testme;
+---------------+--+
|  testme.col1  |
+---------------+--+
| Dougs' Diner  |
+---------------+--+


Dr Mich Talebzadeh



LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*



http://talebzadehmich.wordpress.com



On 30 March 2016 at 19:15, Douglas Rapp <dougman82@gmail.com> wrote:

> Hi,
>
> I use JDBC and the beeline client to interact with a Hive 1.2.1 store.
>
> I have some string data that contains single quotes (as well as other
> special characters) that requires being escaped in order to be inserted
> into my tables. For example, the string "Doug's Diner":
>
> INSERT INTO my_table (some_col) VALUES ('Doug\'s Diner')
>
> What I am finding is that the single quote inside the string data is not
> merely escaped to get through the interface, but the escape character
> itself (the backslash) is also getting stored as part of the string. In
> other words, when I select the data out of my_table, I get "Doug\'s Diner"
> rather than "Doug's Diner".
>
> Is this expected behavior with Hive?
>
> Thanks,
> Doug
>

Mime
View raw message