You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Alan Gates (JIRA)" <ji...@apache.org> on 2013/03/16 01:14:12 UTC
[jira] [Created] (HIVE-4192) Use of LEAD in an OVER clauses causes
the query to fail
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