hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thejas M Nair (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5931) SQL std auth - add metastore get_role_participants api - to support DESCRIBE ROLE
Date Sat, 08 Mar 2014 09:47:43 GMT

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

Mime
View raw message