Apache Hive

Apache Hive

Apache Software Foundation
+
+

Related Products

  • HiveMQ
    91 Ratings
    Visit Website
  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • DbVisualizer
    585 Ratings
    Visit Website
  • AnalyticsCreator
    46 Ratings
    Visit Website
  • Planview ProjectAdvantage
    121 Ratings
    Visit Website
  • SCIKIQ
    14 Ratings
    Visit Website
  • Semarchy xDM
    64 Ratings
    Visit Website
  • TIMi
    68 Ratings
    Visit Website
  • ActiveBatch Workload Automation
    375 Ratings
    Visit Website
  • Google Cloud Run
    349 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

Serverless, interactive querying for analyzing data in IBM Cloud Object Storage. Query your data directly where it is stored, there's no ETL, no databases, and no infrastructure to manage. IBM Cloud SQL Query uses Apache Spark, an open-source, fast, extensible, in-memory data processing engine optimized for low latency and ad hoc analysis of data. No ETL or schema definition needed to enable SQL queries. Analyze data where it sits in IBM Cloud Object Storage using our query editor and REST API. Run as many queries as you need; with pay-per-query pricing, you pay only for the data scan. Compress or partition data to drive savings and performance. IBM Cloud SQL Query is highly available and executes queries using compute resources across multiple facilities. IBM Cloud SQL Query supports a variety of data formats such as CSV, JSON and Parquet, and allows for standard ANSI SQL.

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

All types of businesses and organizations requiring a solution to query their data directly where it is stored

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

$5.00/Terabyte-Month
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

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

IBM
Founded: 1911
United States
www.ibm.com/cloud/sql-query

Alternatives

Apache Drill

Apache Drill

The Apache Software Foundation

Alternatives

Apache DataFusion

Apache DataFusion

Apache Software Foundation
Apache HBase

Apache HBase

The Apache Software Foundation
Apache Hudi

Apache Hudi

Apache Corporation
TimescaleDB

TimescaleDB

Tiger Data
Apache Sentry

Apache Sentry

Apache Software Foundation
Apache Phoenix

Apache Phoenix

Apache Software Foundation
Infobright DB

Infobright DB

IgniteTech

Categories

Categories

Relational Database Features

ACID Compliance
Data Failure Recovery
Multi-Platform
Referential Integrity
SQL DDL Support
SQL DML Support
System Catalog
Unicode Support

Integrations

Apache Spark
Data Sentinel
Lyftrondata
Adobe Real-Time CDP
Apache Ranger
Coginiti
DataClarity Unlimited Analytics
Ema
IBM Cloud Pak for Integration
LightBeam.ai
Nucleon Database Master
Okera
PHEMI Health DataLab
Precisely Connect
Rocket Data Replicate & Sync
StreamFlux
Timbr.ai
Union Cloud
eQube®-DaaS

Integrations

Apache Spark
Data Sentinel
Lyftrondata
Adobe Real-Time CDP
Apache Ranger
Coginiti
DataClarity Unlimited Analytics
Ema
IBM Cloud Pak for Integration
LightBeam.ai
Nucleon Database Master
Okera
PHEMI Health DataLab
Precisely Connect
Rocket Data Replicate & Sync
StreamFlux
Timbr.ai
Union Cloud
eQube®-DaaS
Claim Apache Hive and update features and information
Claim Apache Hive and update features and information
Claim IBM Cloud SQL Query and update features and information
Claim IBM Cloud SQL Query and update features and information