You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@phoenix.apache.org by "Istvan Toth (Jira)" <ji...@apache.org> on 2020/03/02 14:23:00 UTC
[jira] [Comment Edited] (PHOENIX-4866) UDFs get error:
org.apache.phoenix.schema.FunctionNotFoundException: ERROR 6001 (42F01):
Function undefined
[ https://issues.apache.org/jira/browse/PHOENIX-4866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17049249#comment-17049249 ]
Istvan Toth edited comment on PHOENIX-4866 at 3/2/20 2:22 PM:
--------------------------------------------------------------
Merged into master and 4.x
Thanks for the fix [~RichardAntal]
was (Author: stoty):
Merged into master 4.x
Thanks for the fix [~RichardAntal]
> UDFs get error: org.apache.phoenix.schema.FunctionNotFoundException: ERROR 6001 (42F01): Function undefined
> -----------------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-4866
> URL: https://issues.apache.org/jira/browse/PHOENIX-4866
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 5.0.0
> Environment: [^ArrayDistinctFunction.java]
> Reporter: cherish peng
> Assignee: Richard Antal
> Priority: Blocker
> Labels: User-Defined-Function, functions, udfs
> Fix For: 5.1.0, 4.16.0
>
> Attachments: ArrayDistinctFunction.java, PHOENIX-4866.master.v1.patch
>
> Original Estimate: 72h
> Remaining Estimate: 72h
>
> I built an udf `ARRAY_DISTINCT`, When i exec:
> {color:#d04437}①{color} SELECT ARRAY_DISTINCT(ARRAY['A', 'B', 'A', 'C'], TRUE);
> throw error:
>
> {code:java}
> org.apache.phoenix.schema.FunctionNotFoundException: ERROR 6001 (42F01): Function undefined. functionName=ARRAY_DISTINCT at org.apache.phoenix.compile.FromCompiler$1.resolveFunction(FromCompiler.java:134) at org.apache.phoenix.compile.ExpressionCompiler.visitLeave(ExpressionCompiler.java:327)
> {code}
>
> However when i exec:
> {color:#d04437}②{color} SELECT ARRAY_DISTINCT(ARRAY['A', 'B', 'A', 'C'], TRUE) {color:#f79232}FROM TABLE_NAME;{color}
> output:
> *+---------------------+*
> *|* *ARRAY['A','B','C']* *|*
> *+---------------------+*
> *+---------------------+*
>
> {color:#d04437}③{color} SELECT ARRAY_DISTINCT({color:#f79232}array_elements{color}, TRUE) as arr {color:#f79232}FROM TABLE_NAME;{color}**
> {color:#f79232}output:{color}
> *+---------------------+*
> *| ARR* * ** |*
> *+---------------------+*
> *| ARRAY['A','B','C'] |***
> *+---------------------+*
>
> The DDL:
> CREATE FUNCTION ARRAY_DISTINCT(VARCHAR[], BOOLEAN) RETURNS VARCHAR AS 'com.godalgo.udf.ArrayDistinctFunction';
> My Environment: apache-phoenix-5.0.0-HBase-2.0-bin hbase-2.0.0 hadoop-3.1.0
>
> I tried the built-in functions which provided by Phoenix, ALL OF THEM ARE OK .
> *I had putted ARRAY_DISTINCT's SOURCE TO attachment.*
--
This message was sent by Atlassian Jira
(v8.3.4#803005)