Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
  b=1ka6ggmrg1j6D4IXkZ38SKawgVnEdJkQoUhR8c6mpbjJuG/qmLvbJAnTTVjN7RT4eQkFG6ZlJbC+UHDU6DB1t1TJ4Od+glVUyy8tAJ6TxDZps89IfAcBTQ4tKJBrTqU/rEEU7IrH8uh2G6kNSunzY5osR7+UwAovEauV+ZuyhRI=;
Message-ID: <192860.25960.qm@web121212.mail.ne1.yahoo.com>
Date: Thu, 24 Feb 2011 06:27:10 -0800 (PST)
From: Bejoy Ks <bejoy_ks@yahoo.com>
Subject: Re: How to add hours/minutes to a timestamp column in Hive Query
To: user@hive.apache.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1617214269-1298557630=:25960"

--0-1617214269-1298557630=:25960
Content-Type: text/plain; charset=us-ascii

Hi Experts
      Could some one please help me out with this? Any similar situations faced 
by any one in your real time hive queries?
If I have to go ahead with an User Defined Function for this, then how could I 
implement and use the same in Hive?
Does Hive have any plans/JIRAs in progress with this functionality 
implementation.

Thank You

Regards
Bejoy K S


________________________________
From: Bejoy Ks <bejoy_ks@yahoo.com>
To: user@hive.apache.org
Sent: Wed, February 23, 2011 5:19:10 PM
Subject: How to add hours/minutes to a timestamp column in Hive Query


Hi 
    Is there any function in hive with which we can add hours/minutes to a given 
stamp. 

Say I have a timestamp oriented column 'Arrival_Time', to do some database 
oriented calculations i have to add 4 hours to the 'Arrival_Time' in my Hive 
Query. How do I accomplish this? I have see in hive documentation that we can 
use the date_add(string startdate, int days) method to add days to a date. Any 
similar methods for time stamps to add hours?

Regards
Bejoy KS


--0-1617214269-1298557630=:25960
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Hi Experts<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Could some one please help me out with this? Any similar situations faced by any one in your real time hive queries?<br>If I have to go ahead with an User Defined Function for this, then how could I implement and use the same in Hive?<br>Does Hive have any plans/JIRAs in progress with this functionality implementation.<br><br>Thank You<br><br>Regards<br>Bejoy K S<br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Bejoy Ks &lt;bejoy_ks@yahoo.com&gt;<br><b><span style="font-weight: bold;">To:</span></b> user@hive.apache.org<br><b><span
 style="font-weight: bold;">Sent:</span></b> Wed, February 23, 2011 5:19:10 PM<br><b><span style="font-weight: bold;">Subject:</span></b> How to add hours/minutes to a timestamp column in Hive Query<br></font><br>
<meta http-equiv="x-dns-prefetch-control" content="off"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">Hi <br>&nbsp;&nbsp;&nbsp; Is there any function in hive with which we can add hours/minutes to a given stamp. <br>Say I have a timestamp oriented column 'Arrival_Time', to do some database oriented calculations i have to add 4 hours to the 'Arrival_Time' in my Hive Query. How do I accomplish this? I have see in hive documentation that we can use the date_add(string startdate, int days) method to add days to a date. Any similar methods for time stamps to add hours?<br><br>Regards<br>Bejoy KS<br>
</div><br>

      <meta http-equiv="x-dns-prefetch-control" content="on"></div></div>
</div><br>

      </body></html>
--0-1617214269-1298557630=:25960--