Skip to Content

Working with SAP HANA data source

test
0 %
Working with SAP HANA data source
Details
// Explore More Tutorials

Working with SAP HANA data source

The SAP HANA data source provides a pluggable mechanism for accessing data stored in SAP HANA from a Spark-based environment through Spark SQL (SAP Vora 1.4).

You will learn

You will learn how to connect to SAP HANA database as a data source and create a SAP Vora table with SAP HANA data. The SAP HANA data source supports read and write access from SAP Vora to SAP HANA.


Step 1: Listing tables from SAP HANA

To list tables from SAP HANA in SAP Vora 1.4 run the following query.

SHOW TABLES USING com.sap.spark.hana
OPTIONS (
    host "hanahost",
    instance "00",
    user "VORAUSER",
    passwd "somepassword",
    tenantdatabase "SYSTEMDB",
    dbschema "SYS",
    tablepattern "%"
);
List HANA tables
Step 2: Create Vora table from HANA data source

To reflect an SAP HANA table in the Spark session catalog, you can use a CREATE TABLE statement that references an existing SAP HANA table. The table metadata is copied from the SAP HANA catalog into the Spark session catalog. The table in SAP HANA has to exist prior to importing it into SAP HANA Vora.

You can also create new tables in SAP HANA using the CREATE TABLE command. A prerequisite is that the table does not yet exist in SAP HANA.

You need to provide a table name, the fully qualified name of the SAP HANA data source package com.sap.spark.hana, and a set of options required by the data source.

--DROP TABLE IF EXISTS HANADATA;
CREATE TABLE HANADATA
USING com.sap.spark.hana
OPTIONS (
    host "hanahost",
    instance "00",
    user "VORAUSER",
    passwd "Welcome17",
    tenantdatabase "SYSTEMDB",
    dbschema "SYS",
    tablepath "DUMMY"
);
Create table from HANA data source

Now you can query the table.

SELECT * FROM HANADATA;
Query table from HANA data source

Next Steps

Next Steps

Back to top