Blog · Innovation · News
Real-time Queries on AWS S3 Table Buckets in ClickHouse®
Connect ClickHouse to AWS’s new S3 Table Buckets using Iceberg, run real-time SQL on Parquet data, and build data pipelines in Altinity.Cloud.
Tales of Restaurants and Food Trucks: Merging Real-time Analytics with Data Lakes
Large data lakes are challenging centralized analytic services. To deliver real-time analytics, databases need to work less like restaurants and more like food trucks.
ClickHouse® MergeTree on S3 – Keeping Storage Healthy and Future Work
The final article of our series on managing large datasets in ClickHouse MergeTree covers how to clean up orphan S3 files. We conclude with ideas for future improvements to S3 storage management.
ClickHouse® MergeTree on S3 – Administrative Best Practices
Our series on managing large datasets in ClickHouse MergeTree tables continues. In Part 2 we discuss best practices for S3 bucket configuration, storage policies, and MergeTree table administration.
ClickHouse® MergeTree on S3 – Intro and Architecture
ClickHouse datasets are getting big. Store MergeTree table data on S3 object storage to handle them economically and flexibly. Part 1 covers architecture and storage organization.
Building A Better ClickHouse® for Parquet in Practice
A few weeks ago we discussed how to read external Parquet data from ClickHouse. The article raised some performance concerns when querying big collections of Parquet files out of AWS S3 buckets. Time flies fast. Altinity engineers have made some…
Reading External Parquet Data from ClickHouse®
ClickHouse support for Apache Parquet is outstanding. We blogged about it last year in “What’s Up With Parquet Performance in ClickHouse”. In this article, we will look at Parquet from a different perspective. Let’s say there is public Parquet data…
Is ClickHouse® Moving Away from Open Source?
Open source licensing helped ClickHouse grow. Now the project is moving to open core. There’s reason for users to be concerned.
Delivering Better S3 Support in ClickHouse®
S3-compatible object storage support is critical for ClickHouse applications. There is a new community proposal to make it much better.
What’s Up with Parquet Performance in ClickHouse®?
Supported in ClickHouse, Apache Parquet has use cases other than just a storage format in the Hadoop ecosystem. See what results we got when we tested it in Altinity.Cloud to query Parquet files at S3 with the same efficiency as…
Loading 100B Rows in Minutes in Altinity.Cloud®
A few weeks ago the SingleStore team published interesting research in their blog. They demonstrated how to load 100 billion rows in a database in 10 minutes. While it did not seem outstanding for ClickHouse, we were intrigued to learn…
Ultra-Fast Data Loading and Testing in Altinity.Cloud®
Learn how you can load and test ClickHouse datasets with lightning speed and leverage the power of cloud operation with this Altinity.Cloud tutorial. PS…You’ll find it’s really easy too!