Task $2(6$ marks$)$

Querying and manipulating data in HBase table

This assignment focuses on implementing HBase queries and data manipulations for a database schema that models customer involvement in sales transactions.

Instructions

$1.$ Set Up the HBase Table

$-$ Download the task$2.$hb file, which contains HBase shell commands to create the HBase table task$2$ and load initial data into it$.$

$-$ Use the HBase shell to process task$2.$hb and confirm that the table task$2$ is created and populated with data.

$2.$ Implement Queries and Data Manipulations

$-$ Use the HBase shell to write and save the following queries and data manipulations in a new file named solution$2.$hb:

$-$ Query $1$: Retrieve all available information for the product with product number $101,$ listing each version in a separate cell.

$-$ Query $2$: Retrieve all available information about sales of product $101$ made by customer $007,$ listing each version in a separate cell.

$-$ Query $3$: Retrieve the name, location $($address$),$ and age group of all customers, listing each customer in a separate cell.

$-$ Query $4$: Retrieve all information about products under the brand 'Samsung', listing each product in a separate cell.

$-$ Task $1$: Add a new column family named SELLER that will store seller information, including the seller's name, address, and contact person. Insert data for at least two sellers with reasonable values.

$-$ Task $2$: Add information for two sales transactions, each by a different seller, with reasonable values.

$-$ Task $3$: Increase the total number of versions in each cell of the PRODUCT column family to $4.$

$3.$ Run and Capture Output

$-$ After writing solution$2.$hb$,$ use the HBase shell to process it$.$

$-$ Copy the output displayed in the Command window from the processing of solution$2.$hb and paste it into a file named solution$2.$pdf$.$