HBase Vs RDBMS

Both HBase and RDBMS, both are column-oriented database management systems. HBase is a column-oriented dbms and it works on top of Hadoop Distributed File System (HDFS). RDBMS uses tables to represent data and their relationships. 

H Base Vs RDBMS

[Read these latest Hadoop Interview Questions that help you grab high-paying jobs!]

Basis CRUD Operations in H Base

• If you want any CRUD Operations in H Base, H Base should be up and running otherwise the operations will not be successful.

• Running the child instance, but not running the master instance is not the same as the running master instance as creating the child instance.

• The initial sets of basic operations are often referred to as CRUD which stands for Create, Read, Update and Delete.

• These are provided by the HTable class.

• Whenever we are creating a table name in  H Base, we must follow the below steps:

• For creating a table, the syntax is

H Base (main):002:0>create ‘table name’, ’column family Name’

Ex:-H Base (main):002:0>create ‘Hadoop Table’, ’column1’,     ’column2’

 [Do Wish to learn more about Hadoop? Check out our comprehensive Hadoop Tutorial]

We can’t delete column family names.

To insert data, the commands are

hbase (main):002:0> put ‘Hadoop Table’, ’row1’, ’ Hadoop: HDRS’, ‘For storage’
h base (main):002:0> put ‘Hadoop Table’, ’row2’, ’ Hadoop: Map Reduce’, For Processing’
h base (main):002:0> put ‘Hadoop Table’, ’row3’, ’ Hadoop: Hive’,’ For Warehouse’
h base (main):002:0> put ‘Hadoop Table’, ’row4’, ’ Hadoop: H Base’,’ For Reads and write’

hbase (main):002:0> scan ‘Hadoop Table’, (like select stmt)

we can see the records of the table.

• To get the particular row, cmd is

Hbase(main):002:0> get ‘Hadoop Table’, ‘row2’

•  To insert multiple columns at a time, cmd is

h base (main):002:0> put ‘Hadoop Table’, ‘row4’ Hadoop: pig, hue, zookeeper’ ‘different components of hadoop’

• To delete the row, cmd is

hbase(main):002:0> Delete ‘Hadoop Table’, ‘row4’‘Hadoop:Hive’

We can delete the complete row, but cannot delete the individual value of the row.

• To insert the new row with the same row key i.e with no overriding concept and it will append, for Example as below

Hbase(main):002:0> put ‘Hadoop Table’, ‘row2’‘Hadoop:New map reduce’ ‘New one’

hbase(main):002:0> count ‘Hadoop Table’

H base(main):002:0> Exist ‘Hadoop Table’

List of Other Big Data Courses: