emanueledomingo opened a new issue, #567:
URL: https://github.com/apache/arrow-datafusion-python/issues/567

   Hi Everyone,
   
   **Is your feature request related to a problem or challenge? Please describe 
what you are trying to do.**
   I'd like to prevent 
[DDL](https://arrow.apache.org/datafusion/user-guide/sql/ddl.html) queries 
while executing them over my Datafusion Context, being them only for analytical 
purposes.
   
   **Describe the solution you'd like**
   I've seen in the rust library that this is possible by setting 
[SQLOptions](https://github.com/apache/arrow-datafusion/blob/bc0ba6a724aaaf312b770451718cbce696de6640/datafusion/core/src/execution/context/mod.rs#L2046-L2054)
 and use the 
[sql_with_options](https://github.com/apache/arrow-datafusion/blob/bc0ba6a724aaaf312b770451718cbce696de6640/datafusion/core/src/execution/context/mod.rs#L456C18-L465)
 function. Unfortunately, this is not being exposed by this python binding:
   
   
https://github.com/apache/arrow-datafusion-python/blob/7de4316b70dd1b2aeed68bfee293d95a2cc384b5/src/context.rs#L282-L286
   
   > It uses 
[.sql](https://github.com/apache/arrow-datafusion/blob/bc0ba6a724aaaf312b770451718cbce696de6640/datafusion/core/src/execution/context/mod.rs#L426C1-L428C6)
 under the hood, that creates default values for SQLOptions, by setting every 
flag to true.
   
   It will be very nice to have the possibility to configure SQLOptions also 
from the python binding.
   


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