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 supportGreenplum seems to satisfy these requirements best. What experiences have you made? Any another solutions you’d recommend?