0

Hello everyone I have extract problem in hana database. In our system, there is a calculation view that I use in Hana and I want to export the result when I run this query in Eclipse.

I did research and saw functions like "extract into", but I think it extract data from the whole system and gives it in different formats.

Firstly I changed the default display result rule which is 1000 lines to 1 million rows. However, my query results returns around 900 thousand lines and when I try right click and export result, the system crashes.

I don't want to export the whole structure from database. We only need excel of some results with some conditions.

Is there any other way to do this?

kalamity
  • 1
  • 3

1 Answers1

0

You can use the EXPORT INTO statement, which works for tables and views. Als this thread maybe helpful.

Mathias Kemeter
  • 933
  • 2
  • 11
  • but if i do this can i lose the data in the database? I dont want to change anything in the database while exporting the results to csv. I saw this topic, but when I use export function, I thought my data was gone, correct me if im wrong please. @Mathias Kemeter – kalamity Jul 01 '22 at 10:58
  • No, it definitely won't change the original data. As the documentation is saying: "Use the EXPORT INTO statement to export the data from a table or view into a single CSV or parquet file." That's what it does. – Mathias Kemeter Jul 01 '22 at 11:04