HANA: export table as csv file

[satya_sreenivasan]

Hello experts:

I am trying to export table data as .csv file from HANA Studio. I have 'Export as CSV', include dependencies and 'Export to local folder' selected.. The export succeeds, however, the 'exported' directory does not contain a data.csv file. There is a 'data' file, but it's not in csv format.

This previously used to work and the data.csv file used to be created in the local export directory under an 'index' folder. Now the 'index' folder is missing.

Wonder if there's some setting change on HANA Studio that's resulting in this change?

Thanks in advance for your help!

[AtulKumarJain · Accepted solution]

Hi Satya,

If you export the table from hana studio

you can export it using on server and on client option.

if you use first option it will go

default location
/usr/sap/<SID>/HDBnr/work
and if you use  2nd option show it will create exported file at client location i.e. at your desktop/laptop where HANA studio installed.

please try first option and it will work .

Note : PLease use the latest sap hana studio.

Best Regards,
Atul

[satya_sreenivasan · Accepted solution]

Hi Atul,

Thanks for your prompt response. The issue seems to have been with the Studio version that I was using. After an upgrade, export seems to work fine.

Thanks again

[AtulKumarJain · Accepted solution]

Hi Satya,

Good to hear issue has been resolved ,please close this thread as answerd.

Thanks

Atul