metesynnada opened a new issue, #5130:
URL: https://github.com/apache/arrow-datafusion/issues/5130

   **Is your feature request related to a problem or challenge? Please describe 
what you are trying to do.**
   I want to create a table from a CSV(JSON or AVRO) file, execute a query and 
write the results into a CSV file.
   
   **Describe the solution you'd like**
   If we support this on a logical plan level, this might be executed. It may 
also require enhancing catalog management.
   
   - Create table
   
   ```sql
   CREATE EXTERNAL TABLE source_table(c1 int) STORED AS CSV LOCATION 'foo.csv'
   ```
   
   - Sink table
   
   ```sql
   CREATE EXTERNAL TABLE sink_table(c1 int) LOCATION 'bar.csv'
   ```
   
   - Insert the sink table
   
   ```sql
   INSERT INTO sink_table
   SELECT * FROM t
   WHERE c1 > 10;
   ```
   
   **Describe alternatives you've considered**
   NA
   
   **Additional context**
   NA


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