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

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.