Apache Hive

Apache Hive is a data warehouse software that facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. It provides a SQL-like interface called HiveQL for querying data stored in Hadoop, along with a WebHCat REST API for job submission and metastore access.

Apache Hive publishes 3 APIs on the APIs.io network: Databases API, Jobs API, and Tables API. Tagged areas include Apache, Big Data, Data Warehouse, ETL, and Hadoop.

The Apache Hive catalog on APIs.io includes 1 JSON-LD context and 2 Spectral governance rulesets.

Apache Hive’s developer surface includes documentation, getting-started guide, and 12 more developer resources.

🌐 Visit website 📡 Source on GitHub

35.4/100 thin ▬ flat Agent 17/100 agent aware self hosted · Apache-2.0 Full breakdown ↓
scored 2026-09-08 · rubric v0.20.0

AccessFreemium

1 APIs 8 Features 5 Use Cases

Apache Big Data Data Warehouse ETL Hadoop Open-Source SQL

Kin Score

Kin Score How this is scored →
scored 2026-09-08 · rubric v0.20.0

Composite quality — 35.4/100 · thin

Contract Quality 10.8 / 20

Developer Ergonomics 4.6 / 16

Access Clarity 2.5 / 16

Operational Transparency 2.2 / 10

Contract Governance 2.8 / 10

Discoverability 4.7 / 8

Open Source Surface 5.0 / 10

Create-or-Update Ergonomics 0.0 / 10

Agent readiness — 17/100 · agent aware

Machine-Readable Contract 18 / 18

Agentic Access Contract 10 / 10

Documented Reversibility 0 / 6

MCP Server 0 / 12

Machine-Readable Auth 0 / 10

Idempotency 0 / 9

Stable Error Semantics 0 / 8

Request/Response Examples 0 / 7

Rate-Limit Signaling 7 / 7

Typed Event Surface 0 / 6

Agent Skills 0 / 5

Well-Known Catalog 0 / 4

Consent & Bot Identity 0 / 3

A2A Agent Card 0 / 8

Dry-Run / Simulate Mode 0 / 4

Delegated User Identity 0 / 6

Protected Resource Metadata 0 / 5

Registration Without a Human 0 / 6

Agentic Commerce Well-Known Document 0 / 5

Open Source Surface applies to this provider. This product is open source and we read its repository directly, so Open Source Surface carries 10 points of the composite. It is scored from what the repository actually publishes — a security policy, a contribution guide, a release history, a code of conduct — read live from the provider rather than inferred from our own catalog pointers. This facet adds; nothing was taken away to make room for it. An open-source project is not excused from the commercial facets, because exemption would strip it of the points it does earn. If we have the wrong repository, or this product is not open source, say so on your provider repo and we will drop the facet rather than have you publish against it.

Create-or-Update Ergonomics applies to this provider. This API accepts writes, so it carries 10 points of the composite. It is scored from the published contracts themselves: whether a caller can create-or-update in one call, whether the write accepts a key the caller already holds, and whether the response says which branch ran. Without that, every write needs a search-and-branch in front of it, and the first time that check is skipped a duplicate record is created. Scored against the observed mean rather than raw — a provider at the catalog average is unchanged by this facet, not penalised by it.

The six quality facets above are damped to 80 points between them, because the conditional facet above carries the other 20. That is why each facet's contribution is shown against a damped maximum: raising a quality facet moves the composite by 80% of its nominal weight, not 100%. The full arithmetic is at apis.io/rating/.

Improve this rating by publishing the missing artifacts — every area above can be raised, and the full rubric is at apis.io/rating/. Every facet and dimension name above is a link: it opens that measurement's own page — what it means, the exact checks that feed it, how the whole catalog distributes on it, and the providers at the top of it. This rating is computed from github.com/api-evangelist/apache-hive: open an issue to ask a question, or submit a pull request to add artifacts. Submit an artifact on GitHub — free → Manage your own listing — the Influence plan, $499/mo →

APIs 4

Individual APIs this provider publishes, each with its own machine-readable definition.

Apache Hive JDBC API

JDBC interface to HiveServer2 for standard SQL client connectivity, supporting parameterized queries, result sets, and connection pooling from Java and ODBC-bridge applications.

Apache Hive Databases API

Database metadata operations

Apache Hive Jobs API

Hive job submission and monitoring

Apache Hive Tables API

Table metadata operations

Open Collections 5

Open, tool-agnostic API collections (OpenAPI-derived and Bruno).

API Collection

OPEN COLLECTION

Apache Hive WebHCat REST Databases API

OPEN COLLECTION

Apache Hive WebHCat REST Databases Jobs API

OPEN COLLECTION

Apache Hive WebHCat REST Databases Tables API

OPEN COLLECTION

Apache Hive WebHCat REST API

OPEN COLLECTION

Pricing Plans 1

Published pricing tiers and plan structures.

Apache Hive Plans Pricing

3 plans

PLANS

Rate Limits 1

Documented rate limits and quota policies.

Apache Hive Rate Limits

5 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals for API financial operations.

Apache Hive Finops

FINOPS

Features 8

Notable capabilities this provider offers.

HiveQL SQL Interface

SQL-like query language for reading, writing, and aggregating data stored in distributed storage.

WebHCat REST API

HTTP REST API (Templeton) for DDL operations, job submission, and metastore metadata access.

HiveServer2 JDBC/ODBC

Thrift-based server with JDBC and ODBC drivers for standard SQL client connectivity.

Hive Metastore

Central repository for table schema, partition metadata, and storage location information.

Partitioning

Partition tables by column values for efficient query pruning and data organization.

ORC and Parquet Storage

Optimized columnar storage formats with predicate pushdown and compression support.

ACID Transactions

Full ACID transaction support for inserts, updates, and deletes on managed ORC tables.

Vectorized Query Execution

Batch processing of rows in CPU register-width vectors for improved query throughput.

Scroll for all 8

Semantic Vocabularies 1

JSON-LD contexts and semantic vocabularies used across these APIs.

Apache Hive Webhcat Context

21 classes · 0 properties

JSON-LD

Spectral Rules 2

Spectral governance rulesets for linting and validating these APIs.

Apache Hive API Rules

5 rules · 3 warnings 2 info

SPECTRAL

Apache Hive API Rules

13 rules · 2 errors 9 warnings 2 info

SPECTRAL

JSON Schema 6

Standalone JSON Schema definitions for this provider's data models.

Column

3 properties

JSON SCHEMA

Database

5 properties

JSON SCHEMA

Job

6 properties

JSON SCHEMA

Partition

5 properties

JSON SCHEMA

QueryResult

4 properties

JSON SCHEMA

Table

8 properties

JSON SCHEMA

JSON Structure 6

JSON Structure definitions describing this provider's data shapes.

Hive Webhcat Column Structure

3 properties

JSON STRUCTURE

Hive Webhcat Database Structure

5 properties

JSON STRUCTURE

Hive Webhcat Job Structure

6 properties

JSON STRUCTURE

Hive Webhcat Partition Structure

5 properties

JSON STRUCTURE

Hive Webhcat Queryresult Structure

4 properties

JSON STRUCTURE

Hive Webhcat Table Structure

8 properties

JSON STRUCTURE

Examples 6

Example request and response payloads for these APIs.

Hive Webhcat Column Example

3 fields

EXAMPLE

Hive Webhcat Database Example

5 fields

EXAMPLE

Hive Webhcat Job Example

6 fields

EXAMPLE

Hive Webhcat Partition Example

5 fields

EXAMPLE

Hive Webhcat Queryresult Example

4 fields

EXAMPLE

Hive Webhcat Table Example

8 fields

EXAMPLE

Security Posture 2

Authentication, domain security, vulnerability disclosure, and trust-center signals.

Apache Hive Domain Security

TLSv1.3 · HSTS · DMARC

SECURITY

Apache Hive Vulnerability Disclosure

security.txt · contact published

SECURITY

Agentic Access 1

Recommended x-agentic-access execution contracts for AI agents.

Apache Hive Agentic Access

7 operations · 1 acting

AGENTIC

Use Cases 5

What developers build with this provider.

Data Warehouse Analytics

Run SQL analytics on petabyte-scale datasets stored in HDFS or object storage.

ETL Pipeline Orchestration

Use HiveQL scripts to transform and load data between raw and curated data lake zones.

Ad-Hoc Data Exploration

Query structured data interactively using Beeline or JDBC-connected BI tools.

Log Analysis

Parse and aggregate application logs stored as text or JSON in HDFS using Hive SerDes.

Data Catalog Integration

Use the Hive Metastore as a shared schema registry for Spark, Flink, and Presto.

Resources

Get Started 1

Portal, sign-up, and the first successful call

GettingStarted

GettingStarted

Documentation 1

Reference material describing how the API behaves

Documentation

Documentation

Agent Surfaces 1

MCP servers, agent skills, and machine-readable catalogs

AgenticAccess

AgenticAccess

Design & Contract 2

Pagination, idempotency, versioning, errors, and events

SpectralRules

SpectralRules

Vocabulary

Vocabulary

Build 3

SDKs, sample code, and the tooling you integrate with

CodeOfConduct

CodeOfConduct

GitHubOrganization

GitHubOrganization

GitHubRepository

GitHubRepository

Access & Security 3

Authentication, authorization, and security posture

SecurityPolicy

SecurityPolicy

VulnerabilityDisclosure

VulnerabilityDisclosure

DomainSecurity

DomainSecurity

Commercial 1

Pricing, plans, and the legal terms of use

License

License

Company 2

The organization behind the API

Website

Website

LinkedIn

Source (apis.yml)

aid: apache-hive
name: Apache Hive
description: Apache Hive is a data warehouse software that facilitates reading, writing, and managing large datasets residing
  in distributed storage using SQL. It provides a SQL-like interface called HiveQL for querying data stored in Hadoop, along
  with a WebHCat REST API for job submission and metastore access.
type: Index
deliveryModel:
  model: self-hosted
  license: Apache-2.0
  open_source: true
  commercial: false
  callable_host: false
  label: Self-hosted open source · you run it yourself
  confidence: high
  source:
  - license
  - openapi
  generated: '2026-08-28'
  method: derived
accessModel:
  pricing: freemium
  onboarding: unknown
  trial: false
  try_now: false
  public: false
  label: Freemium
  confidence: medium
  source:
  - plans
  generated: '2026-07-22'
  method: derived
position: Consuming
access: 3rd-Party
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/apache-hive.png
tags:
- Apache
- Big Data
- Data Warehouse
- ETL
- Hadoop
- Open-Source
- SQL
tags_raw:
- Apache
- Big Data
- Data Warehouse
- ETL
- Hadoop
- Open Source
- SQL
created: '2026-03-16'
modified: '2026-05-19'
url: https://raw.githubusercontent.com/api-evangelist/apache-hive/refs/heads/main/apis.yml
specificationVersion: '0.23'
apis:
- aid: apache-hive:apache-hive-jdbc
  name: Apache Hive JDBC API
  description: JDBC interface to HiveServer2 for standard SQL client connectivity, supporting parameterized queries, result
    sets, and connection pooling from Java and ODBC-bridge applications.
  humanURL: https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBC
  tags:
  - JDBC
  - SQL
  - SDK
  properties:
  - type: Documentation
    url: https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBC
  - type: SDKs
    url: https://search.maven.org/artifact/org.apache.hive/hive-jdbc
    title: Java JDBC Driver (Maven Central)
- aid: apache-hive:apache-hive-databases-api
  name: Apache Hive Databases API
  description: Database metadata operations
  humanURL: https://cwiki.apache.org/confluence/display/Hive/WebHCat
  baseURL: http://localhost:50111/templeton/v1
  tags:
  - Databases
  properties:
  - type: OpenAPI
    url: openapi/apache-hive-databases-api-openapi.yml
  - type: Documentation
    url: https://cwiki.apache.org/confluence/display/Hive/WebHCat
  - type: JSONSchema
    url: json-schema/hive-webhcat-table-schema.json
  - type: JSONLD
    url: json-ld/apache-hive-webhcat-context.jsonld
- aid: apache-hive:apache-hive-jobs-api
  name: Apache Hive Jobs API
  description: Hive job submission and monitoring
  humanURL: https://cwiki.apache.org/confluence/display/Hive/WebHCat
  baseURL: http://localhost:50111/templeton/v1
  tags:
  - Job
  tags_raw:
  - Jobs
  properties:
  - type: OpenAPI
    url: openapi/apache-hive-jobs-api-openapi.yml
  - type: Documentation
    url: https://cwiki.apache.org/confluence/display/Hive/WebHCat
  - type: JSONSchema
    url: json-schema/hive-webhcat-table-schema.json
  - type: JSONLD
    url: json-ld/apache-hive-webhcat-context.jsonld
- aid: apache-hive:apache-hive-tables-api
  name: Apache Hive Tables API
  description: Table metadata operations
  humanURL: https://cwiki.apache.org/confluence/display/Hive/WebHCat
  baseURL: http://localhost:50111/templeton/v1
  tags:
  - Tables
  properties:
  - type: OpenAPI
    url: openapi/apache-hive-tables-api-openapi.yml
  - type: Documentation
    url: https://cwiki.apache.org/confluence/display/Hive/WebHCat
  - type: JSONSchema
    url: json-schema/hive-webhcat-table-schema.json
  - type: JSONLD
    url: json-ld/apache-hive-webhcat-context.jsonld
common:
- type: Website
  url: https://www.apache.org/
- type: SecurityPolicy
  url: https://github.com/apache/hive/blob/master/SECURITY.md
- type: CodeOfConduct
  url: https://github.com/apache/.github/blob/main/.github/CODE_OF_CONDUCT.md
- type: License
  name: Apache-2.0
  url: https://github.com/apache/hive/blob/master/LICENSE
- type: AgenticAccess
  url: agentic-access/apache-hive-agentic-access.yml
- type: VulnerabilityDisclosure
  url: security/apache-hive-vulnerability-disclosure.yml
- type: DomainSecurity
  url: security/apache-hive-domain-security.yml
- type: LinkedIn
  url: https://www.linkedin.com/company/apache-hive
- type: Documentation
  url: https://cwiki.apache.org/confluence/display/Hive/Home
- type: GettingStarted
  url: https://cwiki.apache.org/confluence/display/Hive/GettingStarted
- type: GitHubOrganization
  url: https://github.com/apache
- type: GitHubRepository
  url: https://github.com/apache/hive
- type: SpectralRules
  url: rules/apache-hive-spectral-rules.yml
- type: Vocabulary
  url: vocabulary/apache-hive-vocabulary.yaml
- type: Features
  data:
  - name: HiveQL SQL Interface
    description: SQL-like query language for reading, writing, and aggregating data stored in distributed storage.
  - name: WebHCat REST API
    description: HTTP REST API (Templeton) for DDL operations, job submission, and metastore metadata access.
  - name: HiveServer2 JDBC/ODBC
    description: Thrift-based server with JDBC and ODBC drivers for standard SQL client connectivity.
  - name: Hive Metastore
    description: Central repository for table schema, partition metadata, and storage location information.
  - name: Partitioning
    description: Partition tables by column values for efficient query pruning and data organization.
  - name: ORC and Parquet Storage
    description: Optimized columnar storage formats with predicate pushdown and compression support.
  - name: ACID Transactions
    description: Full ACID transaction support for inserts, updates, and deletes on managed ORC tables.
  - name: Vectorized Query Execution
    description: Batch processing of rows in CPU register-width vectors for improved query throughput.
- type: UseCases
  data:
  - name: Data Warehouse Analytics
    description: Run SQL analytics on petabyte-scale datasets stored in HDFS or object storage.
  - name: ETL Pipeline Orchestration
    description: Use HiveQL scripts to transform and load data between raw and curated data lake zones.
  - name: Ad-Hoc Data Exploration
    description: Query structured data interactively using Beeline or JDBC-connected BI tools.
  - name: Log Analysis
    description: Parse and aggregate application logs stored as text or JSON in HDFS using Hive SerDes.
  - name: Data Catalog Integration
    description: Use the Hive Metastore as a shared schema registry for Spark, Flink, and Presto.
- type: Integrations
  data:
  - name: Apache Hadoop HDFS
    description: Hive reads and writes data stored in HDFS as the primary storage layer.
  - name: Apache Spark
    description: Spark uses the Hive Metastore for table discovery and supports Hive UDFs.
  - name: Apache HBase
    description: Hive HBase storage handler enables HiveQL queries against HBase tables.
  - name: Apache Tez
    description: Apache Tez DAG execution engine replaces MapReduce for faster Hive query processing.
  - name: Presto / Trino
    description: Presto and Trino use the Hive Metastore for table metadata in federated SQL queries.
- type: Integrations
  url: https://cwiki.apache.org/confluence/display/connectors
integrations:
- name: Apache Connectors Framework
- name: Please wait
- name: 'User icon: Anonymous'
- name: 'User icon: kwright@metacarta.com'
maintainers:
- FN: Kin Lane
  email: info@apievangelist.com

Work with this as data

Every provider 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 providers

9 MCP tools reach this

find_providersBrowse and filter every provider in the catalog.
get_provider_artifactsEvery artifact this provider publishes, grouped by type.
get_provider_operationsEvery operation across all of their OpenAPIs — one call instead of parsing every spec.
get_provider_toolsEvery MCP tool they ship, with the operation each wraps.
get_provider_evidenceHow each part of their score was established. Free — the basis for a claim should not sit behind it.
get_provider_ratingPRO — composite, band, trend and facet scores.
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.

All 92 tools →

Call it yourself

curl for this page

This provider

curl "https://apis.io/api/v1/providers/apache-hive"

All providers

curl "https://apis.io/api/v1/providers?limit=25"

Every operation they expose

curl "https://apis.io/api/v1/providers/apache-hive/operations?limit=25"

How their score was established

curl "https://apis.io/api/v1/providers/apache-hive/evidence"

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.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.