SAP Knowledge Base Article - Preview

2396577 - Cannot Add Hadoop Objects As HANA Virtual Tables

Symptom

Supported version of Spark Controller is configured correctly for Smart Data Access remote source with "SPARK SQL" as adapter type, HIVE or HANA Vora is used as remote datasource. When adding tables from this remote source to HANA, the operation failed with error:

"SAP DBTech JDBC: [476]: invalid remote object name: Unable to retrieve remote metadata for <NULL>.<NULL>.SparkSQL.<remote_source_name>.<table_name>: line 0 col 0 (at pos0)"

 

HANA indexserver trace shows error:

e FedTrace         SparkSQLAccess.cpp(03047) : SparkSQLAccess::GetColumnInfo: failed with error: java.lang.NullPointerException
    at org.apache.spark.sql.hive.hana.HanaSQLContext.getTableMetaNew(HanaSQLContext.scala:347)
    at com.sap.hana.spark.network.CommandHandler.handleMessage(CommandRouter.scala:516)
    at com.sap.hana.spark.network.CommandHandler$$anonfun$receive$2$$anon$1.run(CommandRouter.scala:272)


Spark Controller log shows similar error:

ERROR CommandHandler:
java.lang.NullPointerException
     at org.apache.spark.sql.hive.hana.HanaSQLContext.getTableMetaNew(HanaSQLContext.scala:347)
     at com.sap.hana.spark.network.CommandHandler.handleMessage(CommandRouter.scala:516)
     at com.sap.hana.spark.network.CommandHandler$$anonfun$receive$2$$anon$1.run(CommandRouter.scala:272)

Read more...

Environment

  • SAP HANA 1.0
  • Spark Controller
  • HIVE or SAP HANA Vora

Product

SAP HANA 1.0, platform edition

Keywords

Hive, HANA Vora, SDA , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , EIM-VO , SAP Vora , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.