# Apache Hive

**Canonical:** https://apis.io/providers/apache-hive/  
**APIs profiled:** 4

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.

## Kin Score — 33.6 / 100 (thin)

Scored 2026-08-20 under rubric 0.12.0. Trend: flat (+0.0 from 33.6).

| Facet | Score |
|---|---|
| Discoverability | 64.8 |
| Contract Quality | 55.7 |
| Governance | 25.0 |
| Contract Governance | 25.0 |
| Operational Transparency | 21.1 |
| Developer Ergonomics | 21.4 |
| Commercial Clarity | 15.8 |
| Access Clarity | 15.8 |

## Agent readiness — 20.5 (agent-aware)

| Dimension | Value |
|---|---|
| Spec Presence | yes |
| Agentic Access | derived |
| Reversibility Documented | no |
| MCP Server | no |
| Auth Clarity | no |
| Idempotency | no |
| Error Semantics | no |
| OpenAPI Examples | no |
| Rate Limit Signal | documented |
| Event Surface Described | no |
| Agent Skills | no |
| Well Known Catalog | no |
| Consent Identity | no |
| Agent Card | no |
| Dry Run Mode | no |

## Access

Freemium — onboarding: unknown, pricing: freemium, trial: no (confidence: medium).

## APIs (4)

- **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

## Agentic access (1)

- **Apache Hive Agentic Access** — 7 operations · 1 acting

## Security (2)

- **Apache Hive Domain Security** — TLSv1.3 · HSTS · DMARC
- **Apache Hive Vulnerability Disclosure** — security.txt · contact published

## Plans (1)

- **Apache Hive Plans Pricing**

## Use cases (5)

- **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.

## Tags

Apache, Big Data, Data Warehouse, ETL, Hadoop, Open-Source, SQL

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/providers/apache-hive/). Scores are computed from the provider's own public artifacts under a published rubric.