Thank you, rajeshbabu! On Fri, Apr 7, 2017 at 4:33 PM, rajeshb...@apache.org < chrajeshbab...@gmail.com> wrote:
> It's a bug and already fixed https://issues.apache. > org/jira/browse/PHOENIX-2841. > > On Fri, Apr 7, 2017 at 1:18 PM, Bernard Quizon <bernard.quizon@ > stellarloyalty.com> wrote: > >> HI, >> >> I'm using Phoenix-4.4-hbase-1.1 and whenever I run a statement that has a >> UDF in the SELECT clause with the sort merge join hint, it results to the >> error function undefined. >> >> Sample: >> >> SELECT /*+ USE_SORT_MERGE_JOIN */ >> my_udf(test_column) as udf >> FROM table1 a >> INNER JOIN >> table2 b >> on a.id = b.id >> >> Is this a known bug? If it is, is there a workaround? >> >> >> Thanks! >> >> >> >> >