CODEWITHSUNDEEP
google-bigquery
Febian Shah
Febian Shah

Reputation: 1007

BigQuery - Join Each Error

BigQuery is throwing a Join Each error even though I am using Join Each:

My query: 

SELECT MS.CUSIP
FROM MS
JOIN EACH MM
ON  MS.C = MM.C;

Error :

Error: Table too large for JOIN. Consider using JOIN EACH. For more details, please see https://developers.google.com/bigquery/docs/query-reference#joins

Upvotes: 1

Views: 645

Answers (3)

Deepak Mittal
Deepak Mittal

Reputation: 199

You could try reducing the size of table that you are joining like,

SELECT MS.CUSIP
FROM 
(
    SELECT CUSIP,C FROM MS
)
MS
JOIN EACH MM
ON  MS.C = MM.C;

Size of joining table is reduced as this has only 2 columns that are needed in the query.

Upvotes: 0

Jordan Tigani
Jordan Tigani

Reputation: 26617

See the answer here: 'Response too large to return' error when using a destination table and 'Allow Large Results' option This is a known bug, we hope to have a fix by end-of-day today.

Upvotes: 1

user2684143
user2684143

Reputation: 25

This is not a long term solution, but try turning off "Allow Large Results" and see if it work. I just tried that and it seems to work.

Upvotes: 1

Related Questions