3 ms·
> you should first consider switching to a purpose-built column-store like Redshift/BigQuery/Snowflake. True, unless you have regulatory requirements that you
by glial 10y ago
> you should first consider switching to a purpose-built column-store like Redshift/BigQuery/Snowflake.
True, unless you have regulatory requirements that you can't store your data off-site.
- nattaylor 10y agoSomething like self hosted HDFS + Parquet + Presto/Hive would work though, wouldn't it?
- georgewfraser 10y agoWell there's lots of good on-prem columnar data warehouses. They're expensive, but you have to think in terms of total cost of ownership: a good warehouse will require less time from your team building workarounds.
- greggyb 10y agoI'm not sure what your threshold of expensive is, but this is available in MS SQL Server. You don't necessarily need to purchase an application solution or a specific DW RDBMS. https://www.microsoft.com/en-us/sql-server/sql-server-editions https://www.microsoft.com/en-us/sql-server/sql-server-editio...