igor-suhorukov opened a new issue, #211:
URL: https://github.com/apache/arrow-java/issues/211

   ### Describe the enhancement requested
   
   DuckDB support ArrowArrayStream as virtual table. JDBC driver of DuckDB has 
"register" ArrowStream method on  DuckDBConnection.
   
   VectorSchemaRoot convertion into ArrowArrayStream object will allows perform 
complex SQL transformation with CTE,window function on existing Arrow data from 
java process without data format transformation and also as workaround to write 
parquet file from VectorSchemaRoot.
   
   ```
   try (DuckDBConnection connection = (DuckDBConnection) 
DriverManager.getConnection("jdbc:duckdb:")){
       connection.registerArrowStream("arrow_stream", arrowArrayStream);
       try (Statement preparedStatement = connection.createStatement()){
           preparedStatement.executeUpdate("COPY (SELECT * FROM arrow_stream) 
TO '"+filePath+"' (FORMAT 'PARQUET', CODEC 'ZSTD')");
       }
   }
   ```
   
   @lidavidm do you have idea how to implement such conversion?
   
   ### Component(s)
   
   Java


-- 
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: issues-unsubscr...@arrow.apache.org.apache.org

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

Reply via email to