Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Wed, 20 Mar 2013 17:55:17 +0000 (UTC)
From: "Alan Gates (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12637304.1363392775091.20783.1363802117151@arcas>
In-Reply-To: <JIRA.12637304.1363392775091@arcas>
References: <JIRA.12637304.1363392775091@arcas>
Subject: [jira] [Commented] (HIVE-4192) Use of LEAD in an OVER clauses
 causes the query to fail
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/HIVE-4192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13607918#comment-13607918 ] 

Alan Gates commented on HIVE-4192:
----------------------------------

I agree throwing exception at compile time is better than silently dropping the window frame.
                
> 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