Announcing OSA Con: The Open Source Analytics Conference

Announcing OSA Con: The Open Source Analytics Conference

Altinity is excited to announce OSA Con, a new conference on open source analytics. We will bring together developers of open source analytic projects with developers who use open source in analytic applications. OSA Con will take place online on…

Announcing Analytics Track at Percona Live Online

Announcing Analytics Track at Percona Live Online

We are proud to announce the Percona Live community analytics track, organized by Altinity. There are so many great talks on up-and-coming data warehouses and databases. Join us May 12-13, 2021!

Goodbye XML, hello SQL! ClickHouse User Management Goes Pro

Goodbye XML, hello SQL! ClickHouse User Management Goes Pro

Access control is one of the essential features of database management. Starting in late 2019 ClickHouse contributor Vitaly Baranov began to introduce robust, full-featured Role Based Access Control (RBAC). As a result of this work–which included a huge number of…

ClickHouse is Apache 2.0

ClickHouse is Apache 2.0

Open source licenses are in the news again. Elastic recently changed the licensing for ElasticSearch and Kibana from Apache 2.0 to a choice of Server Side Public License (SSPL) or the non-open source Elastic license. Like most open source licensing…

Connecting to Altinity.Cloud with the ClickHouse Web UI

Connecting to Altinity.Cloud with the ClickHouse Web UI

Did you know that ClickHouse has a built-in Web UI? The Web UI is a simple but extremely useful feature Alexey Milovidov added to ClickHouse in October 2020. In this short article I’m going to show you how it works…

The ClickHouse Community

The ClickHouse Community

Editor’s Note: This blog article is also posted on the official ClickHouse blog. We would like to thank Alexey Milovidov, Ivan Blinkov, and Alexander Zaitsev for their kind assistance. One of the great “features” of ClickHouse is a friendly and…

Harnessing the Power of ClickHouse Arrays – Part 3

Harnessing the Power of ClickHouse Arrays – Part 3

This final article completes our tour of array capabilities. We’ll survey functions for array map and reduce operations, demonstrating behavior and commenting on performance. This is an opportunity to dig further into lambdas, which are critical for using arrays effectively.