[HIVE-4192] Use of LEAD in an OVER clauses causes the query to fail

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 0.11.0
• Component/s: PTF-Windowing
• Assignee: Unassigned
• Reporter: Alan Gates
• Created: 16/Mar/13 00:12
• Updated: 06/May/13 18:17
• Resolved: 20/Mar/13 18:00

Description

Running a query like:

select i, lead(s) over (partition by bin order by d desc 
                        rows between current row and 1 following) 
from over100k;

gives an error:

FAILED: SemanticException Function lead((TOK_TABLE_OR_COL s)) org.apache.hadoop.hive.ql.parse.WindowingSpec$WindowSpec@13e15f7 as _wcol0 doesn't support windowing