[
https://issues.apache.org/jira/browse/HIVE-10625?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nemon Lou updated HIVE-10625:
-----------------------------
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 :
{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}
was:
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}
> 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)
