Closed Bug 1803534 Opened 2 years ago Closed 2 years ago

Airflow task bqetl_mobile_search.search_derived__mobile_search_clients_daily__v1 failing on 2022-12-01

Categories

(Data Platform and Tools :: General, defect)

Product:
Data Platform and Tools
Component:
General
Type:
defect

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: akomar, Assigned: srose)

References

(Regression)

Details

(Whiteboard: [airflow-triage])

Airflow task bqetl_mobile_search.search_derived__mobile_search_clients_daily__v1 failing on 2022-12-01 due to query complexity.
This might be related to https://github.com/mozilla/bigquery-etl/pull/3343
As a quick workaround we could split this query into 2 stages.

Assignee: nobody → srose
Status: NEW → ASSIGNED

This has been temporarily fixed by bigquery-etl PR 3394 which reverted bigquery-etl PR 3343.

As a more permanent fix, we've also requested that Google increase the query complexity limit for the moz-fx-data-shared-prod project.

Status: ASSIGNED → RESOLVED
Closed: 2 years ago
Resolution: --- → FIXED
Regressed by: 1771733
You need to log in before you can comment on or make changes to this bug.