[HIVE-13663] Create UDFs using existing functions in Hive instead from JAR files

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Abandoned
• Component/s: UDF
• Labels: features
• Assignee: Jason Dere
• Reporter: Nuthan Reddy Gantla
• Created: 01/May/16 07:07
• Updated: 01/Jun/20 14:20
• Resolved: 01/Jun/20 14:20

Description

Recently i came across
FIRST_DAY_OF_YEAR UDF in SQL which returns Jan 1st of that year.

This could be made simply using existing functions in Hive as
suppose our input date is '2016-03-04'
concat(Year('2016-03-04'),'-01-01')

instead of loading a JAR file. And moreover i guess using JAR has less performance when compared to the above implementation.

We can also use UDFs for hiding complex functions from our query which makes it more readable.

Kindly let me know if i'm wrong about performance.

Issue Links

• is depended upon by: HIVE-19842 Improve Hive UDF/SerDe Usability