News for hackers. Stuff that matters.

A comment on Redshift Spectrum – Exabyte-Scale In-Place Queries of S3 Data. Parent comment

Re:Redshift Spectrum – Exabyte-Scale In-Place Queries of S3 ... by idunno246 on Wednesday April 19, 2017 @02:50PM (#14150596)
And you can actually materialize a query in redshift since Athena doesn't have create table as select. This is neat, though I wonder if opening Athena to connect to Postgres(presto can) and do the join inside Athena would have been better
[ Parent | on HN ]
Re:Redshift Spectrum – Exabyte-Scale In-Place Queries of S3 ... by openasocket on Wednesday April 19, 2017 @03:35PM (#14151001)
I'd say that I have more confidence in the Redshift query planner and execution engine than that of presto. And having the option to join that with data stored in-memory on redshift nodes is very attractive.
[ Parent | on HN ]