Here's one implementation of it: https://github.com/livingsocial/HiveSwarm#dayofweekdate.
The code for it is pretty straight forward: https://github.com/livingsocial/HiveSwarm/blob/master/src/main/java/com/livingsocial/hive/udf/DayOfWeek.java On Mon, Feb 10, 2014 at 4:38 PM, Stephen Sprague <sprag...@gmail.com> wrote: > 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.pa...@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.pa...@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. >> >
