You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2022/09/10 06:38:00 UTC

[jira] [Commented] (DRILL-8303) Add support for inserts into JDBC storage

    [ https://issues.apache.org/jira/browse/DRILL-8303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17602628#comment-17602628 ] 

ASF GitHub Bot commented on DRILL-8303:
---------------------------------------

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.
   




> Add support for inserts into JDBC storage
> -----------------------------------------
>
>                 Key: DRILL-8303
>                 URL: https://issues.apache.org/jira/browse/DRILL-8303
>             Project: Apache Drill
>          Issue Type: Sub-task
>            Reporter: Vova Vysotskyi
>            Assignee: Vova Vysotskyi
>            Priority: Major
>
> Allow inserting into JDBC tables and pushing down complete insert statement where possible.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)