What are the semantics for ROW_NUMBER? Is it a global row number? Per a partition? Per a bucket?
-- Owen On Wed, Feb 20, 2013 at 11:33 PM, kumar mr <kumar...@aol.com> wrote: > Hi, > > This is Kumar, and this is my first question in this group. > > I have a requirement to implement ROW_NUMBER() from Teradata in Hive > where partitioning happens on multiple columns along with multiple column > ordering. > It can be easily implemented in Hadoop MR, but I have to do in Hive. By > doing in UDF can assign same rank to grouping key considering dataset is > small, but ordering need to be done in prior step. > Can we do this in lot simpler way? > > Thanks in advance. > > Regards, > Kumar >