ClickHouse

Meet ClickHouse at @alibaba_cloud Data & AI Forward Day (HK) on Mar 25 🇭🇰 🎤 Jason Wong, Sr. Support Engineer, speaks at 4:15PM on unlocking millisecond insights for FinTech with ApsaraDB for ClickHouse 🚀 Real-world AI use cases 🔐 New AI Agent launch 💻 Win Mac Mini / cloud credits 👉 clickhou.se/47bPQ80

The ClickHouse community is reuniting this May! 🎉 Open House is back. Year two. San Francisco. May 26–28. Free to attend. Stay tuned for the full agenda dropping soon 👀 Register → clickhou.se/41gsHxC

Full-text search GA. chDB 4. @Hookdeck's 60x search speedup. @triggerdotdev's tenant-safe SQL DSL. clickhou.se/4lEHLi8 The March newsletter has a lot going on.

Every search and chart in ClickStack generates a query. You just never see how much work goes into it. A look under the hood at the optimizations — chunked aggregations, materialized view routing, index-aware rewrites, adaptive sampling — that make observability fast without any tuning. clickhou.se/477JLte

You solved the incident. You closed the tab. Three weeks later, same incident. 🙃 Introducing AI Notebooks for ClickStack — an investigation workspace where the work becomes an artifact your whole team can use. clickhou.se/4uzao4a

Turns out "built for AI" and "built for ClickHouse" describe the same thing. @tbragin on why three markets - real-time analytics, data warehousing, and observability - are all hitting the same wall at once. clickhou.se/4dqhmlV

We’re excited to share one of the first user stories of a team using Postgres managed by ClickHouse in production! clickhou.se/41bWFTs See how @getsocialpruf cut CDC costs, eliminated connectivity issues, and achieved up to 5x faster queries 👇

Hot take: your data strategy is more likely to derail your AI initiative than your model choice is. Everyone's debating which LLM to use. Almost nobody is asking whether their data platform can actually serve it. In my latest post (clickhouse.com/blog/ai-redraw…), I cover three converging shifts: real-time analytics, data warehousing, and observability — and why the architectural demands of AI (high concurrency, low latency, full-fidelity data) don't match what incumbent platforms were designed for.

We're excited to be kicking off the week at NVIDIA GTC 🙌 Come hang out at AI Builders Night today at 7:30pm with RunReveal and Docker. Free food, free drinks, and talks from engineers actually shipping AI infrastructure. If you're at GTC, stop by booth 3114 to meet the ClickHouse team! RSVP: luma.com/xoq2dz0l

The executor-based async client was a workaround. `clickhouse-connect` v0.12.0 ships the real thing. clickhou.se/47PEPcC Half-sync/half-async design: async I/O and CPU parsing overlap. 1.16× faster overall, P95 variance down from ±1581ms to ±164ms at high concurrency.

ClickHouse 26.2: ClickStack now lives inside the binary. Navigate to localhost:8123, click ClickStack, done. clickhou.se/4bpWTLw Plus 3.2× faster OUTER JOINs, text index at GA, and time-based streaming inserts.

"Just use JSON—it's easy, and everyone knows it." clickhou.se/3ZUQlzl We hear this a lot. And while JSON *works*, our FastFormats benchmark shows it's 51% slower than Native format for ingestion. That's not a typo. This deep dive explores: • Performance differences across 70+ input formats • Why columnar formats (Native, Arrow, Parquet) outperform row-based ones • The real impact of compression (hint: LZ4 is almost always worth it) • How ClickHouse clients automatically optimize your inserts If you're building a high-throughput data pipeline, the format you choose matters more than you think.

🚀 Korean Webinar: CDC ClickPipes 복잡한 CDC 파이프라인 없이 Postgres, MySQL, MongoDB 데이터를 ClickHouse로 실시간 복제하는 방법을 확인해 보세요. 라이브 데모 + AMA 포함. 👉 지금 등록하세요 clickhou.se/3N4A5ZN

Canva recently acquired an analytics startup — but they've already been doing wild things with observability at 260M users. clickhou.se/4siFDPx 14x compression, 10x faster trace searches, 70% cost reduction. Here's how they process 6M spans+logs/second with ClickHouse.

Nothing humbles a data engineer faster than a column full of dates in five different formats. clickhou.se/4cKYT3g New post: five ways ClickHouse handles date parsing, from the explicit and precise to the "just deal with whatever I give you" end of the spectrum. 🔹 Exact conversion functions for known timestamp types 🔹 Best-effort parsing for when the format is a mystery 🔹 Graceful handling when the "date" isn't actually a date 🔹 A casting approach that keeps your queries clean One of these will save you from that cursed date column 😅

Network transfer: often the 3rd-largest cloud bill item, rarely forecasted. clickhou.se/4rlF9Ym We built kubenetmon to monitor data transfer across AWS, GCP, and Azure in dozens of regions. 400 billion rows in one region. 2.66 TiB compressed from 86.69 TiB. Tracks individual connections, attributes to pods/workloads, and aggregates costs. No existing tool did all three.