question Re: Getting issue for user defined function in pheniox in Archives of Support Questions (Read Only)

Getting issue for user defined function in pheniox

ashneesharma88 — Tue, 07 Jun 2016 17:46:24 GMT

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)

Re: Getting issue for user defined function in pheniox

jyadav — Tue, 07 Jun 2016 18:01:32 GMT

@Ashnee Sharma

Restart the HBase Master and Region Servers.

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_installing_manually_book/content/configuring-hbase-for-phoenix.html

Re: Getting issue for user defined function in pheniox

ashneesharma88 — Tue, 07 Jun 2016 18:03:53 GMT

I have restarted with all settings.

Re: Getting issue for user defined function in pheniox

ashneesharma88 — Tue, 07 Jun 2016 18:11:07 GMT

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.

Re: Getting issue for user defined function in pheniox

jyadav — Tue, 07 Jun 2016 18:30:14 GMT

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

Re: Getting issue for user defined function in pheniox

ashneesharma88 — Thu, 09 Jun 2016 13:05:39 GMT

@Jitendra Yadav,

No I am doing changes from ambari web UI.