01-15-2019 08:18 AM - edited 01-15-2019 08:20 AM
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