In this blog post, let’s learn about the error message “1189 The number clustering key columns for table-or-index exceeds maximum-number-key-columns.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1189 The number clustering key columns for table-or-index exceeds maximum-number-key-columns.
Reason for the Error
The number of columns specified in the primary key or index columns exceeds the maximum number allowed.
Solution
Ensure that the number of key columns or index columns is less than the maximum limit and resubmit