The GitHub Actions job "Build images for Sync v2-5-stable with v2-5-test to release 2.5.2 https://github.com/apache/airflow/pull/29978 " on airflow.git has failed. Run started by GitHub user pierrejeambrun (triggered by pierrejeambrun).
Head commit for run: 354ea879e3403e4d8bdfebb1651c54595fecc9f2 / Tamer Abousoud <[email protected]> Update pipeline.rst - Fix query in `merge_data()` task (#29158) * Update pipeline.rst - Fix query in `merge_data()` task The alias for the subquery was missing in the `merge_data()` function's query, so it just needed to be added. Otherwise, the `employees` table remains empty. I found the error in the postgres container logs: ``` 2023-01-25 08:00:03 2023-01-25 14:00:03.256 UTC [70428] ERROR: subquery in FROM must have an alias at character 74 2023-01-25 08:00:03 2023-01-25 14:00:03.256 UTC [70428] HINT: For example, FROM (SELECT ...) [AS] foo. 2023-01-25 08:00:03 2023-01-25 14:00:03.256 UTC [70428] STATEMENT: 2023-01-25 08:00:03 INSERT INTO employees 2023-01-25 08:00:03 SELECT * 2023-01-25 08:00:03 FROM ( 2023-01-25 08:00:03 SELECT DISTINCT * 2023-01-25 08:00:03 FROM employees_temp 2023-01-25 08:00:03 ) 2023-01-25 08:00:03 ON CONFLICT ("Serial Number") DO UPDATE 2023-01-25 08:00:03 SET "Serial Number" = excluded."Serial Number"; ``` Thank you! * Update docs/apache-airflow/tutorial/pipeline.rst Co-authored-by: Josh Fell <[email protected]> --------- Co-authored-by: Josh Fell <[email protected]> (cherry picked from commit 0d3d0e2e746dd07ab04752800f0cb7f860f6ac46) Report URL: https://github.com/apache/airflow/actions/runs/4368315526 With regards, GitHub Actions via GitBox --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
