Support for UPDATE predicates

cqlsh:spdatarp> UPDATE t_spdatarpro_ro SET amount = 10 WHERE messageid = '123456';
Bad Request: Non PRIMARY KEY messageid found in where clause

In this case, messageid is the secend index. I want to update all rows which messageid is '123456', but it failed