hive has no built-in rank function. you'd need to use a user-defined function (UDF) to simulate it. there are a few custom implementations on the net that you can leverage.
On Mon, Jul 9, 2012 at 10:40 PM, Raihan Jamal <jamalrai...@gmail.com> wrote: > What's wrong with the below query. > > > SELECT buyer_id, item_id, created_time > FROM ( > SELECT buyer_id, item_id, rank(buyer_id) as rank, created_time > FROM testingtable1 > DISTRIBUTE BY buyer_id, item_id > SORT BY buyer_id, item_id, created_time desc > ) a > WHERE rank < 10 > ORDER BY buyer_id, rank > > > I am always getting as - > > FAILED: Error in semantic analysis: line 3:30 Invalid Function rank > > > I am using Hive 0.6 I guess. > > > > Raihan Jamal >
