set hive.mapred.mode = strict; This will fail query if query doesnt specify filter containing partitioning column.
On Tue, Sep 29, 2015 at 10:56 AM, Smit Shah <who...@gmail.com> wrote: > Hey, > > We have exposed hive console to our org via command line and through Hue > ui. However, we are currently facing issues when user runs a blanket select > or insert query from table without specifying partition indexes. > > I wanted to know if its possible to enforce users to provide partition > index in queries or fail otherwise. (Our partition indexes are date and > time). Also, if that's possible we also want to restrict the range of date > to 2 days so no malicious user can effect the cluster availability by > querying for months worth of data. > > > 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. > > > Regards, > Smit >
