Apache Hive vs. MongoDB

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.

Incentivized

MongoDB [is] great at storing JSON data grouped into "collections". In this format, you can store any JSON documents and conveniently categorize them by collections. The JSON document contained in MongoDB is called binary JSON or BSON and, like any other document in this format, is unstructured. Therefore, unlike traditional DBMS, any kind of data can be stored in collections, and this flexibility is combined with the horizontal scalability of the database. It should be noted that MongoDB does not have links between documents and “collections” (this is partially compensated by the Database Reference - links in the DBMS, but this does not completely solve the problem). As a result, a situation arises in which there is a certain set of data that is not related to other information in the database, and there is no way to combine data from different documents. In SQL systems, this would be an elementary task.

• 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.

Incentivized

• Easy to learn. When I picked up MongoDB for the first time, I had little background in database management or modeling. If you have a background in javascript (and JSON)... then you can figure out how to use MongoDB pretty fast.
• Fast performance.
• It's relatively easy to set up in certain environments because there are lots of ready-made solutions out there.
• There's a lot of support in the existing ecosystem for it —, especially in the node.js realm.
• Query syntax is pretty simple to grasp and utilize.
• Aggregate functions are powerful.
• Scaling options.
• Documentation is quite good and versioned for each release.

Incentivized

• 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.

Incentivized

• I love the idea of Map-Reduce native support in MongoDB. Admittedly I have not used it as much as I would like -- it always seems to trip me up.
• Recent additions to the aggregation queries have helped reduce (no pun intended) my need to better wield the weapon that is Map-Reduce.

Incentivized

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

MongoDB is one of the most famous non-relational databases in the world, there are famous active projects that use this database. I think that the same company that develops the database gives you the online induction totally free is something that really is very positive. Accounts with a first-class support to be able to relate the correct implementation of the database, in addition to teaching you the best practices to optimize your projects, I believe that with this decision it is more than obvious which is the best decision at the time of seeing with which database to work.

Incentivized

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.

Incentivized

It is one of the reasons why we prefer it to store documents in a JSON-style format, to access the desired document very quickly regardless of its size, to be readable by human eyes, and to be easily scalable and manageable.

Incentivized

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.

Incentivized

I have reached multiple times to the MongoDB community for the help and they have provided each and easy solution for every problem. Over the internet and on stack overflow many people responds over the challenges. Now this tool is very much used in every company and projects so internally many people are there to give a support.

Incentivized

While the setup and configuration of MongoDB is pretty straight forward, having a vendor that performs automatic backups and scales the cluster automatically is very convenient. If you do not have a system administrator or DBA familiar with MongoDB on hand, it's a very good idea to use a 3rd party vendor that specializes in MongoDB hosting. The value is very well worth it over hosting it yourself since the cost is often reasonable among providers.

Incentivized

We have used a simple but necessary function such as merging certain data tables, which although they may be from different areas, complement each other or are necessary, you can use metadata if what you need is to validate the origin of your information and what impact it has, is also feasible.

Incentivized

The environment I work in is somewhat unique in that we use both MySQL and MongoDB. However, each is used for specific purposes that the other is not well suited for. MongoDB is not a relational database like MySQL, so it serves as the perfect place to dump key bits of data for quick retrieval later. This is something we can't easily do with MySQL. On this smaller database, MongoDB also lets us retrieve data more quickly with its fast and efficient querying.

Incentivized

• Good ROI for being able to access data easily across the network, we have large amounts of data and this is a good system to access it
• Good ROI for being easy to learn how to use for new employees, not much time spent which saves costs
• Good ROI for being able to integrate with Spark and other applications, hence data can be analyzed through programs

Incentivized

• We can make more open and flexible systems due to its easy adaptation to new evolutions in web applications.
• In the latest versions it offers support for different transactions and we could carry out real tests related to the concurrency of the application.
• MongoDB allows you to have distributed clusters, which improves the speed of the queries by reducing the latency that exists between the database cluster and the service that executes the query.

Incentivized