Import CSV into SAP HANA, express edition using IMPORT FROM SQL command
2018-09-10
You will learn
In this tutorial, you will learn how to use the IMPORT FROM SQL command and load data set files to your SAP HANA, express edition.
The IMPORT FROM SQL command requires the files to be physically located on your SAP HANA, express edition host.
It requires the table to be created before the execution of the command.
For more details on the available options you can check the SAP HANA SQL and System Views Reference > IMPORT FROM Statement (Data Import Export) documentation.
As an alternate solution, you can also use the SAP HANA Tools for Eclipse which provides a subset of features available in the IMPORT FROM SQL command.
However, it allows you to import data directly from your client and not the AP HANA, express edition host.
For more information, you can check the following tutorial: Import CSV into SAP HANA, express edition using the SAP HANA Tools for Eclipse
Prerequisites
- SSH and FTP client installed, running and properly connected to your SAP HANA, express edition.
- Install a SQL query tool for SAP HANA, express edition.
- Prepare your SAP HANA, express edition instance for Machine Learning