Subject - Computer Science (Big Data Engineering)

Note: Assignment last date 30-Jan. Early response appreciated. Will upvote all answer.

Attempt the following HBase related questions: [2+2 +1 +1 +2 +1 +1 = 10) a. Write the correct command to create table 'Employee' having the below-mentioned structure: Personnel Details Contact Details Official Info Name Date_of_Birth Home Mobile No Company Address Email Phone No Name b. Is it possible to create the below shown table structure using HBase? Explain briefly. Personnel Details Contact Details Official Info Name Mobile No Address Email Date_of_Birth Home Phone No Company Name Harish 11-Jan-1982 1234 1234123412 ABC Corp Pune 11-Jan-1982 3456 4545454545 XYZ Corp h@email.com hr@email.com a@email.com Akshay 13-Nov-1990 9898989898 Mumbai Consider the following Employee table for answering the sub-questions "c" to g. ROW ID Personnel Details Contact Details Official Info Name Mobile No Email Date_of_Birth Home Phone No Company Address Name 1 Harish 11-Jan-1982 1234 Pune h@hmail.com 1234123412 ABC Corp 2 Amey 21-Mar-1984 2345 Pune 4545454545 ABC Corp a@hmail.com 3 Akshay 13-Nov-1990 9898989898 Mumbai a@email.com Kunal 3-Dec-1987 2334 Mumbai 9098989898 XYZ Corp k@email.com c. What would be the command to retrieve Mobile No for RowID 2? d. Write the command to retrieve the "official info for employee with ROWID 3? e. Write a command to insert the following record into the Employee table. Name Mobile No Address Email XYZ 8776654534 Pune xyz@email.com f. What is the correct command to delete only Address for employee 'Akshay'? g. What is the command that needs to be used before dropping the table Employee