Hi, Thank you all for the responses. Works as expected. I do have another question though, more advice than anything. So I can now import data from SQL Server to Hive but if I want to apply business logic to my data how do you think I'm best doing this. Only something simple for now I think. Shall I do it; 1. In the import, so query the data rather than a table in my import and have some logic there. 2. Import it to HIVE as I have done and then do something there. 3. Do something else. Any pointers would be appreciated. Thanks, Nic. ... View more

That did the job for me. Thanks again. ... View more

Thank you both for the responses. Greatly appreciate both. Kuldeep - That worked perfectly Daniel - Very useful to know, I'm sure it will end up being used down the line. ... View more

@Nic Hopper - You are most welcome! Happy Hadooping!! 🙂 ... View more

Thanks again Artem for your response and anyone else who took the time read it. ... View more