Thanks for the explanation on why CONVERT is better in the long run @simplifylife. I was hesitant to use this feature because didn't understand it. I will use it next time to convert to Hive.
Appreciate you taking the time to put this tutorial together.
You’re welcome! Yes it is kinda confusing as no one talks about it. At the beginning I was quite hesitant to use it myself.