To DLI
If the destination link of a job is the Link to DLI, configure the destination job parameters based on Table 1.
To use CDM to migrate data to DLI, you must obtain the read permissions of OBS.
Parameter |
Description |
Example Value |
---|---|---|
Resource Queue |
Resource queue to which the destination table belongs The default queue of DLI cannot be used for migration jobs. You need to create a SQL queue in DLI. |
cdm |
Database Name |
Name of the database to which data will be written |
dli |
Table Name |
Name of the table to which data will be written |
car_detail |
Clear Data Before Import |
Whether to clear data in the destination table before data import If this parameter is set to Yes, data in the destination table will be cleared before the task is started. |
No |
Data Clearing Mode |
This parameter is available when Clear Data Before Import is set to Yes. TRUNCATE: deletes standard data. INSERT_OVERWRITE: overwrites existing data with inserted data. |
TRUNCATE |
Partition |
This parameter is available when Clear Data Before Import is set to Yes. When you enter partitions, data in these partitions will be cleared. |
year=2020,location=sun |
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