phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bernard Quizon <bernard.qui...@stellarloyalty.com>
Subject Re: UDF doesn't work with Sort Merge Join Hint
Date Mon, 10 Apr 2017 03:14:30 GMT
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:
>
>> 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.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!
>>>
>>>
>>>
>>>
>>
>

Mime
View raw message