You can call a function created in another database by using the fully qualified function name - select db_name.function_name(…) from … This is similar to referencing tables from other databases in your query.
On Feb 17, 2015, at 8:03 PM, vengatesh.babu <vengatesh.b...@zohocorp.com<mailto:vengatesh.b...@zohocorp.com>> wrote: Hi, I am using JDBC Client to create Function in hive (Ex. IFNULL) , it works only for database for which I created. If I want to use the same Function in another database, i need to create once again that function. Why Functions are working in single database alone ? Is there any way to create Function common to all databases in hive ? Thanks Vengatesh Babu K M