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.             ... View more

How, exactly, should a single quote ' be escaped in an Hive SQL insert statement?   In the Hive editor in HUE I jave tried \' and 2 single quotes '' which gives the following results when queried so neither of these look to be correct:   35 We Rmyoyi''w Rymih 35 We Rmyoyi\'w Rymih   The JDBC driver (org.apache.hive.jdbc.HivePreparedStatement) is escaping single quotes by doing    public void setString(int parameterIndex, String x) throws SQLException { x=x.replace("'", "\\'"); this.parameters.put(parameterIndex,"'"+x+"'"); }   however this is also results as records being inserted as which is not correct either.   35 We Rmyoyi\'w Rymih ... View more