Apache Hive vs. Splunk Enterprise

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Apache Hive
Score 8.0 out of 10
N/A
Apache Hive is database/data warehouse software that supports data querying and analysis of large datasets stored in the Hadoop distributed file system (HDFS) and other compatible systems, and is distributed under an open source license.N/A
Splunk Enterprise
Score 8.4 out of 10
N/A
Splunk is software for searching, monitoring, and analyzing machine-generated big data, via a web-style interface. It captures, indexes and correlates real-time data in a searchable repository from which it can generate graphs, reports, alerts, dashboards and visualizations.N/A
Pricing
Apache HiveSplunk Enterprise
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Apache HiveSplunk Enterprise
Free Trial
NoYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Apache HiveSplunk Enterprise
Features
Apache HiveSplunk Enterprise
Security Information and Event Management (SIEM)
Comparison of Security Information and Event Management (SIEM) features of Product A and Product B
Apache Hive
-
Ratings
Splunk Enterprise
8.1
84 Ratings
3% above category average
Centralized event and log data collection00 Ratings9.080 Ratings
Correlation00 Ratings8.182 Ratings
Event and log normalization/management00 Ratings8.881 Ratings
Deployment flexibility00 Ratings8.174 Ratings
Integration with Identity and Access Management Tools00 Ratings8.075 Ratings
Custom dashboards and workspaces00 Ratings8.281 Ratings
Host and network-based intrusion detection00 Ratings7.760 Ratings
Data integration/API management00 Ratings7.728 Ratings
Behavioral analytics and baselining00 Ratings7.626 Ratings
Rules-based and algorithmic detection thresholds00 Ratings8.027 Ratings
Response orchestration and automation00 Ratings7.623 Ratings
Reporting and compliance management00 Ratings8.228 Ratings
Incident indexing/searching00 Ratings8.331 Ratings
Best Alternatives
Apache HiveSplunk Enterprise
Small Businesses
Google BigQuery
Google BigQuery
Score 8.8 out of 10
LevelBlue USM Anywhere
LevelBlue USM Anywhere
Score 7.5 out of 10
Medium-sized Companies
Cloudera Enterprise Data Hub
Cloudera Enterprise Data Hub
Score 9.0 out of 10
Sumo Logic
Sumo Logic
Score 8.8 out of 10
Enterprises
Oracle Exadata
Oracle Exadata
Score 9.8 out of 10
Sumo Logic
Sumo Logic
Score 8.8 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Apache HiveSplunk Enterprise
Likelihood to Recommend
8.0
(35 ratings)
8.2
(86 ratings)
Likelihood to Renew
10.0
(1 ratings)
7.0
(18 ratings)
Usability
8.5
(7 ratings)
7.9
(19 ratings)
Availability
-
(0 ratings)
10.0
(1 ratings)
Support Rating
7.0
(6 ratings)
8.0
(18 ratings)
Online Training
-
(0 ratings)
8.0
(1 ratings)
Implementation Rating
-
(0 ratings)
7.0
(3 ratings)
Product Scalability
-
(0 ratings)
9.1
(1 ratings)
User Testimonials
Apache HiveSplunk Enterprise
Likelihood to Recommend
Apache
Software work execution is on a large scale, it is good to use for new projects or organizational changes, data lineage mapping has always been dubious but this one has had good results. You can store and synchronize data from different departments, the storage process can be manual but it is best automated.
Read full review
Cisco
It's well suited for what I do, which is network security operations. And that's for anything from troubleshooting incidents, troubleshooting performance, troubleshooting for the purpose of a compliance and auditing. It's not best suited for users who are new in terms of they're new to the product and they have expectations that probably Splunk cannot meet.
Read full review
Pros
Apache
  • Apache Hive allows use to write expressive solutions to complex problems thanks to its SQL-like syntax.
  • Relatively easy to set up and start using.
  • Very little ramp-up to start using the actual product, documentation is very thorough, there is an active community, and the code base is constantly being improved.
Read full review
Cisco
  • It is very useful in creating custom rules for analyzing system logs and display relevant information. The query language is very easy to learn.
  • We can create custom UI to visualize the output of our data. The interface is very flexible. It also allows the sharing of rules among users.
  • There is an open online community to help others. Stackoverflow also has a splunk community. These resources make it more convenient to learn.
Read full review
Cons
Apache
  • Some queries, particularly complex joins, are still quite slow and can take hours
  • Previous jobs and queries are not stored sometimes
  • Switching to Impala can sometimes be time-consuming (i.e. the system hangs, or is slow to respond).
  • Sometimes, directories and tables don't load properly which causes confusion
Read full review
Cisco
  • Splunk light limits number of users to 5. Wish there was a flexible license, where one could add more users.
  • Splunk light does not let you add > few realtime alerts. Wish there was a flexible license, where one could add as many realtime alerts as wanted.
  • Better insight into daily ingestion values
Read full review
Likelihood to Renew
Apache
Since I do not know the second data warehouse solution that integrate with HDFS as well as Hive.
Read full review
Cisco
We are using Splunk extensively in our projects and we have recently upgraded to Splunk version 6.0 which is quite efficient and giving expected results. We keep track of updates and new features Splunk introduces periodically and try to introduce those features in our day to day activities for improvement in our reporting system and other tasks.
Read full review
Usability
Apache
Hive is a very good big data analysis and ad-hoc query platform, which supports scaling also. The BI processes can be easily integrated with Hadoop via the Hive. It can deal with a much larger data set that traditional RDBMS can not. It is a "must-have" component of the big data domain.
Read full review
Cisco
You can literally throw in a single word into Splunk and it will pull back all instances of that word across all of your logs for the time span you select (provided you have permission to see that data). We have several users who have taken a few of the free courses from Splunk that are able to pull data out of it everyday with little help at all.
Read full review
Reliability and Availability
Apache
No answers on this topic
Cisco
When properly setup and configured, Splunk is extremely reliable.
Read full review
Support Rating
Apache
Apache Hive is a FOSS project and its open source. We need not definitely comment on anything about the support of open source and its developer community. But, it has got tremendous developer support, awesome documentation. I would justify the fact that much support can be gathered from the community backup.
Read full review
Cisco
Splunk maintains a well resourced support system that has been consistent since we purchased the product. They help out in a timely manner and provide expert level information as needed. We typically open cases online and communicate when possible via e-mail and are able to resolve most issues with that method.
Read full review
Online Training
Apache
No answers on this topic
Cisco
The online course was simple clear and described the main capabilities of the solution. There is also an initial module that can be done for free so anyone can familiarize themselves with the functionality of this solution. On the other hand, however, there could be more free online courses. Maybe even with a certificate, this would broaden the group of people who are familiar with the platform while increasing familiarity with the solution itself.
Read full review
Implementation Rating
Apache
No answers on this topic
Cisco
Smooth without too many major issues.
Read full review
Alternatives Considered
Apache
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
Cisco
I didn't get to fully evaluate Logstash as our corporation was already using Logstash, but both seemed like viable solutions to the problem that we were having. I wanted to evaluate Logstash some more, both did seem like they would work for the business needs that we had, we went with splunk as many teams were already using it.
Read full review
Scalability
Apache
No answers on this topic
Cisco
Splunk can scale in to the petabyte per day range which of course is awesome
Read full review
Return on Investment
Apache
  • Apache hive is secured and scalable solution that helps in increasing the overall organization productivity.
  • Apache hive can handle and process large amount of data in a sufficient time manner.
  • It simplifies writing SQL queries, hence helping the organization as most companies use SQL for all query jobs.
Read full review
Cisco
  • I don't have any numbers to share but Splunk has positively served as a 24/7 monitoring tool that has saved hours of work by self-detecting, saving statistics and alerting problems in the system or from external interfaces as soon as they happen.
  • Splunk dashboards does a solid job in collecting, analyzing data and creating reports that contain an entire day's activity and then automatically sent out to the business.
  • Splunk is very easy to learn and very useful to any program or business application.
Read full review
ScreenShots