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
What is ssh? SSH , or Secure Shell, is a protocol used to securely log onto remote systems. It is the most common way to access remote Linux and Unix-like servers. ssh commands: If your username on the remote system is the same as your username on your local system:                               #ssh remote_host remote_host means ip address or domain name that you are trying to connect to. If your username is different on the remote system, you can specify it by using this syntax:                         #ssh remote_username@remote_host How to Set Up SSH on Linux systems Edit the configuration file of sshd #vim /etc/ssh/sshd_config It may be a good idea to change this to a non-standard port to help obscure your ...
Post a Comment
Read more