hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nuthan Reddy Gantla (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-13663) Create UDFs using existing functions in Hive instead from JAR files
Date Sun, 01 May 2016 07:08:13 GMT
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)

Mime
View raw message