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.

SAP HANA Impala ODBC Connector unable to create remote table

SAP HANA Impala ODBC Connector unable to create remote table

Explorer

Hello experts,

 

I have installed all like in this documentation:

http://blog.cloudera.com/blog/2016/05/how-to-configure-sap-hana-with-apache-impala-incubating/

 

The last tests with "isql" are positive. It is possible to see Impala tables and it also possible to get data (select statement).

 

In HANA Studio I can create with the help of Smart Data Access Impala as remote source and I can see my implala tables.

 

But it is not possible to create remote tables based of these impala tables.

My SQL:

CREATE VIRTUAL TABLE "schema_name"."table_name"

AT "CLIMPALA_NAME"."IMPALA"."IMPALA_NAME"."TABLE_NAME";

 

Error is very generic: Could not execute .... Data receive failed [Connection reset].

 

I get this error even with SYSTEM user.

 

 

 

Thank You!

Stefan