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.
Read MoreHarnessing the Power of ClickHouse Arrays – Part 2
ClickHouse arrays combine neatly with GROUP BY aggregation. We show how arrays track sequences and offer a couple of ways to do funnel analysis.
Read MoreHigh Performance, High Reliability Data Loading on ClickHouse
December 9, 2020
with Alexander Zaitsev
Data loading is a critical topic when building real-time data warehouses on ClickHouse. This webinar covers three ClickHouse topics every app designer should understand: insert performance, transaction reliability, and data deduplication.
ClickHouse and S3 Compatible Object Storage
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 to other systems (aka a data lake) and offer cheap and highly durable storage for table data. ClickHouse now supports both of these uses for S3 compatible object storage.
Read MoreHarnessing the Power of ClickHouse Arrays – Part 1
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.
Read MoreThe Altinity Way to Building Enterprise QA Process in ClickHouse – Part 2
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.
Read MoreIntroduction to High-Velocity Analytics Using ClickHouse Arrays
As databases and stateful apps rapidly adopt Kubernetes, the reality of accidental data loss isn't far behind. Robert Hodges, Altinity CEO, will give listeners tools to push through the paranoia and ensure happy experiences with cloud native data.
Read MoreAltinity Introduces Altinity.Cloud and Secures $4M in Funding from Accel
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.
Read MoreWhat we learned by closing a $4M investment from Accel
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 out our new Altinity.Cloud platform and to strengthen ClickHouse into the best analytic database on the planet.
Read MoreThe Altinity Way to Building Enterprise QA Process in ClickHouse – Part 1
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.
Read MoreAltinity Stable Release™ Update 20.3.19.4
We are delighted to announce that 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.
Read MoreClickHouse Data Integration — September 2020 Meetup Report
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.[...]
Read More