Search code examples
databasehana

How to unload tables from hana for every one minute?

I have to unload all the tables from the SAP HANA database every one minute. So I need actually a cronjob which automatically unload all the tables in the database every one minute. How can I do that?

Solution

  • There's no specific feature that would allow you to do that. Usually manually loading/unloading of table columns is not required nor recommended.

    For cases where a preferred unloading is required, the UNLOAD PRIORITY table attribute can be used.

    Unloading all tables on a regular basis doesn't make much sense when using an in-memory database. What's the use case here?