ClickHouse

    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…

    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…

    Amplifying ClickHouse® Capacity with Multi-Volume Storage (Part 1)

    As longtime users know well, ClickHouse has traditionally had a basic storage model.  Each ClickHouse server is a single process that accesses data located on a single storage device. The design offers operational simplicity–a great virtue–but restricts users to a…

    Altinity and ClickHouse® at KubeCon 2019

    The Altinity team just returned from sponsoring at KubeCon North America in San Diego November 19-21. I would like to thank all the people who visited our booth, especially current customers and ClickHouse users. It’s starting to be a real…

    Using Live View Tables with a Real Dataset

    My previous blog article introduced Live View tables, a new feature in ClickHouse that enables users to subscribe to query results and get new results as the underlying input changes. In this article, we will continue to explore using Live…

    Making Data Come to Life with ClickHouse® Live View Tables

    Have you ever wanted to get a notification from your database when the query result has changed due to new data? Have you ever wanted to build a real-time dashboard where your graphs would change in real-time based on fresh…