Re: Exception when create an index with UDF but not using this UDF in select statement

Very helpful analysis, Mac. Please file a JIRA. It seems that you've found an issue with functional indexes over UDFs. Thanks, James On Wednesday, June 1, 2016, 方震(大数据&滴滴研究院) wrote: > Guys, > > One exception i have met but not sure if it is an issue. here are the steps > 1. Create a function > >

Exception when create an index with UDF but not using this UDF in select statement

Guys, One exception i have met but not sure if it is an issue. here are the steps 1. Create a function CREATE FUNCTION geohash_1(double, double) returns varchar as 'co.mac.test.GeoHashFunction' using jar '/Users/mac/Downloads/phoenix-4.5.2-HBase-1.0/phoenix-plugins/target/phoenix-plugins-4

Re: UDF in SELECT

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, 201

Re: UDF in SELECT

Hi Kathiresan, Thanks for trying the UDFs. bq. 1.Will any function (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 c

UDF in SELECT

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