Scenario-7

Have you subscribed for update ? Please subscribe here

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.