Hive queries & datasets cleaning

You should be doing the dataset cleaning using hive queries and analyzing the data and providing the formal report.