Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: remove broken link to old doc

...

Info
titleVersion: Hive 0.12.0 and later

GET jobs is introduced in Hive release 0.12.0. It is equivalent to GET queue in prior releases.
GET queue is now deprecated (HIVE-4443) and will be removed in Hive 0.14.0 (HIVE-6432).

URL

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

...

Name

Description

Required?

Default

fields

If fields set to "*", the request will return full details of the job. If fields is missing, will only return the job ID. Currently the value can only be "*", other values are not allowed and will throw exception.

Optional

None

showall

If showall is set to "true", the request will return all jobs the user has permission to view, not only the jobs belonging to the user.

Optional

false

jobid

If jobid is present, only the records whose job ID is lexicographically greater than jobid are returned. For example, if jobid = "job_201312091733_0001", the jobs whose job ID is greater than "job_201312091733_0001" are returned. The number of records returned depends on the value of numrecords.

This parameter is not available in releases prior to Hive 0.13.0. (See HIVE-5519.)

Optional in Hive 0.13.0+None
numrecords

If the jobid and numrecords parameters are present, the top numrecords records appearing after jobid will be returned after sorting the job ID list lexicographically. If the jobid parameter is missing and numrecords is present, the top numrecords will be returned after lexicographically sorting the job ID list. If the jobid parameter is present and numrecords is missing, all the records whose job ID is greater than jobid are returned.

This parameter is not available in releases prior to Hive 0.13.0. (See HIVE-5519.)

Optional in Hive 0.13.0+All

The standard parameters are also accepted.

...

Returns an array of jobs either belonging to the user, or which the user has permission to view (showall="true"), based on the filter conditions specified by the user.

Every element inside the array includes:

...

No Format
% curl -s 'http://localhost:50111/templeton/v1/jobs?user.name=daijy&showall=true'

JSON Output (showall)

...

No Format
% curl -s 'http://localhost:50111/templeton/v1/jobs?user.name=daijy&fields=*'

JSON Output (fields)

...

...

[{"id":"job_201304291205_0015",
  "detail":{
    "status":{
      "jobACLs":{
        "MODIFY_JOB":{"allAllowed":false,"aclstring":" "},
        "VIEW_JOB":{"allAllowed":false,"aclstring":" "}},
      "runState":2,
      "startTime":1367264912274,
      "schedulingInfo":"NA",
      "failureInfo":"NA",
      "jobPriority":"NORMAL",
      "username":"daijy",
      "jobID":{"id":16,"jtIdentifier":"201304291205"},
      "jobId":"job_201304291205_0016",
      "jobComplete":true},
    "profile":{
      "user":"daijy",
      "jobFile":"hdfs://localhost:8020/Users/daijy/hadoop-1.0.3/tmp/mapred/staging/
          daijy/.staging/job_201304291205_0016/job.xml",
      "url":"http://localhost:50030/jobdetails.jsp?jobid=job_201304291205_0016",
      "queueName":"default",
      "jobName":"word count",
      "jobID":{"id":16,"jtIdentifier":"201304291205"},
      "jobId":"job_201304291205_0016"},
      "id":"job_201304291205_0016",
      "parentId":"job_201304291205_0015",
      "percentComplete":"map 100% reduce 100%",
      "exitValue":0,
      "user":"daijy",
      "callback":"http://daijymacpro.local:57815/templeton/$jobId",
      "completed":"done"}}]

JSON Output (fields, Hive 0.12.0 and later)

Info
titleVersion: Hive 0.12.0 and laterbug

In Starting in Hive release 0.12.0 , the first line of JSON output for the fields parameter returns user arguments as well as status information gives the parent jobid instead of the actual jobid (HIVE-5031).5510). The example below shows the correct jobid, as displayed in release 0.13.0 and later.


No Format
[{"id":"job_201304291205_00150016",
  "detail":{
    "status":{
      "jobACLs":{
        "MODIFY_JOB":{"allAllowed":false,"aclstring":" "},
        "VIEW_JOB":{"allAllowed":false,"aclstring":" "}},
      "runState":2,
      "startTime":1367264912274,
      "schedulingInfo":"NA",
      "failureInfo":"NA",
      "jobPriority":"NORMAL",
      "username":"daijy",
      "jobID":{"id":16,"jtIdentifier":"201304291205"},
      "jobId":"job_201304291205_0016",
      "jobComplete":true},
    "profile":{
      "user":"daijy",
      "jobFile":"hdfs://localhost:8020/Users/daijy/hadoop-1.0.3/tmp/mapred/staging/
          daijy/.staging/job_201304291205_0016/job.xml",
      "url":"http://localhost:50030/jobdetails.jsp?jobid=job_201304291205_0016",
      "queueName":"default",
      "jobName":"word count",
      "jobID":{"id":16,"jtIdentifier":"201304291205"},
      "jobId":"job_201304291205_0016"},
      "id":"job_201304291205_0016",
      "parentId":"job_201304291205_0015",
      "percentComplete":"map 100% reduce 100%",
      "exitValue":0,
      "user":"daijy",
      "callback":"http://daijymacpro.local:57815/templeton/$jobId",
      "completed": "done",
      "userargs" => {
        "callback"  => null,
        "define"    => [],
        "enablelog" => "false",
        "execute"   => "select a,rand(b) from mynums",
        "file"      => null,
        "files"     => [],
        "statusdir" => null,
        "user.name" => "hadoopqa",
      },
    }]

...

Panel
titleColorindigo
titleBGColorsilver
titleNavigation Links

Previous: DELETE queue/:jobid
Next: GET jobs/:jobid

General: WebHCat ReferenceWebHCat ManualHCatalog ManualHive Wiki HomeHive Project Site

Replaces deprecated resource: GET queue
Old version of deprecated resource (HCatalog 0.5.0): GET queue