04-30-2018 08:04 AM - last edited on 04-30-2018 02:19 PM by cjervis
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:
05-01-2018 04:33 AM
Related bug reports. Only fixed in V2 and not backported unfortunately.