hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-4192) Use of LEAD in an OVER clauses causes the query to fail
Date Sat, 16 Mar 2013 00:14:12 GMT
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

Mime
View raw message