ClickHouse® February Community Events
US-based 2020 ClickHouse meetups started the year with a bang: two events in San Francisco and New York City. Here is a summary of the talks including links to presentation slides.
ClickHouse® Altinity Stable release update 19.16.12.49 for Kafka users
Important notice for our beloved Apache Kafka users. We continue to improve Kafka engine reliability, performance and usability, and as a part of this entertaining process we have released 19.16.12.49 Altinity Stable ClickHouse release. This release supersedes the previous stable…
Fast Insight from Fast Data. Integrating ClickHouse® and Apache Kafka
Apache Kafka is a popular way to load large data volumes quickly to ClickHouse. In this webinar we will cover best practices for integrating Kafka and ClickHouse including setup of Kafka clusters, defining materialized views to pull data into ClickHouse,…
New ClickHouse® Altinity Stable Release 19.16.10.44
Welcome to the year 2020! New Year came and it’s a good time to update your ClickHouse to the latest Altinity stable version which we are presenting today. As always, Altinity Stable is a version we know is good and…
ClickHouse® Cost-Efficiency in Action: Analyzing 500 Billion Rows on an Intel NUC
See how ClickHouse delivers faster query performance on 500 billion rows of data compared to ScyllaDB, leveraging an Intel NUC mini PC, advanced compression, and materialized views.
Creating Beautiful Grafana Dashboards on ClickHouse®: a Tutorial
Dec 28, 2019Grafana is a popular tool to create dashboards of time series data. It features outstanding graphics, interactive displays that zoom in on data, and support for a wide range of data sources. It turns out that one of…
Connecting Excel to ClickHouse® using the Windows ODBC driver
Many years ago a wise customer once said, “every report wants to be an Excel spreadsheet when it grows up!” I have always had a soft spot for Excel–it’s one of the most useful programs that Microsoft ever released. To…
ClickHouse® December Community Events
The year 2019 ended with a burst of ClickHouse community events in the US and Europe. There were many great talks about ClickHouse from users exploring new use cases as well as operating at large scale. Here is a quick…
Webinar: A Practical Introduction to Handling Log Data in ClickHouse®
Log messages are one of the most important types of application data. ClickHouse is very good at storing log data; many SaaS applications use it under the covers. In this webinar we will show examples of different application logs and…
Taking a Closer Look at ClickHouse® Live View Tables
In the couple of previous blog posts, I have introduced Live Views tables and covered basic usage. Now, in this post, we will take a closer look at Live View tables. Specifically, we will look at the options available for…
Webinar: Tips and tricks every ClickHouse® user should know.
New users of ClickHouse love the speed but may run into a few surprises when designing applications. Column storage turns classic SQL design precepts on their heads. This talk shares our favorite tricks for building great applications. We’ll talk about…
Amplifying ClickHouse® Capacity with Multi-Volume Storage (Part 2)
This article is a continuation of the series describing multi-volume storage, which greatly increases ClickHouse server capacity using tiered storage. In the previous article we introduced why tiered storage is important, described multi-volume organization in ClickHouse, and worked through a…