Bigquery, Execution Plan, Query Optimization.
join key. If one table’s joined key is heavily skewed to a few values, say 90% is null, it will cause one bucket is way bigger than the others, thus resulting in one worker having to process a lot more data than it can handle. You can easily notice this issue by investigating the Execution Plan. If