hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alan Gates <>
Subject Re: Hive SQL based authorization don't have support for group
Date Thu, 12 May 2016 17:09:43 GMT
By group here I assume you mean posix style file group (from HDFS)?  No, there isn’t any
connection right now.  We’d like to be able to pick up groups from HDFS and define those
as roles in Hive, but we haven’t added that feature.

You’ll need to define a role that includes the members of that group.


> On May 12, 2016, at 02:01, kumar r <> wrote:
> Hi,
> I have configured hive-1.2.1 with Hadoop-2.7.2. I have enabled SQL standard based authorization.
> I can give permission for user or roles. i cannot find any option for groups.
> Is there any feature available for group permission on Hive SQL standard based authorization?
> When i am trying to execute below command getting exception,
> grant select on sample to group Testing;
> Exception
> Error: Error while processing statement: FAILED: Execution Error, return 
> code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Invalid principal     
> type in principal Principal [name=Testing, type=GROUP] (state=08S01,code=1)
> Stack overflow question: 
> Thanks,
> Kumar

View raw message