It'll be faster than Redshift and about the same as ClickHouse, +/- depending on hardware and setup.
It's a great system, we used it for 2 years and it's one of the most polished databases out there with a simple MySQL interface. It's more general purpose than kdb, with a nice rowstore + columnstore architecture. I believe they're adding full-text search indexes in the latest version too.
If you need the query language, the advanced/asof joins, or the tightly integrated query/process environment, then there's no match to kdb though.
It's a great system, we used it for 2 years and it's one of the most polished databases out there with a simple MySQL interface. It's more general purpose than kdb, with a nice rowstore + columnstore architecture. I believe they're adding full-text search indexes in the latest version too.
If you need the query language, the advanced/asof joins, or the tightly integrated query/process environment, then there's no match to kdb though.