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
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
5 REPLIES 5

avatar
Super Guru

avatar

I have restarted with all settings.

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

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.