Import/Export Jobs

更新时间:
复制 MD 格式

When you run an 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 import and export job information for an AnalyticDB for MySQL Data Warehouse Edition cluster.

View import and export jobs

  1. 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. Find the cluster that you want to manage and click the cluster ID.

  2. In the left-side navigation pane, click Diagnostics and Optimization.

  3. Click the Import/Export Jobs tab.

    By default, the console displays all import and export jobs from the past 24 hours. You can search for jobs by job status or time range. The page displays a filter area and a job list. The filter area contains a Job Status drop-down list, a time range picker, and a Query button. The job list includes the following columns: Job ID, Asynchronous Job Name, Started At, Status Updated At, Processed Rows, Database, Job Status, and SQL. Job statuses include init, running, finish, and failed.

    The following table describes the columns in the job list.

    Parameter

    Description

    Job ID

    The job's internal ID within AnalyticDB for MySQL.

    Asynchronous Job Name

    The ID returned to the client after you submit the asynchronous job.

    Started At

    The time when the import or export job started.

    Status Updated At

    The time when the status was last updated.

    Processed Rows

    The number of data rows processed by the job.

    Database

    The username of the database account that submitted the SQL statement.

    Job Status

    The status of the job. Valid values:

    • init: The job is initializing.

    • running: The job is running.

    • finish: The job completed successfully.

    • failed: The job failed.

      If a job fails, go to the SQL Diagnostics page and search for its Job ID to perform diagnostics and optimization.

      Note

      The Job ID corresponds to the query ID on the SQL Diagnostics page.

    SQL

    The SQL statement that initiated the job. You can click 2 to copy the full statement.

Related API

DescribeLoadTasksRecords