question ERROR: SELECT query reserved (but escaped) colum name breaks in DESCRIBE in Archives of Support Questions (Read Only) https://community.cloudera.com/t5/Archives-of-Support-Questions/ERROR-SELECT-query-reserved-but-escaped-colum-name-breaks-in/m-p/29082#M6425 <P>I'm sending a simple SELECT query using jdbc4 2.5.22 to a table which is named using a reserved key (Symbol).</P><P>I've escaped the table name with backticks but the query fails as if it didn;t recognise the escaping.</P><P>&nbsp;</P><P>The error happen not on the SELECT query but on a hidden DESCRIBE query</P><P>the error doesn't happen with&nbsp;jdbc3 2.5.5</P> Mon, 29 Jun 2015 16:25:10 GMT Ermes 2015-06-29T16:25:10Z ERROR: SELECT query reserved (but escaped) colum name breaks in DESCRIBE https://community.cloudera.com/t5/Archives-of-Support-Questions/ERROR-SELECT-query-reserved-but-escaped-colum-name-breaks-in/m-p/29082#M6425 <P>I'm sending a simple SELECT query using jdbc4 2.5.22 to a table which is named using a reserved key (Symbol).</P><P>I've escaped the table name with backticks but the query fails as if it didn;t recognise the escaping.</P><P>&nbsp;</P><P>The error happen not on the SELECT query but on a hidden DESCRIBE query</P><P>the error doesn't happen with&nbsp;jdbc3 2.5.5</P> Mon, 29 Jun 2015 16:25:10 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/ERROR-SELECT-query-reserved-but-escaped-colum-name-breaks-in/m-p/29082#M6425 Ermes 2015-06-29T16:25:10Z Re: ERROR: SELECT query reserved (but escaped) colum name breaks in DESCRIBE https://community.cloudera.com/t5/Archives-of-Support-Questions/ERROR-SELECT-query-reserved-but-escaped-colum-name-breaks-in/m-p/29083#M6426 <P>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).</P><P>&nbsp;</P><P><A href="http://www.cloudera.com/content/cloudera/en/documentation/connectors/latest/PDF/Cloudera-JDBC-Driver-for-Impala-Install-Guide.pdf" target="_blank">http://www.cloudera.com/content/cloudera/en/documentation/connectors/latest/PDF/Cloudera-JDBC-Driver-for-Impala-Install-Guide.pdf</A></P><P>&nbsp;</P> Mon, 29 Jun 2015 17:48:39 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/ERROR-SELECT-query-reserved-but-escaped-colum-name-breaks-in/m-p/29083#M6426 alex.behm 2015-06-29T17:48:39Z