1

分布式运维比较难直接上 Doris 或者 starrocks

2

直接用 doris 就行了

3

我存日志，有 573 亿，做了 7 个 clickhouse ，都是虚拟机，同一台全闪 7525 ，查询毫秒级，数据库后端这部分自己写的，没用其他中间件，体验很好，升级也没有太多坑，已经线上用了三年多了

4

Check the `Distributed table engine` of clickhouse.
1 trilliion rows is not big for clickhouse, the key is how your data partition.
what's the columns split your data, what's the minimum & maximum rows of one part, and how many parts of your general query will read.
For `order by` and `group by`, you will also focus on the columns you used,
clickhouse is not good at non primary key, you can check what called `mark` in clickhouse.
If your query sample from or sort in many marks, it will cause very low performance.

6

@red13 单台虚拟机 8 核心 24G 内存，服务器是 PowerEdge R7525 ，处理器:AMD EPYC 7H12 ，服务器负载常年 10%左右，服务器上还有其他业务一共 20 个左右虚拟机，clickhouse 只有 7 个