Thanks for your very useful post even for those not using HiveSQL. Simple, clear and accurate ;) I'm glad you did it!