ClickHouse can push cold data directly to S3, so S3 will be used as cold storage and the local filesystem as hot storage.

Another approach is to store all in S3 with local caching, it is much more easy and somewhat more efficient.

ClickHouse Cloud covers these concerns.