In this blog post, let’s learn about the error message “1095 The PARTITION BY column column-name should also be part of the clustering/storage key.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1095 The PARTITION BY column column-name should also be part of the clustering/storage key.
Reason for the Error
This error is reported if a column specified in the partitioning key of the “PARTITION BY (partitioning_columns>)” clause of a CREATE TABLE or CREATE INDEX statement is not also a member of the clustering key.
Solution
Either remove the offending column from the partitioning key specification (and possibly replace it with a column that is a member of the clustering key) or add the offending column to the clustering key by using the STORE BY clause or by adding it to the primary key
