Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id AC8ACE5CC for ; Wed, 5 Dec 2012 21:37:38 +0000 (UTC) Received: (qmail 61812 invoked by uid 500); 5 Dec 2012 21:37:37 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 61742 invoked by uid 500); 5 Dec 2012 21:37:37 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 61729 invoked by uid 99); 5 Dec 2012 21:37:37 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Dec 2012 21:37:37 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of gtevelde-hive@hotmail.com designates 65.54.190.141 as permitted sender) Received: from [65.54.190.141] (HELO bay0-omc3-s3.bay0.hotmail.com) (65.54.190.141) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Dec 2012 21:37:28 +0000 Received: from BAY154-W30 ([65.54.190.189]) by bay0-omc3-s3.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Wed, 5 Dec 2012 13:37:08 -0800 X-Originating-IP: [108.13.230.170] X-EIP: [xul1E4tGExvEa7tButPlhDr2I9VI5JrJ] X-Originating-Email: [gtevelde-hive@hotmail.com] Message-ID: Content-Type: multipart/alternative; boundary="_459f9565-3fde-4422-9fbc-86583c5140ca_" From: Babe Ruth To: Subject: RE: Determining DateDiff By Minutes in Hive Date: Wed, 5 Dec 2012 13:37:07 -0800 Importance: Normal In-Reply-To: References: , MIME-Version: 1.0 X-OriginalArrivalTime: 05 Dec 2012 21:37:08.0106 (UTC) FILETIME=[AD2F46A0:01CDD330] X-Virus-Checked: Checked by ClamAV on apache.org --_459f9565-3fde-4422-9fbc-86583c5140ca_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable this seems to be only for day=2C I was wondering how to determine if a rec= ord is within 15 minutes of a previous record=20 Date: Wed=2C 5 Dec 2012 12:53:27 -0800 Subject: Re: Determining DateDiff By Minutes in Hive From: grover.markgrover@gmail.com To: user@hive.apache.org George=2CThere is a datediff UDF which will tell you the difference between= 2 dates.https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UD= F#LanguageManualUDF-DateFunctions You can find the number of minutes with simple arithmetic. Keep in mind tha= t this method would not account for lost (or gained) minutes due to day lig= ht savings time. If that's important=2C it will be best to convert precise = timestamps to UTC and then subtract them. Mark On Wed=2C Dec 5=2C 2012 at 12:33 PM=2C Babe Ruth wrote: Hello All=2C I would like to find the total amount of minutes between two dates. Not su= re if this is possible in hive. Any help would be great. Thanks=2C George =20 = --_459f9565-3fde-4422-9fbc-86583c5140ca_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
this seems to be only for day=2C  =3BI was wondering how to determine i= f a record is within 15 minutes of a previous record =3B

Date: Wed=2C 5 = Dec 2012 12:53:27 -0800
Subject: Re: Determining DateDiff By Minutes in = Hive
From: grover.markgrover@gmail.com
To: user@hive.apache.org
George=2C
There is a datediff UDF which will tell you the difference = between 2 dates.

You can find the number of minutes with simple arithmet= ic. Keep in mind that this method would not account for lost (or gained) mi= nutes due to day light savings time. If that's important=2C it will be best= to convert precise timestamps to UTC and then subtract them.

Mark

On Wed=2C D= ec 5=2C 2012 at 12:33 PM=2C Babe Ruth <=3Bgtevelde-hive@hotmail.com>=3B = wrote:
Hello All=2C

I would like to find the total amount of mi= nutes between two dates.  =3BNot sure if this is possible in hive. &nbs= p=3BAny help would be great.


Thanks= =2C
George

= --_459f9565-3fde-4422-9fbc-86583c5140ca_--