Work with this as data
Every API here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for apis
7 MCP tools reach this
find_apisBrowse and filter every API in the catalog.get_api_artifactsOne API's artifacts, grouped by type.get_openapiThe primary OpenAPI for this API.find_similar_apisAPIs that look like this one.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/apache-hive-tables-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.
OpenAPI Specification
openapi: 3.2.0
info:
title: Apache Hive WebHCat REST Databases Tables API
version: 1.0.0
description: WebHCat REST API for Apache Hive providing DDL operations, HiveQL job submission, and Hive Metastore metadata access over HTTP.
contact:
email: user@hive.apache.org
license:
name: Apache 2.0
url: https://www.apache.org/licenses/LICENSE-2.0
servers:
- url: http://localhost:50111/templeton/v1
description: WebHCat (Templeton) REST API
tags:
- name: Tables
description: Table metadata operations
paths:
/ddl/database/{dbName}/table:
get:
operationId: listTables
summary: Apache Hive List Tables
description: List all tables in a Hive database.
tags:
- Tables
parameters:
- name: dbName
in: path
required: true
schema:
type: string
responses:
'200':
description: Tables listed
content:
application/json:
schema:
type: object
properties:
tables:
type: array
items:
type: string
/ddl/database/{dbName}/table/{tableName}:
get:
operationId: getTable
summary: Apache Hive Get Table
description: Get schema and metadata for a specific Hive table.
tags:
- Tables
parameters:
- name: dbName
in: path
required: true
schema:
type: string
- name: tableName
in: path
required: true
schema:
type: string
description: Table name
responses:
'200':
description: Table retrieved
content:
application/json:
schema:
$ref: '#/components/schemas/Table'
'404':
description: Table not found
/ddl/database/{dbName}/table/{tableName}/partition:
get:
operationId: listPartitions
summary: Apache Hive List Partitions
description: List all partitions for a Hive table.
tags:
- Tables
parameters:
- name: dbName
in: path
required: true
schema:
type: string
- name: tableName
in: path
required: true
schema:
type: string
responses:
'200':
description: Partitions listed
content:
application/json:
schema:
type: object
properties:
partitions:
type: array
items:
$ref: '#/components/schemas/Partition'
components:
schemas:
Partition:
type: object
description: Hive table partition
properties:
tableName:
type: string
description: Table name
example: sales
dbName:
type: string
description: Database name
example: mydb
values:
type: array
items:
type: string
description: Partition key values
example:
- 2024-01
- US
location:
type: string
description: Partition HDFS location
example: hdfs://namenode/user/hive/warehouse/mydb.db/sales/dt=2024-01/country=US
numRows:
type: integer
format: int64
description: Approximate row count
example: 50000
Table:
type: object
description: Hive table metadata
properties:
tableName:
type: string
description: Table name
example: sales
dbName:
type: string
description: Database name
example: mydb
tableType:
type: string
description: Table type (MANAGED_TABLE, EXTERNAL_TABLE, VIRTUAL_VIEW)
example: MANAGED_TABLE
comment:
type: string
description: Table description
example: Sales transaction data
location:
type: string
description: HDFS data location
example: hdfs://namenode/user/hive/warehouse/mydb.db/sales
inputFormat:
type: string
description: Input format class
example: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
outputFormat:
type: string
description: Output format class
example: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
numRows:
type: integer
format: int64
description: Approximate number of rows
example: 1000000