Apache Hive : WebHCat Reference GetDB

Describe Database — GET ddl/database/:db

• Describe Database — GET ddl/database/:db
  • Description
  • URL
  • Parameters
  • Results
  • Example
    • Curl Command
    • JSON Output
    • JSON Output (error)

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