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.



Reply via email to