You can define them in groovy from inside the CLI... https://gist.github.com/mwinkle/ac9dbb152a1e10e06c16
On Thu, Oct 1, 2015 at 12:57 PM, Ryan Harris <ryan.har...@zionsbancorp.com> wrote: > If you want to use python... > > The python script should expect tab-separated input on stdin and it should > return tab-separated delimited columns for the output... > > > > add file mypython.py; > > SELECT TRANSFORM (tbl.id, tbl.name, tbl.city) > > USING 'python mypython.py' > > AS (id, name, city, state) > > FROM my_db.my_table ; > > > > *From:* Daniel Lopes [mailto:dan...@bankfacil.com.br] > *Sent:* Thursday, October 01, 2015 7:12 AM > *To:* user@hive.apache.org > *Subject:* Better way to do UDF's for Hive > > > > Hi, > > > > I'd like to know the good way to do a a UDF for a single field, like > > > > SELECT > > tbl.id AS id, > > tbl.name AS name, > > tbl.city AS city, > > state_from_city(tbl.city) AS state > > FROM > > my_db.my_table tbl; > > > > *Native Java*? *Python *over *Hadoop* *Streaming*? > > > > I prefer Python, but I don't know how to do in a good way. > > > > Thanks, > > > *Daniel Lopes, B.Eng* > > Data Scientist - BankFacil > > CREA/SP 5069410560 > <http://edital.confea.org.br/ConsultaProfissional/cartao.aspx?rnp=2613651334> > > Mob +55 (18) 99764-2733 <callto:+5518997642733> > > Ph +55 (11) 3522-8009 > > http://about.me/dannyeuu > > > > Av. Nova Independência, 956, São Paulo, SP > > Bairro Brooklin Paulista > > CEP 04570-001 > > https://www.bankfacil.com.br > > > ------------------------------ > THIS ELECTRONIC MESSAGE, INCLUDING ANY ACCOMPANYING DOCUMENTS, IS > CONFIDENTIAL and may contain information that is privileged and exempt from > disclosure under applicable law. If you are neither the intended recipient > nor responsible for delivering the message to the intended recipient, > please note that any dissemination, distribution, copying or the taking of > any action in reliance upon the message is strictly prohibited. If you have > received this communication in error, please notify the sender immediately. > Thank you. >
