Skip to Content
avatar image
Former Member

EXPORT CSV with hana client hdbsql

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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.

    Regards,

    Lucas de Oliveira

    Add comment
    10|10000 characters needed characters exceeded