I had lot of success with Clickhouse recently for tables that are 200+ millions row and that was with the Log table engine, not the Merge tree one so I would expect it to get even faster when we change.

It's very easy to setup so you should be able to test it quickly to see if it fits your needs.