Differences

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

Link to this comparison view

kb:bigdata:hive [2017/11/26 16:30]
yehuda created
kb:bigdata:hive [2018/05/08 12:44] (current)
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 ===== ===== Migrate CSV to hive table =====
 <code sql> <code sql>
kb/bigdata/hive.txt ยท Last modified: 2018/05/08 12:44 by yehuda
Back to top
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0