点击关注上方“知了小巷”,
设为“置顶或星标”,第一时间送达干货。
Impala使用md5函数对数据加密
Hive提供了一些常用的UDF
函数,源码位置如图:
org.apache.hadoop.hive.ql.udf.UDFMd5.java
/**
* UDFMd5.
* 如需自定义UDF,继承UDF并重写evaluate方法;不过UDF已经@Deprecated
* 建议集成抽象类GenericUDF,比如public class UDFYear extends GenericUDF {...}
*/
@Description(name = "md5",
value = "_FUNC_(str or bin) - Calculates an MD5 128-bit checksum for the string or binary.",
extended = "The value is returned as a string of 32 hex digits, or NULL if the argument was NULL.\n"
+ "Example:\n"
+ " > SELECT _FUNC_('ABC');\n"
+ " '902fbdd2b1df0c4f70b4a5d23525e932'\n"
+ " > SELECT _FUNC_(binary('ABC'));\n"
+ " '902fbdd2b1df0c4f70b4a5d23525e932'")
public class UDFMd5 extends UDF {
private final Text result = new Text();
private final MessageDigest digest;
public UDFMd5