TLDR Amir asked about query results when using S3 for cold storage. Srikanth confirmed it's possible with a performance hit, as metadata is kept on disk for reference.
Hi guys, a question regarding S3 configuration for cold storage - will I be able to get query results from S3 when it is configured? If not, how can I run queries on the offloaded data. Thanks!
You should be able to get the query results but with some hit to performance. ClickHouse keeps a metadata for s3 objects on the disk and fetches info when needed.
Indexed 1060 threads
Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI