Apache Hive : WebHCat Reference DeleteJobID

Delete Job — DELETE jobs/:jobid

• Delete Job — DELETE jobs/:jobid
  • Description
  • URL
  • Parameters
  • Results
  • Example
    • Curl Command
    • JSON Output

Description

Kill a job given its job ID. Substitute “:jobid” with the job ID received when the job was created.

Version: Hive 0.12.0 and later

DELETE jobs/:jobid is introduced in Hive release 0.12.0. It is equivalent to [DELETE queue/:jobid](https://hive.apache.org/docs/latest/webhcat-reference-deletejob_34017204/) in prior releases.
DELETE queue/:jobid is now deprecated (HIVE-4443) and will be removed in Hive 0.14.0 (HIVE-6432).

URL

http://www.myserver.com/templeton/v1/jobs/:jobid

Parameters

Name	Description	Required?	Default
:jobid	The job ID to delete. This is the ID received when the job was created.	Required	None

The standard parameters are also supported.

Results

Name	Description
status	A JSON object containing the job status information. See the Hadoop documentation (Class JobStatus) for more information.
profile	A JSON object containing the job profile information. WebHCat passes along the information in the JobProfile object, which is subject to change from one Hadoop version to another. See the Hadoop documentation (API docs) for org.apache.hadoop.mapred.JobProfile for more information.
id	The job ID.
parentId	The parent job ID.
percentComplete	The job completion percentage, for example “75% complete”.
exitValue	The job’s exit value.
user	User name of the job creator.
callback	The callback URL, if any.
completed	A string representing completed status, for example “done”.

Example

Curl Command

% curl -s -X DELETE 'http://localhost:50111/templeton/v1/jobs/job\_201111111311\_0009?user.name=ctdean'

JSON Output

{
 "status": {
            "startTime": 1321047216471,
            "username": "ctdean",
            "jobID": {
                      "jtIdentifier": "201111111311",
                      "id": 9
                     },
            "jobACLs": {
                       },
            "schedulingInfo": "NA",
            "failureInfo": "NA",
            "jobId": "job\_201111111311\_0009",
            "jobPriority": "NORMAL",
            "runState": 1,
            "jobComplete": false
           },
 "profile": {
             "url": "http://localhost:50030/jobdetails.jsp?jobid=job\_201111111311\_0009",
             "user": "ctdean",
             "jobID": {
                       "jtIdentifier": "201111111311",
                       "id": 9
                      },
             "queueName": "default",
             "jobFile": "hdfs://localhost:9000/tmp/hadoop-ctdean/mapred/staging/ctdean/.staging/job\_201111111311\_0009/job.xml",
             "jobName": "streamjob3322518350676530377.jar",
             "jobId": "job\_201111111311\_0009"
            }
 "id": "job\_201111111311\_0009",
 "parentId": "job\_201111111311\_0008",
 "percentComplete": "10% complete",
 "exitValue": 0,
 "user": "ctdean",
 "callback": null,
 "completed": "false"
}

Note

The job is not immediately deleted, therefore the information returned may not reflect deletion, as in our example. Use GET jobs/:jobid to monitor the job and confirm that it is eventually deleted.

Navigation Links Previous: GET jobs/:jobid

General: WebHCat Reference – WebHCat Manual – HCatalog Manual – Hive Wiki Home – Hive Project Site

Replaces deprecated resource: DELETE queue/:jobid