# SHOW JOB ```SQL SHOW JOB; ``` `SHOW JOB`语句显示已经提交的单个任务详情。 ## Example 提交在线数据导入任务: ``` LOAD DATA INFIEL 'file:///tmp/test.csv' INTO TABLE demo_db.t1 options(format='csv', header=false, mode='append'); ---- ------------------ ----------- ------------ --------------- ---------------------------------------------------------------------------------------------------------------------------- --------- ---------------- ------- id job_type state start_time end_time parameter cluster application_id error ---- ------------------ ----------- ------------ --------------- ---------------------------------------------------------------------------------------------------------------------------- --------- ---------------- ------- 1 ImportOnlineData Submitted 0 1641981373227 LOAD DATA INFIEL 'file:///tmp/test.csv' INTO TABLE demo_db.t1 options(format='csv', header=false, mode='append'); local ---- ------------------ ----------- ------------ --------------- ---------------------------------------------------------------------------------------------------------------------------- --------- ---------------- ------- ``` 查看Job ID为1的任务: ``` SHOW JOB 1; ---- ------------------ ----------- ------------ --------------- ---------------------------------------------------------------------------------------------------------------------------- --------- ---------------- ------- id job_type state start_time end_time parameter cluster application_id error ---- ------------------ ----------- ------------ --------------- ---------------------------------------------------------------------------------------------------------------------------- --------- ---------------- ------- 1 ImportOnlineData Submitted 0 1641981373227 LOAD DATA INFIEL 'file:///tmp/test.csv' INTO TABLE demo_db.t1 options(format='csv', header=false, mode='append'); local ---- ------------------ ----------- ------------ --------------- ---------------------------------------------------------------------------------------------------------------------------- --------- ---------------- ------- ``` ## 相关语句 [SHOW JOBS](./SHOW_JOBS.md) [STOP JOBS](./STOP_JOB.md)