SAP Knowledge Base Article - Preview

3448188 - Range partitioning of table fails

Symptom

When trying to range partition a table using the following syntax

Alter Table <tablename> PARTITION BY RANGE (YEAR(<column_name)) (PARTITION VALUE = '2024', PARTITION VALUE = '2023', PARTITION OTHERS);

on of the following error occurs:

  • SAP DBTech JDBC: [2048]: column store error: fail to alter partition: [2051] partition specification not valid;The column <column_name> is not a key column.
  • SAP DBTech JDBC: [2048]: column store error: fail to alter partition: [2051] partition specification not valid;The column type of attribute <column_name> is not allowed in a partition specification. Attributes with year() and month() functions have to be one of the date types.


Read more...

Product

SAP HANA, platform edition 2.0

Keywords

SAP HANA, HANA, SAP, HANA partitioning, range, range partitioning, partitioning, partition specification not valid, the column, the column is not a key column, key column, partition, specification, partition specification, key, column , 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.