macOS
brew install hivelocal Homebrew formula metadata
brew
hive のインストール経路、実行ファイル、メタデータ、AI エージェント向けセキュリティノートを確認します。
インストール
brew install hivelocal Homebrew formula metadata
概要
Hadoop-based data summarization, query, and analysis
履歴
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.
セキュリティ状態
broad file, network, media, or database tool signal. generalized runtime or code generation signal.
リスク yellow · 信頼度 中 · runtime
エージェントに無人実行させる前に、このツールが平文の認証情報を読むか、リモート状態を書き込むか、成果物を公開するか、プラグインを起動するかを確認してください。
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.xml実行可能ファイル
| コマンド | 種類 | 公開範囲 | メモ |
|---|---|---|---|
beeline | cli | グローバル実行可能ファイル | |
hive | cli | グローバル実行可能ファイル | |
hive-config.sh | cli | グローバル実行可能ファイル | |
hiveserver2 | cli | グローバル実行可能ファイル | |
hplsql | cli | グローバル実行可能ファイル | |
init-hive-dfs.sh | cli | グローバル実行可能ファイル | |
metatool | cli | グローバル実行可能ファイル | |
replstats.sh | cli | グローバル実行可能ファイル | |
schematool | cli | グローバル実行可能ファイル |
鮮度
これらの信号は、ページ生成時期、パッケージマネージャの活動、上流リリース比較を分けて示します。バージョン遅れは、証拠 URL と比較可能なバージョンがある場合だけ警告されます。
インストールメタデータ
| パッケージキー | brew:hive |
|---|---|
| バージョン | 4.2.0 |
| パッケージマネージャ | Homebrew |
| パッケージマネージャページ | https://formulae.brew.sh/formula/hive |
| ホームページ | https://hive.apache.org |
| リポジトリ | https://github.com/apache/hive |
| 上流ドキュメント | https://hive.apache.org/development/gettingstarted-latest |
| ライセンス | Apache-2.0 |
| ソースアーカイブ | https://www.apache.org/dyn/closer.lua?path=hive/hive-4.2.0/apache-hive-4.2.0-bin.tar.gz |
| 最終更新 | 2026-06-22T14:03:43-07:00 |
| Pulse | updated |
| 依存関係 | hadoop, openjdk@21 |
| Bottle | 利用可能 (対象 all) |
| Homebrew post-install | 未定義 |
| サービス | 宣言なし |
| 注意点 | If you want to use HCatalog with Pig, set $HCAT_HOME in your profile: export HCAT_HOME=$HOMEBREW_PREFIX/opt/hive/libexec/hcatalog |
レジストリ情報
| 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 |
|
ソース経路
このページは scripts/generate-pkg-sqlite.py が生成した非公開のパッケージ SQLite アーティファクトから av-web によって提供されます。
View the package source record on GitHub.