Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB