Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Connecting from SQL Server to Impala

Highlighted

Connecting from SQL Server to Impala

Rising Star

I have installed Impala ODBC driver and tried to query Imapala tables, failed with this error.

 

OLE DB provider "MSDASQL" for linked server "IMPALA" returned message "[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala

 

The linked server works fine, test connectivity is succsefull, Imapala driver correctly fetches the list of tables, but when I query

select * from Impala.Impala.[default].my_table  or select count(*) from Impala.Impala.[default].my_table it fails with this error:

 

OLE DB provider "MSDASQL" for linked server "IMPALA" returned message "[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Syntax error in line 1:
select * from `Impala`.`default`.`rtp2sms_hive`
^
Encountered: .
Expected: ADD, AS, CACHED, CHANGE, COMMENT, CROSS, DROP, FROM, FULL, GROUP, HAVING, INNER, JOIN, LEFT, LIKE, LIMIT, LOCATION, OFFSET, ON, ORDER, PARTITION, PARTITIONED, RENAME, REPLACE, RIGHT, ROW, SELECT, SET, STORED, STRAIGHT_JOIN, TBLPROPERTIES, TO, UNCACHED, UNION, USING, VALUES, WHERE,".
Msg 7306, Level 16, State 2, Line 1
Cannot open the table "`Impala`.`default`.`rtp2sms_hive`" from OLE DB provider "MSDASQL" for linked server "IMPALA".

Don't have an account?
Coming from Hortonworks? Activate your account here