Excellent explanation of what is happening in HIVE, thank you for your contribution to the community.
!COFFEE