Describe Database — GET ddl/database/:db
Description
Describe a database. (Note: This resource has a "format=extended" parameter however the output structure does not change if it is used.)
URL
http://www.myserver.com/templeton/v1/ddl/database/:db
Parameters
Name | Description | Required? | Default |
|---|---|---|---|
:db | The database name | Required | None |
The standard parameters are also supported.
Results
Name | Description |
|---|---|
location | The database location |
params | The database parameters |
comment | The database comment |
database | The database name |
Example
Curl Command
% curl -s 'http://localhost:50111/templeton/v1/ddl/database/newdb?user.name=ctdean'
JSON Output
{
"location":"hdfs://localhost:9000/warehouse/newdb.db",
"params":"{a=b}",
"comment":"Hello there",
"database":"newdb"
}
JSON Output (error)
{
"error": "No such database: newdb",
"errorCode": 404
}
Navigation Links
Previous: GET ddl/database
Next: PUT ddl/database/:db
General: DDL Resources – WebHCat Reference – WebHCat Manual – HCatalog Manual – Hive Wiki Home – Hive Project Site