v.20.5New Feature

Add _timestamp_ms Virtual Column for Kafka Engine

Add _timestamp_ms virtual column for Kafka engine (type is Nullable(DateTime64(3))). #11260 (filimonov).
Added a new virtual column _timestamp_ms of type Nullable(DateTime64(3)) to the Kafka engine in ClickHouse.

Why it matters

This feature provides users with the ability to access the timestamp of Kafka messages with millisecond precision directly from the Kafka engine, enabling more precise time-based querying and processing of Kafka data.

How to use it

Users can simply query the Kafka engine and include the virtual column _timestamp_ms in their SELECT statements to retrieve the timestamp of each Kafka message with millisecond precision.