Subpartitions in HANA

[former_member303055]

Hi All,

we are trying to move Oracle tables to HANA.

for one of the table we found sub-partitions, is this feature possible in HANA.

We tried using RR, Hash,Range.. Please suggest if there is a possibility.

Regards,

Suresh

[former_member303055 · Accepted solution]

yes, it is working.

[former_member303055]

Trying something like..

Range on A , B

Range on C..

got example for Hash + Range, Hash, Hash.. let  me know if the above case if possible or not.

Regards,

Suresh.

[former_member303055]

Hi Amerjit,

Thanks for your reply.

Yes, I am looking same page as your post your message.:)

Regards,

Suresh.

[Former Member]

Hello Suresh,

Have you looked at multi-level partitioning ?

http://saphanawiki.com/2015/09/faq-sap-hana-partitioning/

SAP HANA Administration Guide - SAP Library

KR,

Amerjit