Re: Implement Custom Aggregate Functions in Phoenix

Hi friend,are you fixed this problem? I have some problem when I simulate sumAggregateFunction, I call it ZSumAggregateFunction, also, I add some class such ZDecimalAggregator, ZSumAggregateParseNode, and anyone were related with SumAggregateFunction. so now, I can't find what place will

Re: Implement Custom Aggregate Functions in Phoenix

Hi Swapna, I happen to run into same issue and have written a custom aggregate UDF and successfully compiled phoenix-core and full phoenix project too. But after replacing phoenix-client, phoenix-server and phoenix-core jar I still get following error- Error: ERROR 6001 (42F01): Function

Re: Implement Custom Aggregate Functions in Phoenix

HI James/Team, 1. I'm trying to implement the generic (custom) aggregate function and using verison: *phoenix-4.6.0-HBase-0.98 *with single-node (having hbase and phoenix exists in one node) When i downloaded and installed, noticed that SumAggregateFunction.class exists in all the below

Re: Implement Custom Aggregate Functions in Phoenix

No, custom UDFs can be added dynamically as described here: https://phoenix.apache.org/udf.html. No need to re-build Phoenix. It's just custom aggregates that would require rebuilding. FYI, we have support for UPPER and LOWER already. On Thu, Mar 17, 2016 at 6:09 PM, Swapna Swapna

Re: Implement Custom Aggregate Functions in Phoenix

Yes, we do have support UPPER and LOWER. I just provided as an example to refer to UDF. For custom UDF's, i understand that we can go ahead and create custom UDF jar. but how do we register that function? As per the blog, i found the below lines: *Finally, we'll need to register our new

Re: Implement Custom Aggregate Functions in Phoenix

Thank you James for swift response. is the process (adding to phoenix-core and rebuild the jar) remains the same for custom UDF's as well (like as for custom aggregate functions)? ex: we have UDF's like UPPER, LOWER ,etc On Thu, Mar 17, 2016 at 5:53 PM, James Taylor

Re: Implement Custom Aggregate Functions in Phoenix

No need to register your custom UDFs. Did you see these directions: https://phoenix.apache.org/udf.html#How_to_write_custom_UDF? Have you tried it yet? On Thu, Mar 17, 2016 at 6:49 PM, Swapna Swapna wrote: > Yes, we do have support UPPER and LOWER. I just provided as an

Re: Implement Custom Aggregate Functions in Phoenix

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

Re: Implement Custom Aggregate Functions in Phoenix

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,

Re: Implement Custom Aggregate Functions in Phoenix

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