phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathiresan S <kathiresanselva...@gmail.com>
Subject Re: UDF in SELECT
Date Mon, 04 May 2015 13:08:07 GMT
Thanks Rajeshbabu.

Could you please explain the benefits of UDF, does it provide any low level
data access/performance benefits,etc.? and also, the technical difficulties
involved in running functions in a SELECT clause on server side in Phoenix
on a high level?

Thanks,
Kathir

On Sun, May 3, 2015 at 12:16 AM, rajeshbabu@apache.org <
chrajeshbabu32@gmail.com> wrote:

> Hi Kathiresan,
> Thanks for trying the UDFs.
>
> bq. 1.Will any function
> <http://phoenix.apache.org/language/functions.html> (UDF or built-in) in
> a SELECT be run only on client side in Phoenix?
> Yes. if we use a function in select clause it will be evaluated at client
> side.
>
> bq. 2.Is there an option, i can push an UDF in a SELECT query to run on
> server side?
> If you use the functions in where clause they will be pushed down to the
> server and run at server side.
> That phoenix automatically do it for you.
>
> Thanks,
> Rajeshbabu.
>
> On Sun, May 3, 2015 at 1:02 AM, Kathiresan S <kathiresanselvaraj@gmail.com
> > wrote:
>
>> Hi,
>>
>> I've tried the new UDF feature of Phoenix.
>>
>> Below are the version details
>>
>> Phoenix : master (tag : v4.4.0-HBase-0.98-rc0)
>> Hbase : hbase-0.98.12-hadoop2
>>
>> I created a UDF and tested with a simple SELECT statement. Looks like,
>> its executed on the client side.
>>
>> Also, in one of the JIRAs
>> <https://issues.apache.org/jira/browse/PHOENIX-538>, i see the statement
>> "A function will be evaluated on the client side if it's used in the
>> SELECT clause"
>>
>> *Couple of quesitons:*
>>
>> 1.Will any function <http://phoenix.apache.org/language/functions.html> (UDF
>> or built-in) in a SELECT be run only on client side in Phoenix?
>> 2.Is there an option, i can push an UDF in a SELECT query to run on
>> server side?
>>
>> Thanks,
>> Kathir
>>
>
>

Mime
View raw message