Apache Hive

Apache Hive

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

SpectX is a powerful log analyzer for incident investigation and data exploration. It does not ingest or index data but runs queries directly on log files stored in file systems or blob storage. Local log servers, cloud storage, Hadoop clusters, JDBC-databases, production servers, Elastic clusters, or anything that speaks HTTP - SpectX turns any text-based log files into structured virtual views. SpectX query language is inspired by piping in Unix. An extensive library of built-in query functions allows analysts to compose complex queries and get advanced insights. In addition to the browser-based interface, every query can be easily executed via RESTful API, with advanced options to customize the resultset. This makes it easy to integrate SpectX with other applications in need of clean and structured data. SpectX easy-to-read pattern matching language can flexibly match any data, no need to read or write regex.

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 Supported
Mac Supported
Linux 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

security analysts, data engineers, system administrators

Support

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

Support

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

API

Offers API Not Supported

API

Offers API Supported

Screenshots and Videos

Screenshots and Videos

Pricing

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

Pricing

$79/month
No limits on data volumes.
Free Version 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 Not Supported
Live Online Not Supported
In Person Supported

Company Information

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

Company Information

SpectX
Founded: 2015
Estonia
www.spectx.com

Alternatives

Apache Drill

Apache Drill

The Apache Software Foundation

Alternatives

Mirada XD

Mirada XD

Mirada Medical
Apache HBase

Apache HBase

The Apache Software Foundation
Apache Hudi

Apache Hudi

Apache Corporation
Hermia

Hermia

Hermes Medical Solutions
Apache Sentry

Apache Sentry

Apache Software Foundation
ProSpect

ProSpect

Mitchell1
LogFusion

LogFusion

Binary Fortress Software

Categories

ETL Supported
Query Engines Supported

Categories

Log Analysis Supported
Log Management Supported

Log Management Features

Archiving Supported
Audit Trails Supported
Compliance Reporting Not Supported
Consolidation Supported
Data Visualization Supported
Event Logs Supported
Network Logs Supported
Remediation Not Supported
Syslogs Supported
Thresholds Supported
Web Logs Supported

Integrations

ActionIQ Supported
Amadea Supported
Apache Sentry Supported
Ascend Supported
Astro by Astronomer Supported
Baidu Sugar Supported
BigBI Supported
Causal Supported
Cloudera Data Warehouse Supported
E-MapReduce Supported
IBM API Connect Supported
Inferyx Supported
Mage Dynamic Data Masking Supported
Mage Static Data Masking Supported
Nightfall Supported
Privacera Supported
Protegrity Supported
SQL Supported
WEBDEV Supported
jethro Supported

Integrations

ActionIQ Not Supported
Amadea Not Supported
Apache Sentry Not Supported
Ascend Not Supported
Astro by Astronomer Not Supported
Baidu Sugar Not Supported
BigBI Not Supported
Causal Not Supported
Cloudera Data Warehouse Not Supported
E-MapReduce Not Supported
IBM API Connect Not Supported
Inferyx Not Supported
Mage Dynamic Data Masking Not Supported
Mage Static Data Masking Not Supported
Nightfall Not Supported
Privacera Not Supported
Protegrity Not Supported
SQL Not Supported
WEBDEV Not Supported
jethro Not Supported
Claim Apache Hive and update features and information
Claim Apache Hive and update features and information
Claim SpectX and update features and information
Claim SpectX and update features and information