Updated on 2024-10-23 GMT+08:00

To DLI

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.

For details about how to create a queue, see Creating a Queue.

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

Import Mode

Import mode

  • TRUNCATE: The task is executed before the import.
  • TRUNCATE: DLI table partitions are cleared.
  • INSERT_OVERWRITE: Data is written in partition overwriting mode.

INSERT_OVERWRITE

Convert empty strings to null

If this parameter is set to Yes, an empty string is regarded as null.

No

Table Preparation Mode

One-click creation: During job configuration, one-click table creation is performed. After a table is generated, the job can be configured.

One-click creation

Partition

Partition information. Enter the partition value in the text box corresponding to the partition field.

year=2020,location=sun