ClickHouse

People sometimes ask: When will you stop optimizing JOIN performance? We will never stop! 🔥 ClickHouse 25.10 delivers massive JOIN improvements: ⭐️ Lazy column replication in JOINs — faster joins ⭐️ Automatic Bloom filters in JOINs — faster joins ⭐️ Condition pushdown in JOINs — faster joins ⭐️ Automatic column stats for JOINs — you guessed it — faster joins But that's not all in 25.10: 🎯 QBit data type - tune vector search precision at query time 📊 Enhanced SQL - <=> operator, negative LIMIT/OFFSET, LIMIT BY ALL ✈️ Arrow Flight server/client compatibility ⚡ Late materialization of secondary indices https://lnkd.in/gDUsNTxR

Ever wonder what the ClickHouse security team uses to monitor... ClickHouse? Plot twist: It's ClickHouse (plus RunReveal). We wrote about how we migrated from a tangle of Lambda functions to a cleaner SIEM setup that actually scales. The post covers: - Why ClickHouse makes sense as a security logging platform (spoiler: compression + speed) - How we went from "n + many ETL pipelines" to a single ingestion engine - Writing detections in SQL that run directly on ClickHouse - Real examples from our own security monitoring If you've ever thought "could ClickHouse work as a SIEM?" the answer is yes, and here's how we're doing it. https://lnkd.in/dSnAMRVe

We're proud to announce the launch of ClickHouse K.K., our new Japanese subsidiary, in partnership with Japan Cloud! 🇯🇵 This marks an exciting new chapter as we expand in Japan to help more enterprises harness the power of real-time analytics and AI, driving innovation, transformation, and growth in one of the world's most dynamic markets. "Japan is one of the most dynamic and fast-growing markets for AI and data analytics. The establishment of ClickHouse K.K. (ClickHouse Japan) with JAPAN CLOUD marks an important step forward as we deepen our commitment to the Japanese market." - Aaron Katz, CEO of ClickHouse. 🔗 Read more: https://lnkd.in/gMKUZRXn

When Polygon.io streams huge volumes of live market data, ClickHouse handles it with ease and low latency. That’s exactly what we built StockHouse to show — an open-source demo that brings together live data streaming, low-latency analytics, and real-time visualization with Perspective. 🔗 Live demo: https://lnkd.in/dktnaA2Q

🚀 What's New in ClickStack – October '25 (fashionably late edition 😅) Another exciting month for the open-source observability stack built on ClickHouse, OTel, and HyperDX. This release brought: 🚨 ClickHouse Cloud alerting – no more custom setup, just click and alert 📊 Dashboard filters – finally! The feature everyone's been asking for 🔬 Event Deltas customization – way more flexibility for root cause analysis ⚡ Massive performance wins – charts load 95% faster with progressive rendering

🇹🇭 สวัสดีกรุงเทพฯ! เรากำลังจะจัดงาน ClickHouse Meetup อีกครั้ง — คราวนี้มาในธีม Observability 🔍 มาร่วมฟังเนื้อหาน่าสนใจ อยู่ต่อชมเดโม ทานของว่าง และพบปะเพื่อนๆ ในชุมชนสุดเจ๋งกัน! 🎉 📅 วันอังคารที่ 25 พฤศจิกายน ⏰ 18:30 – 21:00 น. (ICT) 📍 สำนักงาน Amazon Web Services (AWS) อาคารสิงห์ คอมเพล็กซ์ 🎟️ สำรองที่นั่งล่วงหน้าได้เลย — ที่นั่งมีจำนวนจำกัด! 👉 https://lnkd.in/dDAzP3bu Rana Banerji Maruthi Prithivirajan Lokananthan Bryan Seah Rakesh Puttaswamy #databaseengineer #dataengineer #databaseengineering #realtimeanalytics

🇮🇳 Mumbai, the ClickHouse crew is headed your way for another meetup, and this time with an Observability flavor! 🗓️ Saturday, November 22 ⏰ 10:30 AM - 2:00 PM IST 📍 Awfis Space Solutions @ Parinee Crescenzo (BKC) Spots are limited, register early 👉 https://lnkd.in/d3S9G5A4 Lalit Mishhra Anshul Mathur Mit Vaidya Rakesh Puttaswamy #databaseengineer #dataengineer #databaseengineering #datawarehouse #realtimeanalytics

Heading to KubeCon? 🚀 The ClickHouse team has a packed week planned — and we’d love to see you there! 🍸 ClickStack Happy Hour – Unwind after the conference with great food, drinks, and conversation on Monday Nov 10th. 💻 ClickStack Training – Learn how to build modern observability with ClickHouse + OpenTelemetry on Monday Nov 10th. 📍 Visit Our Booth – Meet the team, catch live demos, and join our KubeCon Passport Program at booth #130 for prizes and swag! Let’s make KubeCon unforgettable — come say hi! 👋 👉 Join the Happy Hour: https://luma.com/56t729bb 👉 Join the Training: https://lnkd.in/gyD3VFBq #KubeconNA #Atlanta #TrainingObservability #HappyHour

“At Modal, we try to keep things operationally simple. We want to be able to move fast, but we also care a lot about reliability.” When Ro Arepally and the team at Modal needed to scale real-time observability for AI workloads running across thousands of GPUs and containers, they turned to ClickHouse Cloud. At our Open House Roadshow in NYC, Ro shared how a single ClickHouse table powers hundreds of billions of logs and multiple real-time dashboards—and what the team is doing next to make it even faster. Catch his full talk and read more on our blog 👇 https://lnkd.in/eqKpdfea