3809948 - Repartition target number, online vs standard

• You need to repartition a very large table  because current partitions are nearing the 2-billion-rows-per-partition limit and data continues to grow.
• The following SAP documents are consulted and they are advising "conflicting" partitioning strategy:
  • Performing Table Partitioning - SAP Learning: "If a table is already partitioned, it is most efficient to choose a new number of partitions that is a factor 2 multiple or divider of the current number of partitions (such as 4 -> 8 or 6 -> 3 partitions)."
  • 2044468 - FAQ: SAP HANA Partitioning - SAP for Me: "it is optimal for the repartitioning performance when ... in context of hash partitioning when the number of source of target partitions have no common divisor. For example, a repartitioning from HASH 10 to HASH 21 will be better parallelized than a repartitioning from HASH 10 to 20."
• You want to know the actual recommended repartition number

• SAP HANA 1.0, platform edition
• SAP HANA 2.0, platform edition

sap hana partitioning, online partitioning, repartition, hash partition, repartition number, divisor, multiple, standard partitioning , KBA , HAN-DB-ENG , SAP HANA DB Engines , Problem