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

How can I create a User-defined analytic function?

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Impala 3.0
    • Fix Version/s: None
    • Component/s: Frontend
    • Epic Color:
      ghx-label-8

      Description

      I can create a UDAF with the "create aggregate function ....", but when I use this aggregate function for the analysis function, such as sql : select hour,my_udaf(id) over (partition by hour) from mytable ,it reports the following error.

      ERROR: AnalysisException: Aggregate function 'my_udaf(id)' not supported with OVER clause.

      How can I create the analytic function? Is this an imperfect function, or is it not designed to provide this function for some reason?

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              zhangjun Jun Zhang
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: