Apache Hive

Apache Hive

Apache Software Foundation
Apache Phoenix

Apache Phoenix

Apache Software Foundation
+
+

Related Products

  • HiveMQ
    77 Ratings
    Visit Website
  • Google Cloud BigQuery
    2,008 Ratings
    Visit Website
  • DbVisualizer
    561 Ratings
    Visit Website
  • AnalyticsCreator
    46 Ratings
    Visit Website
  • Semarchy xDM
    64 Ratings
    Visit Website
  • dbt
    239 Ratings
    Visit Website
  • ActiveBatch Workload Automation
    366 Ratings
    Visit Website
  • Declarative Webhooks
    3 Ratings
    Visit Website
  • ChatD&B
    Visit Website
  • Google Cloud Run
    341 Ratings
    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 Phoenix enables OLTP and operational analytics in Hadoop for low-latency applications by combining the best of both worlds. The power of standard SQL and JDBC APIs with full ACID transaction capabilities and the flexibility of late-bound, schema-on-read capabilities from the NoSQL world by leveraging HBase as its backing store. Apache Phoenix is fully integrated with other Hadoop products such as Spark, Hive, Pig, Flume, and Map Reduce. Become the trusted data platform for OLTP and operational analytics for Hadoop through well-defined, industry-standard APIs. Apache Phoenix takes your SQL query, compiles it into a series of HBase scans, and orchestrates the running of those scans to produce regular JDBC result sets. Direct use of the HBase API, along with coprocessors and custom filters, results in performance on the order of milliseconds for small queries, or seconds for tens of millions of rows.

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Audience

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

Audience

Anyone searching for a solution to manage their OLTP and operational analytics for Apache Hadoop

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

API

Offers API

API

Offers API

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version
Free Trial

Pricing

Free
Free Version
Free Trial

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

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Company Information

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

Company Information

Apache Software Foundation
phoenix.apache.org

Alternatives

Apache Drill

Apache Drill

The Apache Software Foundation

Alternatives

Apache HBase

Apache HBase

The Apache Software Foundation
Apache Trafodion

Apache Trafodion

Apache Software Foundation
Apache Hudi

Apache Hudi

Apache Corporation
Apache Spark

Apache Spark

Apache Software Foundation
Apache Sentry

Apache Sentry

Apache Software Foundation

Categories

Categories

Integrations

Amazon EMR
Apache Spark
Data Sentinel
SQL
Salesforce Data 360
Apache Flume
Apache Hudi
Captain Compliance
ClicData
Dataiku
Hue
OpenText Structured Data Manager
Progress DataDirect
StarRocks
Union Cloud
e6data
lakeFS

Integrations

Amazon EMR
Apache Spark
Data Sentinel
SQL
Salesforce Data 360
Apache Flume
Apache Hudi
Captain Compliance
ClicData
Dataiku
Hue
OpenText Structured Data Manager
Progress DataDirect
StarRocks
Union Cloud
e6data
lakeFS
Claim Apache Hive and update features and information
Claim Apache Hive and update features and information
Claim Apache Phoenix and update features and information
Claim Apache Phoenix and update features and information