feat(clickhouse sink): support JSONB by writing as string

[fuyufjh]

risingwave/src/connector/src/sink/clickhouse.rs

Lines 726 to 730 in fa6d630

	ScalarRefImpl::Jsonb(_) => {
	return Err(SinkError::ClickHouse(
	"clickhouse rust interface can not support Json".to_string(),
	))
	}

Let's try to write JSONB as string. Hopefully it can just work.

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.

[hzxa21]

@xxhZs Any updates?

[xxhZs]

Because ck supports jsonb, but it's clikchouse-rs that doesn't support jsonb, so for the time being, I'm not writing it as a string.

[hzxa21]

Are we planning to add jsonb support in clickhouse-rs? If not, I will remove this issue from milestone first.

[xxhZs]

It looks as if their community is doing something similar, might be able to shut it down for now until their support is complete
ClickHouse/clickhouse-rs#144

[hzxa21]

Blocked by: ClickHouse/clickhouse-rs#144

[slvrtrn]

Using ClickHouse 24.10, you can now store/read the new JSON as a string. See the examples from this PR: ClickHouse/clickhouse-rs#171

It is now just a matter of a few settings that should be applied to the client instance (or per query/insert); the current client version should already be capable of doing this.