SAP Knowledge Base Article - Preview

3482330 - Understanding the PARTNAMES Parameter in SAP HANA Table Partition Specification

Symptom

During the process of converting a table on SAP HANA from range partitioning to hash partitioning, a query that includes the PARTNAMES parameter emerges in the table partition specification tab.

The query appears as follows:

PARTITION BY HASH ("column_name")
PARTITIONS X WITH PARAMETERS ('PARTNAMES'=('name1','name2','...','nameX'))

However, the user had not included the PARTNAMES clause in their original repartitioning query and is seeking clarification as to what the PARTNAMES parameter corresponds to.


Read more...

Product

SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB-ENG , SAP HANA DB Engines , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.