Apache Hive

Apache Hive

Apache Software Foundation
5.0 out of 5 stars
Apache Hive WarehousePG

Related Products

  • HiveMQ
    4.5 out of 5 stars 92 Ratings
    Visit Website for HiveMQ
  • Google Cloud BigQuery
    4.5 out of 5 stars 2,037 Ratings
    Visit Website for Google Cloud BigQuery
  • AnalyticsCreator
    4.6 out of 5 stars 46 Ratings
    Visit Website for AnalyticsCreator
  • DbVisualizer
    4.8 out of 5 stars 593 Ratings
    Visit Website for DbVisualizer
  • Planview ProjectAdvantage
    4.3 out of 5 stars 121 Ratings
    Visit Website for Planview ProjectAdvantage
  • Semarchy xDM
    4.7 out of 5 stars 64 Ratings
    Visit Website for Semarchy xDM
  • SCIKIQ
    4.6 out of 5 stars 14 Ratings
    Visit Website for SCIKIQ
  • TIMi
    4.9 out of 5 stars 68 Ratings
    Visit Website for TIMi
  • ActiveBatch Workload Automation
    4.5 out of 5 stars 383 Ratings
    Visit Website for ActiveBatch Workload Automation
  • ChatD&B
    Visit Website for ChatD&B
Apache Hive:

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.
WarehousePG:

About

WarehousePG is an open-source, massively parallel processing (MPP) database for large-scale data warehousing, business intelligence, and analytics. Based on PostgreSQL, it distributes data and query work across clusters of coordinator and segment servers. SQL users can connect through PostgreSQL-compatible clients and interfaces, including psql, JDBC, ODBC, and libpq. Capabilities include append-optimized row- or column-oriented storage, table partitioning, parallel data loading through external tables, workload and resource management, query planning with GPORCA, and high availability through coordinator and segment mirroring. The Platform Extension Framework (PXF) lets WarehousePG query and write external data in sources such as Hadoop, object stores, and JDBC-accessible SQL databases. It supports analytical warehouse and BI workloads, with cluster deployments on Linux in on-premises or cloud infrastructure.
Apache Hive:

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
WarehousePG:

Platforms Supported

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

Audience

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

Audience

Data warehouse administrators, data engineers, and business intelligence and analytics teams managing large-scale analytical workloads.
Apache Hive:

Support

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

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Not Supported
Apache Hive:

API

Offers API Not Supported
WarehousePG:

API

Offers API Supported
Apache Hive:

Screenshots and Videos

WarehousePG:

Screenshots and Videos

Apache Hive:

Pricing

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

Pricing

$0
The WarehousePG project is free and open source.
Free Version Supported
Free Trial Not Supported
Apache Hive:

Reviews/Ratings

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

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
Apache Hive:

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.
Apache Hive:

Training

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

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported
Apache Hive:

Company Information

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

Company Information

EDB
Founded: 2004
United States
warehouse-pg.io
Apache Hive:

Alternatives

Apache Drill

Apache Drill

The Apache Software Foundation
WarehousePG:

Alternatives

Apache Doris

Apache Doris

The Apache Software Foundation
Apache Hive:
Apache HBase

Apache HBase

The Apache Software Foundation
WarehousePG:
Apache Phoenix

Apache Phoenix

Apache Software Foundation
Apache Hive:
Apache Hudi

Apache Hudi

Apache Corporation
WarehousePG:
Apache Trafodion

Apache Trafodion

Apache Software Foundation
Apache Hive:
Apache Sentry

Apache Sentry

Apache Software Foundation
WarehousePG:
Apache Hive:
WarehousePG:
Apache Hive:

Categories

ETL Supported
Query Engines Supported
WarehousePG:

Categories

Data Warehouse Supported
SQL Databases Supported
Apache Hive:

Integrations

3forge Supported
Acryl Data Supported
Apache Impala Supported
Apache Sentry Supported
Ascend Supported
Azure Blob Storage Not Supported
Chat2DB Supported
DataGrip Supported
Datameer Supported
IRI Data Protector Suite Supported
OLake Fusion Supported
PHEMI Health DataLab Supported
Progress DataDirect Supported
Qlik Staige Supported
Rational BI Supported
Sifflet Supported
eQube®-DaaS Supported
lakeFS Supported
WarehousePG:

Integrations

3forge Not Supported
Acryl Data Not Supported
Apache Impala Not Supported
Apache Sentry Not Supported
Ascend Not Supported
Azure Blob Storage Supported
Chat2DB Not Supported
DataGrip Not Supported
Datameer Not Supported
IRI Data Protector Suite Not Supported
OLake Fusion Not Supported
PHEMI Health DataLab Not Supported
Progress DataDirect Not Supported
Qlik Staige Not Supported
Rational BI Not Supported
Sifflet Not Supported
eQube®-DaaS Not Supported
lakeFS Not Supported
Apache Hive:
Claim Apache Hive and update features and information
Claim Apache Hive and update features and information
WarehousePG:
Claim WarehousePG and update features and information
Claim WarehousePG and update features and information