[GitHub] [arrow-datafusion] r4ntix commented on issue #6763: Allow usage of datafusion-cli from other programs

["r4ntix (via GitHub)" <gi...@apache.org>]

r4ntix commented on issue #6763:
URL: https://github.com/apache/arrow-datafusion/issues/6763#issuecomment-1606108019

   The current datafusion-cli has the ability to execute sql file and format the output:
   ```shell
   $ echo 'show tables;' > sql.txt
   
   $ ./target/debug/datafusion-cli --file sql.txt --format json
   DataFusion CLI v26.0.0
   [{"table_catalog":"datafusion","table_name":"tables","table_schema":"information_schema","table_type":"VIEW"},{"table_catalog":"datafusion","table_name":"views","table_schema":"information_schema","table_type":"VIEW"},{"table_catalog":"datafusion","table_name":"columns","table_schema":"information_schema","table_type":"VIEW"},{"table_catalog":"datafusion","table_name":"df_settings","table_schema":"information_schema","table_type":"VIEW"}]
   4 rows in set. Query took 0.045 seconds.
   ```
   
   I don't know if this will work for you? 🤔️


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org