You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morningman (via GitHub)" <gi...@apache.org> on 2023/06/05 02:28:37 UTC
[GitHub] [doris] morningman opened a new issue, #18230: [Feature] support insert overwrite stmt
morningman opened a new issue, #18230:
URL: https://github.com/apache/doris/issues/18230
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Description
Support stmt like:
```
// overwrite all table
insert overwrite table xxx select * from yyy;
// overwrite specified partition of the table
insert overwrite table xxx partition(p1) select * from yyy;
```
Similar to normal `insert` stmt, the difference is a `overwrite` keywords.
Which means it will erase all data in table(partition) and write new data.
### Use case
User can use following step to overwrite a table's data:
1. truncate table
2. insert into table
But it is not a atomic operation, after the `truncate` operation and before the `insert` operation, user is unable to read
any data because table is empty.
By using `insert overwrite`, use can always read the old data before the `insert` finished.
### Related issues
To implement this, you can wrap the following step into one `insert overwrite` operation:
1. For overwriting table
1. create a temp table using `create table like` stmt, this will create a table with exactly same schema like origin table.
2. insert data into this temp table.
3. using [replace table](https://doris.apache.org/zh-CN/docs/dev/advanced/alter-table/replace-table) to swap the temp table and origin table.
4. done.
2. For overwrite partition
1. create a [temp partition](https://doris.apache.org/zh-CN/docs/dev/advanced/partition/table-temp-partition).
2. insert data into this temp partition
3. using `alter table replace partition` to swap the temp partition and origin partition.
4. done
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] Yukang-Lian closed issue #18230: [Feature] support insert overwrite stmt
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian closed issue #18230: [Feature] support insert overwrite stmt
URL: https://github.com/apache/doris/issues/18230
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] GoGoWen commented on issue #18230: [Feature] support insert overwrite stmt
Posted by "GoGoWen (via GitHub)" <gi...@apache.org>.
GoGoWen commented on issue #18230:
URL: https://github.com/apache/doris/issues/18230#issuecomment-1489632170
Hi morningman, does anyone take it? if not, can i take it?
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] Yukang-Lian closed issue #18230: [Feature] support insert overwrite stmt
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian closed issue #18230: [Feature] support insert overwrite stmt
URL: https://github.com/apache/doris/issues/18230
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org