Differences

This shows you the differences between two versions of the page.

--- kb:bigdata:hive [2017/11/26 16:30] – created yehuda
+++ kb:bigdata:hive [2018/05/08 12:44] – yehuda
@@ Line 1: / Line 1: @@
+===== ADDING UDFs =====
+<code sql>
+grant all on uri 'file:///opt/local/hive/lib/tex*********t.jar' to role etl_ops
+drop function etl_db.test_yehuda_hash
+create function etl_db.test_yehuda_hash as 'com.*******HashMultiParamsUDF'
+using jar 'hdfs:///data_lake/udfs/tex***.jar';
+select et2l_db.test_yehuda_hash("test","a")
+</code>
 ===== Migrate CSV to hive table =====
 <code sql>

kb/bigdata/hive.txt · Last modified: 2022/01/03 16:03 by 127.0.0.1

Back to top