BQML Errors

2 views
Skip to first unread message

Tom Krywitsky

unread,
Mar 19, 2024, 2:51:55 PMMar 19
to Instant BQML Users
Hello, 

We've faced errors when trying to launch the instant BQML training pipeline. It appears that there are nulls in the final joined training table.



Any ideas on what could be going wrong? I suspect they might not have enough events/engagements etc to build the full training set and are getting nulls on the join. 

Thanks,
Tom

Instant BQML Users

unread,
Mar 19, 2024, 5:00:02 PMMar 19
to Instant BQML Users
Hi Tom,

I'm resending the screenshot that didn't come through initially. You're seeing two errors: one about an "internal error" and another about NULLs in your data. The NULL warning is standard; BigQuery ML handles it automatically, so it's likely not the cause.

Rather, after a bit of scouring on the Internet, I was able to find this document that indicates that when seeing this error in BigQuery ML it may be related to the hyperparameter ENABLE_GLOBAL_EXPLAIN being set to TRUE. This is indeed the case with Instant BQML models, so I think I would test setting ENABLED_GLOBAL_EXPLAIN to FALSE and trying again.

If that doesn't work, please grab the job ID of the query and escalate to BigQuery support.

Thanks again for reaching out.

image (2).png
Reply all
Reply to author
Forward
0 new messages