hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashutosh Chauhan <ashutosh.chau...@gmail.com>
Subject Re: Force users to specify partition indexes in queries
Date Tue, 29 Sep 2015 20:48:19 GMT
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 <who828@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
>

Mime
View raw message