phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Implement Custom Aggregate Functions in Phoenix
Date Fri, 18 Mar 2016 01:17:42 GMT
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 <talktoswapna@gmail.com>
wrote:

> 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 <jamestaylor@apache.org>
> wrote:
>
>> 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 <talktoswapna@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 <jamestaylor@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 <talktoswapna@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
>>>>>
>>>>
>>>>
>>>
>>
>

Mime
View raw message