I'm quite new to Hortonworks and have been working to install a function in the sandbox for 2.6.3.
I have a Hive UDF that I can run in the CLI under the root user with no issue, but when I try to use the function in a query with the Maria_dev user in Ambari, it says the function does not exist. I've used both create temporary and create function options, and I can see both the temporary and full functions in the CLI, but still can't query against it in the Ambari user. I can run a query using the function in the HIve CLI with the root user with no issue.
I thouight that I created the standard function, without it being temporary, that it would carry over to the other users for permission.