Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Getting issue for user defined function in pheniox

avatar

I set the property in hbase for pheniox userd defined funtion to true but still getting the error for the same.:-

phoenix.functions.allowUserDefinedFunctions = true

Command to connect pheonix:-

Command to connect:-

/usr/hdp/2.3.2.0-2950/phoenix/bin/sqlline.py localhost:2181:/hbase-unsecure

CREATE FUNCTION jsonstring(varchar,varchar) returns varchar as 'com.xyz.accesslayer.GetStringFrom Json';

Error: ERROR 6003 (42F03): User defined functions are configured to not be allowed. To allow configure phoenix.functions.allowUserDefinedFunctions to true. (state=42F03,code=6003)

1 ACCEPTED SOLUTION

avatar

Issue is resolved after coping the updated hbase-sites.xml

cp -r <HBASE_CONFIG_DIR>/hbase-site.xml <PHOENIX_HOME>/bin/hbase-site.xml

Thanks fro imidiate reply.

View solution in original post

5 REPLIES 5

avatar
Super Guru

avatar

I have restarted with all settings.

avatar

Issue is resolved after coping the updated hbase-sites.xml

cp -r <HBASE_CONFIG_DIR>/hbase-site.xml <PHOENIX_HOME>/bin/hbase-site.xml

Thanks fro imidiate reply.

avatar
Super Guru

Are you using Ambari to change these parameter or manually adding it?

avatar

@Jitendra Yadav,

No I am doing changes from ambari web UI.