[
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)
