Nuthan Reddy Gantla created HIVE-13663:
------------------------------------------

             Summary: 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


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)

Reply via email to