ClickHouse

    New Release for Grafana ClickHouse® Plugin

    Grafana is a very powerful and popular open source dashboard tool used in many ClickHouse projects. ClickHouse in Grafana is enabled by the Grafana ClickHouse plugin developed by the company Vertamedia, a ClickHouse early adopter.  Many users in the community…

    Moscow Meetup, Cutting Edge ClickHouse® Features and Roadmap

    The recent Moscow ClickHouse meetup was quite a big event, as expected. ClickHouse is very popular in Russia and usage has penetrated widely among companies here.  450 people registered, and around 200 showed up at the Yandex conference hall on…

    ClickHouse® Materialized Views Illuminated, Part 2

    In the previous blog post on materialized views, we introduced a way to construct ClickHouse materialized views that compute sums and counts using the SummingMergeTree engine. The SummingMergeTree can use normal SQL syntax for both types of aggregates. We also let…

    ClickHouse® Materialized Views Illuminated, Part 1

    Readers of the Altinity blog know we love ClickHouse materialized views. Materialized views can compute aggregates, read data from Kafka, implement last point queries, and reorganize table primary indexes and sort order. Beyond these functional capabilities, materialized views scale well…

    New Altinity Stable ClickHouse® 19.11.8 Release Is Out!

    It has been quite a while since we announced the previous ‘Altinity Stable’ ClickHouse in December 2018. Since then there have been a lot of changes and new features in ClickHouse. The core team has merged almost 1000 pull requests,…

    ClickHouse® at Data Con LA 2019

    On August 17 I had the pleasure of presenting at Data Con LA 2019.  My talk was Data Warehouse and Kubernetes:  Lessons from the ClickHouse Operator. It described learnings from our work to enable ClickHouse to run easily on Kubernetes….

    Silicon Valley ClickHouse® Meetup Report

    The latest San Francisco Bay Area ClickHouse Meetup was in Silicon Valley on August 13th. We had between 25 and 30 attendees at H2O.ai, who kindly hosted the event at their offices in Mountain View. The crowd was enthusiastic, leading…

    Webinar: Introduction to the Mysteries of ClickHouse® Replication

    Built-in replication is a powerful ClickHouse feature that helps scale data warehouse performance as well as ensure high availability. This webinar will introduce how replication works internally, explain configuration of clusters with replicas, and show you how to set up…

    Podcast: My Future Business Interview with Robert Hodges

    July 24, 2019If you’re a business that manages a lot of commercial data, and you need a solution that reliably stores and analyzes that information, then this call is for you!Robert Hodges, Altinity CEO with Rick Nuske, My Future Business

    New Encodings to Improve ClickHouse® Efficiency

    July 10, 2019Modern analytical databases would not exist without efficient data compression. Storage gets cheaper and more performant, but data sizes typically grow even faster. Moore’s Law for big data outperforms its analogy in hardware. In our blog we already…

    Podcast: Scale Your Analytics On The Clickhouse® Data Warehouse

    July 8, 2019Robert Hodges and Alexander Zaitsev on Data Engineering Podcast with Tobias Macey The market for data warehouse platforms is large and varied, with options for every use case. ClickHouse is an open source, column-oriented database engine built for…