Delete a database.
http://
www.myserver.com/templeton/v1/ddl/database/
:db
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 " | Optional | None |
The standard parameters are also supported.
Name | Description |
---|---|
database | The database name |
% curl -s -X DELETE "http://localhost:50111/templeton/v1/ddl/database/newdb?user.name=ctdean" |
{ "database":"newdb" } |
{ "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" } |
Previous: PUT ddl/database/:db General: DDL Resources – WebHCat Reference – WebHCat Manual – HCatalog Manual – Hive Wiki Home – Hive Project Site |