Export Path issue

[former_member640483]

Hi there,

i want to export a table from SAP Hana Studio into a folder for example my program files. Therfore i use the simple expression:

EXPORT AL_ST_ODV_PARAMETERS AS csv INTO 'C:\Program Files (x86)' ;

however this doesnt work and causes the error:

Could not execute 'EXPORT AL_ST_ODV_PARAMETERS AS csv INTO 'C:\Program Files (x86)''

SAP DBTech JDBC: [12]: cannot open file: Cannot open the path C:\Program Files (x86) and also its parent directory C:

so there is something wrong with the path ! I tried several different paths none except this did work:

EXPORT AL_ST_ODV_PARAMETERS AS csv INTO '/tmp' ;

I want to address a specific Folder Location and not use a temporary file to store my Information, so my question is what did I do wrong with the path description and how can I solve that issue ?

[lbreddemann]

This question has been asked many times over on this platform.

The main point here is: EXPORT in SAP HANA Is a server-side command.

It does not store data on your client machine (which is why your local path string leads to an error) but instead can only write into specific folders that are accessible to the HANA indexserver process (hdbindexserver).

The documentation has the details on what folders are accessible and how to set up other folders, but the bottom line for your question is: EXPORT does not save any data on your local client computer.

[former_member640483]

Thank you for your detailed explaination ! I do now understand the problem and I will find another way for the data Export.