ClickHouse I would say is more for analytics and data warehouse types of loads. So not a direct competitor to those tools except maybe for Pinot.

It is very easy to ingest data into CH. We connected exchange topics and it just worked with zero code.

But the thing with CH is that it is pretty much a Russian product so you should not use it for production anymore.

We’ve come at a time in which we fear exploring projects like Apache Doris because we fear that OSS might be used in malicious ways by state-backed actors.

I would like to see some sources on your claim about it being Russian. It is incorporated in the US with most developers in Amsterdam.

After the invasion of Ukraine they stayed silent for a while but that was because they needed to allow there developers to get out of Russia. Many of them are Ukrainians including the CTO and founder. As soon as it was safe for there team they took a very firm stance against Russia with Ukrainian flags on the website and written statement from the team.

I am not aware of any Russian influence currently.