Dropping a UDF function that is the same as an internal function? substr


Hadoop Eco System Forums Hadoop Discussion Forum Dropping a UDF function that is the same as an internal function? substr

This topic contains 0 replies, has 1 voice, and was last updated by  Daryl 7 months, 2 weeks ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #11792

    Daryl

    The function was created using:

    CREATE FUNCTION substr AS ‘com.nexr.platform.hive.udf.UDFSubstrForOracle’ USING JAR ‘hdfs:///user/bbm_analytics_app/nexr-hive-udf-0.2-SNAPSHOT.jar’;

    It worked fine for months but now is giving problems so I want to drop it as I dont think it was really needed. I cant drop it.

    use mygroup;
    drop function substr;
    drop function mygroup.substr;
    show functions; <-Always shows it but not sure if its the UDF or the built in one.

    I get the error when I use it via hiveserver2.
    mpala.error.HiveServer2Error: Error while compiling statement: FAILED: SemanticException [Error 10014]: Line 1:7 Wrong arguments ’10’: The UDF implementation class ‘com.nexr.platform.hive.udf.UDFSubstrForOracle’ is not present in the class path.

    How to drop it or perhaps I can correct the above error.
    We are stumped here…

    Thanks

    Daryl

Viewing 1 post (of 1 total)

The forum ‘Hadoop Discussion Forum’ is closed to new topics and replies.

Review Comments
default image

I am a plsql developer. Intrested to move into bigdata.

Neetika Singh ITA Hadoop in Dec/2016 December 22, 2016

.