After you execute an INSERT OVERWRITE 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
- Log on to the AnalyticDB for MySQL console.
- In the upper-left corner of the page, select a region.
- In the left-side navigation pane, click Clusters.
- On the Data Warehouse Edition (V3.0) tab, find the cluster that you want to manage and click the Cluster ID.
In the left-side navigation pane, click Diagnostics and Optimization.
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.
NoteThe 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
icon to copy the SQL statement.