CODEWITHSUNDEEP
google-bigquery
Emre Colak
Emre Colak

Reputation: 814

Resources exceeded during query execution when I use join each

I tried running a join query on Bigquery and I got the "table too large for joining" error which I understand. Then I tried using JOIN EACH instead of JOIN and I got an error saying "Resources exceeded during query execution". Are there limits on JOIN EACH that I need to be aware of too?

Upvotes: 0

Views: 498

Answers (1)

Jordan Tigani
Jordan Tigani

Reputation: 26617

If you are doing a GROUP BY or a COUNT DISTINCT with a large bucket count, you can get resources exceeded when doing a JOIN EACH query (each of these has workarounds).

If you share your query, we can give a more precise diagnosis.

Upvotes: 0

Related Questions