1. 刪除原函數(shù)和jar包

1.1 在hive窗口e中執(zhí)行刪除原函數(shù)

hive>DROP FUNCTION msgloanappsproc;

1.2 在beeline中執(zhí)行刪除jar包

hive (default)>  list jars;
/tmp/448a59e7-5ef8-4b76-8eed-ba04c73e126a_resources/udf-1.0.jar
hive (default)> delete jar hdfs:///user/hive/warehouse/extlib/udf-1.0.jar;
hive (default)>  list jars;
/tmp/448a59e7-5ef8-4b76-8eed-ba04c73e126a_resources/udf-1.0.jar
hive (default)> delete jar /tmp/448a59e7-5ef8-4b76-8eed-ba04c73e126a_resources/udf-1.0.jar;
Deleted [/tmp/448a59e7-5ef8-4b76-8eed-ba04c73e126a_resources/udf-1.0.jar] from class path
hive (default)>  list jars;
hive (default)> 

1.3 從hdfs上刪除jar包

hdfs dfs -rm -f -skipTrash /user/hive/warehouse/extlib/udf-1.0.jar

2 重新上傳jar包，注冊(cè)函數(shù)

2.1 上傳新的jar包到hdfs

hdfs dfs -put -f  /home/hadoop/shell/udf/udf-1.0.jar /user/hive/warehouse/extlib/

2.2 在hive窗口中執(zhí)行添加jar包

hive> add jar hdfs:///user/hive/warehouse/extlib/udf-1.0.jar;

2.3 在hive窗口中執(zhí)行注冊(cè)永久函數(shù)

hive> create function msgloanappsproc as "udf_ltf.MsgLoanAppsProc" using jar 'hdfs:///user/hive/warehouse/extlib/udf-1.0.jar';

2.4 在hive窗口中查看結(jié)果

hive>show functions like '*Proc';

3 重啟所有節(jié)點(diǎn)的hive server服務(wù)，UDF生效。