DDL Command — POST ddl
Description
Performs an HCatalog DDL command. The command is executed immediately upon request. Responses are limited to 1 MB. For requests which may return longer results consider using the Hive resource as an alternative.
URL
http://www.myserver.com/templeton/ddl
Parameters
Name | Description | Required? | Default |
|---|---|---|---|
exec | The HCatalog ddl string to execute | Required | None |
group | The user group to use when creating a table | Optional | None |
permissions | The permissions string to use when creating a table. The format is " | Optional | None |
The standard parameters are also supported.
Results
Name | Description |
|---|---|
stdout | A string containing the result HCatalog sent to standard out (possibly empty). |
stderr | A string containing the result HCatalog sent to standard error (possibly empty). |
exitcode | The exitcode HCatalog returned. |
Example
Curl Command
% curl -s -d 'exec=show tables;' \
'http://localhost:50111/templeton/v1/ddl?user.name=ekoifman'
Version information
Prior to Hive 0.13.0, user.name was specified in POST requests as a form parameter: curl -d user.name=<user>.
In Hive 0.13.0 onward, user.name should be specified in the query string (as shown above): 'http://.../templeton/v1/ddl?user.name=<name>'. Specifying user.name as a form parameter is deprecated.
JSON Output
{
"stdout": "important_table
my_other_table
my_table
my_table_2
pokes
",
"stderr": "WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated...
Hive history file=/tmp/ctdean/hive_job_log_ctdean_201111111258_2117356679.txt
OK
Time taken: 1.202 seconds
",
"exitcode": 0
}
JSON Output (error)
{
"stdout": "",
"stderr": "WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated...
Hive history file=/tmp/ctdean/hive_job_log_ctdean_201204051246_689834593.txt
FAILED: Parse Error: line 1:5 Failed to recognize predicate 'tab'...
",
"exitcode": 11
}
Previous: GET version/hadoop
Next: GET ddl/database
General: DDL Resources – WebHCat Reference – WebHCat Manual – HCatalog Manual – Hive Wiki Home – Hive Project Site