回复: Find TOP 10 using HiveQL

[Andes]

hello, you can use "desc" and "limit 10" to filter the top 10.

2012-07-10



Best Regards
Andes




发件人：Raihan Jamal
发送时间：2012-07-10 10:31
主题：Find TOP 10 using HiveQL
收件人："user"<user@hive.apache.org>
抄送：

When I run this query,


SELECT TOP 10 FROM TestingTable1 WHERE ORDER BY buyer_id, created_time DESC;





I always get error as-


FAILED: Parse Error: line 1:7 cannot recognize input 'TOP' in select expression


Is there any way around to use TOP 10 or something similar that will work in 
HiveQL?



Raihan Jamal