hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Grover <>
Subject Re: Get current date in hive
Date Thu, 26 Apr 2012 00:54:26 GMT
Hi Saurabh,
You might want to consider populating the right hand side of this expression 
local_dt >= date_sub(to_date(unix_timestamp()), 3) 

in the Hive client code that is issuing the Hive query.


Mark Grover, Business Intelligence Analyst
OANDA Corporation 

www: www: 

"Best Trading Platform" - World Finance's Forex Awards 2009. 
"The One to Watch" - Treasury Today's Adam Smith Awards 2009. 

----- Original Message -----
From: "Saurabh S" <>
Sent: Wednesday, April 25, 2012 8:48:46 PM
Subject: Get current date in hive


How do I get the current date in Hive? Specifically, I’m looking for the equivalent of following
SQL where clause: 

where LOCAL_DT >= current date - 3 day 

I tried using 

where local_dt >= date_sub(to_date(unix_timestamp()), 3) 

but this method seems to be many times slower than hardcoding the date. local_dt is the local
date and also the partition key for the table. 

View raw message