SAP HANA Vora 1.2:无法在HANA Studio中作为虚拟表加载 [英] SAP HANA Vora 1.2 : Cannot load as virtual table in HANA Studio

问题描述

在SAP HANA Vora 1.2 Dev Edition中:我已经配置了Spark Controller并启动了服务器.然后，我运行spark-shell并创建一个新表.现在，在SAP HANA Studio中，我可以看到其中创建的文件夹"spark_velocity"和"table001".当我尝试使用添加为虚拟表"选项将此表添加到我的HANA文件夹时，收到错误消息:

In SAP HANA Vora 1.2 Dev Edition: I've configured the Spark Controller and started server. Then I run the spark-shell and created a new table. In SAP HANA Studio i can see now folder "spark_velocity" and "table001" in it, which I created. When I try to add this table my HANA folder with "Add as Virtual Table" option I receive an error:

SAP DBTech JDBC:[476]:无效的远程对象名称:无法检索 的远程元数据 SparkSQL.spark_velocity.SparkSQL.spark_velocity.table001:第0行第0行 (在pos 0)

SAP DBTech JDBC: [476]: invalid remote object name: Unable to retrieve remote metadata for SparkSQL.spark_velocity.SparkSQL.spark_velocity.table001: line 0 col 0 (at pos 0)

这是完整的例外情况:

com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [476]: invalid remote object name: Unable to retrieve remote metadata for SparkSQL.spark_velocity.SparkSQL.spark_velocity.table001: line 0 col 0 (at pos 0)
    at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:345)
    at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:185)
    at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:102)
    at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1031)
    at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:820)
    at com.sap.db.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:898)
    at com.sap.db.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:947)
    at com.sap.db.jdbc.StatementSapDB.execute(StatementSapDB.java:256)
    at com.sap.db.jdbc.StatementSapDB.executeUpdate(StatementSapDB.java:417)
    at com.sap.db.jdbc.trace.Statement.executeUpdate(Statement.java:218)
    at com.sap.ndb.studio.federation.services.ds.impl.sql.FederationSQLService.executeUpdate(FederationSQLService.java:212)
    at com.sap.ndb.studio.federation.services.ds.impl.sql.FederationSQLService.createProxyTable(FederationSQLService.java:1156)
    at com.sap.ndb.studio.federation.services.ds.impl.sql.DataProvisioningService.createProxyTable(DataProvisioningService.java:421)
    at com.sap.ndb.studio.federation.catalog.job.AddAsProxyJob.run(AddAsProxyJob.java:135)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

推荐答案

使用不兼容的版本时，我已经看到了此问题.对于Vora 1.2，您需要Spark Controller 1.5补丁5(HANASPARKCTRL00P_5-70001262.RPM)和HANA SPS11.还要确保使用Vora1.2数据源jar(spark-sap-datasources-1.2.33-assembly.jar)配置Spark控制器.

I have seen this issue when incompatible versions were used. With Vora 1.2 you need Spark Controller 1.5 Patch 5 (HANASPARKCTRL00P_5-70001262.RPM) and HANA SPS11. Also make sure to configure the Spark Controller with the Vora1.2 datasources jar (spark-sap-datasources-1.2.33-assembly.jar).

这篇关于SAP HANA Vora 1.2:无法在HANA Studio中作为虚拟表加载的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！