alamb opened a new issue #1214: URL: https://github.com/apache/arrow-datafusion/issues/1214
**Is your feature request related to a problem or challenge? Please describe what you are trying to do.** It would be great / handy to use the `datafusion-cli` to transform data and write the transformed data to another format (e.g. convert from CSV to parquet, with possibly some transformations along the way. **Describe the solution you'd like** I propose adding the `INTO` clause like clickhouse or mysql; https://clickhouse.com/docs/en/faq/integration/file-export/ https://dev.mysql.com/doc/refman/5.7/en/select-into.html So one could export the contents of a table into a file using a command such as ```sql SELECT * FROM table INTO OUTFILE 'file' FORMAT CSV ``` Like #1213 I think this feature should be something that can be disabled for those implementations that do not want to allow their users to write to local files **Describe alternatives you've considered** Note that postgres uses the `COPY` command for the same purpose -- https://www.postgresql.org/docs/8.1/sql-copy.html So like `COPY foo to 'file'` **Additional context** - [ ] I don't think sqlparser has this syntax: https://docs.rs/sqlparser/0.12.0/sqlparser/ast/struct.Select.html -- 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]
