If there is proper authentication mechanism, you can access the user information and query plan in HookContext. And with some tricky way, it's possible to find if the query is select * or not.
But if it's not the case(no authentication) and cannot control login name of hive JDBC, hook might not that helpful. Thanks, Navis 2014-07-22 4:12 GMT+09:00 sai chaitanya tirumerla <tirume...@gmail.com>: > Hi Navis, > > Thank you so much for the information.I'm newbie to hooks in hive , could > you please let me know how we can implement hooks for restricting users and > do we have any reference/examples to look at. > > Thanks, > > Sai > > > On Sun, Jul 20, 2014 at 9:23 PM, Navis류승우 <navis....@nexr.com> wrote: > >> You can implement that in Hook and register in hive-site.xml. >> >> Thanks, >> Navis >> >> >> 2014-07-19 17:32 GMT+09:00 sai chaitanya tirumerla <tirume...@gmail.com>: >> >> Hi, >>> >>> I would like to restrict users doing >>> "select * from table;" when accessed from any jdbc/odbc tools like sql >>> workbench/excel etc.. connecting to hiveserver2 on port 10000. I am able to >>> successfully restrict users from running mapreduce jobs like "select >>> count(*) from table" by changing permissions on tmp directory on hdfs >>> allowing only certain users to access. >>> I have tried using SQL based authorization but it is introduced in hive >>> 0.13 and the version i am currently on is hive 0.11. >>> I have also tried using hive client authorization which works only for >>> hive cli but not hiveserver2 when connected from jdbc/odbc tools as the >>> connection is done via the default user. >>> >>> So is there any way that we can restrict users accessing the data ( >>> select * from table )? >>> >>> Thanks in Advance!! >>> >>> ---sai--- >>> >> >> >
