How to upload a csv file to an existing table using Development Tools SAP HANA Web-based Development Workbench?

Question

SAP

How to upload a csv file to an existing table using Development Tools SAP HANA Web-based Development Workbench?

Answer 1

You can try using export-import. First, export the table (in zip - it drags triggers, keys and everything else), then pull the data file out of the zip, add the necessary csv lines there, put it back in the zip to the same place and import with replacing the old one. And the easiest way is to connect with Eclipse (Khana Studio) to the cloud source and at the same time Access or Excel via ODBC and write anything there in the most convenient way. In my case, the host address for odbc is localhost:30315 - well, you can see it in eclipse - it forwards the tunnel.

Answer 2

Create a .hdbti file
import = [{
table = "";
schema = "";
file = "package:file.csv";
header=false;
delimField = ";";
}];
.xsaccess {"exposed" : false}
When the package is activated, the csv will be loaded into the table

Answer 3

There is also a quick-and-dirty solution. It helps in cases where the CSV is too large, and Hana doesn’t like something in it - this is to generate a column from INSERT (or UPSERT) commands through Excel. Something like INSERT INTO ...
Don't forget COMMIT or ROLLBACK at the end. Of the possible errors with CSV import, look out for decimal separators, quotation marks and the appearance of delimField in text columns, as well as duplicate keys.