11.4 impala自定义永久函数及hive自定义函数在cdh hue中使用

演示转大小写的函数

1.编写类并打包

2.上传到hdfs上

/user/hive/udf/hive_udf-1.0-SNAPSHOT.jar

3.使用impala创建函数并执行

[mini2:21000] default> create function mylower(string) returns string location '/user/hive/udf/hive_udf-1.0-SNAPSHOT.jar' symbol='Lower';
Query: create function mylower(string) returns string location '/user/hive/udf/hive_udf-1.0-SNAPSHOT.jar' symbol='Lower'
+----------------------------+
| summary                    |
+----------------------------+
| Function has been created. |
+----------------------------+
Fetched 1 row(s) in 0.52s
[mini2:21000] default> show functions;
Query: show functions
+-------------+-----------------+-------------+---------------+
| return type | signature       | binary type | is persistent |
+-------------+-----------------+-------------+---------------+
| STRING      | mylower(STRING) | JAVA        | false         |
+-------------+-----------------+-------------+---------------+
Fetched 1 row(s) in 0.00s
[mini2:21000] default> select mylower('DDD')
                     > ;
Query: select mylower('DDD')
Query submitted at: 2019-08-01 13:50:34 (Coordinator: http://mini2:25000)
Query progress can be monitored at: http://mini2:25000/query_plan?query_id=f840890a9cf3253b:f0a6505300000000
+------------------------+
| default.mylower('ddd') |
+------------------------+
| ddd                    |
+------------------------+
Fetched 1 row(s) in 0.45s

------------------------------------------------------------

在hue中使用