Apache Hive vs. MariaDB Platform

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Apache Hive
Score 8.2 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
MariaDB Platform
Score 7.6 out of 10
N/A
MariaDB is an open-source relational database made by the original developers of MySQL, supported by the MariaDB Foundation and a community of developers. The community states recent additional capabilities as including clustering with Galera Cluster 4, compatibility with Oracle Database, and Temporal Data Tables, allowing one to query the data as it stood at any point in the past.N/A
Pricing
Apache HiveMariaDB Platform
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Apache HiveMariaDB Platform
Free Trial
NoYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeOptional
Additional Details
More Pricing Information
Community Pulse
Apache HiveMariaDB Platform
Top Pros
Top Cons
Best Alternatives
Apache HiveMariaDB Platform
Small Businesses
Google BigQuery
Google BigQuery
Score 8.6 out of 10
InfluxDB
InfluxDB
Score 8.5 out of 10
Medium-sized Companies
Cloudera Enterprise Data Hub
Cloudera Enterprise Data Hub
Score 9.0 out of 10
SQLite
SQLite
Score 9.1 out of 10
Enterprises
Oracle Exadata
Oracle Exadata
Score 8.1 out of 10
SQLite
SQLite
Score 9.1 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Apache HiveMariaDB Platform
Likelihood to Recommend
8.0
(35 ratings)
7.0
(29 ratings)
Likelihood to Renew
10.0
(1 ratings)
-
(0 ratings)
Usability
8.5
(7 ratings)
6.4
(3 ratings)
Support Rating
7.0
(6 ratings)
8.7
(16 ratings)
User Testimonials
Apache HiveMariaDB Platform
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
MariaDB
  • Applications where the users need [to] execute many short queries.
  • With new storage engines such as Aria, which allows to replace MyISAM with some improvements, and XtraDB, which evolves InnoDB.
  • To fuse the legacy features with the features available in NoSQL databases.
  • Connection management, which allows multiplying the number of concurrent accesses.
  • New clustering engines, such as Galera, which allow interesting possibilities for Cloud adoption.
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
MariaDB
  • Simpler learning curve. MariaDB is a cleaner, simpler system that is (IMO) easier to learn and easier to manage effectively than many other database systems.
  • Lower hardware requirements. After migrating to MariaDB from another database software system, we find that our hardware needs have substantially decreased.
  • MariaDB support is very responsive. It's like they actually care. On the few occasions we've run into technical issues, support has always come through with what we needed. Once it was showing me a relatively new feature the server supported that I wasn't aware of, that, once I was able to properly make use of it helped me resolve a serious production performance issue.
  • Architectural flexibility. As an example, the ready availability of synchronous (Galera) versus asynchronous replication schemes without being locked into one of the other by enormous technical complexity or punitive licensing, allows the customer to find what really works best for their needs.
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
MariaDB
  • Driver Support - Some third party applications use database drivers that cause unexplained slowness with MariaDB. This can be worked around by using the MySQL drivers, but it's not clear what causes the problem in the first place.
  • Support - While online communities are helpful in diagnosing problems, there isn't as much professional documentation/support available for MariaDB as some of the other major database options.
  • Data Visualization - It would be helpful if there were more built in options for analyzing statistics and generating reports.
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
MariaDB
No answers on this topic
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
MariaDB
MariaDB is very usable and stable to be used in production settings as an alternative to MySQL. The shortcomings of SQL are present but well understood in the community, and if the decision were to be made again, I would choose MariaDB over MySQL on future projects.
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
MariaDB
We have launched several inquiries to MariaDB support and they have always responded very quickly and have not been tutoring for the duration of the incident/problem.
Likewise, they want to hold constant meetings with the client to get their opinion as well as how they can help.
I see a very human support and concerned about the customer.
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
MariaDB
MariaDB stacks up the the competition just fine. Due to is ture open source nature we do not have to worry about licencing and spending money on nothing. Moreover, MariaDB does everything that we need to get done. We can run data that is a million rows or many smaller projects on the same environment with little overhead. One of the best features that MariaDB has is the ability of backup or dump data to standard text sql statements. That was one of the reasons why we choose MariaDb because it makes backups or transferring data a snap
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
MariaDB
  • Low CAPEX if you have a team that use open source software day by day
  • Medium OPEX if you have a team that use open source software day by day
  • Perfect to use in academic ambient to support researchers and students
Read full review
ScreenShots