[ https://issues.apache.org/jira/browse/HIVE-13663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nuthan Reddy Gantla updated HIVE-13663: --------------------------------------- Labels: features newbie (was: newbie) > Create UDFs using existing functions in Hive instead from JAR files > ------------------------------------------------------------------- > > Key: HIVE-13663 > URL: https://issues.apache.org/jira/browse/HIVE-13663 > Project: Hive > Issue Type: Improvement > Components: UDF > Reporter: Nuthan Reddy Gantla > Assignee: Jason Dere > Priority: Minor > Labels: features, newbie > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)