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 02:24:45 GMT
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.
> 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!
>>
>>
>>
>>
>

Mime
View raw message