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
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
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
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
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
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
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
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