You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/01/26 03:30:43 UTC
[GitHub] [incubator-doris] EmmyMiao87 opened a new issue #5298: Backup and Restore support view and external table
EmmyMiao87 opened a new issue #5298:
URL: https://github.com/apache/incubator-doris/issues/5298
# Background
Existing function
Only olap table backup is supported, and the name of the table to be backed up must be manually declared, which is inconvenient for full database backup.
# Requirement
1. backup full database, data or metadata, partial table
2. backup an restore view, external table, related resources etc.
3. When restoring, overwrite all data in the existing table, if it does not exist, create a new table directly
4. backup the entire database but only restores individual tables during restore.
5. The backup support excludes some tables that are too large, and backs up the others.
# API design
```
BACKUP SNAPSHOT [db_name].{snapshot_name}
TO 'repo_name'
[on clause]
[EXCLUDE (
'table_name' [partition (p1,...)]
)]
[properties (
"content" = "metadata_only|data_only"
)]
RESTORE SNAPSHOT [db_name].{snapshot_name}
TO 'repo_name'
[on clause]
[EXCLUDE (
'table_name' [partition (p1,...)]
)]
[properties (
"content" = "metadata_only|data_only"
)]
```
----------------------------------------------------------------
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.
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] [incubator-doris] EmmyMiao87 closed issue #5298: Backup and Restore support view and external table
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 closed issue #5298:
URL: https://github.com/apache/incubator-doris/issues/5298
----------------------------------------------------------------
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.
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