Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> On hive date functions


+
Matthieu Labour 2012-10-09, 03:54
Copy link to this message
-
Re: On hive date functions
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
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB