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
-
Invalid Function rank in HiveQL
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*