hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Frederick Oko <>
Subject Re: Group by week?
Date Wed, 05 Aug 2009 15:14:53 GMT
Totally, if your input is sql date strings like 2009-08-04 while a generic
to_char with format string input could be added substr(pdate,1,7) is simple
means of extracting month -- tho instead of another udf it could be cool if
that could just be aliased to e.g. month_format() via config but I don't
think such is possible.

On Aug 4, 2009 8:47 PM, "Saurabh Nanda" <> wrote:

> [btw from my experience support for handling dates in hive is extremely
weak, and code becomes hea...

That's the first thing I noticed -- lack of native date format. However, if
you mange the zero-padding while importing the data, storing dates as
strings works just fine.

I would recommend that instead of jumping hoops each time you need to run a


View raw message