Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Reference: WebHCat Resources

This overview page lists all of the WebHCat resources. (DDL resources are listed here and on another overview page. For information about HCatalog DDL commands, see HCatalog DDL. For information about Hive DDL commands, see Hive Data Definition Language.)

 

Category

Resource (Type)

Description

General

:version (GET)

Return a list of supported response types.

 

status (GET)

Return the WebHCat server status.

 

version (GET)

Return a list of supported versions and the current version.

 version/hive (GET)Return the Hive version being run. (Added in Hive 0.13.0.)
 version/hadoop (GET)Return the Hadoop version being run. (Added in Hive 0.13.0.)

DDL

ddl (POST)

Perform an HCatalog DDL command.

 

ddl/database (GET)

List HCatalog databases.

 

ddl/database/:db (GET)

Describe an HCatalog database.

 

ddl/database/:db (PUT)

Create an HCatalog database.

 

ddl/database/:db (DELETE)

Delete (drop) an HCatalog database.

 

ddl/database/:db/table (GET)

List the tables in an HCatalog database.

 

ddl/database/:db/table/:table (GET)

Describe an HCatalog table.

 

ddl/database/:db/table/:table (PUT)

Create a new HCatalog table.

 

ddl/database/:db/table/:table (POST)

Rename an HCatalog table.

 

ddl/database/:db/table/:table (DELETE)

Delete (drop) an HCatalog table.

 

ddl/database/:db/table/:existingtable/like/:newtable (PUT)

Create a new HCatalog table like an existing one.

 

ddl/database/:db/table/:table/partition (GET)

List all partitions in an HCatalog table.

 

ddl/database/:db/table/:table/partition/:partition (GET)

Describe a single partition in an HCatalog table.

 

ddl/database/:db/table/:table/partition/:partition (PUT)

Create a partition in an HCatalog table.

 

ddl/database/:db/table/:table/partition/:partition (DELETE)

Delete (drop) a partition in an HCatalog table.

 

ddl/database/:db/table/:table/column (GET)

List the columns in an HCatalog table.

 

ddl/database/:db/table/:table/column/:column (GET)

Describe a single column in an HCatalog table.

 

ddl/database/:db/table/:table/column/:column (PUT)

Create a column in an HCatalog table.

 

ddl/database/:db/table/:table/property (GET)

List table properties.

 

ddl/database/:db/table/:table/property/:property (GET)

Return the value of a single table property.

 

ddl/database/:db/table/:table/property/:property (PUT)

Set a table property.

MapReduce

mapreduce/streaming (POST)

Create and queue Hadoop streaming MapReduce jobs.

 

mapreduce/jar (POST)

Create and queue standard Hadoop MapReduce jobs.

Pig

pig (POST)

Create and queue Pig jobs.

Hive

hive (POST)

Run Hive queries and commands.

Queue
(deprecated in Hive 0.12,
removed in Hive 0.14)

queue (GET)

Return a list of all job IDs. (Removed in Hive 0.14.0.)

 

queue/:jobid (GET)

Return the status of a job given its ID. (Removed in Hive 0.14.0.)

 

queue/:jobid (DELETE)

Kill a job given its ID. (Removed in Hive 0.14.0.)

Jobs
(Hive 0.12 and later)

jobs (GET)

Return a list of all job IDs.

 

jobs/:jobid (GET)

Return the status of a job given its ID.

 

jobs/:jobid (DELETE)

Kill a job given its ID.

Panel
titleColorindigo
titleBGColorsilver
titleNavigation Links

Previous: Configuration
Next: GET :version

Overview of DDL resources: WebHCat Reference: DDL
HCatalog DDL commands: HCatalog DDL
Hive DDL commands: Hive Data Definition Language

General: WebHCat ManualHCatalog ManualHive Wiki HomeHive Project Site
Old version of this document (HCatalog 0.5.0): Reference: Templeton Resources