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.