'How to error Resources exceeded during query execution: Not enough resources for query planning - too many subqueries or query is too complex
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
Solution 1:[1]
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
Solution 2:[2]
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
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Tran AnhQuoc |
| Solution 2 | Nicolas Pepinster |