willshen99 opened a new issue, #47167:
URL: https://github.com/apache/airflow/issues/47167

   ### Apache Airflow Provider(s)
   
   trino
   
   ### Versions of Apache Airflow Providers
   
   6.0.1
   
   ### Apache Airflow version
   
   2.9.0
   
   ### Operating System
   
   Red Hat Enterprise Linux 9.5
   
   ### Deployment
   
   Virtualenv installation
   
   ### Deployment details
   
   _No response_
   
   ### What happened
   
   I'm following this 
[document](https://airflow.apache.org/docs/apache-airflow-providers-trino/stable/operators/trino.html#using-the-operator)
 to use SQLExecuteQueryOperator to issue multiple queries separated with 
semicolon to Trino. 
   I got a syntax error complaining `mismatched input ';'`. I have to add an 
additional `split_statements=True` parameter to get it work. 
   
   ### What you think should happen instead
   
   SQLExecuteQueryOperator defers ``split_statements`` to the default value in 
the ``run`` method of the configured hook. Such is not defined in Trino hook so 
it uses False and throws the error. 
   
   ### How to reproduce
   
   ```
   SQLExecuteQueryOperator(
       task_id='t1',
       sql='SELECT 1; SELECT 2;',
       conn_id='loading_user_trino'     # Adding split_statements=True will work
   )
   ```
   
   ### Anything else
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [x] 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to