Question: how to calculate months between two dates in hive?
Answer: Covert date(s) to unix time stamps.
substract higher time stamp from lower.
result is time duration between two dates.
divide result by (60 sec * 60 min * 24 hrs * 30 days) to get month.