v.22.11New Feature

Introduce s3_plain Disk Type for Write-Once-Read-Many Operations in MergeTree Table

Introduce s3_plain disk type for write-once-read-many operations. Implement ATTACH of MergeTree table for s3_plain disk. #42628 (Azat Khuzhin).
Introduces a new s3_plain disk type optimized for write-once-read-many operations and implements support for ATTACH of MergeTree tables using the s3_plain disk.

Why it matters

This feature addresses the need for efficient storage and retrieval of data on S3-compatible storage where data is written once and read many times, improving performance and reliability. It enables users to leverage S3 storage for MergeTree tables with optimized handling, facilitating better integration with cloud object storage for scenarios where data immutability after write is expected.

How to use it

Users can configure a new disk of type s3_plain in their ClickHouse storage configuration to enable write-once-read-many access patterns. Then, they can ATTACH existing MergeTree tables located on the s3_plain disk to make use of this feature.