Apache Hive : WebHCat Reference DeleteTable

Delete Table — DELETE ddl/database/:db/table/:table

• Delete Table — DELETE ddl/database/:db/table/:table
  • Description
  • URL
  • Parameters
  • Results
  • Example
    • Curl Command
    • JSON Output

Description

Delete (drop) an HCatalog table.

URL

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

Parameters

Name	Description	Required?	Default
:db	The database name	Required	None
:table	The table name	Required	None
ifExists	Hive 0.70 and later returns an error if the table specified does not exist, unless ifExists is set to true.	Optional	false
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
table	The table name
database	The database name

Example

Curl Command

% curl -s -X DELETE 'http://localhost:50111/templeton/v1/ddl/database/default/table/test\_table?user.name=ctdean'

JSON Output

{
 "table": "test\_table",
 "database": "default"
}

Navigation Links Previous: POST ddl/database/:db/table/:table Next: PUT ddl/database/:db/table/:existingtable/like/:newtable

General: DDL Resources – WebHCat Reference – WebHCat Manual – HCatalog Manual – Hive Wiki Home – Hive Project Site