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

Handle Authorization for 'select <expr>' hive queries in SQL Standard Authorization

    XMLWordPrintableJSON

Details

    Description

      Hive internally rewrites this 'select <expression>' query into 'select <expression> from _dummy_database._dummy_table', where these dummy db and table are temp entities for the current query.
      The SQL Standard Authorization need to handle these special objects.

      Typing "select reverse("123");" in beeline,will get this error :

      Error: Error while compiling statement: FAILED: HiveAuthzPluginException Error getting object from metastore for Object [type=TABLE_OR_VIEW, name=_dummy_database._dummy_table] (state=42000,code=40000)
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              nemon Nemon Lou
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: