-
Type:
Bug
-
Status: Open
-
Priority:
Trivial
-
Resolution: Unresolved
-
Affects Version/s: 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
-
Fix Version/s: None
-
Component/s: Frontend
-
Labels:None
-
Target Version:
-
Epic Color:ghx-label-9
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;