In this post, I will be sharing how to insert data in HBase table. As we know, HBase is a column-oriented NoSQL database and stores data column wise.
Here I will be explaining How to create data in HBase table. Inserting data in HBase table can be done with the help of below three commands and methods-
• put command,
• add() method of Put class, and
• put() method of HTable class
Using put command you can insert a record into the HBase table easily.
Insert Data in HBase Table Syntax
Here is the HBase Create data syntax. We will be using Put command to insert data into HBase table.
put ‘<table name>’,’row1’,’<columnfamily:colname>’,’<value>’
Considering the example we considered in the HBase Create table example-
No, we need to insert data in HBase table “employee” as per the records are shown in above table.
Put ‘employee’, ‘1’, ‘personaldata:Name’,’John’ –> This will insert the Name field for Row 1 in the employee table under PersonalData column family, “John”.
Similarly, you can insert other records as well like below-
Put ‘employee’, ‘1’, ‘careerdata:salary’, ‘100k’ Put ‘employee’, ‘2’, ‘personaldata: Name’, ‘Chris’ Put ‘employee’, ‘2’, ‘careerdata: Salary’, ‘200k’
With this, now you have all the records shown in above table.
Verify Records in HBase Table
Now as we have inserted the data in HBase table, employee, let’s validate whether the records are same what we expected.
You can use “scan” command to validate the data.
It will list you all the rows and records of the table ‘employee’.
This was all about How to Insert Data in HBase table. Inserting records in HBase table is easy and all you need is to use Put command for the same.
But with the Put command, you would be able to insert a record every time and if ever you need to do a bulk insert, you will find the issue.
In the next blog post, I will be telling you how to bulk insert into HBase table and HBase table Edit & Delete Operation.