> create function my_length(string) returns int location '/tmp/hive-exec-1.1.0-cdh5.4.7.jar' symbol='org.apache.hadoop.hive.ql.udf.UDFLength';
Query: create function my_length(string) returns int location '/tmp/hive-exec-1.1.0-cdh5.4.7.jar' symbol='org.apache.hadoop.hive.ql.udf.UDFLength'
Fetched 0 row(s) in 0.03s
> select my_length('abcde') ;
Query: select my_length('abcde')
+----------------------------+
| default.my_length('abcde') |
+----------------------------+
| 5 |
+----------------------------+
Fetched 1 row(s) in 0.01s
> create function get_json_object(string, string) returns string location '/tmp/hive-exec-1.1.0-cdh5.4.7.jar' symbol='org.apache.hadoop.hive.ql.udf.UDFJson';
Query: create function get_json_object(string, string) returns string location '/tmp/hive-exec-1.1.0-cdh5.4.7.jar' symbol='org.apache.hadoop.hive.ql.udf.UDFJson'
Fetched 0 row(s) in 0.02s
> select get_json_object('{"a":"b"}', '$.a') ;
Query: select get_json_object('{"a":"b"}', '$.a')
+---------------------------------------------+
| default.get_json_object('{"a":"b"}', '$.a') |
+---------------------------------------------+
| b |
+---------------------------------------------+
> create function my_base64(string) returns string location '/tmp/hive-exec-1.1.0-cdh5.4.7.jar' symbol='org.apache.hadoop.hive.ql.udf.UDFBase64';
Query: create function my_base64(string) returns string location '/tmp/hive-exec-1.1.0-cdh5.4.7.jar' symbol='org.apache.hadoop.hive.ql.udf.UDFBase64'
Fetched 0 row(s) in 0.03s
> select my_base64('abcde') ;
Query: select my_base64('abcde')
+----------------------------+
| default.my_base64('abcde') |
+----------------------------+
| YWJjZGU= |
+----------------------------+
Fetched 1 row(s) in 0.15s