@ramesh yes i am suspecting the same some jar is missing here is the list of jars available under hive lib for ranger
ranger-hive-plugin-shim-0.7.0.2.6.2.0-205.jar ranger-plugin-classloader-0.7.0.2.6.2.0-205.jar ranger-hive-plugin-impl: eclipselink-2.5.2.jar httpcore-4.4.4.jar mysql-connector-java.jar ranger-plugins-audit-0.7.0.2.6.2.0-205.jar solr-solrj-5.5.1.jar gson-2.2.4.jar httpmime-4.5.2.jar noggit-0.6.jar ranger-plugins-common-0.7.0.2.6.2.0-205.jar httpclient-4.5.1.jar javax.persistence-2.1.0.jar ranger-hive-plugin-0.7.0.2.6.2.0-205.jar ranger-plugins-cred-0.7.0.2.6.2.0-205.jar Thanks & Regards Amithsha On Thu, Nov 16, 2017 at 9:29 PM, Amith sha <amithsh...@gmail.com> wrote: > 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 >>>>> >>>> >>>> >>> >> >