Hi Jon. I'm currently trying to learn as much as possible about Hive in order to become more productive.
In the process I discovered this info which confirmed exactly what you explained to me in answer to my question.
I just thought I'll share it here and maybe someone else might also benefit from it...
I found it here.
Thanks again for your help and I hope this might help someone else too.