In this blog post, let’s learn about the error message “4333 Column ColumnName is not part of the partitioning key.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4333 Column ColumnName is not part of the partitioning key.
Reason for the Error
The user has specified a column in the PARTITIONING_KEY clause that is not part of the partitioning key of the table specified in the PARTITIONING_KEY option of KEY_RANGE_COMPARE function.
Solution
Specify a column that is part of the partitioning key in the PARTITIONING_KEY clause of KEY_RANGE_COMPATRE function