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

    • 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
    • Frontend
    • 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

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

            Dates

              Created:
              Updated: