[
https://issues.apache.org/jira/browse/IMPALA-7223?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong updated IMPALA-7223:
----------------------------------
Target Version: Product Backlog
Priority: Trivial (was: Minor)
> 'Function LAST_VALUE does not accept the keyword IGNORE NULLS' exception
> thrown wrong
> -------------------------------------------------------------------------------------
>
> Key: IMPALA-7223
> URL: https://issues.apache.org/jira/browse/IMPALA-7223
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 2.7.0, Impala 2.8.0, Impala 2.7.1, Impala 2.9.0,
> Impala 2.10.0, Impala 2.11.0, Impala 3.0, Impala 2.12.0
> Reporter: Zsombor Fedor
> Priority: Trivial
>
> When parsing last_value() with _over_ not next to the function
> {code:java}
> select a, b, concat(last_value(c ignore nulls), 'abc') over (partition by a)
> as last_c from t1;{code}
> {quote}_ERROR: AnalysisException: Function LAST_VALUE does not accept the
> keyword IGNORE NULLS._
> {quote}
> thrown instead of
> {quote}_ERROR: AnalysisException: Analytic function requires an OVER clause:
> last_value(c)_
> {quote}
> This checking is happening so early, with any syntax similar to this,
> regardless if its a real function or not, the same exception thrown.
> For example:
> {code:java}
> select a, b, asd(last_value(c ignore nulls)) over (partition by a) as last_c
> from t1;{code}
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
