How about:
select * from Customers limit 2;
select * from Customers order by salary limit 2;
From: Ravisankar Mani [mailto:ravisankarm...@syncfusion.com]
Sent: Tuesday, June 02, 2015 2:12 PM
To: user@hive.apache.org
Subject: Top N list in Hive
Hi Everyone,
I am unable to get top N list when
Hi Everyone,
I am unable to get top N list when using Hive guery.
But I get top N list properly in sql
Example
"SELECT TOP 2 * FROM Customers"
Could you please provide other way to find top n tables
Regards,
Ravisankar M R
