Getting started with HBase browser on Cloudera

Standard

Step 1: Click on Hue in the welcome screen. This will take you to the Hadoop UI of the cloudera.

1.jpg

Step 2: To load the sample data into HBase data store click on “Step 2: Examples” tab.

1

Step 3: Click on “HBase Browser” below. On clicking this will start initializing the few example tables to HBase database. Wait until the initialization part is done.

1.jpg

Step 4: Click on Data Browser tab, under that Hbase , now you will land up in HBase Browser Home location.

1.jpg

  • You can see few sample data have been initialized on HBase database.

1.jpg

Step 5: Now let’s construct the below database of a company’s employees

1.jpg

  1.  Click on the New Table button on the right top corner to add new table to the HBase database.1
  2. Fill in the table details like Table name as Employee and we have to column family names: Personal data and professional data. Click on “add an additional column family” to add more column family names. Once done Click submit.1.jpg
  3. Employee table is created now.1.jpg
  4. To add rows and data to the employee table click on the Employee link.
  5.  To add a new row click on to the ” New Row” button on the lower right corner of the screen.1.jpg
  6. Fill in the details of new row as shown in the image below. To add more fileds click on “Add Field” button. Once filling all the required details click “Submit” button to insert the row.1.jpg
  7. You can see the row has been inserted.1
  8. Likewise we can add few more columns and final table will be like this.1
  9. Now to search or write a query you can type it in the Search box as shown below. To search for employee 1 details type in “emp1” and hit enter or click search icon.1.jpg
  10. To get employee 1 Personal details the query will be ” emp1[Personal Data: ]
  11. To get employee 1 Personal and Professiona details the query will be  “emp1[Personal Data: , Professional Data: ]
  12. To get employee1 name, the query will be “emp1[Personal Data: Name ].

 

Hope you enjoyed learning your first HBase lesson.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s