Skip to main content

What is the difference between Hive and MongoDb

Hive:
Hive is an external tool which works only with Hadoop framework.
Hive is open source software by Apache software foundation.
Earlier it was the Facebook who developed this Query based dataware housing on top of HDFS( Hadoop Distributed  File System )
Hive is not an NoSql database like MongoDB
Hive used for data processing used only in Hadoop.
Hive can load the data from external file.
Hive has partitioning and bucketing technique to divide the data on the basis of particular keyword
The partitioning will help to lead data faster

*****************************************************************************************
MongoDB:
MongoDB is also an open source software but not maintained by Apache
It is managed by MongoDB Unversity
Certification for this was free but now we need to pay for MongoDB certification
MongoDb has its own server to manage the MongoDB database
MongoDB is an NoSQL database
MongoDB stores its data in file whereas Hive stores its data in Derby(bidefault) database
There is no constraint to follow like RDBMS
Data can be stored in BSON format( Binary JSON )
MongoDB can be used independently whereas Hive cannot

Comments

Post a Comment

Popular posts from this blog

Problem: Date Formatting cannot be Changed in Microsoft Excel

In this article, we will learn how to change the date formatting. We will use “Text to Column” wizard to resolve the problem of change the date formatting in Microsoft Excel. Let’s understand the functions: - Text to Column:  “Text to Column” is used for separating the cell content which is depending on the way your data is arranged. You can divide the data on the basis of content in the cell such as space, comma, period, semicolon, etc. Let’s take an example and understand how we can convert the date into Text. We have dates, foramatted as text in column A. Now, we want to convert it into date format.     If we want to convert the formatting into numbers, then we need to follow below given steps:- Select the range A2:A11. Go to Data tab, and click on Text to Columns from the Data tools group.     Covert Text to Columns Wizard – Step1 of 3 dialog box will appear. Select fixed width, and click on Next button.     Skip step-2, and...
Post a Comment
Read more
How To Remove Gphone Virus Well gphone.exe is nowadays one of the most dangerous virus spreading very rapidly. It is a Trojan and changes your IE homepage and sends tries to open gtalk and yahoo messenger. It even sends messages to gtalk contacts. Its icon is just like that of folder icon and people thinking of folder click on it get infected by the virus. Gphone virus basically is a 260 kb .exe file which looks like a folder and it can take any name of any other folder if you have clicked on the virus folder which looks like a folder but it is not. If you have a folder name ―movies‖ in your D drive it will make a exe file in the folder named movies.exe and if you click on that exe file it too work as a virus. It makes .exe files in all the folders you have with the name of the folder. How to remove this virus Method 1 1. Go to Task Manager then Processes and then click on gphone.exe and click on end process. 2. Manually go to folder where gphone.exe is present and delete it. 3...
Post a Comment
Read more