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.comwrote:
Thanks ShriKanth.
On Fri, Dec 14, 2012 at 11:22 AM, shrikanth shankar
sshan...@qubole.comwrote:
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