ClickHouse

    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…

    Managing ClickHouse® Datasets with ad-cli

    July 1, 2019Large datasets are critical for anyone trying out or testing ClickHouse. ClickHouse is so fast that you typically need at least 100M rows to discern differences when tuning queries. Also, killer features like materialized views are much more…

    clickhouse-local: The power of ClickHouse® SQL in a single command

    June 11, 2019The most interesting innovations in databases come from asking simple questions.  For example: what if you could run ClickHouse queries without a server or attached storage?  It would just be SQL queries and the rich ClickHouse function library….

    ClickHouse® Events in Austin and San Francisco

    June 10, 2019The last two weeks have been a busy time for ClickHouse-related events. Altinity as well as the Yandex teams have been doing a world tour that included events in the US as well as Asia. Besides the opportunity…

    Webinar: Analyzing Billion Row Datasets with ClickHouse®

    This talk shows how to get a sub-second response from datasets containing a billion rows or more. We’ll start with defining schema and loading quickly data in parallel. We will then introduce tricks like LowCardinality datatype, ASOF joins, and materialized…