📣

TiDB Cloud Serverless 现已更名为
Starter
!此页面由 AI 自动翻译,英文原文请见
此处。

SHOW IMPORT

SHOW IMPORT 语句用于显示在 TiDB 中创建的导入任务。该语句只能显示由当前用户创建的任务。

所需权限

  • SHOW IMPORT JOBS:如果用户具有 SUPER 权限,则此语句显示 TiDB 中所有的导入任务。否则,只显示由当前用户创建的任务。
  • SHOW IMPORT JOB <job-id>:只有导入任务的创建者或具有 SUPER 权限的用户才能使用此语句查看特定任务。

语法

ShowImportJobsStmt
SHOWIMPORTJOBS
ShowImportJobStmt
SHOWIMPORTJOBJobID

SHOW IMPORT 语句的输出字段说明如下:

列名描述
Job_ID任务的ID
Data_Source数据源信息
Target_Table目标表的名称
Phase任务当前阶段,包括 importingvalidatingadd-index
Status任务当前状态,包括 pending(表示已创建但未开始)、runningcanceledfailedfinished
Source_File_Size源文件的大小
Imported_Rows已读取并写入目标表的数据行数
Result_Message如果导入失败,此字段返回错误信息,否则为空
Create_Time任务创建时间
Start_Time任务开始时间
End_Time任务结束时间
Created_By创建该任务的数据库用户名称

示例

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 兼容性

此语句为 TiDB 对 MySQL 语法的扩展。

相关链接

文档内容是否有帮助?