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:
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:
- 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.
Hope you understand this feature "export". In the next document i will focus on "export" and "import" of landscapes.
Thank you for reading