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

hive sql std auth select query fails on partitioned tables

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 0.13.0
    • 0.13.1, 0.14.0
    • Authorization
    • None

    Description

      analyze table studentparttab30k partition (ds) compute statistics;
Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied. Principal [name=hadoopqa, type=USER] does not have following privileges on Object [type=PARTITION, name=null] : [SELECT] (state=42000,code=40000)

      Sql std auth is supposed to ignore partition level objects for privilege checks, but that is not working as intended.

      Attachments

        1. HIVE-6919.1.patch
          8 kB
          Thejas Nair

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. HIVE-5837 SQL standard based secure authorization for hive

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link review board

          Activity

            People

              thejas Thejas Nair
              thejas Thejas Nair
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: