Exception when try to save kafka avro data into clickhouse about clickhouse-kafka-connect HOT 6 CLOSED

@mshustov Cause Avro has only a few Primitive Types, but there's lots of data types in ClickHouse. If these types are ignored when using, exceptions will occur according to the current implementation.
It has several possible solutions, the first one is to mapping all types within ClickHouse data type. but i think it will cause lots of efforts. The second one is to point out which data types in ClickHouse is already implemented. The root cause of my exception is UINT64 which i'm using but it hasn't been covered, and it cannot pass the data schema validation.
Hope it works, the connector is helpful. thank you.

from clickhouse-kafka-connect.

I looked into the source code, and found the root cause is the type mismatch, Also in com.clickhouse.kafka.connect.sink.db.mapping.Column, it only includes only a few types in clickhouse.
If there's some avro type and clickhouse type mapping document, it will be helpful for the user.

from clickhouse-kafka-connect.

configuration issue, not a bug, maybe should deliver an enhancement

from clickhouse-kafka-connect.

configuration issue, not a bug, maybe should deliver an enhancement

@licongchao what would you suggest adding to the documentation to improve the user experience?

from clickhouse-kafka-connect.

The only types currently not supported by the Sink are bytes & struct as value. We introduce some implicit conversions within Dates see #63 issue [#57]. If you see any other need to implicit conversions, please open an issue, and we will address it.

from clickhouse-kafka-connect.

Given the code added to v0.0.10 by @hamsterready this should be resolved - if it continues to persist, please reopen and thanks!

from clickhouse-kafka-connect.