[IMPALA-1882] Remove ORDER BY restriction from first_value()/last_value()

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.1, Impala 2.2
• Fix Version/s: Impala 2.10.0
• Component/s: Frontend
• Labels: ansi-sql ramp-up sql-language
• Target Version: Product Backlog
• Assignee: Bikramjeet Vig
• Reporter: Jonathan Seidman
• Created: 12/Mar/15 17:44
• Updated: 31/Jul/17 17:51
• Resolved: 31/Jul/17 17:31

Description

Ordering requirement should be removed from first_value() usage. This is not required by ISO SQL spec, and is a deficiency for BI tools leveraging analytic functionality.