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
