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)