> If this is not doable in Hive at the moment, I am interested in writing >a patch for it. I am not familiar with hive codebase so not sure how >complex this is. Any hints or tips would be great and if I do need to >write such a patch, I would be happy to contribute back to the source.
There are execution hooks in hive, which can be used to walk the operator tree & look for a TableScan operator. Here's an example of me doing something really horrible with a hook https://github.com/t3rmin4t0r/captain-hook You can have your hive hook look up the table + filter clause & then deny a query. Cheers, Gopal