I am looking for open-source alternatives to SQL Server Enterprise Edition for a mostly-read analytics workload. The main key features that I'm looking for are
- Column-oriented storage
- Parallel query execution - in particular, sorts/group by etc. should use multiple cores, like SQL Server does.
- Clustering / horizontal scaling options. I am not interested in sharding or shared-nothing as much as I am in being able to add additional CPUs to a single (logical) DB instance.
I looked at PostgreSQL with cstore_fdw, which gets a column-store but individual queries are still single-threaded.
What else should I be looking at?