Problem Scenerio 7 : You have been given following data format file. Each datapoint is separated by '|'.
Name|Sex|Age|Father_Name
Example Record
Anupam|Male|45|Daulat
Create an Hive table named "Family_Head" with following details.
- Table must be created in existing database named "Family"
- You must take care that if table is already exist it should not be created again.
- Table must be created inside Hive warehouse directory and should not be an external table.
- You must take care that if table is already exist it should not be created again.
- Table must be created inside Hive warehouse directory and should not be an external table.
