Skip to Content
0
Former Member
Jul 06, 2017 at 09:53 AM

SAP Vora: Not able to add Vora table as Virtual table via Smart Data Access in HANA Studio

279 Views Last edit Jul 06, 2017 at 09:54 AM 2 rev

I'm using a VM with HANA Express 2 SP 01. On a small test cluster I installed the Hortonworks Data Platform 2.6 with Spark 1.6.3, and also added HANA Vora 1.4 and the Spark Controller 2.1.

I followed the SAP Vora Installation and Administration guide: https://help.sap.com/http.svc/rc/f09ec811fe634f588647c342cac84c38/1.4/en-US/SAP_Vora_Installation_Admin_Guide_1.4_en.pdf until chapter 2.9. Everything works fine, but the Zeppelin part with the %jdbc interpreter:

%jdbc
select * from sys.tables using com.sap.spark.engines
============================================================

java.lang.NoSuchMethodError: org.apache.hive.service.cli.thrift.TExecuteStatementReq.setQueryTimeout(J)V

Here I get a NoSuchMethodError. However, if I follow the instructions in the next chapter (2.9 Connect SAP HANA Spark Controller to SAP Vora), I'm also not able to add a table from the Vora DataSource to my HANA Express Database. See also this screenshot:

So my questions here are:

- Is there a relation between the Exception I get in Zeppelin and the Smart Data Access problem?

- How to solce this Smart Data Access Problem (I tried to use uppercase / lowercase letters for the table name, no differences, still can't add the table as virtual table)?

Attachments