Reply
Explorer
Posts: 7
Registered: ‎09-07-2018

SAP HANA Impala ODBC Connector unable to create remote table

[ Edited ]

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

Announcements