It is my pleasure to announce that Altinity is now a member of the Cloud Native Computing Foundation (CNCF). We will also be a sponsor at Kubecon/CloudNativeCon North America 2019 in San Diego 18-21 November.Read More
It is already more than 3 years since ClickHouse surprisingly popped up from inside the Yandex labs and moved to open source. Since then it grew up from an ugly duckling, that was sometimes not that easy to deal with, to a mature well established analytical database, used at companies from small startup to Fortune 500 enterprises all around the world. Today, ClickHouse has made one more important step, it moved from the Yandex cradle to its own new home at Github!Read More
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 now depend on the Vertamedia implementation.Read More
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 Thursday evening. Some attendees flew over from other cities and countries. The first talk started at 7pm, and the last clickhousers left the building shortly after midnight, full of ideas from interesting talks and conversations.Read More
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 the materialized view definition create the underlying table for data automatically. Both of these techniques are quick but have limitations for production systems.
In the current post we will show how to create a materialized view with a range of aggregate types on an existing table.
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 across large numbers of nodes and work on large datasets. They are one of the distinguishing features of ClickHouse.Read More
Sept 5, 2019
Robert Hodges on The Python Podcast with Tobias Macey
The ecosystem of tools and libraries in Python for data manipulation and analytics is truly impressive, and continues to grow. There are, however, gaps in their utility that can be filled by the capabilities of a data warehouse. In this episode Robert Hodges discusses how the PyData suite of tools can be paired with a data warehouse for an analytics pipeline that is more robust than either can provide on their own. This is a great introduction to what differentiates a data warehouse from a relational database and ways that you can think differently about running your analytical workloads for larger volumes of data.Read More
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, and 217 contributors completed about 6000 commits. Unfortunately, during those months of active development ClickHouse suffered from stability issues. We have been working hard together with the core ClickHouse team to nail them down. Today we are happy to introduce a new 'Altinity Stable’ release 19.11.8!Read More