Re: Help on restricting users

2014-07-21 Thread Navis류승우
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 th

Re: Help on restricting users

2014-07-21 Thread sai chaitanya tirumerla
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류승우 wrote: > You can implement that

Re: Help on restricting users

2014-07-20 Thread Navis류승우
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 : > 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 hiveserv

Help on restricting users

2014-07-19 Thread sai chaitanya tirumerla
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 1. I am able to successfully restrict users from running mapreduce jobs like "select count(*) from table" by changing permissi