question obtain error while connecting to Impala via Power Query in Archives of Support Questions (Read Only)

obtain error while connecting to Impala via Power Query

Yumi — Fri, 16 Sep 2022 09:21:30 GMT

I am trying connecting to Database using Cloudera ODBC Driver for Impala by a connection string runing in Power Query, however it does not work, my connection string like follow

DRIVER={Cloudera ODBC Driver for Impala};Host=192.168.123.14;Port=21050;Schema=default;DefaultTable=default;AuthMech=0;TrustedCerts=C:\Program Files\Cloudera ODBC Driver for Impala\lib\cacerts.pem;

,and the like follow

DataSource.Error: ODBC: ERROR [HY000] [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : Error: Error: could not match input

Message=ERROR [HY000] [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : Error: Error: could not match input ErrorCode=-2146232009.

Can someone help me to revise it? Thanks!

Re: obtain error while connecting to Impala via Power Query

alex.behm — Thu, 12 Feb 2015 06:54:30 GMT

The error sounds like the ODBC connection was successful, but the Impala query failed to parse.

A common issue is sending a SQL string that is terminated by a semicolon. Impala cannot parse such a query. Remove the trailing semicolon to make it work.

Future versions of Impala will also accept a trailing semicolon.

Let me know if this olves ths issue

Re: obtain error while connecting to Impala via Power Query

Yumi — Thu, 12 Feb 2015 07:28:56 GMT

Thanks for you kindly help, it works!