Delete Database — DELETE ddl/database/:db
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 " |
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
General: DDL Resources – WebHCat Reference – WebHCat Manual – HCatalog Manual – Hive Wiki Home – Hive Project Site