How to resolve a ClickHouse sink error with invalid params and format issues?

I've been trying to get the clickhouse sink to work, but all I get is gRPC request to meta service failed: Internal error: Sink error: ClickHouse error: invalid params: invalid format in the console (and as a response). I've tried with different configurations but still facing the issue. Here is my sink definition and table definition. How can I resolve this error?



Asked on Jan 18, 2024

  1. Remove primary_key = 'matchid' from the sink definition if using type = 'append-only'.

  2. Ensure the correct URL format in the ClickHouse sink configuration, e.g., clickhouse.url = 'http://clickhouse:8123' instead of clickhouse.url = 'clickhouse:8123'.

Jan 18, 2024Edited by