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.