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.
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.
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.