# STOP JOB ```SQL STOP JOB; ``` `STOP JOB`语句停止已经提交的单个任务。 ## Example 提交在线数据导入任务: ``` LOAD DATA INFIEL 'file:///tmp/test.csv' INTO TABLE demo_db.t1 options(format='csv', header=false, mode='append'); ---- ------------------ ----------- ------------ --------------- ---------------------------------------------------------------------------------------------------------------------------- --------- ---------------- ------- 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的任务: ``` STOP JOB 1; ---- ------------------ ----------- ------------ --------------- ---------------------------------------------------------------------------------------------------------------------------- --------- ---------------- ------- id job_type state start_time end_time parameter cluster application_id error ---- ------------------ ----------- ------------ --------------- ---------------------------------------------------------------------------------------------------------------------------- --------- ---------------- ------- 1 ImportOnlineData STOPPED 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) [SHOW JOB](./SHOW_JOB.md)