Support Questions

Find answers, ask questions, and share your expertise

ERROR: SELECT query reserved (but escaped) colum name breaks in DESCRIBE

avatar
New Contributor

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

1 ACCEPTED SOLUTION

avatar

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

 

http://www.cloudera.com/content/cloudera/en/documentation/connectors/latest/PDF/Cloudera-JDBC-Driver...

 

View solution in original post

1 REPLY 1

avatar

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

 

http://www.cloudera.com/content/cloudera/en/documentation/connectors/latest/PDF/Cloudera-JDBC-Driver...