Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Get current date in hive

Copy link to this message
Re: Get current date in hive
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: oanda.com www: fxtrade.com

"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" <[EMAIL PROTECTED]>
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.