The ClickHouse Community

Editor’s Note: This blog article is also posted on the official ClickHouse blog. We would like to thank Alexey Milovidov, Ivan Blinkov, and Alexander Zaitsev for their kind assistance. One of the great “features” of[...]

Read More
Harnessing the Power of ClickHouse Arrays – Part 3

This final article completes our tour of array capabilities. We’ll survey functions for array map and reduce operations, demonstrating behavior and commenting on performance. This is an opportunity to dig further into lambdas, which are critical for using arrays effectively.

Read More
Harnessing the Power of ClickHouse Arrays – Part 2

ClickHouse arrays combine neatly with GROUP BY aggregation. We show how arrays track sequences and offer a couple of ways to do funnel analysis.

Read More
Harnessing the Power of ClickHouse Arrays – Part 1

ClickHouse contributors regularly add analytic features that go beyond standard SQL. This design approach is common in successful open source projects and reflects a bias toward solving real-world problems creatively. Arrays are a great example.

Read More
Introduction to High-Velocity Analytics Using ClickHouse Arrays

Arrays are a prominent ClickHouse SQL extension that can accelerate query speed up to 100x in well-chosen use cases. This webinar introduces ClickHouse arrays and shows how to use them effectively. We provide examples of idiomatic usage and guides you on use cases where you should immediately reach for arrays. Please join us to become a power user of this popular ClickHouse feature.

Read More
What we learned by closing a $4M investment from Accel

I’m pleased to share the news that Altinity has raised a $4M seed investment from Accel, led by Dan Levine. We are honored by Accel’s trust and delighted to work with Dan. We plan to use the investment to roll out our new Altinity.Cloud platform and to strengthen ClickHouse into the best analytic database on the planet.

Read More
ClickHouse Data Integration — September 2020 Meetup Report

Our last ClickHouse SF Bay Area meetup was on September 10th and focused on data integration. This turned out to be a popular subject.  We had well over 100 signups with 59 people in attendance.[...]

Read More
Conference Slides. Five Great Ways to Lose Data on Kubernetes (And How to Avoid Them)

As databases and stateful apps rapidly adopt Kubernetes, the reality of accidental data loss isn't far behind. Robert Hodges, Altinity CEO, will give listeners tools to push through the paranoia and ensure happy experiences with cloud native data.

Read More
Webinar Slides. ClickHouse Unleashed 2020: Our Favorite New Features for Your Analytical Applications

Curious what’s new in ClickHouse? This talk is for you! Watch to learn about new features of ClickHouse, ranging from tiered storage to compact MergeTree format to SQL join improvements. Preview new features like object storage and LDAP support planned for the remainder of 2020. We close out, by discussing Altinity Stable Releases and how they help you decide when features are ready for production use. Don’t miss this opportunity to get current on ClickHouse improvements to help you build even better analytics!

Read More
ClickHouse Unleashed 2020: Our Favorite New Features for Your Analytical Applications

August 6, 2020
Alexander Zaitsev and Robert Hodges

Curious, what's new in ClickHouse? This talk is for you! Learn about new features of ClickHouse, preview new features like object storage and LDAP support planned for the remainder of 2020, and closeout with Altinity Stable Releases and how they help you decide when features are production-ready. Don't miss this opportunity to get current on ClickHouse improvements to help you build even better analytics!

Read More
Webinar Slides. Adventures in Observability: How In-House ClickHouse Deployment Enabled Instana to Build Better Monitoring for Users

Instana is an Application Performance Monitoring solution that provides complete visibility into complex distributed systems, including ClickHouse servers. In this webinar, we welcome Marcel Birkner and Yoann Buch of Instana. They describe how the Instana team uses ClickHouse to power their solution, lessons they have learned, and how they integrated them back into Instana's own ClickHouse monitoring features. Along the way, you'll learn how to set up Instana on ClickHouse, what important metrics you should track, how ClickHouse is integrated in end-to-end distributed tracing, and what level of automation is available for root cause analysis and alerting.

Read More
Webinar Slides. Big Data in Real-Time: How ClickHouse powers Admiral’s visitor relationships for publishers

By James Hartig and Robert Hodges Slides for the Webinar, presented on June 16, 2020 Webinar recording is available here Advertising is dying in the wake of privacy and adblockers. Join us for a conversation with James Hartig, a Co-Founder at Admiral (getadmiral.com), who helps publishers diversify their revenue and build more meaningful relationships with users. We'll start with an overview of Admiral's platform and how they use large scale session data to power their engagement engine. We'll then discuss the ClickHouse features that Admiral uses to power these real-time decisions. Finally, we'll walk through how Admiral migrated from MongoDB to ClickHouse and some of their plans for future projects. Join us to learn how ClickHouse drives cutting edge real-time applications today!

Read More