Re: Hive Authorization and Views

2013-05-16 Thread John Omernik
> Reply-To: "user@hive.apache.org" > Date: Thursday, May 16, 2013 2:05 PM > To: "user@hive.apache.org" > Subject: Re: Hive Authorization and Views > > The largest issue is that the RDBMS security model does not match with > hive. Hive/Hadoop has file

Re: Hive Authorization and Views

2013-05-16 Thread Sanjay Subramanian
e.org>" mailto:user@hive.apache.org>> Subject: Re: Hive Authorization and Views The largest issue is that the RDBMS security model does not match with hive. Hive/Hadoop has file permissions, RDMBS have column and sometimes row level permissions. When you physically have access to th

Re: Hive Authorization and Views

2013-05-16 Thread Edward Capriolo
The largest issue is that the RDBMS security model does not match with hive. Hive/Hadoop has file permissions, RDMBS have column and sometimes row level permissions. When you physically have access to the underlying file (row level) permissions are not enforceable. The only way to enforce this typ

Re: Hive Authorization and Views

2013-05-16 Thread John Omernik
I am curious on the thoughts of the community here, this seems like something many enterprises would drool over with Hive... I am not a coder so the level coding involved something like this is unknown. On Sat, May 4, 2013 at 8:31 AM, John Omernik wrote: > We were doing some tests this past wee

Hive Authorization and Views

2013-05-04 Thread John Omernik
We were doing some tests this past week with hive authorization, one of our current use "challenges" is when we have an underlying, well managed and partitioned table, and we want to allow access to certain columns in that table. Our first thoughts went to VIEWs as that's a common use case with Re