aadant

for a regular MT you can use this design (similar to EBay) and ClickHouse Inc. https://github.com/ClickHouse/clickhouse-kafka-connect/blob/main/docs/DESIGN.md

Please note that the above architecture is not generic. You need an intermediate MySQL server and triggers. It is probably cleaner to publish denormalized data to Kafka and persist it...

@BorisTyshkevich one other route would be to support projections with RMT : https://github.com/ClickHouse/ClickHouse/issues/24778

Actually you can change the default timezone for ClickHouse server and it should solve the issue. Reopen if it is not the case.

ok @subkanthi let us fix this by supporting the timezone in the DateTime64

@sudmed I took another look, you can make it work if you add the timezone info on the CH table DateTime64. This is not done automatically but this is a...

@subkanthi the issue exists in MySQL too. you need to add the TZ in all DateTime64. This is something we should fix. Related to other recent issues

add the transaction information

@Naros thanks, looks like it, indeed we use this ``` # java --version openjdk 11.0.16 2022-07-19 OpenJDK Runtime Environment 18.9 (build 11.0.16+8) OpenJDK 64-Bit Server VM 18.9 (build 11.0.16+8, mixed...

@Naros unfortunately the issue continues to happen with OpenJDK 17 ... ``` bash-4.4# java --version openjdk 17.0.2 2022-01-18 OpenJDK Runtime Environment (build 17.0.2+8-86) OpenJDK 64-Bit Server VM (build 17.0.2+8-86, mixed...