获取系统当前时间:
package com.zjs.udf;
import org.apache.hadoop.hive.ql.exec.UDF;
import java.text.SimpleDateFormat;
import java.util.Date;
/**
* Created by Administrator on 2017/8/2.
*/
public class now extends UDF{
public String evaluate(){
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
return df.format(new Date());
}
}
添加jar包路径:
hive> add jar /home/inf/zhangjishuai/udf/udf_now.jar;
创建函数:
hive> create temporary function now as 'com.zjs.udf.now';
测试:
select now();
OK
2017-08-02 11:13:35
Time taken: 0.361 seconds, Fetched: 1 row(s)