Event properties in ClickHouse — typed columns vs JSON type, for ~6M events/day with 29 event types (stackoverflow.com)stack
15 points by Jay in stackoverflow.com · 32h ago · stack
I'm building an event analytics pipeline (Kafka → ClickHouse) with ~6M events/day and 29 distinct event types. Each event has a fixed set of core fields, plus a properties object that varies per event type (e.g., search_submitted has city_id , result_count ; booking_created has…