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.
ClickHouse arrays combine neatly with GROUP BY aggregation. We show how arrays track sequences and offer a couple of ways to do funnel analysis.
ClickHouse is a polyglot database that can talk to many external systems using dedicated engines or table functions. In modern cloud systems, the most important external system is object storage. It can hold raw data to import from or export…
ClickHouse contributors regularly add analytic features that go beyond standard SQL. This design approach is common in successful open source projects and reflects a bias toward solving real-world problems creatively. Arrays are a great example.
We continue the journey of Altinity’s enterprise QA process in ClickHouse shows how we use TestFlows open source testing framework to help us author our automated tests.
Arrays are a prominent ClickHouse SQL extension that can accelerate query speed up to 100x in well-chosen use cases. This webinar introduces ClickHouse arrays and shows how to use them effectively. We provide examples of idiomatic usage and guides you…
BERKELEY, October 1, 2020 | Altinity, the largest enterprise ClickHouse services provider, today launched its first cloud service, Altinity.CloudTM, which offers best-in-class operations, administration and maintenance to support application development with ClickHouse.
I’m pleased to share the news that Altinity has raised a $4M seed investment from Accel, led by Dan Levine. We are honored by Accel’s trust and delighted to work with Dan. We plan to use the investment to roll…
The first part of Altinity’s modern QA process in ClickHouse shows how we work with requirements and execute each step to fit into an open-source project.
We’ll talk about our experience building a next-generation OLAP capability for eBay event data using ClickHouse and realizing large infrastructure savings compared to the previous-generation solution built on Druid. Given the scale of eBay, this requires a highly scalable, performant…
We are delighted to announce that the ClickHouse Altinity Stable Release is updated to 20.3.19.4. This release includes several dozen bug fixes not present in the previous 20.3.12.112.
Our last ClickHouse SF Bay Area meetup was on September 10th and focused on data integration. This turned out to be a popular subject. We had well over 100 signups with 59 people in attendance. This article summarizes the talks…
