Spark · easy · ~10 min
A daily join between events and accounts used to finish in 6 minutes. Today it's been running for 45. The Spark UI shows the final stage is 199 of 200 tasks complete — but one task has been running for 40 minutes with no end in sight. Cluster CPU is mostly idle.
events
accounts
Figure out why one task refuses to finish.