Hive queries completed by Babu and commited by Nagarjuna