[I] AthenaOperator behaviour changed in 2.7.3 [airflow]

2023-11-08 Thread via GitHub
nenkie76 opened a new issue, #35533: URL: https://github.com/apache/airflow/issues/35533 ### Apache Airflow version 2.7.3 ### What happened Airflow update from 2.7.2 to 2.7.3. (Astronomer 9.4.0 => 9.5.0) has changed the way SQL statements are parsed for Athena. Endlines

Re: [I] AthenaOperator behaviour changed in 2.7.3 [airflow]

2023-11-08 Thread via GitHub
boring-cyborg[bot] commented on issue #35533: URL: https://github.com/apache/airflow/issues/35533#issuecomment-1802237362 Thanks for opening your first issue here! Be sure to follow the issue template! If you are willing to raise PR to address this issue please do so, no need to wait for ap

Re: [I] AthenaOperator behaviour changed in 2.7.3 [airflow]

2023-11-08 Thread via GitHub
Taragolis commented on issue #35533: URL: https://github.com/apache/airflow/issues/35533#issuecomment-1802339909 I've unable to reproduce on Airflow 2.7.3 and latest amazon provider (8.10.0) ```python import pendulum from airflow.models.dag import DAG from airflow.provider

Re: [I] AthenaOperator behaviour changed in 2.7.3 [airflow]

2023-11-08 Thread via GitHub
nenkie76 commented on issue #35533: URL: https://github.com/apache/airflow/issues/35533#issuecomment-1802447704 @Taragolis is you task and query actually completing in Athena? My task log in Airflow also outputs `\n ` in log, while then, later it fails: ``` [2023-11-08, 07:20

Re: [I] AthenaOperator behaviour changed in 2.7.3 [airflow]

2023-11-08 Thread via GitHub
jedcunningham commented on issue #35533: URL: https://github.com/apache/airflow/issues/35533#issuecomment-1802462672 For reference, the provider version jumped from 8.7.1 to 8.10.0, and it's most likely an issue in that provider update not core. -- This is an automated message from the Ap

Re: [I] AthenaOperator behaviour changed in 2.7.3 [airflow]

2023-11-08 Thread via GitHub
Taragolis commented on issue #35533: URL: https://github.com/apache/airflow/issues/35533#issuecomment-1802480220 > is you task and query actually completing in Athena? Yep, works fine ![image](https://github.com/apache/airflow/assets/3998685/ab4e7440-7da4-4046-881e-179893dc33a5

Re: [I] AthenaOperator behaviour changed in 2.7.3 [airflow]

2023-11-08 Thread via GitHub
Taragolis closed issue #35533: AthenaOperator behaviour changed in 2.7.3 URL: https://github.com/apache/airflow/issues/35533 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To

Re: [I] AthenaOperator behaviour changed in 2.7.3 [airflow]

2023-11-08 Thread via GitHub
Taragolis commented on issue #35533: URL: https://github.com/apache/airflow/issues/35533#issuecomment-1802582548 I think the problem with Athena query parser (or Trino) itself, some queries just doesn't work with one line comments It could be easily check on sample Athena query with m