SAP Knowledge Base Article - Preview

3509522 - "invalid expression: partition column not in primary key columns" is raised when you create a table

Symptom

You failed to create a table with heterogeneous partitioning. Following error is shown.

e.g.
Could not execute 'CREATE TABLE AAA (A INT PRIMARY KEY, B INT) PARTITION BY RANGE (B) ((PARTITION OTHERS))'
Error: (dberror) [435]: invalid expression: partition column not in primary key columns: B: line 1 col 64 (at pos 64) 

However, the same table can be created successfully in on premise HANA database.


Read more...

Environment

HANA Cloud

Product

SAP HANA Cloud 1.0

Keywords

KBA , HAN-CLS-HC , HANA Cloud Services HANA Cloud , How To

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.