Attempt the following HBase related questions: a. Write the correct command to create table Employee' having...

 

 
 

Transcribed Image Text:

Attempt the following HBase related questions: a. Write the correct command to create table Employee' having the below-mentioned structure: Personnel Details Contact Details Official Info Name Name Date of Birth Home Harish b. Is it possible to create the below shown table structure using HBase? Explain briefly. Personnel Details Contact Details Official Info Phone No Date of Birth Home 11-Jan-1982 13-Nov-1990 Phone No 1234 11-Jan-1982 3456 Mobile No Company Address Name Mobile No Company Address Email Name 1234123412 4545454545 XYZ Corp 9898989898 ABC Corp Pune Akshay Consider the following "Employee" table for answering the sub-questions "c" to "g". Mumbai Email h@email.com hr@email.com a@email.com Activ Go to S ROW Personnel Details ID 1 2 3 نا Name Harish Amey Contact Date of Birth Home Phone No 11-Jan-1982 1234 21-Mar-1984 2345 Details Mobile No Official Info Company Address Email Name 1234123412 ABC Corp 4545454545 ABC Corp Akshay 13-Nov-1990 9898989898 Kunal 3-Dec-1987 2334 9098989898 XYZ Corp Pune h@hmail.com Pune a@hmail.com Mumbai a@email.com Mumbai 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 Pune 8776654534 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? XYZ Email xyz@email.com Attempt the following HBase related questions: a. Write the correct command to create table Employee' having the below-mentioned structure: Personnel Details Contact Details Official Info Name Name Date of Birth Home Harish b. Is it possible to create the below shown table structure using HBase? Explain briefly. Personnel Details Contact Details Official Info Phone No Date of Birth Home 11-Jan-1982 13-Nov-1990 Phone No 1234 11-Jan-1982 3456 Mobile No Company Address Name Mobile No Company Address Email Name 1234123412 4545454545 XYZ Corp 9898989898 ABC Corp Pune Akshay Consider the following "Employee" table for answering the sub-questions "c" to "g". Mumbai Email h@email.com hr@email.com a@email.com Activ Go to S ROW Personnel Details ID 1 2 3 نا Name Harish Amey Contact Date of Birth Home Phone No 11-Jan-1982 1234 21-Mar-1984 2345 Details Mobile No Official Info Company Address Email Name 1234123412 ABC Corp 4545454545 ABC Corp Akshay 13-Nov-1990 9898989898 Kunal 3-Dec-1987 2334 9098989898 XYZ Corp Pune h@hmail.com Pune a@hmail.com Mumbai a@email.com Mumbai 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 Pune 8776654534 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? XYZ Email xyz@email.com Attempt the following HBase related questions: a. Write the correct command to create table Employee' having the below-mentioned structure: Personnel Details Contact Details Official Info Name Name Date of Birth Home Harish b. Is it possible to create the below shown table structure using HBase? Explain briefly. Personnel Details Contact Details Official Info Phone No Date of Birth Home 11-Jan-1982 13-Nov-1990 Phone No 1234 11-Jan-1982 3456 Mobile No Company Address Name Mobile No Company Address Email Name 1234123412 4545454545 XYZ Corp 9898989898 ABC Corp Pune Akshay Consider the following "Employee" table for answering the sub-questions "c" to "g". Mumbai Email h@email.com hr@email.com a@email.com Activ Go to S ROW Personnel Details ID 1 2 3 نا Name Harish Amey Contact Date of Birth Home Phone No 11-Jan-1982 1234 21-Mar-1984 2345 Details Mobile No Official Info Company Address Email Name 1234123412 ABC Corp 4545454545 ABC Corp Akshay 13-Nov-1990 9898989898 Kunal 3-Dec-1987 2334 9098989898 XYZ Corp Pune h@hmail.com Pune a@hmail.com Mumbai a@email.com Mumbai 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 Pune 8776654534 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? XYZ Email xyz@email.com Attempt the following HBase related questions: a. Write the correct command to create table Employee' having the below-mentioned structure: Personnel Details Contact Details Official Info Name Name Date of Birth Home Harish b. Is it possible to create the below shown table structure using HBase? Explain briefly. Personnel Details Contact Details Official Info Phone No Date of Birth Home 11-Jan-1982 13-Nov-1990 Phone No 1234 11-Jan-1982 3456 Mobile No Company Address Name Mobile No Company Address Email Name 1234123412 4545454545 XYZ Corp 9898989898 ABC Corp Pune Akshay Consider the following "Employee" table for answering the sub-questions "c" to "g". Mumbai Email h@email.com hr@email.com a@email.com Activ Go to S ROW Personnel Details ID 1 2 3 نا Name Harish Amey Contact Date of Birth Home Phone No 11-Jan-1982 1234 21-Mar-1984 2345 Details Mobile No Official Info Company Address Email Name 1234123412 ABC Corp 4545454545 ABC Corp Akshay 13-Nov-1990 9898989898 Kunal 3-Dec-1987 2334 9098989898 XYZ Corp Pune h@hmail.com Pune a@hmail.com Mumbai a@email.com Mumbai 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 Pune 8776654534 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? XYZ Email xyz@email.com Attempt the following HBase related questions: a. Write the correct command to create table Employee' having the below-mentioned structure: Personnel Details Contact Details Official Info Name Name Date of Birth Home Harish b. Is it possible to create the below shown table structure using HBase? Explain briefly. Personnel Details Contact Details Official Info Phone No Date of Birth Home 11-Jan-1982 13-Nov-1990 Phone No 1234 11-Jan-1982 3456 Mobile No Company Address Name Mobile No Company Address Email Name 1234123412 4545454545 XYZ Corp 9898989898 ABC Corp Pune Akshay Consider the following "Employee" table for answering the sub-questions "c" to "g". Mumbai Email h@email.com hr@email.com a@email.com Activ Go to S ROW Personnel Details ID 1 2 3 نا Name Harish Amey Contact Date of Birth Home Phone No 11-Jan-1982 1234 21-Mar-1984 2345 Details Mobile No Official Info Company Address Email Name 1234123412 ABC Corp 4545454545 ABC Corp Akshay 13-Nov-1990 9898989898 Kunal 3-Dec-1987 2334 9098989898 XYZ Corp Pune h@hmail.com Pune a@hmail.com Mumbai a@email.com Mumbai 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 Pune 8776654534 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? XYZ Email xyz@email.com Attempt the following HBase related questions: a. Write the correct command to create table Employee' having the below-mentioned structure: Personnel Details Contact Details Official Info Name Name Date of Birth Home Harish b. Is it possible to create the below shown table structure using HBase? Explain briefly. Personnel Details Contact Details Official Info Phone No Date of Birth Home 11-Jan-1982 13-Nov-1990 Phone No 1234 11-Jan-1982 3456 Mobile No Company Address Name Mobile No Company Address Email Name 1234123412 4545454545 XYZ Corp 9898989898 ABC Corp Pune Akshay Consider the following "Employee" table for answering the sub-questions "c" to "g". Mumbai Email h@email.com hr@email.com a@email.com Activ Go to S ROW Personnel Details ID 1 2 3 نا Name Harish Amey Contact Date of Birth Home Phone No 11-Jan-1982 1234 21-Mar-1984 2345 Details Mobile No Official Info Company Address Email Name 1234123412 ABC Corp 4545454545 ABC Corp Akshay 13-Nov-1990 9898989898 Kunal 3-Dec-1987 2334 9098989898 XYZ Corp Pune h@hmail.com Pune a@hmail.com Mumbai a@email.com Mumbai 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 Pune 8776654534 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? XYZ Email xyz@email.com

Answer rating: 100% (QA)

ANSWER HBASE Database a WRITE CORRECT COMMAND TO CREATE TABLE EMPLOYEE HAVING THE BELOW MENTIONED ST... View the full answer