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.quizon@stellarloyalty.com> wrote:
Thank you, rajeshbabu! 

On Fri, Apr 7, 2017 at 4:33 PM, rajeshbabu@apache.org <chrajeshbabu32@gmail.com> wrote:

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!