Use String functions https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-StringFunctions
2012/7/16 Guy Doulberg <guy.doulb...@conduit.com> > Hi guys, > > I have a table with three fields, (uid,event_guid,timestamp) I need to > find out for each event_guid the index of it in the context of the user. I > want to extract a table with the fields (event_guid, index). > * each event has a unique guid. > > Example > > u1, ue1, 1111111 > ...... > u1,ue2, 11111112 > ....... > u1,ue3, 11111113 > > > I want to produce the table > > ue1, 1 > ue2,2 > ue3,3 > > How would you do that using hive? > > Thanks, Guy. > > > >