Re: Implement Custom Aggregate Functions in Phoenix

2016-03-27 Thread Swapna Swapna
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 mentione

Re: Implement Custom Aggregate Functions in Phoenix

2016-03-20 Thread Swapna Swapna
Thank you James for providing the URL, I will be trying today as per the directions. On Thu, Mar 17, 2016 at 6:52 PM, James Taylor wrote: > 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

Re: Implement Custom Aggregate Functions in Phoenix

2016-03-19 Thread Swapna Swapna
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 b

Re: Implement Custom Aggregate Functions in Phoenix

2016-03-19 Thread James Taylor
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 example to > refer to UD

Re: Implement Custom Aggregate Functions in Phoenix

2016-03-19 Thread James Taylor
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, an

Re: Implement Custom Aggregate Functions in Phoenix

2016-03-19 Thread Swapna Swapna
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 wrote: > Hi Swapna, > We

Re: Implement Custom Aggregate Functions in Phoenix

2016-03-19 Thread James Taylor
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 wrote: > Than

Re: Implement Custom Aggregate Functions in Phoenix

2016-03-19 Thread Swapna Swapna
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 functio

Re: Implement Custom Aggregate Functions in Phoenix

2016-01-29 Thread James Taylor
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 F

Implement Custom Aggregate Functions in Phoenix

2016-01-29 Thread Swapna Swapna
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