How to error Resources exceeded during query execution: Not enough resources for query planning - too many subqueries or query is too complex

user_4472100 0
Viewed 9917

How this error occurs "Resources exceeded during query execution: Not enough resources for query planning - too many subqueries or query is too complex" in google BigQuery

enter image description here

google-bigquery
2 Answers

You can use sql same here to reduce query is to complex

SAFE_DIVIDE(SUM(week_1_cohort)*100, SUM(IF(row_number >= 1, week_0_cohort, 0))) as week_1_cohort

user_44721000

that means probably that or you slim the amount of memory required by your query, or you need to increase your limits, whose explanation you find at this link

user_125057790
Related