hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Sprague <sprag...@gmail.com>
Subject Re: FUNCTION HIVE to DAYS OF WEEK
Date Mon, 10 Feb 2014 21:38:30 GMT
oddly enough i don't see one here:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions

however, you're not the only one finding something like this useful. cf.
https://issues.apache.org/jira/browse/HIVE-6046

in the meantime it appears as though you'll have to write your own UDF or
perhaps setup a streaming job via transform() function.

Cheers,
Stephen.

PS. The transform() function is _really_ easy to use so don't be scared
off.  cf.
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Transform
(the last example is the simplest.)


On Mon, Feb 10, 2014 at 8:33 AM, Eduardo Parra Valdes | BEEVA <
eduardo.parra@beeva.com> wrote:

> Hello! all
> I wish to find a function that returns hive day of the week (Monday,
> Tuesday .. etc) to enter a parameter (timestamp).
> Anyone have an idea of how to do it?
>
> --
>  [image: BEEVA]
>
> *Eduardo Parra Valdés*
> eduardo.parra@beeva.com
>
> BEE OUR CLIENT
>
> WWW.BEEVA.COM <http://www.beeva.com/>
>
> Clara del Rey 26, 4ª planta.
>
> [28002] Madrid.
> <https://www.facebook.com/somosBEEVA><http://www.linkedin.com/company/beeva><https://twitter.com/beeva_es>
>
> Antes de imprimir este mensaje, por favor compruebe que es necesario
> hacerlo.
>
> Before you print this message please consider if it really necesary.
> Aviso Legal:
> Este mensaje, su contenido y cualquier fichero transmitido con él, está
> dirigido únicamente a su destinatario y es confidencial. Por ello, se
> informa a quien lo reciba por error o tenga conocimiento del mismo sin ser
> su destinatario, que la información contenida en él es reservada y su uso
> no autorizado, por lo que en tal caso le rogamos nos lo comunique por la
> misma vía, así como que se abstenga de reproducir el mensaje mediante
> cualquier medio o remitirlo o entregarlo a otra persona, procediendo a su
> borrado de manera inmediata.Disclaimer:
> This message, its content and any file attached thereto is for the
> intended recipient only and is confidential. If you have received this
> e-mail in error or had access to it, you should note that the information
> in it is private and any use thereof is unauthorised. In such an event
> please notify us by e-mail. Any reproduction of this e-mail by whatsoever
> means and any transmission or dissemination thereof to other persons is
> prohibited. It should be deleted immediately from your system.
>

Mime
View raw message