Stop pretending you struggled when you're an IT guy. There are people who actually struggled, people who don't live in luxury in the richest parts of Europe like you do and yet they are happy to be part of the struggle for better world that EU is trying and don't hate everyone like you do.
You can be both right. I would say that ClickHouse is a focused system - it is really really good at the things it's good at, and it is not good at the rest.
Anecdote: I tested ClickHouse as possible replacement of Trino+DeltaLake+S3 for some of our use cases.
When querying a precomputed flat tables it was easily 10x to 100x faster. When running complex ETL to prepare those tables, I gave up when CTAS with six CTEs that takes Trino 30 seconds to compute on the fly turned into six intermediate tables that took 40 minutes to compute, and I wasn't even halfway done.
The tricky part is, how do you know whether your use case fits? But you have to ask this question about all the "specialized tools", including Pinot.
Israel is still considered ally for multitude of reasons: big organisations don't turn on a dime and sometimes take decades to change course (same reason Turkey is still considered ally), fascists love Israel as model "pure people state" more than they hate Jews, and small but influential part of American Evangelicals believe that Jews having their own state is necessary step to get us the Rapture.
But you probably know all this, nothing you said was in good faith and and just come to HN to turn your hatred on random people.
Just downvote, flag and move on. This guy is here to insult people for fun and stir shit. No reason to engage (and yes, I know I'm also guilty of engaging with anti-Western but definitely not pro-Chinese/pro-Russian trolls).
Alliances are not just about power, but also about common values and goals. Strong allies are good. Strong enemies that are for historic reason part of alliance are pretty bad, and need to be managed.
That is why Turkey is not getting F-35s or even F-16s now. Why help arm your enemy?
RedShift, Snowflake, Citus, Greenplum and Athena are OLAP engines, but not real-time focused. For this one, it is more similar to Druid, ClickHouse or RockSet.
The 1.0 version of Pinot seems to bring a lot of maturity, they seem to have added new engine that can do joins now. I'm not sure how stable it is, but it seems interesting.
As for what is this kind of database usedful for, this is for operational analytics on large data that also update in real time. In my domain that would be things like having insight into large supply chains or manufacturing operations, like power plants or factories, just in general for monitoring stuff. I know it's also used in security and finance (for fraud).
> Mark Buckingham is free to do his version of Fables (and I dearly hope he does). Steve Leialoha is free to do his version of Fables (which I’d love to see). And so on.
Back of the napkin: hundred million iPhones recharging their 13 Wh battery once a day every day from zero to full for a year is about 60 % the electric energy that this power plant [1] makes in a year.
Not huge amount of energy, but not negligible either.
The evil of USSR did was because Russia was in charge.