question Hive statement INSERT INTO X VALUES (...) does not escape as expected. in Support Questions

question Hive statement INSERT INTO X VALUES (...) does not escape as expected. in Support Questions https://community.cloudera.com/t5/Support-Questions/Hive-statement-INSERT-INTO-X-VALUES-does-not-escape-as/m-p/66828#M4276 A Hive statement of the form below does not seem to escape single quotes as expected.    <PRE>insert into table x values ('Jim', 'O\'Brien');</PRE>   whereas the following is inserted as expected.   <PRE>insert into table x select 'Jim', 'O\'Brien'; </PRE>   The former fails for inserts made using the HUE editor and over JDBC with records being inserted as:   O\'Brien.             Fri, 16 Sep 2022 13:09:45 GMT Alan-H 2022-09-16T13:09:45Z