on 09-25-2015 12:40 AM
Hi,
is there a way to mark a table in HDB ask disk-based, so that all data is stored on disk and not in memory? Or maybe something similar for a column?
I am not talking about Dynamic Tiering using IQ or Smart Data Access using another DB, but a HANA built in feature that allows this disk-based storage.
Thank you.
Regards,
Alex
So I have heard that there is a function called "paged attributes", which allows cold/disk-based partitions in HDB.
So far I am unable to find a concrete example for that.
Any help here would be appreciated
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Paged attributes can be used to have very large non-partioned table columns loaded into memory in smaller chunks. This comes to the expense of compression factor and scan efficency.
With HANA you see the idea is to keep all data you may want to work with in memory most of the time.
If you have lager amounts of data that you barely ever need, you may look into using LOB columns for that data.
Maybe it would be a good idea if you tell us what exactly it is you want to do - then its a lot easier for me to tell you if and how that's doable with HANA.
There is no 'disk-only' table available.
Setting the unload priority as mentioned by Chandra is the correct way to get as close as possible to the behavior of a 'disk-only' table.
For LOB columns however, there exists the option to have them stored and kept exclusively on disk. Upon usage, the data will be temporarily loaded to memory, processed and then unloaded once not required anymore.
All this is in the documentation (and several SAP notes) for reference.
- Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lars,
thanks for your reply!
The LOB column "MEMORY THRESHOLD" parameter to keep those columns on disk I am aware of. In our use case, we would also like to do that with columns of other data types, or rather the complete table.
Do you know whether this might be a feature in a not-yet-released development version of HDB?
Thanks!
Hello Alexander,
Sorry, can't find the information regarding to only in disk table for HANA build in feature.
Regards,
Ning
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alex,
How about setting the UNLOAD PRIORITY to 9 for the table?
Regards,
Chandra.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.