phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "alihossein shahabi (Jira)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-5480) Function undefined. functionName=[ARRAY_ELEM]
Date Mon, 16 Sep 2019 21:25:00 GMT
alihossein shahabi created PHOENIX-5480:
-------------------------------------------

             Summary: Function undefined. functionName=[ARRAY_ELEM] 
                 Key: PHOENIX-5480
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5480
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.14.1
            Reporter: alihossein shahabi


hi. I create a view but when I want to create INDEX, I encounter by this message : 

CREATE LOCAL INDEX "ALITEST_FUCK_UPPERCASE_VERSION2_VIEW22_INDEX_UPPER4" ON "ALITEST_FUCK_UPPERCASE_VERSION2_VIEW22"
(ARRAY_ELEM("personal_data"."name")) ;
{code:java}
// Error: ERROR 6001 (42F01): Function undefined. functionName=[ARRAY_ELEM] (state=42F01,code=6001)Error:
ERROR 6001 (42F01): Function undefined. functionName=[ARRAY_ELEM] (state=42F01,code=6001)org.apache.phoenix.schema.FunctionNotFoundException:
ERROR 6001 (42F01): Function undefined. functionName=[ARRAY_ELEM] at org.apache.phoenix.jdbc.PhoenixStatement.throwIfUnallowedUserDefinedFunctions(PhoenixStatement.java:2112)
at org.apache.phoenix.jdbc.PhoenixStatement.access$800(PhoenixStatement.java:214) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableCreateIndexStatement.compilePlan(PhoenixStatement.java:1070)
at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableCreateIndexStatement.compilePlan(PhoenixStatement.java:1059)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:401) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:391)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:390)
at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:378) at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1825) at sqlline.Commands.execute(Commands.java:822)
at sqlline.Commands.sql(Commands.java:732) at sqlline.SqlLine.dispatch(SqlLine.java:813) at
sqlline.SqlLine.begin(SqlLine.java:686) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:291)
{code}




 

 

 

Can't use the `ARRAY_ELEM‍` function in making the index?

 



--
This message was sent by Atlassian Jira
(v8.3.2#803003)

Mime
View raw message