hive.exec.dynamic.partition.mode=strict ,seems does the same thing.
From: Ashutosh Chauhan Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" Date: Tuesday, September 29, 2015 at 1:48 PM To: "user@hive.apache.org<mailto:user@hive.apache.org>" Subject: Re: Force users to specify partition indexes in queries 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<mailto: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
