1.1自定义函数

  1. <dependencies>
  2. <!-- https://mvnrepository.com/artifact/org.apache.hive/hive-exec -->
  3. <dependency>
  4. <groupId>org.apache.hive</groupId>
  5. <artifactId>hive-exec</artifactId>
  6. <version>1.2.1</version>
  7. </dependency>
  8. </dependencies>
  9. 代码参考

代码参考
add jar /opt/module/datas/udf.jar;
create temporary function mylower as “com.atguigu.hive.Lower”;
select ename, mylower(ename) lowername from emp;
2.1压缩