Great analysis, thanks for sharing!

Here I wrote a summary of Mark Lit’s finding when running the same queries over the same billion row datasets over many platforms:

(summary: BigQuery is the only one that took 2 seconds with no optimizations needed — every other platform was many times slower and required way more optimizations)