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--- >> > >
