CRUD operations in HBase in Hadoop - Mini Project: Build & Apply

CRUD operations in HBase

📖 Scenario: You work at a company that stores customer information in HBase, a big data database. You need to practice how to create, read, update, and delete data in HBase tables.

🎯 Goal: Build a simple HBase workflow to create a table, add data, read data, update data, and delete data using HBase shell commands.

📋 What You'll Learn

Use HBase shell commands to create a table

Insert data into the table

Read data from the table

Update existing data in the table

Delete data from the table

💡 Why This Matters

🌍 Real World

HBase is used in big data systems to store large amounts of data in a fast, scalable way. Knowing CRUD operations helps manage this data efficiently.

💼 Career

Many data engineer and big data analyst roles require working with HBase or similar NoSQL databases to store and retrieve data.

1

Create HBase table

In HBase shell, create a table called customers with one column family named info. Use the command create 'customers', 'info'.

Hadoop

# Type the HBase shell command to create the table
# Your code here

Need a hint?

Use the create command with the table name and column family in single quotes.

2

Insert data into the table

Insert a row with row key row1 into the customers table. Add a column info:name with value John Doe using the command put 'customers', 'row1', 'info:name', 'John Doe'.

Hadoop

create 'customers', 'info'
# Type the HBase shell command to insert data
# Your code here

Need a hint?

Use the put command with table name, row key, column, and value.

3

Read data from the table

Read the data for row key row1 from the customers table using the command get 'customers', 'row1'.

Hadoop

create 'customers', 'info'
put 'customers', 'row1', 'info:name', 'John Doe'
# Type the HBase shell command to read data
# Your code here

Need a hint?

Use the get command with table name and row key to read data.

4

Update and delete data

Update the info:name column for row row1 to Jane Smith using put 'customers', 'row1', 'info:name', 'Jane Smith'. Then delete the row row1 using deleteall 'customers', 'row1'.

Hadoop

create 'customers', 'info'
put 'customers', 'row1', 'info:name', 'John Doe'
get 'customers', 'row1'
# Type the HBase shell commands to update and delete data
# Your code here

Need a hint?

Use put to update and deleteall to delete the entire row.