Escaping Single Quote in Hive

[#1]

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

[#2]

@Alan-H

There could be different ways, but I tried the below steps and it is working for me

Step1: using select class with hardcoded value

create table default.mytest(col1 string, col2 int);
insert into default.mytest
select 'For testing single quote\'s', 1;
insert into default.mytest
select 'For testing double quote\"s', 2;

select * from default.mytest;

Step2: using select class by passing value in parameter

set hivevar:col1 = 'For testing single quote\'s';
set hivevar:col2 = 3;

insert into default.mytest
select ${hivevar:col1}, ${hivevar:col2};

select * from default.mytest;

Step3: using select class by passing value in parameter

set hivevar:col1 = 'For testing double quote\"s';
set hivevar:col2 = 4;

insert into default.mytest
select ${hivevar:col1}, ${hivevar:col2};

select * from default.mytest;

Step4:

drop table default.mytest;

[#3]

Any idea why 

insert into default.mytest
select 'For testing single quote\'s', 1;

works and 

insert into default.mytest
values ('For testing single quote\'s', 1);

doesn't work? 

[#4]

Related bug reports. Only fixed in V2 and not backported unfortunately.

https://issues.apache.org/jira/browse/HIVE-17358?jql=project%20%3D%20HIVE%20AND%20text%20~%20%22inse...

https://issues.apache.org/jira/browse/HIVE-11723?jql=project%20%3D%20HIVE%20AND%20text%20~%20%22inse...