CCA159 : Task Scenario-35

Problem Scenario 35 :  You have been given data as below.

ID,URL,DATE,PUBID,ADVERTISERID

1,http://hadoopexam.com/path1/p.php?keyword=hadoop&country=india#Ref1,30/JUN/2016,PUBHADOOPEXAM,GOOGLEADSENSE

2,http://QuickTechie.com/path1/p.php?keyword=hive&country=us#Ref1,30/JUN/2016,PUBQUICKTECHIE,GOOGLEADSENSE

3,http://training4exam.com/path1/p.php?keyword=spark&country=india#Ref1,30/JUN/2016,PUBTRAINING4EXAM,GOOGLEADSENSE

4,http://hadoopexam.com/path1/p.php?keyword=pig&country=us#Ref1,30/JUN/2016,PUBHADOOPEXAM,GOOGLEADSENSE

5,http://QuickTechie.com/path1/p.php?keyword=datascience&country=india#Ref1,30/JUN/2016,PUBQUICKTECHIE,GOOGLEADSENSE

6,http://training4exam.com/path1/p.php?keyword=java&country=us#Ref1,30/JUN/2016,PUBTRAINING4EXAM,GOOGLEADSENSE

7,http://hadoopexam.com/path1/p.php?keyword=jee&country=india#Ref1,01/JUL/2016,PUBHADOOPEXAM,GOOGLEADSENSE

8,http://QuickTechie.com/path1/p.php?keyword=apache&country=us#Ref1,01/JUL/2016,PUBQUICKTECHIE,GOOGLEADSENSE

9,http://training4exam.com/path1/p.php?keyword=hadoopexam&country=india#Ref1,01/JUL/2016,PUBTRAINING4EXAM,GOOGLEADSENSE

10,http://hadoopexam.com/path1/p.php?keyword=hadooptraining&country=us#Ref1,01/JUL/2016,PUBHADOOPEXAM,GOOGLEADSENSE

11,http://QuickTechie.com/path1/p.php?keyword=de575&country=india#Ref1,01/JUL/2016,PUBQUICKTECHIE,GOOGLEADSENSE

12,http://training4exam.com/path1/p.php?keyword=cca175&country=us#Ref1,01/JUL/2016,PUBTRAINING4EXAM,GOOGLEADSENSE

Accomplish following activities.

- Load this data in HDFS

- Define Hive Managed table which partitioned by Advertised Host and Advertised Country

- Table must containg following columns

ID,DATE,PUBID,ADVERTISERID,KEYWORD