You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by GitBox <gi...@apache.org> on 2022/11/10 23:30:01 UTC
[GitHub] [airflow] sbbagal13 opened a new issue, #27610: TrinoOperator not allowing to run multiple sql statements from file
sbbagal13 opened a new issue, #27610:
URL: https://github.com/apache/airflow/issues/27610
### Apache Airflow Provider(s)
trino
### Versions of Apache Airflow Providers
apache-airflow-providers-trino 4.0.0
### Apache Airflow version
2.2.4
### Operating System
Debian GNU/Linux 10 (buster)
### Deployment
Official Apache Airflow Helm Chart
### Deployment details
Openshift on prem deployment
### What happened
When putting two queries in SQL file and providing to trino operator it failing with unexpected syntax for ending first query with semicolon
`run_queries = TrinoOperator(
task_id="push_to_refined",
trino_conn_id='trino-conn',
sql="scripts/platform/sql/execute_queries.sql",
handler=list,
)`
Error:
`io.trino.sql.parser.ParsingException: line 1:67: mismatched input ';'. Expecting: '%', '*', '+', '-', '.', '/', 'AND', 'AT', 'OR', '[', '||', <EOF>, <predicate>
at io.trino.sql.parser.ErrorHandler.syntaxError(ErrorHandler.java:109)`
There are two queries in sql file , One is for setting session properties which I can't take into different task
SQL file runs fine on CLI
### What you think should happen instead
It should run without execption as its execute on trino CLI
### How to reproduce
Put two queries in SQL file and provide it to Trino Operator task
### Anything else
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
--
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 unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] tirkarthi commented on issue #27610: TrinoOperator not allowing to run multiple sql statements from file
Posted by GitBox <gi...@apache.org>.
tirkarthi commented on issue #27610:
URL: https://github.com/apache/airflow/issues/27610#issuecomment-1311480857
Related issues https://github.com/apache/airflow/issues/23431 and https://github.com/apache/airflow/issues/23112
--
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 unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] boring-cyborg[bot] commented on issue #27610: TrinoOperator not allowing to run multiple sql statements from file
Posted by GitBox <gi...@apache.org>.
boring-cyborg[bot] commented on issue #27610:
URL: https://github.com/apache/airflow/issues/27610#issuecomment-1311039970
Thanks for opening your first issue here! Be sure to follow the issue template!
--
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 unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] eladkal commented on issue #27610: TrinoOperator not allowing to run multiple sql statements from file
Posted by GitBox <gi...@apache.org>.
eladkal commented on issue #27610:
URL: https://github.com/apache/airflow/issues/27610#issuecomment-1311464924
Please upgrade the provider to latest version.
This was already fixed (in combination with common.sql provider).
--
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 unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] potiuk commented on issue #27610: TrinoOperator not allowing to run multiple sql statements from file
Posted by GitBox <gi...@apache.org>.
potiuk commented on issue #27610:
URL: https://github.com/apache/airflow/issues/27610#issuecomment-1317275467
Closing it provisionally. We can re-open if this is still an issue.
--
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 unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] sbbagal13 commented on issue #27610: TrinoOperator not allowing to run multiple sql statements from file
Posted by GitBox <gi...@apache.org>.
sbbagal13 commented on issue #27610:
URL: https://github.com/apache/airflow/issues/27610#issuecomment-1311746121
@eladkal thanks for responding , let me upgrade to latest version and confirm back.
--
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 unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] potiuk closed issue #27610: TrinoOperator not allowing to run multiple sql statements from file
Posted by GitBox <gi...@apache.org>.
potiuk closed issue #27610: TrinoOperator not allowing to run multiple sql statements from file
URL: https://github.com/apache/airflow/issues/27610
--
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 unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org