Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]
Created on
01-28-2020
03:57 AM
- last edited on
01-28-2020
04:32 AM
by
ask_bill_brooks
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.
Created 01-28-2020 04:57 AM
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)
Created 01-28-2020 04:57 AM
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)
Created 01-29-2020 03:15 AM
Thankyou Steven 🙂