HCatalog
 
PDF -icon
PDF

DELETE ddl/database/:db

Description

Delete a database.

URL

http://www.myserver.com/templeton/v1/ddl/database/:db

Parameters

NameDescriptionRequired?Default
:db The database name Required None
ifExists Hive returns an error if the database specified does not exist, unless ifExists is set to true. Optional false
option Parameter set to either "restrict" or "cascade". Restrict will remove the schema if all the tables are empty. Cascade removes everything including data and definitions. Optional None
group The user group to use Optional None
permissions The permissions string to use. The format is "rwxrw-r-x". Optional None

The standard parameters are also supported.

Results

NameDescription
database The database name

Example

Curl Command 

% curl -s -X DELETE "http://localhost:50111/templeton/v1/ddl/database/newdb?user.name=ctdean"

JSON Output 

{
 "database":"newdb"
}

JSON Output (error) 

{
  "errorDetail": "
    NoSuchObjectException(message:There is no database named my_db)
        at org.apache.hadoop.hive.metastor...
    ",
  "error": "There is no database named newdb",
  "errorCode": 404,
  "database": "newdb"
}