question Re: Hive in-built functions in Archives of Support Questions (Read Only)

Hive in-built functions

avinashrpds7 — Tue, 14 Jun 2016 18:05:44 GMT

We are planning to migrate from HAWQ to Hive. HAWQ has 2000+ in-built functions and in existing code around 400+ in-built functions are used. We have a task to make all 400+ available in HIVE and noticed only 150+ are available in HIVE sanbox environment we are using. We noticed below URL has few, which we deployed in Hive and are working as expected.

https://github.com/brndnmtthws/facebook-hive-udfs/tree/master/src/main/java/com/facebook/hive/udf

Please share any opensource repositories like above URL where we can find code of UDFs and use them directly.

Re: Hive in-built functions

bleonhardi — Tue, 14 Jun 2016 19:25:51 GMT

Thanks for the facebook link, never used it before. I like the brickhouse ones:

https://github.com/klout/brickhouse

Re: Hive in-built functions

TimothySpann — Tue, 14 Jun 2016 20:48:59 GMT

There are a lot of Hive UDF Libraries

https://github.com/nexr/hive-udf/wiki

https://github.com/sharethrough/hive-udfs

https://github.com/yahoo/hive-funnel-udf

https://github.com/livingsocial/HiveSwarm

Hive UDF with Yahoo Data sketches

http://datasketches.github.io/docs/Theta/ThetaHiveUDFs.html

Re: Hive in-built functions

TimothySpann — Tue, 14 Jun 2016 22:14:41 GMT

Hive UDFs Similar to Oracle Funcitons

https://github.com/nexr/hive-udf/wiki