When it comes to conducting analysis on very large structured data sets, there are a limited number of viable players which won’t require a second mortgage and army of consultants to use (looking at you, Exadata). For the last several years my platform of choice has been HP Vertica: it’s fast, scales well, relatively easy to manage/performance tune, and is fairly middle of the pack for pricing. However, for the last several months I’ve been using Redshift as my primary data warehouse and feel ready to make a comparison on where the platforms materially differ.
Check out the full post here:
http://robertwinters.nl/2015/06/2015-06 ... t-vertica/