Enabling or Disabling Multiversion Backup
Function
DLI controls multiple versions of backup data for restoration. After the multiversion function is enabled, the system automatically backs up table data when you delete or modify the data using insert overwrite or truncate, and retains the data for a certain period. You can quickly restore data within the retention period. For details about the syntax related to the multiversion function, see Backing Up and Restoring Data of Multiple Versions.
Currently, the multiversion function supports only OBS tables created using the Hive syntax. For details about the syntax for creating a table, see Creating an OBS Table Using the Hive Syntax.
Syntax
- Enable the multiversion function.
ALTER TABLE [db_name.]table_name SET TBLPROPERTIES ("dli.multi.version.enable"="true");
- Disable the multiversion function.
1 2
ALTER TABLE [db_name.]table_name UNSET TBLPROPERTIES ("dli.multi.version.enable");
After multiversion is enabled, data of different versions is automatically stored in the OBS storage directory when insert overwrite or truncate is executed. After multiversion is disabled, run the following statement to restore the multiversion backup data directory:RESTORE TABLE [db_name.]table_name TO initial layout;
Keywords
- SET TBLPROPERTIES: Used to set table properties and enable multiversion.
- UNSET TBLPROPERTIES: Used to unset table properties and disable multiversion.
Parameters
Parameter |
Description |
---|---|
db_name |
Database name that contains letters, digits, and underscores (_). It cannot contain only digits or start with an underscore (_). |
table_name |
Table name |
Precautions
Currently, the multiversion function supports only OBS tables created using the Hive syntax. For details about the syntax for creating a table, see Creating an OBS Table Using the Hive Syntax.
Example
- Modify the test_table table to enable multiversion.
1 2
ALTER TABLE test_table SET TBLPROPERTIES ("dli.multi.version.enable"="true");
- Modify the test_table table to disable multiversion.
1 2
ALTER TABLE test_table UNSET TBLPROPERTIES ("dli.multi.version.enable");
Restore the multiversion backup data directory.RESTORE TABLE test_table TO initial layout;
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot