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

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

Thanks ShriKanth.
On Fri, Dec 14, 2012 at 11:22 AM, shrikanth shankar <[EMAIL PROTECTED]>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
>
>
>

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
<[EMAIL PROTECTED]>wrote:

> Thanks ShriKanth.
>
>
> On Fri, Dec 14, 2012 at 11:22 AM, shrikanth shankar <[EMAIL PROTECTED]>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
>>
>>
>>
>