[GitHub] [arrow-datafusion] alamb commented on pull request #1875: Add new option for running sql file and keeping df-cli open

[GitBox <gi...@apache.org>]

alamb commented on pull request #1875:
URL: https://github.com/apache/arrow-datafusion/pull/1875#issuecomment-1057113073


   Taking inspiration from`psql` , it implements a `\i` command (not a command line argument) for this usecase. It *includes* a file:
   
   https://www.postgresql.org/docs/13/app-psql.html
   
   > \i or \include filename
   > Reads input from the file filename and executes it as though it had been typed on the keyboard.
   > 
   > If filename is - (hyphen), then standard input is read until an EOF indication or \q meta-command. This can be used to intersperse interactive input with input from files. Note that Readline behavior will be used only if it is active at the outermost level.
   
   It appears that mysql has a similar command `source` or `\.` that does the same thing
   
   https://dev.mysql.com/doc/refman/8.0/en/mysql-batch-commands.html
   
   
   Thus I would recommend implementing a `\i` command (and possibly also a `source` command)
   
   


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