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

Row Filtering in Hive

Row Filtering in Hive




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.


Any help would be greatly appreciated!