Details
-
Bug
-
Status: Open
-
Trivial
-
Resolution: Unresolved
-
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
-
None
-
None
-
ghx-label-9
Description
When parsing last_value() with over not next to the function
select a, b, concat(last_value(c ignore nulls), 'abc') over (partition by a) as last_c from t1;
ERROR: AnalysisException: Function LAST_VALUE does not accept the keyword IGNORE NULLS.
thrown instead of
ERROR: AnalysisException: Analytic function requires an OVER clause: last_value(c)
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:
select a, b, asd(last_value(c ignore nulls)) over (partition by a) as last_c from t1;