Apologies for some of the coding I attempted here. It seemed to have worked in peaked and then I attempted to correct it in hive so I will have to develop my skills and knowledge to get exactly what I intended :)