vvysotskyi opened a new pull request, #2646:
URL: https://github.com/apache/drill/pull/2646

   # [DRILL-8303](https://issues.apache.org/jira/browse/DRILL-8303): Add 
support for inserts into JDBC storage
   
   ## Description
   This PR contains changes required for adding support for inserts into JDBC 
storage.
   Inserting data is implemented based on generating and executing ```INSERT 
INTO ... VALUES()``` statements.
   It is also possible to push down the complete ```INSERT INTO``` statement 
where possible (when using insert from values or another JDBC table).
   Rewritten existing code for JDBC CTAS to use Calcite for generating `CREATE 
TABLE` and `INSERT INTO` statements, simplified reading values to write.
   Added ability to match JDBC rules to both `NONE` and `DRILL_LOGICAL` 
conventions to allow the planner to push down more cases than before.
   
   ## Documentation
   Insert statement syntax completely matches Calcites definition and is the 
following:
   ```sql
   { INSERT | UPSERT } INTO tablePrimary [ '(' column [, column ]* ')' ] query
   ```
   Where `query` is an arbitrary SQL query.
   
   ## Testing
   Added unit tests for inserts, existing tests pass.
   


-- 
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: dev-unsubscr...@drill.apache.org

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

Reply via email to