Alan Gates created HIVE-4192: -------------------------------- Summary: Use of LEAD in an OVER clauses causes the query to fail Key: HIVE-4192 URL: https://issues.apache.org/jira/browse/HIVE-4192 Project: Hive Issue Type: Bug Components: PTF-Windowing Affects Versions: 0.11.0 Reporter: Alan Gates
Running a query like: {code} select i, lead(s) over (partition by bin order by d desc rows between current row and 1 following) from over100k; {code} gives an error: {code} FAILED: SemanticException Function lead((TOK_TABLE_OR_COL s)) org.apache.hadoop.hive.ql.parse.WindowingSpec$WindowSpec@13e15f7 as _wcol0 doesn't support windowing {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira