DTS adds additional columns to the tables that are synchronized to MaxCompute. These additional columns are used to manage metadata, sort data, and remove duplicates. If the names of additional columns are the same as the names of existing columns in the destination table, data synchronization fails. To avoid this issue, we recommend that you modify the naming rules for additional columns.

Background information

Before you modify the naming rules for additional columns, check whether additional columns and existing columns in the destination table will have name conflicts. The following table lists the previous and new naming rules for additional columns.

Note In step 2, you can specify whether to use the new naming rules for additional columns.
Table 1. Naming rules for additional columns
Destination instance Previous additional column name New additional column name Reference
MaxCompute
  • record_id
  • operation_flag
  • utc_timestamp
  • before_flag
  • after_flag
  • modifytime_year
  • modifytime_month
  • modifytime_day
  • modifytime_hour
  • modifytime_minute
  • new_dts_sync_record_id
  • new_dts_sync_operation_flag
  • new_dts_sync_utc_timestamp
  • new_dts_sync_before_flag
  • new_dts_sync_after_flag
  • new_dts_sync_modifytime_year
  • new_dts_sync_modifytime_month
  • new_dts_sync_modifytime_day
  • new_dts_sync_modifytime_hour
  • new_dts_sync_modifytime_minute
For more information, see Schema of an incremental data table.

Procedure

  1. Create and configure a data synchronization task. For more information, see steps 1 to 7 in Create a data synchronization task.
  2. In the Select Objects to Synchronize step, specify whether you want to use the new naming rules for additional columns.
    Modify the naming rules for additional columns
    Option Description
    Yes If you select Yes, the new naming rules for additional columns are used.
    Note If the previous names of additional columns are the same as the names of existing columns in the destination table, select Yes to avoid name conflicts.

    DTS adds the new_dts_sync_ prefix to the previous names of additional columns.

    For example, if the previous name of an additional column is record_id, the new name of the additional column is new_dts_sync_record_id.

    No If you select No, the previous naming rules for additional columns are used.
    Note For more information about the naming rules for additional columns, see Table 1.
  3. Configure other parameters that are required for the data synchronization task.

Related topics