Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-26259

Alter Function does not update resource uris

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.1.2
    • None
    • Hive

    Description

      Bug Description:
      The jar of Hive permanent UDF can be loaded based on the resource uris, but we encountered an issue after changing the resource uris through spark-sql:

      CREATE OR REPLACE FUNCTION test_db.test_udf AS 'com.xxx.xxx'
      USING JAR 'hdfs://path/to/jar';
      

      Then when we use the UDF `test_db.test_udf`, an error occured like this:

      Error in query: Can not load class 'com.xxx.xxx' when registering the function 'test_db.test_udf'...
      

      Root Cause:
      Hive metastore does not update resource uris while executing `alter_function()`, which should be included and will not make any side effect.

      Attachments

        Issue Links

          Activity

            People

              wechar Wechar
              wechar Wechar
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h 40m
                  1h 40m