In this post, we will come across with a new technique of registering(creating) and running a hive UDF function. In the previous post, I have mentioned how to write an UDF function and run it.
To avoid the restarting of Hive Server2, use hive reloadable in place of hive aux path. Below are the steps:-
- Set hive reloadable path in security value in Advance configuration (One Time Process).
- Get access to the jar at HDFS and reloadable path.
- Use reload on hive command line, to reflect all the new changes.
- Create and register function and run the jar.
Note: Hive reloadable path should be used in Cloudera version 5.9.x or above. If you use reloadable path in lower version 5.8.x, you could face an issue with Hive Service which will goes down after the cluster restart.
Provide your comments and feedback on the post.
hadooptech 