Getting issue for user defined function in pheniox

[#1]

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)

[#2]

@Ashnee Sharma

Restart the HBase Master and Region Servers.

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_installing_manually_book/content/configu...

[#3]

I have restarted with all settings.

[#4 · Accepted solution]

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.

[#5]

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

[#6]

@Jitendra Yadav,

No I am doing changes from ambari web UI.