zhangjun created IMPALA-7849:
--------------------------------

             Summary: How can I create a User-defined analytic function?
                 Key: IMPALA-7849
                 URL: https://issues.apache.org/jira/browse/IMPALA-7849
             Project: IMPALA
          Issue Type: Improvement
          Components: Clients, Frontend
    Affects Versions: Impala 3.0
            Reporter: zhangjun


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?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to