[IMPALA-7223] 'Function LAST_VALUE does not accept the keyword IGNORE NULLS' exception thrown wrong

• 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
• Component/s: Frontend
• Target Version: Product Backlog
• Epic Color: ghx-label-9
• Assignee: Unassigned
• Reporter: Zsombor Fedor
• Created: 29/Jun/18 15:57
• Updated: 02/Nov/18 18:51

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;