STOP JOB
Contents
STOP JOB#
STOP JOB语句停止已经提交的单个任务。
STOP JOB job_id;
Attention
yarn模式下，STOP JOB会kill yarn job并更改job info表中的job状态。
local或yarn-client模式下，STOP JOB只会更改job info表中的job状态，不会真的kill job进程。
Example#
提交在线数据导入任务:
LOAD DATA INFILE 'file:///tmp/test.csv' INTO TABLE demo_db.t1 options(format='csv', header=false, mode='append');
---- ------------------ ----------- ------------ --------------- ---------------------------------------------------------------------------------------------------------------------------- --------- ---------------- -------
1 ImportOnlineData Submitted 0 1641981373227 LOAD DATA INFILE '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 INFILE 'file:///tmp/test.csv' INTO TABLE demo_db.t1 options(format='csv', header=false, mode='append'); local
---- ------------------ ----------- ------------ --------------- ---------------------------------------------------------------------------------------------------------------------------- --------- ---------------- -------