Hive in-built functions

[#1]

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.

[#2]

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

https://github.com/klout/brickhouse

[#3 · Accepted solution]

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

[#4]

Hive UDFs Similar to Oracle Funcitons

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