In this blog post, let’s learn about the error message “1116 The current partitioning scheme requires a user-specified clustering key on object table-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1116 The current partitioning scheme requires a user-specified clustering key on object table-name.
Reason for the Error
The partitioning scheme requires a user-specified clustering key.
Solution
Specify a clustering key, either through a PRIMARY KEY, STORE BY, or PARTITION BY clause