The GitHub Actions job "Tests" on airflow.git has succeeded. Run started by GitHub user josh-fell (triggered by josh-fell).
Head commit for run: 0d3d0e2e746dd07ab04752800f0cb7f860f6ac46 / 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]> Report URL: https://github.com/apache/airflow/actions/runs/4367262105 With regards, GitHub Actions via GitBox --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
