Apache Hive

Apache Hive

Apache Software Foundation
+
+

Related Products

  • HiveMQ
    91 Ratings
    Visit Website
  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • AnalyticsCreator
    46 Ratings
    Visit Website
  • DbVisualizer
    585 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
    375 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

SelectDB is a modern data warehouse based on Apache Doris, which supports rapid query analysis on large-scale real-time data. From Clickhouse to Apache Doris, to achieve the separation of the lake warehouse and upgrade to the lake warehouse. The fast-hand OLAP system carries nearly 1 billion query requests every day to provide data services for multiple scenes. Due to the problems of storage redundancy, resource seizure, complicated governance, and difficulty in querying and adjustment, the original lake warehouse separation architecture was decided to introduce Apache Doris lake warehouse, combined with Doris's materialized view rewriting ability and automated services, to achieve high-performance data query and flexible data governance. Write real-time data in seconds, and synchronize flow data from databases and data streams. Data storage engine for real-time update, real-time addition, and real-time pre-polymerization.

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

Companies interested in a solution to manage their real-time data writing and query response processes

Support

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

Support

Phone Support Supported
24/7 Live Support 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.22 per hour
Free Version Not Supported
Free Trial 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 Supported
Live Online Supported
In Person Supported

Company Information

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

Company Information

SelectDB
China
www.selectdb.com

Alternatives

Apache Drill

Apache Drill

The Apache Software Foundation

Alternatives

Apache Doris

Apache Doris

The Apache Software Foundation
Apache HBase

Apache HBase

The Apache Software Foundation
Apache Hudi

Apache Hudi

Apache Corporation
Apache Sentry

Apache Sentry

Apache Software Foundation
Apache Kylin

Apache Kylin

Apache Software Foundation

Categories

ETL Supported
Query Engines Supported

Categories

Integrations

Apache Doris Supported
TapData Supported
Airtool Supported
Apache Ranger Supported
Aqua Data Studio Supported
CelerData Cloud Supported
DBeaver Community Supported
Datalogz Supported
Hackolade Supported
IBM API Connect Supported
IBM App Connect Supported
IBM Cloud Mass Data Migration Supported
Immuta Supported
Nightfall Supported
PHEMI Health DataLab Supported
Predibase Supported
Privacera Supported
Secoda Supported
Trino Not Supported
WINDEV Supported

Integrations

Apache Doris Supported
TapData Supported
Airtool Not Supported
Apache Ranger Not Supported
Aqua Data Studio Not Supported
CelerData Cloud Not Supported
DBeaver Community Not Supported
Datalogz Not Supported
Hackolade Not Supported
IBM API Connect Not Supported
IBM App Connect Not Supported
IBM Cloud Mass Data Migration Not Supported
Immuta Not Supported
Nightfall Not Supported
PHEMI Health DataLab Not Supported
Predibase Not Supported
Privacera Not Supported
Secoda Not Supported
Trino Supported
WINDEV Not Supported
Claim Apache Hive and update features and information
Claim Apache Hive and update features and information
Claim SelectDB and update features and information
Claim SelectDB and update features and information