Assume that Cloudera VM is installed on your PC and Apache Hive is installed on this VM. We consider a dataset saved on text file named employee.txt and located on: /home/cloudera/hive_exam

The employee.txt file content is:

1. Using Apache Hive, give all the commands to create from the employee.txt data an external table named employee.
2. Display the row where the name is Paul.

Tips: the table columns are name, location, extension, and job