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

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

     [ https://issues.apache.org/jira/browse/HIVE-10625?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nemon Lou resolved HIVE-10625.
------------------------------
    Resolution: Duplicate

Same work is going on at HIVE-11498,so close this one.

> 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)