phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "cherish peng (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-4866) UDFs get error: org.apache.phoenix.schema.FunctionNotFoundException: ERROR 6001 (42F01): Function undefined
Date Fri, 24 Aug 2018 09:58:00 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-4866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

cherish peng updated PHOENIX-4866:
----------------------------------
    Description: 
 
{code:java}
Environment: 

apache-phoenix-5.0.0-HBase-2.0-bin 

hbase-2.0.0

hadoop-3.1.0
{code}
I built an udf `ARRAY_DISTINCT`, When i exec:

{color:#d04437}①{color} SELECT ARRAY_DISTINCT(ARRAY['A', 'B', 'A', 'C'], TRUE);

throw error: "org.apache.phoenix.schema.FunctionNotFoundException: ERROR 6001 (42F01): Function
undefined"

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'] |***

*+---------------------+*

 
 My ddl: 

CREATE FUNCTION ARRAY_DISTINCT(VARCHAR[], BOOLEAN) RETURNS VARCHAR AS 'com.godalgo.udf.ArrayDistinctFunction';

*I tried the built-in functions which provided by Phoenix, they only output ③ .*

*I put the  ARRAY_DISTINCT SOURCE TO attachment.*

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

{color:#d04437}①{color} SELECT ARRAY_DISTINCT(ARRAY['A', 'B', 'A', 'C'], TRUE);

throw error: "org.apache.phoenix.schema.FunctionNotFoundException: ERROR 6001 (42F01): Function
undefined"

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'] |***
 
 *+---------------------+*
 
  
 My ddl: 

CREATE FUNCTION ARRAY_DISTINCT(VARCHAR[], BOOLEAN) RETURNS VARCHAR AS 'com.godalgo.udf.ArrayDistinctFunction';


 *I tried the built-in functions which provided by Phoenix, they only output ③ .*

*I put the  ARRAY_DISTINCT SOURCE TO attachment.*


> 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
>            Priority: Blocker
>              Labels: User-Defined-Function, functions, udfs
>         Attachments: ArrayDistinctFunction.java
>
>   Original Estimate: 72h
>  Remaining Estimate: 72h
>
>  
> {code:java}
> Environment: 
> apache-phoenix-5.0.0-HBase-2.0-bin 
> hbase-2.0.0
> hadoop-3.1.0
> {code}
> I built an udf `ARRAY_DISTINCT`, When i exec:
> {color:#d04437}①{color} SELECT ARRAY_DISTINCT(ARRAY['A', 'B', 'A', 'C'], TRUE);
> throw error: "org.apache.phoenix.schema.FunctionNotFoundException: ERROR 6001 (42F01):
Function undefined"
> 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'] |***
> *+---------------------+*
>  
>  My ddl: 
> CREATE FUNCTION ARRAY_DISTINCT(VARCHAR[], BOOLEAN) RETURNS VARCHAR AS 'com.godalgo.udf.ArrayDistinctFunction';
> *I tried the built-in functions which provided by Phoenix, they only output ③ .*
> *I put the  ARRAY_DISTINCT SOURCE TO attachment.*



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message