Hi Swapna, We don't support custom aggregate functions, only scalar functions (see PHOENIX-2069). For a custom aggregate function, you'd need to add them to phoenix-core and rebuild the jar. We're open to adding them to the code base if they're general enough. That's how FIRST_VALUE, LAST_VALUE, and NTH_VALUE made it in. Thanks, James
On Thu, Mar 17, 2016 at 12:11 PM, Swapna Swapna <talktoswa...@gmail.com> wrote: > Hi, > > I found this in Phoenix UDF documentation: > > - After compiling your code to a jar, you need to deploy the jar into > the HDFS. It would be better to add the jar to HDFS folder configured for > hbase.dynamic.jars.dir. > > > My question is, can that be any 'udf-user-specific' jar which need to be > copied to HDFS or would it need to register the function and update the > custom UDF classes inside phoenix-core.jar and rebuild the > 'phoenix-core.jar' > > Regards > Swapna > > > > > On Fri, Jan 29, 2016 at 6:31 PM, James Taylor <jamestay...@apache.org> > wrote: > >> Hi Swapna, >> We currently don't support custom aggregate UDF, and it looks like you >> found the JIRA here: PHOENIX-2069. It would be a natural extension of UDFs. >> Would be great to capture your use case and requirements on the JIRA to >> make sure the functionality will meet your needs. >> Thanks, >> James >> >> On Fri, Jan 29, 2016 at 1:47 PM, Swapna Swapna <talktoswa...@gmail.com> >> wrote: >> >>> Hi, >>> >>> I would like to know the approach to implement and register custom >>> aggregate functions in Phoenix like the way we have built-in aggregate >>> functions like SUM, COUNT,etc >>> >>> Please help. >>> >>> Thanks >>> Swapna >>> >> >> >