clickhouse-kafka-connect icon indicating copy to clipboard operation
clickhouse-kafka-connect copied to clipboard

Ingestion fails if a field name in the clickhouse table contains characters other than alphanumeric

Open niting112 opened this issue 5 years ago • 1 comments

@DmitryBe

Ingestion in clickhouse fails through this connector if field name in the clickhouse schema contains characters other than alphanumeric. E.g:- CREATE TABLE sample (Event-Name String, Unique-ID String, Event-Time DateTime) ENGINE = MergeTree() PARTITION BY toYYYYMM(Event-Time) ORDER BY (toYYYYMM(Event-Time), Event-Name) SETTINGS index_granularity = 8192

In the above schema all the fields have "-" in their names.

This might be required if we want to have direct mapping from field names in kafka event to schema fields in clickhouse table.

There is a small fix for this. I want to create a pull request for this. Please let me know.

niting112 avatar Dec 12 '19 05:12 niting112

@DmitryBe Is this not active repo?

niting112 avatar Dec 16 '19 05:12 niting112