hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raihan Jamal <jamalrai...@gmail.com>
Subject Invalid Function rank in HiveQL
Date Tue, 10 Jul 2012 05:40:08 GMT
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*

Mime
View raw message