In this blog post, let’s learn about the error message “4335 The degree num1 specified for the left operand of the PARTITIONING KEY clause does not match the number of columns num2 in the partitioning key for table tablename.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4335 The degree num1 specified for the left operand of the PARTITIONING KEY clause does not match the number of columns num2 in the partitioning key for table tablename.
Reason for the Error
The user did not specify the correct number of columns in the left operand of the PARTITIONING_KEY clause of the KEY_RANGE_COMPARE function, so that it matches the partitioning columns of table tablename.
Solution
Specify the correct columns in the left operand of the PARTITIONING_KEY clause of the KEY_RANGE_COMPARE function that matches the partitioning columns of table tablename
