Mohan, There is a couple things here.
I think a lcase udf already exists. You need to things add jar '/path/to/udf' create function If you want this to always be there. There is a jira open for a .hiverc that can run a set of commands on startup. You can also just patch FunctionRegistry, it is in the ql subfolder. That is how UDFs are added to hive permanently. On Thu, Nov 26, 2009 at 1:53 AM, Mohan Agarwal <[email protected]> wrote: > Hi, > I have created a simple User Define Function (namely "my_lower" which > converts all the characters of input text to lower case and return the > modified text). I have to register this function every time after staring > Hive using command "create temporary function my_lower as > 'com.example.hive.udf.Lower"; > > Can someone help to solve this problem,so that I don't have to register UDF > every time after starting Hive; > > Thanking You > Mohan Agarwa >
