[Feature] Cancel-Load support State condition

[dataalive]

Search before asking

• I had searched in the issues and found no similar issues.

Description

when we have so many loading tasks, doris now support cancel load with label and lable-* regex match.

CANCEL LOAD
[FROM db_name]
WHERE [LABEL = "load_label" | LABEL like "label_pattern"];

but sometimes we need to cancel dedicated state tasks like all PENDING tasks

so i suggest to support syntax like the following

CANCEL LOAD
[FROM db_name]
WHERE [LABEL = "load_label" | LABEL like "label_pattern"] [AND/OR] [STATE = "PENDING"]; 

Use case

we could cancel load with dedicated state.

Related issues

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[stalary]

If you're not working on this feature, you can assign to me.