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 }
Previous: GET ddl/database
Next: PUT ddl/database/:db
General: DDL Resources – WebHCat Reference – WebHCat (Templeton) Manual – HCatalog Manual – Hive Home
Old version of this document (HCatalog 0.5.0): GET ddl/database/:db