I dont understand the need to NiH things, why not clickhouse with weekly, monthly, etc aggregation. It comes with built in sharding, can store time series data somewhat efficiently and doesn't have some hack h/a setup (in general not thanos).
Wouldn’t Clickhouse be the NIH solution? Thanos supports Prometheus natively, but Clickhouse doesn’t (or at least doesn’t appear on the integrations list in the Prometheus docs), so you’d have to write an adapter for it.
I'll bite, no because Prometheus, Thanos, etc all have to reinvent sharding (Thanos), a query language (Promql), vectorizing (Prometgeus can't), transactions (Prometheus internals), etc when it all exists in clickhouse and uses somewhat standard SQL. There are trade-offs but imo it's not worth NiHing something