You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Bernard Quizon <be...@stellarloyalty.com> on 2017/04/07 07:48:50 UTC
UDF doesn't work with Sort Merge Join Hint
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!
Re: UDF doesn't work with Sort Merge Join Hint
Posted by James Taylor <ja...@apache.org>.
The Phoenix 4.4 release is almost two years old. There have been six
subsequent releases. I encourage you to upgrade.
Thanks,
James
On Sun, Apr 9, 2017 at 8:14 PM Bernard Quizon <
bernard.quizon@stellarloyalty.com> wrote:
> 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.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!
>
>
>
>
>
>
>
Re: UDF doesn't work with Sort Merge Join Hint
Posted by Bernard Quizon <be...@stellarloyalty.com>.
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!
>>>
>>>
>>>
>>>
>>
>
Re: UDF doesn't work with Sort Merge Join Hint
Posted by Bernard Quizon <be...@stellarloyalty.com>.
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!
>>
>>
>>
>>
>
Re: UDF doesn't work with Sort Merge Join Hint
Posted by "rajeshbabu@apache.org" <ch...@gmail.com>.
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!
>
>
>
>