Bigquery, Execution Plan, Query Optimization.
several workers at stage 2 because all the records of the same key are sent to one worker. Image by the author Similarly, the following SQL functions will invoke redistribution of data at shuffle layer: GROUP BY/ DISTINCT: as explained above JOIN: Data from each table is shuffled based on the