1.UDF中没有引用其他资源文件
Hive UDF 函数,写完后打成jar包。放到指定目录下
例如:/home/hadoop/udf/
并且在该目录下启动hive cli 执行
add jar /home/hadoop/udf/timeOffset.jar
create temporary function timeOffset(time) as 'cn.gitv.analysis.TimeOffset'
之后就可以用了,没有路径问题
当然你也可以将jar文件,上传到hdfs的某个目录中
add jar hdfs://nameservice1/udf/timeOffset.jar (nameservice1 是dfs集群名称)
create temporary function timeOffset(time) as 'cn.gitv.analysis.TimeOffset'
同样没有路径问题
2.UDF中引用了其他资源文件
package cn.gitv.bi.log.analysis.udf;
import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.util.Hashtable;
import org.apache.hadoop.hive.ql.exec.Description;
import org.apache.hadoop.hive.ql.exec.UDFArgumentException;
import org.apache.hadoop.hive.ql.exec.UDFArgumentLengthException;
import org.apache.hadoop.hive.ql.metadata.HiveException;
import org.apache.hadoop.hive.ql.udf.generic.GenericUDF;
import org.apache.hadoop.hive.serde2.objectinspector.ObjectInspector;
import org.apache.hadoop.hive.serde2.objectinspector.primitive.PrimitiveObjectInspectorFactory;
import org.apache.hadoop.hive.serde2.objectinspector.primitive.StringObjectInspector;
@Description(
name="loc 2 id",
value="_FUNC_(string arg1, string arg2) - input two string",
extended="return the MAC corresponding to arg1 and arg2 \n" +
"Example:\n" +
"> SELECT _FUNC_(