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