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

["David Mollitor (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-23505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Mollitor updated HIVE-23505:
----------------------------------
    Affects Version/s: 4.0.0
                       1.2.0
                       1.1.1
                       2.2.0
                       3.1.2

> 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
>    Affects Versions: 1.2.0, 1.1.1, 2.2.0, 4.0.0, 3.1.2
>         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
>            Assignee: David Mollitor
>            Priority: Major
>
> 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)