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 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
