Loading analytic function to a database other than beehive.

Aster
N/A

Loading analytic function to a database other than beehive.

Hello:

When I log on to act from a database other than beehive as db_superuser I receive an error:

"Unable to open input file: install.sh"

I've already installed these once in beehive, but I want to be able to access them from another database.

How do I install these functions in a database other than beehive as I can't seem to do this or is it an access right thing.  Do I need to grant execute or something to my new database?  Thank you.

2 REPLIES

Re: Loading analytic function to a database other than beehive.

Cross database references are not implemented in Aster.  That means you cannot access an object from database X if it is installed in database Y.  Best would be to duplicate it in all the databases.  We did same for all SQL-MR functions in our environment. 

N/A

Re: Loading analytic function to a database other than beehive.

Thank you Ravi.  That makes sense.  I was thinking that since these were just jar files that I unzipped that all the database should be able to access them. Good to know.