George, There is a datediff UDF which will tell you the difference between 2 dates. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions
You can find the number of minutes with simple arithmetic. Keep in mind that this method would not account for lost (or gained) minutes due to day light savings time. If that's important, it will be best to convert precise timestamps to UTC and then subtract them. Mark On Wed, Dec 5, 2012 at 12:33 PM, Babe Ruth <gtevelde-h...@hotmail.com>wrote: > Hello All, > > I would like to find the total amount of minutes between two dates. Not > sure if this is possible in hive. Any help would be great. > > > Thanks, > George >
