Updated on 2024-11-30 GMT+08:00

Precautions

Notes and Constraints

  • MgC cannot migrate the DATETIME type of data from MaxCompute. Before the migration, you need to convert such data to the STRING format.
  • MgC cannot migrate the VARCHAR or CHAR type of data from MaxCompute. Before the migration, you need to convert such data to the STRING format.
  • MgC cannot migrate the metadata of transaction tables (those with the transactional=true field in DDL statements).
  • The TIMESTAMP_NTZ type of data in MaxCompute is not supported by the Alibaba Cloud SDK. As a result, the metadata of involved tables will fail to be migrated.

Notes

  • Editing a CSV template file

    When using the CSV template provided by MgC to filter data, do not use Excel to edit the CSV file. The file edited and saved in Excel cannot be identified by MgC.

  • Selecting a DLI connection

    Metadata migration and data migration require different DLI connections. Metadata migration requires a DLI connection with a SQL queue configured, and data migration requires a DLI connection with a general-purpose queue configured. If an incorrect connection is configured for the migration task, the migration task will fail.

  • Constraints on the number of databases

    During the metadata migration, MgC automatically creates the same number of databases identified in metadata on DLI. A maximum of 10 DLI databases can be created in an account. If the number of databases you want to migrate exceeds the quota, the metadata migration may fail.