Ask HN: Best open source replacement for Redshift

[charistoph]

Currently searching for open-source data warehouse replacement for Redshift.

These are the ideal requirements of such a solution (Redshift doesn't satisfy all): Open source, columnar storage + read optimized, foreign key support, interfaces with the more common DBs & BI tools + streaming ingestion, horizontal scaling, reasonable maintenance effort, string search indexing, a large & active dev community & commercial support

Greenplum seems to satisfy these requirements best. What experiences have you made? Any another solutions you’d recommend?