I haven't come across a query that takes more than a minute or so in BigQuery, except this one for some reason. Can anyone shed light on why this query would take so long?

If any Google engineers are viewing this, the job ID is job_qHSgmV1CKbJnQeEZpqw1cb1g6f4.