Skip to Content

EXPORT CSV with hana client hdbsql

Mar 21, 2017 at 02:36 PM


avatar image
Former Member

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.

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


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

1 Answer

avatar image
Former Member
Mar 22, 2017 at 08:38 PM

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.


Lucas de Oliveira

10 |10000 characters needed characters left characters exceeded