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 [2022/01/03 16:03] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== Quick code ======
+<code sql>
+set hive.execution.engine=mr;
+set hive.execution.engine=tez;
+</code>
+<code bash>
+hive --hiveconf hive.root.logger=DEBUG,console
+</code>
+===== 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.1511713801.txt.gz · Last modified: 2022/01/03 16:03 (external edit)

Back to top