SHOW IMPORT

The SHOW IMPORT statement is used to show the IMPORT jobs created in TiDB. This statement can only show jobs created by the current user.

Required privileges

  • SHOW IMPORT JOBS: if a user has the SUPER privilege, this statement shows all import jobs in TiDB. Otherwise, this statement only shows jobs created by the current user.
  • SHOW IMPORT JOB <job-id>: only the creator of an import job or users with the SUPER privilege can use this statement to view a specific job.

Synopsis

ShowImportJobsStmt
SHOWIMPORTJOBS
ShowImportJobStmt
SHOWIMPORTJOBJobID

The output fields of the SHOW IMPORT statement are described as follows:

ColumnDescription
Job_IDThe ID of the task
Data_SourceInformation about the data source
Target_TableThe name of the target table
PhaseThe current phase of the job, including importing, validating, and add-index
StatusThe current status of the job, including pending (means created but not started yet), running, canceled, failed, and finished
Source_File_SizeThe size of the source file
Imported_RowsThe number of data rows that have been read and written to the target table
Result_MessageIf the import fails, this field returns the error message. Otherwise, it is empty.
Create_TimeThe time when the task is created
Start_TimeThe time when the task is started
End_TimeThe time when the task is ended
Created_ByThe name of the database user who creates the task

Example

SHOW IMPORT JOBS;
+--------+-------------------+--------------+----------+-------+----------+------------------+---------------+----------------+----------------------------+----------------------------+----------------------------+------------+ | Job_ID | Data_Source | Target_Table | Table_ID | Phase | Status | Source_File_Size | Imported_Rows | Result_Message | Create_Time | Start_Time | End_Time | Created_By | +--------+-------------------+--------------+----------+-------+----------+------------------+---------------+----------------+----------------------------+----------------------------+----------------------------+------------+ | 1 | /path/to/file.csv | `test`.`foo` | 116 | | finished | 11GB | 950000 | | 2023-06-26 11:23:59.281257 | 2023-06-26 11:23:59.484932 | 2023-06-26 13:04:30.622952 | root@% | | 2 | /path/to/file.csv | `test`.`bar` | 130 | | finished | 1.194TB | 49995000 | | 2023-06-26 15:42:45.079237 | 2023-06-26 15:42:45.388108 | 2023-06-26 17:29:43.023568 | root@% | +--------+-------------------+--------------+----------+-------+----------+------------------+---------------+----------------+----------------------------+----------------------------+----------------------------+------------+ 1 row in set (0.01 sec)
SHOW IMPORT JOB 60001;
+--------+--------------------+--------------+----------+-------+---------+------------------+---------------+----------------+----------------------------+------------+----------+------------+ | Job_ID | Data_Source | Target_Table | Table_ID | Phase | Status | Source_File_Size | Imported_Rows | Result_Message | Create_Time | Start_Time | End_Time | Created_By | +--------+--------------------+--------------+----------+-------+---------+------------------+---------------+----------------+----------------------------+------------+----------+------------+ | 60001 | /path/to/small.csv | `test`.`t` | 361 | | pending | 16B | NULL | | 2023-06-08 15:59:37.047703 | NULL | NULL | root@% | +--------+--------------------+--------------+----------+-------+---------+------------------+---------------+----------------+----------------------------+------------+----------+------------+ 1 row in set (0.01 sec)

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also