[HADOOP-4086] Add limit to Hive QL

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.19.0
• Release Note: Added LIMIT to Hive query language.
• Assignee: Namit Jain
• Reporter: Ashish Thusoo
• Created: 05/Sep/08 17:41
• Updated: 08/Jul/09 17:06
• Resolved: 21/Oct/08 18:49

Description

Add a limit feature to the Hive Query language.

so you can do the following things:

SELECT * FROM T LIMIT 10;

and this would just return the 10 rows.

No gaurantees are made on which 10 rows are returned by the query.

Issue Links

• relates to: HADOOP-4183 select * to console issues in Hive