[jira] [Created] (HIVE-10625) Handle Authorization for 'select ' hive queries in SQL Standard Authorization

["Nemon Lou (JIRA)" <ji...@apache.org>]

Nemon Lou created HIVE-10625:
--------------------------------

             Summary: Handle Authorization for  'select <expr>' hive queries in  SQL Standard Authorization
                 Key: HIVE-10625
                 URL: https://issues.apache.org/jira/browse/HIVE-10625
             Project: Hive
          Issue Type: Bug
          Components: Authorization, SQLStandardAuthorization
    Affects Versions: 1.1.0
            Reporter: Nemon Lou


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 :
{code}
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)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)