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

No ADMIN PRIVILEGE need for creating and dropping temporary function.

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 0.13.1, 1.1.0
    • None
    • None

    Description

      SQLStandardAuthorization require ADMIN PRIVILEGE need for creating and dropping temporary function as the following:

      > create function example_add AS 'org.apache.hadoop.hive.contrib.udf.example.UDFExampleAdd';
      Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: Principal [name=admin, type=USER] does not have following privileges for operation CREATEFUNCTION [[ADMIN PRIVILEGE] on Object [type=DATABASE, name=default], [ADMIN PRIVILEGE] on Object [type=FUNCTION, name=default.example_add]] (state=42000,code=40000)

      > drop function example_add;
      Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: Principal [name=admin, type=USER] does not have following privileges for operation DROPFUNCTION [[ADMIN PRIVILEGE] on Object [type=DATABASE, name=default], [ADMIN PRIVILEGE] on Object [type=FUNCTION, name=default.example_add]] (state=42000,code=40000)

      But we think it is unnecessary to create and drop temporary function.

      Attachments

        1. HIVE-11899-01.patch
          4 kB
          Hison Huang

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Hison Huang Hison Huang Assign to me
            Hison Huang Hison Huang

            Dates

              Created:
              Updated:

              Slack

                Issue deployment