Apache Hive

Apache Hive

Apache Software Foundation
Apache Ossie

Apache Ossie

Apache Software Foundation
+
+

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

Apache Ossie is an open specification and converter toolkit for exchanging semantic metadata across analytics, business intelligence, and AI systems. Its YAML-based format describes semantic models, datasets, fields, metrics, dimensions, relationships, and SQL expressions in a portable structure. Data and analytics engineers can use compatible implementations to author, translate, and reuse these definitions across connected platforms, supporting consistent business context for reporting and AI-assisted analysis. The project is an open-source community effort under the Apache License 2.0, with available conversions depending on each platform’s implementation.

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 Not 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 and analytics engineers, semantic-model authors, data-platform teams, and developers building or connecting analytics, BI, and AI systems that need to exchange reusable semantic definitions across compatible tools.

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

No images available

Pricing

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

Pricing

No information available.
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

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

Alternatives

Apache Drill

Apache Drill

The Apache Software Foundation

Alternatives

No Alternatives
Apache HBase

Apache HBase

The Apache Software Foundation
Apache Hudi

Apache Hudi

Apache Corporation
Apache Sentry

Apache Sentry

Apache Software Foundation

Categories

ETL Supported
Query Engines Supported

Categories

Semantic Layer Supported

Integrations

Acceldata Supported
Acryl Data Supported
Airtool Supported
Apache Iceberg Supported
Apache Zeppelin Supported
Cloudera Data Platform Supported
DbVisualizer Supported
DigDash Supported
Ema Supported
Flyte Supported
Foundational Supported
Holistics Not Supported
Hue Supported
IBM watsonx.data Supported
Mode Supported
Okera Supported
SAS Federation Server Supported
Tableau Not Supported
Yandex Data Proc Supported

Integrations

Acceldata Not Supported
Acryl Data Not Supported
Airtool Not Supported
Apache Iceberg Not Supported
Apache Zeppelin Not Supported
Cloudera Data Platform Not Supported
DbVisualizer Not Supported
DigDash Not Supported
Ema Not Supported
Flyte Not Supported
Foundational Not Supported
Holistics Supported
Hue Not Supported
IBM watsonx.data Not Supported
Mode Not Supported
Okera Not Supported
SAS Federation Server Not Supported
Tableau Supported
Yandex Data Proc Not Supported
Claim Apache Hive and update features and information
Claim Apache Hive and update features and information
Claim Apache Ossie and update features and information
Claim Apache Ossie and update features and information