Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-7223

'Function LAST_VALUE does not accept the keyword IGNORE NULLS' exception thrown wrong

    XMLWordPrintableJSON

    Details

    • 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

      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;

       

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              fzsombor Zsombor Fedor
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: