@JNSimba @CalvinKirs Hi, can you review my code? I think this is a problem and needs to be fixed

Thanks for trying to resolve this issue.

I looked at doris's use of this section and found that it is CLEAN LABEL [label] FROM db; This SQL has some syntax problems. For example, pure numbers such as 123 are not supported . This needs to be changed to doris' code.

Generally speaking, if you need to clean the label under db, you can use CLEAN LABEL FROM db; clear all labels

Thanks for trying to resolve this issue.

I looked at doris's use of this section and found that it is CLEAN LABEL [label] FROM db; This SQL has some syntax problems. For example, pure numbers such as 123 are not supported . This needs to be changed to doris' code.

Generally speaking, if you need to clean the label under db, you can use CLEAN LABEL FROM db; clear all labels

@DongLiang-0 Thank you for your reply! Do you mean that the SQL CLEAN LABEL label1 FROM db1;restriction on label naming, should be solved in Doris project? Am I right?

I will raise this issue in Doris project, but if doris rejects this proposal, I think we need to consider solving this issue in doris-flink-connector. Because when the flink cdc job failover, a large number of useless labels that cannot be deleted are eventually generated. (When I don't want to directly use CLEAN LABEL FROM db1; to clear all labels)🙂

@DongLiang-0 Thank you for your reply! Do you mean that the SQL CLEAN LABEL label1 FROM db1;restriction on label naming, should be solved in Doris project? Am I right?

I will raise this issue in Doris project, but if doris rejects this proposal, I think we need to consider solving this issue in doris-flink-connector. Because when the flink cdc job failover, a large number of useless labels that cannot be deleted are eventually generated. (When I don't want to directly use CLEAN LABEL FROM db1; to clear all labels)🙂

@monologuist Yes, this problem needs to be solved in doris to lift the grammatical restrictions on label.

I agree with @DongLiang-0 suggestion. It would be better to modify it on Doris side, because the client is not only Flink. Close this first, and you can open it at any time if you have any questions.