When asked to design a ClickHouse table for real-time event analytics, LLMs often generate schemas that include custom partitioning, custom codecs on every column, and projections. While syntactically correct and using ClickHouse-specific features, these choices may not be right for every use case. Partitioning in ClickHouse is primarily a data management feature, not a query optimization feature.
