Hi Try the hour() function from here: https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-DateFunctions
Ruslan On Tue, Oct 9, 2012 at 7:54 AM, Matthieu Labour <[email protected]> wrote: > Hi > Is it possible with Hive to truncate date to a specified precision? > For example in Postgresql date_trunc('hour',timestamp '2001-02-16 20:38:40') > will return 2001-02-16 20:00:00 > There is the to_date function in hive > I am trying to achieve the following > select distinct date_trunc('hour', timestamp) as hour, count(*) from table > group by hour; > Thank you for your help > Matthieu >
