3 ms·
My team is (over|ab)using Elasticsearch and I've had my eye on ClickHouse for a while. However we're going to migrate everything to AWS and I wonder if RedShift
by hocuspocus 5y ago
My team is (over|ab)using Elasticsearch and I've had my eye on ClickHouse for a while. However we're going to migrate everything to AWS and I wonder if RedShift could be a good alternative too, since it's now supporting JSON and semi-structured data apparently.
- bayan1234 5y agoHaving used Redshift considerably in the past and experienced significant pain with many aspects of it, I would stay away. There are other much better options, ideally Snowflake.
- daniel_levine 5y agoAltinity offers a managed service for ClickHouse on AWS https://altinity.com/cloud-database/ https://altinity.com/cloud-database/
- hocuspocus 5y agoThanks but my employer is becoming an AWS partner and we'll contractually need to spend a lot of money, meaning it's better if we use their SaaS offerings directly rather than going through the marketplace or a 3rd party.
- lima 5y agoThat's a funny way of making engineering design decisions.
- hocuspocus 5y agoSome battles are above my pay-grade.
- joshstrange 5y agoMy company has/in-in-the-process of moving from ES to CH and from my (limited) perspective it's been going well. I greatly prefer writing CH queries over ES. I can't speak to RedShift but I wanted to throw in the data point of an ES->CH move.