HIVＥ自定义函数 UDF
自定义my_md5hash
具体hive源码怎么调用看我另外一篇博客
package udf.hive.myudf; import org.apache.commons.codec.digest.DigestUtils;
import org.apache.hadoop.hive.ql.exec.Description;
import org.apache.hadoop.hive.ql.exec.UDF; @Description(name="my_md5hash", value="md5")
public class MyUdf extends UDF{
public String evaluate(String in) {
return DigestUtils.md5Hex(in);
} }
mvn打包
add JAR /home/cloudera/Desktop/myudf-0.0.3-SNAPSHOT.jar;
CREATE TEMPORARY FUNCTION my_md5hash AS 'udf.hive.myudf.MyUdf';
数据
hive> add JAR /home/cloudera/Desktop/myudf-0.0.3-SNAPSHOT.jar;
Added [/home/cloudera/Desktop/myudf-0.0.3-SNAPSHOT.jar] to class path
Added resources: [/home/cloudera/Desktop/myudf-0.0.3-SNAPSHOT.jar]
hive> CREATE TEMPORARY FUNCTION my_md5hash AS 'udf.hive.myudf.MyUdf';
OK
Time taken: 0.06 seconds
hive> select * from prouct
> ;
OK
1 coco 3.0
2 hamburg 18.0
3 chips 8.0
4 tea 10.0
hive> select my_md5hash(name) from prouct;
OK
ac0ddf9e65d57b6a56b2453386cd5db5
f23bb5e2f7d35c767b40eddd42ac0e08
19136e394ab695f9b071eb24e88ab14d
7239ea2b5dc943f61f3c0a0276c20974
Time taken: 0.433 seconds, Fetched: 4 row(s)
最新文章
- 了解HTML图像
- How to create a Python dictionary with double quotes as default quote format?
- org.hibernate.exception.SQLGrammarException: could not execute query
- 优化MySQL数据库性能的八大方法
- JAVA06数组之动手动脑问题解决
- 在GitHub注册账户的过程
- quick-cocos2d-x 接入支付宝（android）(转，待验证)
- C#获取程序所在目录路径
- 仿《雷霆战机》飞行射击手游开发--GameObject
- Codeforces 603A Alternative Thinking
- Dynamic Programming - leetcode [动态规划]
- 提高MySQL查询速度
- SpringMVC 环境搭建（HelloWorld）
- 对N各集合中的任意元素进行排列组合问题
- Zabbix （五）
- Comparison method violates its general contract 解决
- python+selenium：点击页面元素时报错：WebDriverException: Message: Element is not clickable at point (1372.5, 9.5). Other element would receive the click: <li style="display: list-item;" id="tuanbox"></li>
- Linux-TCP 出现 RST 的几种情况
- bootstrap中如何控制input的宽度
- 搭建互联网架构学习--004--centos安装Mysql