I am running this query on BigQuery but I'm getting this error: Error: Scalar subquery produced more than one element
I'm just trying to update the Success field from Resources_Usage table to that of the job_events table. I can't really figure out what's wrong in my query.
UPDATE Task_Events.Resources_Usage
SET Success = t2.Success
FROM Task_Events.Resources_Usage t1 INNER JOIN Task_Events.job_events
t2 ON t1.job_id = t2.job_id
WHERE t2.Success is not null