This is a listing of successful results of all the various data storage and processing system benchmarks I've conducted using the dataset produced in the Billion Taxi Rides in Redshift blog post. The dataset itself has 1.1 billion records, 51 columns and takes up about 500 GB of disk space uncompressed.
Though these benchmarks used the same dataset, I wouldn't consider any two as comparing apples to apples. The times recorded don't necessarily reflect the top performance these systems are capable of. It's likely each system could have performed faster if more effort was put into setup, configuration and/or better hardware was available. There are some cases where I re-ran a benchmark with more tuning to achieve a better result and in these cases only the fastest benchmark will be listed below.
The table is sorted by the fastest time query 1 finished in (measured in seconds).