Support Questions
Find answers, ask questions, and share your expertise

Row Filtering in Hive

Row Filtering in Hive

Explorer

Hi,

 

I have been exploring Sentry as the authorizing service for users to access data stored in hive tables. One feature, which I would have liked to see is row level filtering. Perhaps a user has access to a table, but perhaps they should not be able to access all the rows in the table. This can be achived by using a table view, which only contains the rows the user can access. However, this solution is not efficient, nor maintainable. Is there any other way that this can be achieved?

 

I was reading a blog post that made it sound that this could be accomplished with Sentry + RecordService, but I have yet to see an example of this in action.

 

http://blog.cloudera.com/blog/2015/09/recordservice-for-fine-grained-security-enforcement-across-the...

 

Any help would be greatly appreciated!