[
https://issues.apache.org/jira/browse/HIVE-5931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13924779#comment-13924779
]
Thejas M Nair commented on HIVE-5931:
-------------------------------------
I am working on adding support for the describe role syntax as well, as part of
this jira.
But there is a problem, the current describe table syntax allows the following -
{code}
DESCRIBE t1 key1;
DESCRIBE EXTENDED t1 key1;
{code}
In hive, almost all keywords are also identifiers . So "describe role
<rolename>" also gets translated to a describe table command with "role" as
table name and "<rolename>" as a column.
This is not a documented syntax AFAIK, but we do have .q tests for it and it
would break backward compatibility.The documented syntax requires a dot
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Describe
. Dot became optional with HIVE-1977 . Since there are tests added as part of
the patch that use this format, it looks like the change was intentional.
I will look at syntax alternatives to 'describe role'.
> SQL std auth - add metastore get_role_participants api - to support DESCRIBE
> ROLE
> ---------------------------------------------------------------------------------
>
> Key: HIVE-5931
> URL: https://issues.apache.org/jira/browse/HIVE-5931
> Project: Hive
> Issue Type: Sub-task
> Components: Authorization
> Reporter: Thejas M Nair
> Attachments: HIVE-5931.thriftapi.2.patch,
> HIVE-5931.thriftapi.3.patch, HIVE-5931.thriftapi.followup.patch,
> HIVE-5931.thriftapi.patch
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> This is necessary for DESCRIBE ROLE role statement. This will list
> all users and roles that participate in a role.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
