SAP HANA single-level and multi-level partitioning.

 

SAP HANA single-level and multi-level partitioning.

SAP HANA Single-level Partitioning.

• HASH
• ROUND ROBIN
• RANGE

If a table is partitioned exclusively by one of the above partitioning approaches is called single-level partitioning.

SAP HANA Multi-level Partitioning.

If each of the partitions itself is partitioned again by other criteria, we call it multi-level partitioning. In the following picture you can see a multi-level partitioning with a HASH partitioning on level 1 and a RANGE partitioning on level 2:

The total number of partitions is the product of the number of partitions on every level.The partition key columns of the second level can be chosen independent of the primary key of the table in case of HASH / HASH and RANGE / HASH partitioning.