question How to accommodate special character '?' in a column name in Hive in Support Questions

How to accommodate special character '?' in a column name in Hive

ep — Tue, 28 Jan 2020 12:32:58 GMT

I have a query where as per the requirement the column name should be 'abc xyz?'. I am using tilted quotes to accommodate the space and special characters in between column name but i am getting the below error with '?':

Parameters cannot be used with normal Statement objects, use PreparedStatements instead.

I am using SQL Workbench for connecting to Hive.

Re: How to accommodate special character '?' in a column name in Hive

stevenmatison — Tue, 28 Jan 2020 12:57:36 GMT

I would highly recommend to not use special characters in columns names. Per documentation hive .13 (link) `column?name` should work with Hive, however, there is no gauruntee that other clients, including SQL Workbench will allow this when the special character can be considered a code like character ($ % & ? " , . etc)

Re: How to accommodate special character '?' in a column name in Hive

ep — Wed, 29 Jan 2020 11:15:09 GMT

Thankyou Steven 🙂