the short answer is there is no native hive UDF that solves your unique
case. That means you have to solve it.
i searched for something like you were looking for myself and found this
off the top of my head i'm not sure how easy this would be in SQL but i
imagine using ROW_NUMBER() function a clever person could do it. And if not
SQL then perhaps a custom UDF but ultimately you have to do the work and
now you have a potential recipe to follow. :)
On Wed, Mar 19, 2014 at 9:37 PM, Seema Datar <[EMAIL PROTECTED]> wrote: