INSERT Date from Unix Timestamp about clickhouse_sinker HOT 7 CLOSED

Date is actually UInt16 in ClickHouse.
It can be a feature to have String to Date in GetValue()

from clickhouse_sinker.

@sundy-li That makes sense. I think we should support 2 types Date(String) or Date(UInt16) for this case

from clickhouse_sinker.

I faced such an issue.
In Kafka I have a JSON message with a date key which is in String format. {"date" = "2020-06-01"}
And if I try to save this message using sinker, I got "0000-00-00" in the table.
Is there any way to solve the issue without creating mat-view?

from clickhouse_sinker.

@bun4uk you can go two ways
or you need to send an int or you can use ElasticDataTime type

example: https://github.com/housepower/clickhouse_sinker/blob/master/conf/tasks/logstash_sample.json

otherwise, you will need to write your own parser

from clickhouse_sinker.

@ArtemChekunov
thanks!
Am I right understood, in case of using ElasticDateTime type column type in the table should be Int64 type?

from clickhouse_sinker.

@bun4uk only if you are going to go way far to the future =)

from clickhouse_sinker.

@bun4uk The master added support for converting number(integer, float) and string(you can customize layout at task config) to Date, DateTime, DateTime64.

from clickhouse_sinker.