Skip to Content
0

EXPORT CSV with hana client hdbsql

Mar 21, 2017 at 02:36 PM

188

avatar image

Dear HANA Expert,

I face some performance issues with exporting table as CSV to a remote server with HANA Client.

Before the Update to REV 07 the performance was acceptable but since one month we need 1 hour to export 7MB.

I searched in Internet and i find an archived question answered by Lars Breddemann.

https://archive.sap.com/discussions/thread/3748102

Lars says: HDBSQL is not particularly slow, but will of course suffer from network bandwidth and latency limitations, while the server side HANA export simply avoids that completely.

I didn't really inderstand what it means and I would like to know if someone know how to configure this latency or network bandwidth or maybe if there any Option to add in my command line to get better result.

Here my Command line

>hdbsql -n XXXX:30015 -i 00 -u XXXXX -p XXXXX 1 -x -resultencoding LATIN1 -a -o "....\g5.csv" "SELECT * FROM SCHEMA.TABLE"

Thanks in advance and best regards

Houssem

10 |10000 characters needed characters left characters exceeded
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lucas Oliveira
Mar 22, 2017 at 08:38 PM
0

Hi Houssem,

What you can do is to login into the HANA host directly and use hdbsql from there. Network latency will be ruled out as you're working directly on the server running the query.

Regards,

Lucas de Oliveira

Share
10 |10000 characters needed characters left characters exceeded