2017-11-16T10:27:16,258 ERROR [Thread-9]: util.PolicyRefresher ()) - PolicyRefresher(serviceName=hivedev): failed to refresh policies. Will continue to use last known version of policies (14) com.sun.jersey.api.client.ClientHandlerException: java.net.ConnectException: Connection refused
This one i fixed yes there is mistake in configuration RANGER ADMIN URL is wrong if fixed it. Now its gone but while executing a query i am getting this beeline > select * from ranger_testing_db.mock_table; Error: Error running query: java.lang.AbstractMethodError: org.apache.ranger.authorization.hive.authorizer.RangerHiveAuthorizer.needTransform()Z (state=,code=0) hiveserver2.log 2017-11-16T21:27:52,145 INFO [HiveServer2-Handler-Pool: Thread-48]: session.SessionState (:()) - Resetting thread name to HiveServer2-Handler-Pool: Thread-48 2017-11-16T21:27:52,145 WARN [HiveServer2-Handler-Pool: Thread-48]: thrift.ThriftCLIService (:()) - Error executing statement: org.apache.hive.service.cli.HiveSQLException: Error running query: java.lang.AbstractMethodError: org.apache.ranger.authorization.hive.authorizer.RangerHiveAuthorizer.needTransform()Z at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:218) at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:269) at org.apache.hive.service.cli.operation.Operation.run(Operation.java:324) at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:467) at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:454) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78) at org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36) at org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59) at com.sun.proxy.$Proxy45.executeStatementAsync(Unknown Source) at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:295) at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:498) at org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1437) at org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1422) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.AbstractMethodError: org.apache.ranger.authorization.hive.authorizer.RangerHiveAuthorizer.needTransform()Z at org.apache.hadoop.hive.ql.parse.TableMask.needTransform(TableMask.java:81) at org.apache.hadoop.hive.ql.parse.TableMask.<init>(TableMask.java:60) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:10691) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10758) at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:239) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:250) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:440) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:332) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1179) at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1148) at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:184) ... 27 more 2017-11-16T21:27:56,133 INFO [Thread-9]: util.PolicyRefresher (:()) - PolicyRefresher(serviceName=hivedev): found updated version. lastKnownVersion=4; newVersion=5 Thanks & Regards Amithsha On Thu, Nov 16, 2017 at 9:09 PM, Amith sha <amithsh...@gmail.com> wrote: > also i want to know how its communicating with hiveserver2 by the user > called *admin* (default by ranger ) > Because in my setup all hadoop users can connect to the hive server via > passwordless login. > > > > > Thanks & Regards > Amithsha > > On Thu, Nov 16, 2017 at 8:57 PM, Amith sha <amithsh...@gmail.com> wrote: > >> Hi all, >> >> hive version is 2.1 >> And i deleted and recreated still same error. >> After uninstalling the ranger hive plugin i can see beeline working >> >> >> >> Thanks & Regards >> Amithsha >> >> On Thu, Nov 16, 2017 at 12:01 PM, Taher Koitawala < >> taher.koitaw...@gslab.com> wrote: >> >>> Hi Amith, >>> Can you try recreating the the plugin in the Ranger webui? >>> When you remove the ranger plugin from the webui. Ranger will remove all >>> the auth from hive. Then try if you can login to beeline with your creds. >>> If you can then again go to the ranger webui and add the hive plugin again. >>> This will enforce a complete new set of policies. Also can you see the >>> ranger hive plugin status as active in the services tab?? >>> >>> Regards, >>> Taher Koitawala >>> >>> On Thu, Nov 16, 2017 at 10:34 AM, Amith sha <amithsh...@gmail.com> >>> wrote: >>> >>>> >>>> https://issues.apache.org/jira/browse/RANGER-1892 >>>> >>>> Thanks & Regards >>>> Amithsha >>>> >>> >>> >> >
