Bigquery, Execution Plan, Query Optimization.
aggregate all records returned stage 1. We can not distribute the workload at stage 2 to multiple workers, simply because one doesn’t know if any others are processing records of the same key (name). Image by the author ▶️ 2️⃣ If we follow the approach 2, we can easily distribute the workload to