Apache Hive

Apache Hive

Apache Software Foundation
OLake Fusion

OLake Fusion

Datazip
+
+

Related Products

  • HiveMQ
    92 Ratings
    Visit Website
  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • AnalyticsCreator
    46 Ratings
    Visit Website
  • DbVisualizer
    593 Ratings
    Visit Website
  • Planview ProjectAdvantage
    121 Ratings
    Visit Website
  • Semarchy xDM
    64 Ratings
    Visit Website
  • SCIKIQ
    14 Ratings
    Visit Website
  • TIMi
    68 Ratings
    Visit Website
  • ActiveBatch Workload Automation
    383 Ratings
    Visit Website
  • ChatD&B
    Visit Website

About

The Apache Hive data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage. A command line tool and JDBC driver are provided to connect users to Hive. Apache Hive is an open source project run by volunteers at the Apache Software Foundation. Previously it was a subproject of Apache® Hadoop®, but has now graduated to become a top-level project of its own. We encourage you to learn about the project and contribute your expertise. Traditional SQL queries must be implemented in the MapReduce Java API to execute SQL applications and queries over distributed data. Hive provides the necessary SQL abstraction to integrate SQL-like queries (HiveQL) into the underlying Java without the need to implement queries in the low-level Java API.

About

OLake Fusion is a self-hosted application for maintaining Apache Iceberg tables in data lakehouses. It automates scheduled table compaction, merging small data files and converting delete files to improve table layout as data is continuously ingested, updated, or deleted. Users can configure maintenance at the table level and schedule Lite, Medium, and Full compaction tiers, review table health and file metrics, and track maintenance runs and logs through a web UI. Fusion connects to Iceberg catalogs, including AWS Glue, Hive Metastore, JDBC, and REST-based catalog implementations such as Nessie, Polaris, Unity Catalog, and Lakekeeper, and can maintain tables created outside OLake. It is deployed on Docker or Kubernetes in a team's cloud or on-premises environment, and is designed for data engineers and platform teams operating analytical lakehouses with Apache Iceberg.

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Not Supported
On-Premises Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

Developers and anyone looking for a data warehouse software that facilitates reading, writing, and managing large datasets using SQL

Audience

Data engineers and data platform teams operating Apache Iceberg lakehouses, particularly those maintaining tables with continuous ingestion, updates, or deletes.

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Supported

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Supported

API

Offers API Not Supported

API

Offers API Not Supported

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version Not Supported
Free Trial Not Supported

Pricing

$0
The open-source software has no license charge; customers pay for the compute and storage they provision.
Free Version Supported
Free Trial Not Supported

Reviews/Ratings

Overall 5.0 / 5
ease 5.0 / 5
features 4.0 / 5
design 5.0 / 5
support 5.0 / 5

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Pros & Cons from Real Users

Pros

  • Open Source Easy to learn - similar to SQL Fast performance Various data structures supported Scalable to meet growing demands Integrates with various tools & databases

Cons

  • Needs more SQL functionalities like subqueries & better optimization for advanced query like joins.

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Supported

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Company Information

Apache Software Foundation
Founded: 1999
United States
hive.apache.org

Company Information

Datazip
United States
olake.io/olake-fusion/

Alternatives

Apache Drill

Apache Drill

The Apache Software Foundation

Alternatives

Apache HBase

Apache HBase

The Apache Software Foundation
OLake Go

OLake Go

Datazip
Apache Hudi

Apache Hudi

Apache Corporation
Apache Iceberg

Apache Iceberg

Apache Software Foundation
Apache Sentry

Apache Sentry

Apache Software Foundation

Categories

ETL Supported
Query Engines Supported

Categories

Data Lake Supported

Integrations

Apache Iceberg Supported
Adobe Real-Time CDP Supported
Amundsen Supported
Apache Hudi Supported
BigBI Supported
Causal Supported
Chat2DB Supported
Datameer Supported
DbVisualizer Supported
Foundational Supported
Hackolade Supported
IRI Voracity Supported
Lyftrondata Supported
MLlib Supported
Mode Supported
Okera Supported
Secoda Supported
eQube®-DaaS Supported
jethro Supported

Integrations

Apache Iceberg Supported
Adobe Real-Time CDP Not Supported
Amundsen Not Supported
Apache Hudi Not Supported
BigBI Not Supported
Causal Not Supported
Chat2DB Not Supported
Datameer Not Supported
DbVisualizer Not Supported
Foundational Not Supported
Hackolade Not Supported
IRI Voracity Not Supported
Lyftrondata Not Supported
MLlib Not Supported
Mode Not Supported
Okera Not Supported
Secoda Not Supported
eQube®-DaaS Not Supported
jethro Not Supported
Claim Apache Hive and update features and information
Claim Apache Hive and update features and information
Claim OLake Fusion and update features and information
Claim OLake Fusion and update features and information