Thanks a lot for this!
It'll really guide me to avoid mistakes here in HIVE.