Introduction of Hive queries

Hive query to recreate functionality seen in the PIG and R scripts