hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raihan Jamal <>
Subject Find TOP 10 using HiveQL
Date Tue, 10 Jul 2012 02:30:53 GMT
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

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

*Raihan Jamal*

View raw message