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)
