hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Smit Shah <>
Subject Force users to specify partition indexes in queries
Date Tue, 29 Sep 2015 17:56:35 GMT

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.


View raw message