What users are saying about
81 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>Score 7.9 out of 100
Based on 81 reviews and ratings
16 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>Score 8.2 out of 100
Based on 16 reviews and ratings
Likelihood to Recommend
Apache Hive
Apache Hive shines for ad-hoc analysis and plugging into BI tools. Its SQL-like syntax allows for ease of use not for only for engineers but also for data analysts. Through our experience, there are probably more desirable tools to use if you are planning on integrating Hive into your processing pipeline.

Verified User
Engineer in Engineering
Computer Software Company, 51-200 employeesKibana
It's well suited to creating dashboards for getting an overview of what is going on with an application.
Software Architect
ScivantageFinancial Services, 51-200 employees
Feature Rating Comparison
BI Standard Reporting
Apache Hive
—
Kibana
10.0
Customizable dashboards
Apache Hive
—
Kibana
10.0
Ad-hoc Reporting
Apache Hive
—
Kibana
10.0
Drill-down analysis
Apache Hive
—
Kibana
10.0
Formatting capabilities
Apache Hive
—
Kibana
10.0
Report sharing and collaboration
Apache Hive
—
Kibana
10.0
Data Discovery and Visualization
Apache Hive
—
Kibana
7.0
Pre-built visualization formats (heatmaps, scatter plots etc.)
Apache Hive
—
Kibana
7.0
Pros
Apache Hive
- 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.
Sr.Technical Manager/Delivery Manager
Nisum Technologies, Inc.Retail, 10,001+ employees
Kibana
- searching
- near real-time
Cloud Native Architect
ElastisysComputer Software, 11-50 employees
Cons
Apache Hive
- 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.

Verified User
Analyst in Engineering
Hospital & Health Care Company, 501-1000 employeesKibana
- Some performance issues with large datasets.
- Linking to dashboards makes extremely long urls.
- Lack of reports.
Software Architect
ScivantageFinancial Services, 51-200 employees
Likelihood to Renew
Apache Hive
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.
Senior Data Scientist
CARD.comFinancial Services, 11-50 employees
Kibana
No score
No answers yet
No answers on this topic
Usability
Apache Hive
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.

Verified User
Team Lead in Information Technology
Internet Company, 10,001+ employeesKibana
No score
No answers yet
No answers on this topic
Support Rating
Apache Hive
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.
Domain Consultant
InfosysInformation Technology & Services, 10,001+ employees
Kibana
Kibana 8.4
Based on 2 answers
We did not use the official Kibana support. Documentation was easy enough to follow.
Cloud Native Architect
ElastisysComputer Software, 11-50 employees
Alternatives Considered
Apache Hive
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
Senior Manager - Engineering
Hike MessengerInternet, 51-200 employees
Kibana
Kibana is free; it was the first and only thing we've tried in this area.
Software Architect
ScivantageFinancial Services, 51-200 employees
Return on Investment
Apache Hive
- 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.

Verified User
Strategist in Information Technology
Package/Freight Delivery Company, 10,001+ employeesKibana
- reduces downtime
- increases developer velocity
Cloud Native Architect
ElastisysComputer Software, 11-50 employees
Pricing Details
Apache Hive
General
Free Trial
—Free/Freemium Version
—Premium Consulting/Integration Services
—Entry-level set up fee?
No
Kibana
General
Free Trial
—Free/Freemium Version
—Premium Consulting/Integration Services
—Entry-level set up fee?
No