ClickHouse at Data Con LA 2019

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

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

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

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

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

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

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…

Webinar: ClickHouse and the Magic of Materialized Views

Webinar: ClickHouse and the Magic of Materialized Views

Materialized views are a killer feature of ClickHouse that can speed up queries 200X or more. Our webinar will teach you how to use this potent tool starting with how to create materialized views and load data. We’ll then walk…

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

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

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

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…