Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive statement INSERT INTO X VALUES (...) does not escape as expected.

Hive statement INSERT INTO X VALUES (...) does not escape as expected.

New Contributor

A Hive statement of the form below does not seem to escape single quotes as expected. 

 

insert into table x values ('Jim', 'O\'Brien');

 

whereas the following is inserted as expected.

 

insert into table x select 'Jim', 'O\'Brien'; 

 

The former fails for inserts made using the HUE editor and over JDBC with records being inserted as:

 

O\'Brien.

 

 

 

 

 

 

1 REPLY 1

Re: Hive statement INSERT INTO X VALUES (...) does not escape as expected.

New Contributor