Hive Job — POST hive
Description
Runs a Hive query or set of commands.
URL
http://www.myserver.com/templeton/v1/hive
Parameters
Name |
Description |
Required? |
Default |
|---|---|---|---|
execute |
String containing an entire, short Hive program to run. |
One of either "execute" or "file" is required. |
None |
file |
HDFS file name of a Hive program to run. |
One of either "execute" or "file" is required. |
None |
define |
Set a Hive configuration variable using the syntax |
Optional |
None |
arg |
Set a program argument. This parameter is not available in releases prior to Hive 0.12.0. |
Optional in Hive 0.12.0+ |
None |
files |
Comma-separated files to be copied to the map reduce cluster. This parameter is not available in releases prior to Hive 0.12.0. |
Optional in Hive 0.12.0+ |
None |
statusdir |
A directory where WebHCat will write the status of the Hive job. If provided, it is the caller's responsibility to remove this directory when done. |
Optional |
None |
callback |
Define a URL to be called upon job completion. You may embed a specific job ID into this URL using |
Optional |
None |
The standard parameters are also supported.
Results
Name |
Description |
|---|---|
id |
A string containing the job ID similar to "job_201110132141_0001". |
info |
A JSON object containing the information returned when the job was queued. See the Hadoop documentation ( |
Example
Curl Command
% curl -s -d user.name=ctdean \
-d execute="select+*+from+pokes;" \
-d statusdir="pokes.output" \
'http://localhost:50111/templeton/v1/hive'
JSON Output
{
"id": "job_201111111311_0005",
"info": {
"stdout": "templeton-job-id:job_201111111311_0005
",
"stderr": "",
"exitcode": 0
}
}
Results
% hadoop fs -ls pokes.output Found 2 items -rw-r--r-- 1 ctdean supergroup 610 2011-11-11 13:22 /user/ctdean/pokes.output/stderr -rw-r--r-- 1 ctdean supergroup 15 2011-11-11 13:22 /user/ctdean/pokes.output/stdout % hadoop fs -cat pokes.output/stdout 1 a 2 bb 3 ccc
Previous: POST pig
Next: GET queue
General: WebHCat Reference – WebHCat Manual – HCatalog Manual – Hive Wiki Home – Hive Project Site
Old version of this document (HCatalog 0.5.0): POST hive