Partition, Archive, cold data

[former_member182675]

Dear expert.

I need your advise. I have a small hana DB (standalone) for COPA implementation. Evry mounth we replicate CE11000 table from ECC to HANA. The CE11000 table is very large - around 60 GB, 1 milion entries.

now it's the time to partition the table, I try create partition in the QA and I used range partition , The partition is by 'PERIO'. So I have 5 partitions for PERION column, and the system create another partition without range.

Now after the progress is finish I see the partition without the range is full of data. why? maybe the range partition is not good for my implemntation? maybe the size of the table? what is the best partition stategy for this table? Now lets say I finish with the partition, do you now if there is a way to load to memory only single partition ? (UNLOAD <table_name> [<partition_restriction>])

I try to do this because I want to archive part of the CE11000 table and I I realy don't now what is the best way for me. If I will archive in Abap system the data will be missing from HANA.

HANA version - 1.00.112

Please advise Naor

[lbreddemann]

couple of remarks:

• 1 million records typically is not a data volume where partitioning would be required.
• 60 GB for those 1 million records for the CE11000 table seems large (ca. 63 KB per record)
• the fact that all records went into the OTHER partition points towards that the partition ranges don't fit the data in the table
• HANA will load/unload partitions as needed automatically - no need to manually unload them
• partitioning is not archiving by any means. Not sure if COPA supports anything like that out of the box, but as long as you need the data in your application archiving is probably not the right thing to do.