In this blog post, let’s learn about the error message “1098 Partition key (key) already specified for object object-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1098 Partition key (key) already specified for object object-name.
Reason for the Error
You attempted to create or change a table so that more than one partition has the same first key.
Solution
Change the statement so that it does not define two partitions to have the same first key, and resubmit