Updated on 2022-08-17 GMT+08:00

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.

Table 1 Parameter description

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