Intermediate
Big Data & Data Engineering
Q45 / 100
What is a "broadcast join" and when is it useful?
Correct! Well done.
Incorrect.
The correct answer is A) A join where a small table is sent to all nodes in full, avoiding a shuffle of the large table when joining with it
A
Correct Answer
A join where a small table is sent to all nodes in full, avoiding a shuffle of the large table when joining with it
Explanation
When one table is small enough to fit in memory on each executor, broadcasting it avoids shuffling the large table, significantly speeding up the join.
Progress
45/100