Reply
New Contributor
Posts: 7
Registered: ‎04-26-2018

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

[ Edited ]

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.

 

 

 

 

 

 

New Contributor
Posts: 7
Registered: ‎04-26-2018

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

Announcements