Hi Shrikanth, Hope you are doing great. Though i created Rank UDF in hive.
Create Temporary Function my_rank as 'com.m6d.hiveudf.com' but when i using this function in my query i am getting error Invalid function my_rank and i can see my function in hive. Do you have any suggestions. Thanks Maya. On Fri, Dec 14, 2012 at 11:26 AM, maya bhardwaj <maya.bhardwa...@gmail.com>wrote: > Thanks ShriKanth. > > > On Fri, Dec 14, 2012 at 11:22 AM, shrikanth shankar > <sshan...@qubole.com>wrote: > >> See >> http://www.edwardcapriolo.com/roller/edwardcapriolo/entry/doing_rank_with_hive >> >> thanks, >> Shrikanth >> >> On Dec 14, 2012, at 8:18 AM, maya bhardwaj wrote: >> >> I am converting the Netezza query in hive.How can i achieve following >> query in hive --> row_number() over (partition by record_id, event_id order >> by e_timestamp desc) as rnum >> >> >> >