Apache Hive vs InfluxDB | TrustRadius

What users are saying about

Score 7.9 out of 10

Based on 81 reviews and ratings

Score 9 out of 10

Based on 11 reviews and ratings

Pros

Hive syntax is almost like SQL, so for someone already familiar with SQL it takes almost no effort to pick up Hive.
To be able to run map reduce jobs using json parsing and generate dynamic partitions in parquet file format.
Simplifies your experience with Hadoop especially for non-technical/coding partners.

Read full review

Bharadwaj (Brad) Chivukula

Sr.Technical Manager/Delivery Manager

Nisum Technologies, Inc.Retail, 10,001+ employees

View all 25 answers on this topic

Perfect handling telemetry data.
Low latency, near real time.
SQL-like language makes it easier to query.

Read full review

Verified User

Engineer in Information Technology

Insurance Company, 10,001+ employees

View all 4 answers on this topic

Cons

Use Hive for analytical work loads. Write once and read many scenarios. Do not prefer updates and deletes.
Behind scenes Hive creates map reduce jobs. Hive performance is slow compared to Apache Spark.
Map reduce writes the intermediate outputs to dial whereas Spark operates in in-memory and uses DAG.

Read full review

Verified User

Analyst in Engineering

Hospital & Health Care Company, 501-1000 employees

View all 25 answers on this topic

GUI based administrator console

Read full review

Stephane Abitbol

Enterprise Systems Manager Specialist

IntactInsurance, 5001-10,000 employees

View all 4 answers on this topic

Likelihood to Renew

Apache Hive 10.0

Based on 1 answer

Since I do not know the second data warehouse solution that integrate with HDFS as well as Hive.

Read full review

Senior Data Scientist

CARD.comFinancial Services, 11-50 employees

View all 1 answers on this topic

InfluxDB 9.1

Based on 2 answers

InfluxDB is a near perfect product for time series database engines. The relatively small list of cons are heavily outweighed by it's ability to just work and be a very flexible and powerful database engine. The community and support provided by the corporation are the only areas I have little experience.

Read full review

Jonathan Yarbor

CEO & Co-Founder

NodecraftComputer Games, 1-10 employees

View all 2 answers on this topic

Usability

Apache Hive 8.5

Based on 9 answers

Thanks to its high usability Apache Hive enables users to craft extensive queries really efficiently and at the same time to how to hold response times very low. HiveQL simplicity makes it super easy to manage large datasets, what was almost an impossible task before introduction of Apache Hive data warehousing platform in our company.

Read full review

Verified User

Team Lead in Information Technology

Internet Company, 10,001+ employees

View all 9 answers on this topic

No score

No answers yet

No answers on this topic

Support Rating

Apache Hive 7.1

Based on 8 answers

Hive also has a community platform of its own just like other Hadoop frameworks. Most of the queries/problems are resolved in the community itself. We can just post our problems or get in touch with a specific user and get the issue resolved. Otherwise there is always the product support team for any resolution.

Read full review

Partha Protim Pegu

Domain Consultant

InfosysInformation Technology & Services, 10,001+ employees

View all 8 answers on this topic

InfluxDB 9.0

Based on 1 answer

We have worked with the InfluxDB support team a few times so far and it has been positive. Issues submitted are worked on promptly and we have good feedback.

Read full review

Stephane Abitbol

Enterprise Systems Manager Specialist

IntactInsurance, 5001-10,000 employees

View all 1 answers on this topic

Alternatives Considered

Besides Hive, I have used Google BigQuery, which is costly but have very high computation speed.Amazon Redshift is the another product, I used in my recent organisation.Both Redshift and BigQuery are managed solution whereas Hive needs to be managed

Read full review

Senior Manager - Engineering

Hike MessengerInternet, 51-200 employees

View all 25 answers on this topic

To be honest, I didn't look at alternatives since InfluxDB performs very well if you can oversee the lack of security and HA features. But for all challenges, there is an easy solution which brings you forward (e.g. read load balancing can be achieved by using a common HTTPS load balancer).

Read full review

Valentin Höbel

Senior Consultant IT Infrastructure

open *i GmbHInformation Technology and Services, 11-50 employees

View all 4 answers on this topic

Return on Investment

It exposes the distributed calculation world (Hadoop) to the users but doesn't require the user to have the in-depth understanding of boilerplate details, it reduces the time of learning and let the data analyst can focus their efforts on the core business.

Read full review

Verified User

Strategist in Information Technology

Package/Freight Delivery Company, 10,001+ employees

View all 25 answers on this topic

Provided us a time series DB.
With the SQL-like language, it is very easy to learn.
Empowered us to keep track of our events.

Read full review

Verified User

Engineer in Information Technology

Insurance Company, 10,001+ employees

View all 4 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Add comparison