RE: Determining DateDiff By Minutes in Hive

2012-12-05 Thread Babe Ruth
this seems to be only for day, I was wondering how to determine if a record is within 15 minutes of a previous record Date: Wed, 5 Dec 2012 12:53:27 -0800 Subject: Re: Determining DateDiff By Minutes in Hive From: grover.markgro...@gmail.com To: user@hive.apache.org George,There is a

Re: Determining DateDiff By Minutes in Hive

2012-12-05 Thread Mark Grover
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 los

Determining DateDiff By Minutes in Hive

2012-12-05 Thread Babe Ruth
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