just test Clickhouse for your cases, because it's really good at aggregation because it has been designed for this and surprisingly good at joining as well