- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ERROR: SELECT query reserved (but escaped) colum name breaks in DESCRIBE
Created ‎06-29-2015 09:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'm sending a simple SELECT query using jdbc4 2.5.22 to a table which is named using a reserved key (Symbol).
I've escaped the table name with backticks but the query fails as if it didn;t recognise the escaping.
The error happen not on the SELECT query but on a hidden DESCRIBE query
the error doesn't happen with jdbc3 2.5.5
Created ‎06-29-2015 10:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you try enabling "use native query"? The driver will send the query to Impala verbatim (sometimes the driver may make some changes to the SQL).
Created ‎06-29-2015 10:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you try enabling "use native query"? The driver will send the query to Impala verbatim (sometimes the driver may make some changes to the SQL).
