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.