By using Hive, we can perform some peculiar functionalities that can't be achieved by Relational Databases. For huge amounts of data that is in beta bytes, querying it and getting results in seconds is important. In this scenario, the hive will achieve fast querying and produce results in a second time.
Some key differences between hive and relational databases are the following
- Relational databases are of “Schema on READ and Schema on Write”. First creating a table and then inserting the data into the particular table. Insertions, Updates, Modifications can be performed on this relational database table.
- Hive is “Schema on READ only”. Update, modifications won't work on this because the hive query in typical cluster is set to run on multiple Data Nodes. So it is not possible to update and modify data across multiple nodes. Hive provides READ Many WRITE Once.
Hive Working Modes
Hive works in two modes. They are Interactive mode and Non Interactive mode. In Interactive mode, it directly goes to hive mode (Hive Shell) when you type hive in command shell. The non interactive mode is about executing code directly in console file mode. In the both the modes, we can create two types of tables – Internal table and External table.
No comments:
Post a Comment