We at Dassana[1] use clickhouse underneath and solve the exact same problem. Have a look and feel free to reach out to me if you have any questions. You can find more details on my ShowHN post[2].

[1] https://lake.dassana.io

[2] https://news.ycombinator.com/item?id=31111432