After you execute an INSERT OVERWRITE INTO statement to import or export data, you can view the task state in the AnalyticDB for MySQL console. This topic describes how to view information about import or export tasks for an AnalyticDB for MySQL Data Warehouse Edition (V3.0) cluster.

View information about import or export tasks

  1. Log on to the AnalyticDB for MySQL console.
  2. In the upper-left corner of the page, select the region where the cluster resides.
  3. In the left-side navigation pane, click Clusters.
  4. On the Data Warehouse Edition (V3.0) tab, find the cluster and click its Cluster ID.
  5. In the left-side navigation pane, click Diagnostics and Optimization.
  6. Click the Import/Export Tasks tab.

    By default, all import and export tasks within the last 24 hours are displayed. You can search for import and export tasks by task state or time range.

    The following table describes the task parameters.
    Parameter Description
    Task ID The ID of the import or export task within AnalyticDB for MySQL.
    Asynchronous Task Name The ID returned to the client after the asynchronous task is submitted.
    Started At The time when the import or export task started to execute.
    Task Status Updated At The time when the state of the import or export task was updated.
    Number of Rows Processed by Task The number of data rows processed by the import or export task.
    Database The name of the database in which the SQL statement used to perform the import or export task is executed.
    Task Status The state of the task. Valid values:
    • INIT: The task is being initialized.
    • RUNNING: The task is running.
    • FINISH: The task is executed.
    • FAILED: The task failed.

      If a task failed, you can search for the task by task ID and perform diagnostics and optimization on the SQL Diagnostics tab.

      Note The task ID on this tab is the query ID on the SQL Diagnostics tab.
    SQL The SQL statement executed to perform the import or export task. You can click the 1 icon to copy the SQL statement.

Related operations

DescribeLoadTasksRecords