[IMPALA-7849] How can I create a User-defined analytic function?

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 3.0
• Component/s: Frontend
• Labels: User-defined analytic function
• Epic Color: ghx-label-8
• Assignee: Unassigned
• Reporter: Jun Zhang
• Created: 14/Nov/18 09:20
• Updated: 18/Jan/19 01:57

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?