hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andes"<>
Subject 回复: Find TOP 10 using HiveQL
Date Tue, 10 Jul 2012 02:56:29 GMT
hello, you can use "desc" and "limit 10" to filter the top 10.


Best Regards

发件人:Raihan Jamal
发送时间:2012-07-10 10:31
主题:Find TOP 10 using HiveQL

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
View raw message