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.
 

problem7_Screen_Stream.avi

Content