Re:Redshift vs. BigQuery vs. Snowflake benchmark
by ruw1090 on Monday October 09, 2017 @01:26PM
(#15435717)
It looks like you had to rewrite the queries pretty significantly to get them to run on all three. Redshit/Bigquery don't support rollup/grouping sets/intersect/except etc. which the TPCDS spec queries have. Is there a reason you don't mention this in the blog post? SQL surface area seems like a pretty important thing to consider when choosing a DW.
[ Parent
| on HN ]
Re:Redshift vs. BigQuery vs. Snowflake benchmark
by dimfeld on Monday October 09, 2017 @03:17PM
(#15436612)
GROUP BY ROLLUP support actually just arrived in Bigquery a week or two ago. Still a lot of things missing, but they are steadily improving.
Re:Redshift vs. BigQuery vs. Snowflake benchmark
by georgewfraser on Monday October 09, 2017 @01:49PM
(#15435916)
I talk about that a little in footnote 5. The changes were mostly just syntax, which I don't think is very important. You may disagree, but surely we can both agree that the important thing is it's all in GitHub so you can see the edit history of the queries :)