Hi, Just noticed that this patch: https://issues.apache.org/jira/secure/attachment/12799314/PHOENIX-2841.patch is missing from: https://github.com/apache/phoenix/tree/4.4-HBase-1.1
Here are the files: https://github.com/apache/phoenix/blob/4.4-HBase-1.1/phoenix-core/src/main/java/org/apache/phoenix/compile/QueryCompiler.java#L418 https://github.com/apache/phoenix/blob/4.4-HBase-1.1/phoenix-core/src/it/java/org/apache/phoenix/end2end/UserDefinedFunctionsIT.java Thanks! On Mon, Apr 10, 2017 at 10:24 AM, Bernard Quizon < bernard.qui...@stellarloyalty.com> wrote: > 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.or >> g/jira/browse/PHOENIX-2841. >> >> On Fri, Apr 7, 2017 at 1:18 PM, Bernard Quizon < >> bernard.qui...@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! >>> >>> >>> >>> >> >