Re: How would you write a query for a use-case I have

2012-07-17 Thread Cdy Chen
Use String functions https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-StringFunctions 2012/7/16 Guy Doulberg > 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 o

How would you write a query for a use-case I have

2012-07-15 Thread Guy Doulberg
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, 111 .. u1,ue2,