SAP HANA: Exporting of Tables into local desktop

[Former Member]

Hello Folks,

In this document I would like to explain on how to use “export” for tables in SAP HANA Studio.

To do export you can choose “Export” from “FILE” or “Quick Launch” as shown below:

OR

Go to the desired table and Select “Export” from the context menu as shown below:

It will lead you to the below screen:

Now choose “Next”.

Now Choose the format as “CSV” as shown below:

Now select the destination to which the files has to be exported as shown below:

Exporting of tables + data begins as shown below:

Well you guys (including me) would be thinking that I am succesfull  in exporting the data, but here SAP HANA has an limitation and raises the exception as shown below:

As you can see in the above screen, that max lob size is 4294967296

Now let us try to demonstrate the same example with another table with less data.

This time I choose table named “city” as shown below:

This time it was successful and I get the below data as a result shown below:

1. I have now create.sql (gives necessary SQL statements to create the table) and data.csv & data.ctl and other files required for file loading. :smile:

Hope you understand this feature "export". In the next document i will focus on "export" and "import" of landscapes.

Thank you for reading :smile: