[PHOENIX-4866] UDFs get error: org.apache.phoenix.schema.FunctionNotFoundException: ERROR 6001 (42F01): Function undefined

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 5.0.0
• Fix Version/s: 5.1.0, 4.16.0
• Labels: User-Defined-Function functions udfs

Environment

ArrayDistinctFunction.java

• Flags: Important
• Assignee: Richárd Antal
• Reporter: cherish peng
• Created: 24/Aug/18 08:45
• Updated: 02/Mar/20 18:31
• Resolved: 02/Mar/20 14:22

Description

 I built an udf `ARRAY_DISTINCT`, When i exec:

① SELECT ARRAY_DISTINCT(ARRAY['A', 'B', 'A', 'C'], TRUE);

throw error:

 

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)

 

However when i exec:

② SELECT ARRAY_DISTINCT(ARRAY['A', 'B', 'A', 'C'], TRUE) FROM TABLE_NAME;

output:

---------------------

| ARRAY['A','B','C'] |

---------------------

---------------------

 

③ SELECT ARRAY_DISTINCT(array_elements, TRUE) as arr FROM TABLE_NAME;**

output:

---------------------

| 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.