2 ms·
> Very BigQuery like system. What makes you say that? The main innovation in BigQuery was the ability to store and query nested data. Amazon Redshift doesn't
by scribu 9y ago
> Very BigQuery like system.
What makes you say that?
The main innovation in BigQuery was the ability to store and query nested data.
Amazon Redshift doesn't support querying nested data. It only has some convenience functions for loading flat data from nested JSON files hosted on S3.
And what I assume Spectrum does is just perform that loading step behind the scenes.
- deleted 9y ago[deleted]
- puzzle 9y agoAt a first read, it sounded like you didn't need to run a cluster ("Spectrum scales to thousands of instances"), which is BigQuery's big advantage. Later, it says that you still need a cluster, but it's only used in the final processing stages. So it looks like it's 3/4 of the way to BQ.