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.
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.
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…
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. This article summarizes the talks…
ClickHouse Unleashed 2020: Our Favorite New Features for Your Analytical Applications
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…
Using Joins in ClickHouse Materialized Views
ClickHouse materialized views provide a powerful way to restructure data in ClickHouse. We have discussed their capabilities many times in webinars, blog articles, and conference talks. One of the most common follow-on questions we receive is whether materialized views can…
Adventures in Observability: How In-House ClickHouse Deployment Enabled Instana to Build Better Monitoring for Users
Instana automated APM provides complete visibility into complex systems, including ClickHouse servers. Hear how their team uses ClickHouse to power their solution and how they’ve integrated them back into their own ClickHouse monitoring features.
Big Data and Beautiful Video: How ClickHouse enables Mux to Deliver Content at Scale
Mux.com enables content providers to stream video to vast audiences while maintaining pin-point control over performance. Join us as Adam Brown, a co-founder of Mux and video expert, explains the role that ClickHouse plays in content delivery. We close with…
Big Data in Real-Time: How ClickHouse powers Admiral’s visitor relationships for publishers
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. Discussion includes how Admiral…
MORE secrets of ClickHouse Query Performance
ClickHouse is famously fast, but a small amount of extra work makes it much faster. Join us for the latest version of our popular talk on single-node ClickHouse performance. We start by examining the system log to see what ClickHouse…
ClickHouse Kafka Engine Tutorial
Our colleague Mikhail Filimonov just published an excellent ClickHouse Kafka Engine FAQ. It provides users with answers to common questions about using stable versions, configuration parameters, standard SQL definitions, and many other topics. Even experienced users are likely to learn…
Monitoring ClickHouse on Kubernetes with Prometheus and Grafana
The ClickHouse Kubernetes operator is great at spinning up data warehouse clusters on Kubernetes. Once they are up, though, how can you see what they are actually doing? It’s time for monitoring!In this article we’ll explore how to configure two…