Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Invalid Function rank in HiveQL


Copy link to this message
-
Re: Invalid Function rank in HiveQL
Vijay 2012-07-10, 05:51
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 <[EMAIL PROTECTED]> 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
>