The following errors occur when issuing the command to add a partition to a partition scheme:
sp_ctrl (alvsupu15:5438)> add partition to scheme1 set name = q1 and condition =
"NUM_COL<10" and route =
Invalid specitication; not in key=value format
The command “add partition….” has a series of set statements depending on the values being set thru this command. The syntax of the command is:
add partition to scheme_name set {condition = column_condition | hash = hash_value} and route = routing_map [and name = partition_name] [and tablename = target_table] [and description = description]
If one of the clause is not specified correctly, then the above error will occur. Correct the syntax of the “add partition” command and re-issue it.
In our case the following clause was incomplete as we did not specify the value for the route:
"and route ="
