[jira] [Created] (HIVE-23505) Unable to run HivePreparedStatement with "?" in the column name

["Somesh Dhal (Jira)" <ji...@apache.org>]

Somesh Dhal created HIVE-23505:
----------------------------------

             Summary: Unable to run HivePreparedStatement with "?" in the column name
                 Key: HIVE-23505
                 URL: https://issues.apache.org/jira/browse/HIVE-23505
             Project: Hive
          Issue Type: Bug
         Environment: I am seeing this issue in hive 1.1. Though the version is old, looking at the updatesql code at [https://github.com/apache/hive/blob/master/jdbc/src/java/org/apache/hive/jdbc/HivePreparedStatement.java] it should be reproable in latest versions as well. 

The problem here is that ? is not considered as a literal here but rather as a parameter. 
            Reporter: Somesh Dhal


I have the below table.

hive> desc spc_tbl;
OK
val?ue int

As you can see I have "?" in the column name. While using the HivePreparedStatement with "select `val?ue` from `default`.`spc_tbl`" query the execute query throws below SQLException- "parameter #1 is unset"

Please let me know if there is an workaround to overcome this.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)