[Feature][clickhouse sink] enable deleteion on clickhouse
- Dominant language
- Java
- Stars
- 4.1k
- Forks
- 1.7k
- PR merge metrics
- No merged PRs in 30d
Description
### Search before asking
- [X] I had searched in the [issues](https://github.com/DTStack/chunjun/issues) and found no similar feature requirement.
### Description
By now chunjun sink deleteion is disable https://github.com/DTStack/chunjun/blob/21b75630b3a4fbd45a165490d99e079441d799e0/chunjun-connectors/chunjun-connector-clickhouse/src/main/java/com/dtstack/chunjun/connector/clickhouse/dialect/ClickhouseDialect.java#L67
I have learn from clickhouse document , There is a sepecial SQL that can delete records from clickhouse,as below:
``` sql
alter table test.order delete where id=6;
```
### Use case
_No response_
### Related issues
_No response_
### Are you willing to submit a PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
Contributor guide
Assessment
This issue has not been assessed yet.