macOS
brew install hivelocal Homebrew formula metadata
brew
Prüfe Installationswege, Executables, Metadaten und Sicherheitshinweise für hive in AI-Agent-Workflows.
Installation
brew install hivelocal Homebrew formula metadata
Überblick
Hadoop-based data summarization, query, and analysis
Verlauf
Apache Hive is a distributed data warehouse system for reading, writing, managing, and querying large datasets in distributed storage using SQL. It began at Facebook as a way to make Hadoop usable by analysts and engineers who did not want to write MapReduce jobs for ordinary aggregation and reporting.
As a package, Hive is historically important because it turned Hadoop clusters into SQL-addressable data warehouses. Installing the package gives users not just a CLI named `hive`, but Beeline, HiveServer2, metastore tooling, schema tooling, HPL/SQL, and the operational surface around Hadoop-era data warehousing.
Facebook engineers started building Hive after data growth exposed the limits of a commercial RDBMS-backed warehouse. The Meta engineering history says Facebook's data grew from a 15 TB dataset in 2007 to more than 2 PB by the time of the 2009 article, and that MapReduce was too low-level for many analysis tasks.
Hive's design brought tables, columns, partitions, and a SQL subset to Hadoop while preserving Hadoop's extensibility. Facebook open sourced Hive in August 2008, and Apache Foundation milestones record Hive entering the Apache Incubator in 2008. ASF milestones record Hive becoming a top-level Apache project in 2010.
The Apache Hive site describes the project as a distributed, fault-tolerant data warehouse at massive scale. It emphasizes SQL over distributed storage, the Hive Metastore as a central metadata repository, HiveServer2 for multi-client access, cost-based optimization, compaction, replication, security integrations, and support for modern storage systems and table formats.
Early adoption was intense inside Facebook. The Meta engineering post says Hive was popular with internal users from the start, regularly ran thousands of jobs, served hundreds of users, stored more than 2 PB of uncompressed data, and loaded 15 TB daily.
Open-source adoption followed because Hive lowered the barrier to Hadoop analytics. It let analysts use a SQL-like language while Hadoop handled distributed execution. The Apache site later presents Hive as used by enterprises and cloud/data-platform vendors, and highlights integrations with S3, Azure Data Lake, Google Cloud Storage, Spark, Presto, Impala, Apache Ranger, Apache Atlas, Apache Iceberg, and other data-stack components.
Hive also created a durable ecosystem surface: the metastore became a central catalog for other engines and data lake architectures, while Beeline and HiveServer2 became common access points for JDBC, ODBC, BI tools, and scripts.
In package-manager terms, users install Hive to get command-line and service entry points. The Homebrew package exposes `beeline`, `hive`, `hive-config.sh`, `hiveserver2`, `hplsql`, `init-hive-dfs.sh`, `metatool`, `replstats.sh`, and `schematool`.
Historically, users ran HiveQL through the `hive` CLI; Beeline and HiveServer2 became the preferred client/server model for multi-client and authenticated access. Operators configure XML files such as `hive-site.xml`, metastore and server configuration files, and Beeline connection files.
Typical workloads include SQL analytics on distributed storage, ETL, table and partition management, metastore-backed data lake catalogs, batch reporting, compaction, replication, and integration with BI and JDBC/ODBC clients.
Hive is one of the packages that made the Hadoop ecosystem approachable to SQL users. It matters in package history because it bridged a low-level distributed-computing substrate and the familiar data-warehouse interface that enterprises already knew how to staff, script, and operate.
The package also illustrates why some CLI packages are really ecosystems. The `hive` formula is not only a command; it packages services, schema tools, metastore administration, connection clients, and configuration conventions. That makes it closer to a platform component than a simple executable.
Hive's long tail is especially visible in the metastore. Even as newer engines evolved, the Hive Metastore remained a shared metadata layer in data-lake deployments, so package maintainers and operators continued to care about Hive compatibility beyond the original MapReduce execution model.
Sicherheitslage
broad file, network, media, or database tool signal. generalized runtime or code generation signal.
yellow Risiko · mittel Konfidenz · runtime
Prüfe vor unbeaufsichtigter Agent-Nutzung, ob das Tool Klartext-Credentials liest, Remote-Zustand schreibt, Artefakte veröffentlicht oder Plugins ausführt.
local files
These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval.
Config paths the tool may read or write during local use.
$HIVE_CONF_DIR/hive-site.xml$HIVE_CONF_DIR/hivemetastore-site.xml$HIVE_CONF_DIR/hiveserver2-site.xml$HIVE_HOME/conf/hive-site.xmlCredential-bearing paths to review before unattended agent runs.
${user.home}/.beeline/beeline-hs2-connection.xml$HIVE_CONF_DIR/beeline-hs2-connection.xml/etc/hive/conf/beeline-hs2-connection.xml${user.home}\beeline\beeline-hs2-connection.xmlExecutables
| Befehl | Art | Sichtbarkeit | Hinweis |
|---|---|---|---|
beeline | cli | globales Executable | |
hive | cli | globales Executable | |
hive-config.sh | cli | globales Executable | |
hiveserver2 | cli | globales Executable | |
hplsql | cli | globales Executable | |
init-hive-dfs.sh | cli | globales Executable | |
metatool | cli | globales Executable | |
replstats.sh | cli | globales Executable | |
schematool | cli | globales Executable |
Aktualität
Diese Signale trennen das Alter der Seitengenerierung, Aktivität des Paketmanagers und Upstream-Release-Vergleich. Versionsrückstand wird nur gemeldet, wenn eine Evidenz-URL und vergleichbare Versionen vorhanden sind.
Installationsmetadaten
| Paketschlüssel | brew:hive |
|---|---|
| Version | 4.2.0 |
| Paketmanager | Homebrew |
| Paketmanager-Seite | https://formulae.brew.sh/formula/hive |
| Homepage | https://hive.apache.org |
| Repository | https://github.com/apache/hive |
| Upstream-Dokumentation | https://hive.apache.org/development/gettingstarted-latest |
| Lizenz | Apache-2.0 |
| Quellarchiv | https://www.apache.org/dyn/closer.lua?path=hive/hive-4.2.0/apache-hive-4.2.0-bin.tar.gz |
| Zuletzt aktualisiert | 2026-06-22T14:03:43-07:00 |
| Pulse | updated |
| Abhängigkeiten | hadoop, openjdk@21 |
| Bottle | verfügbar (auf all) |
| Homebrew post-install | nicht definiert |
| Dienst | keiner deklariert |
| Einschränkungen | If you want to use HCatalog with Pig, set $HCAT_HOME in your profile: export HCAT_HOME=$HOMEBREW_PREFIX/opt/hive/libexec/hcatalog |
Registry-Fakten
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | hive |
| Version Scheme | 0 |
| Revision | 0 |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | no |
| URL Keys |
|
Quellspur
Diese Seite wird von av-web aus dem privaten Paket-SQLite-Artefakt bereitgestellt, das scripts/generate-pkg-sqlite.py erstellt.
View the package source record on GitHub.