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. >
