hive> create temporary function iptocc as 'com.wct.hive.udf.IptoccUDF';
hive> select iptocc(t.col1) from t limit 10;
hive> drop temporary function iptocc;
第2种永久注册hiveudf。
hive> CREATE FUNCTION dimdb.IPTocc AS 'com.wtr.hiveipudf.IPToCCProCity' using jar 'hdfs://hdfs-ha/user/hive/udf/iptocc_keyid.jar', file 'hdfs://hdfs-ha/user/hive/udf/ip_area_keyid.txt';