Force users to specify partition indexes in queries

2015-09-29 Thread Smit Shah
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 i

Re: Force users to specify partition indexes in queries

2015-09-29 Thread Gopal Vijayaraghavan
> 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

Re: Force users to specify partition indexes in queries

2015-09-29 Thread Ashutosh Chauhan
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 wrote: > Hey, > > We have exposed hive console to our org via command line and through Hue > ui. However, we are currently facing issues

Re: Force users to specify partition indexes in queries

2015-09-29 Thread Sathi Chowdhury
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>" Sub

Re: Force users to specify partition indexes in queries

2015-09-30 Thread Smit Shah
gt; > > From: Ashutosh Chauhan > Reply-To: "user@hive.apache.org" > Date: Tuesday, September 29, 2015 at 1:48 PM > To: "user@hive.apache.org" > Subject: Re: Force users to specify partition indexes in queries > > set hive.mapred.mode = strict; > Thi

Re: Force users to specify partition indexes in queries

2015-09-30 Thread Ashutosh Chauhan
m: Ashutosh Chauhan >> Reply-To: "user@hive.apache.org" >> Date: Tuesday, September 29, 2015 at 1:48 PM >> To: "user@hive.apache.org" >> Subject: Re: Force users to specify partition indexes in queries >> >> set hive.mapred.mode = strict; >&g