i really dislike clickhouse for anything less than rudimentary analysis, but appreciate that it’s fast for that.
Can you give some tips on what do you mean by "less than rudimentary analysis"? Considering adopting Clickhouse and wondering whether we will encounter problems down the road.
the biggie for me was that analytic window functions are either non-existent or experimental and must be achieved with array function hacks.
it does have nice built-in skew and kurtosis functions, though.
ClickHouse recently landed Window Functions in GA.