Massively parallel processor architectures (MPP) have quickly developed into the go-to solution for big data analytics. The benchmark confirms how Redshift is the fastest among on-disk solutions, although slower than in-memory queries on Impala and Shark whenever the data could still fit in memory. Google BigQuery was not yet included in the UC Berkeley's benchmark.
We have built MegaPivot to provide access to cutting edge columnar massively parallel processor cloud platforms to any non-technical business analyst that needs flexibility and power to run queries and aggregation over million and even billions of rows. MegaPivot has chosen Google BigQuery as a platform to make it even easier to connect to Google Analytics unsampled data and integrate with Google Apps environments.