Apache Hive : WebHCat Reference DeleteDB
Table of Contents
Apache Hive : WebHCat Reference DeleteDB
Description
Delete a database.
URL
http://www.myserver.com/templeton/v1/ddl/database/:db
Parameters
| Name | Description | Required? | 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
| Name | Description |
|---|---|
| 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"
}
Navigation Links Previous: PUT ddl/database/:db Next: GET ddl/database/:db/table