Perhaps a macro? CREATE TEMPORARY MACRO state_from_city (city string) " + /* HQL column logic */ ...;
On 1 October 2015 at 14:11, Daniel Lopes <dan...@bankfacil.com.br> wrote: > 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 > >
