一、删除语法
DROP FUNCTION IF EXISTS
${FUNCTION_DB}.${FUNCTION_NAME}
;
样例:
DROP FUNCTION IF EXISTS stage.name_format;
二、添加语法
CREATE FUNCTION ${FUNCTION_DB}.${FUNCTION_NAME} AS '${FULL_PATH_PACKAGE}.${UDF_CLASS_NAME}' using jar '${HDFS_JAR_PATH}';
样例:
A).
对于 非ha的Hadoop集群 |
CREATE FUNCTION stage.name_format AS ‘com.david.PatternUDF’ using jar ‘hdfs://
nn1.hadoop.com:8020
/user/hive/udf/UDFUtil-1.0-SNAPSHOT.jar’;
B).
对于 ha的Hadoop集群 |
CREATE FUNCTION stage.name_format AS ‘com.david.PatternUDF’ using jar ‘hdfs://
nameservice1
/user/hive/udf/UDFUtil-1.0-SNAPSHOT.jar’;