After you execute the INSERT OVERWRITE statement to import or export data, you can view the job status in the AnalyticDB for MySQL console. This topic describes how to view information about import or export jobs for an AnalyticDB for MySQL cluster.
View information about import or export jobs
Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. On the Clusters page, click an edition 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 Jobs tab.
By default, all import and export jobs within the last 24 hours are displayed. You can search for import and export jobs by job status or time range.
The following table describes the job parameters.
Parameter
Description
Job ID
The ID of the import or export job within AnalyticDB for MySQL.
Asynchronous Job Name
The ID returned to the client after the asynchronous job is submitted.
Started At
The time when the import or export job started to execute.
Status Updated At
The time when the status of the import or export job was updated.
Processed Rows
The number of data rows processed by the import or export job.
Database
The name of the database in which the SQL statement used to perform the import or export job is executed.
Job Status
The status of the job. Valid values:
INIT: The job is being initialized.
RUNNING: The job is running.
FINISH: The job is executed.
FAILED: The job failed.
If a job failed, you can search for the job by job ID and perform diagnostics and optimization on the SQL Diagnostics tab.
NoteThe job ID on this tab is the query ID on the SQL Diagnostics tab.
SQL
The SQL statement executed to perform the import or export job. You can click the
icon to copy the SQL statement.