Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Explorer

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

avatar
Explorer