I found a working dirty solution, added the queues as follow: root.bt.bt_user1 root.bt.bt_user2 root.bt.bt_user3 root.opt.opt_user1 root.opt.opt_user2 root.opt.opt_user3 and updated the submission script to match it ... View more

@Sriram I have same values exactly as you listed above. Could you share a screenshot of drop down menu next to your username > Interpreter > Filter by spark? Also could you confirm if regular %spark works? ... View more

Hi, Here are some details with Ranger logs (a part of it) : Usersync log : INFO PasswordValidator [Thread-64968] - Response [FAILED: [amb_ranger_admin] does not exists.] for user: amb_ranger_admin INFO PasswordValidator [Thread-64970] - Response [FAILED: [admin] does not exists.] for user: admin >>> Those are infos to say these users are not UNIX users. That's all the logs we have (hundred times a day). For me, it is not our main problem. XAPORTAL log : 2018-06-20 09:10:29,691 [http-bio-6080-exec-8] INFO org.apache.ranger.security.handler.RangerAuthenticationProvider (RangerAuthenticationProvider.java:147) - Authentication with SHA-256 failed. Now trying with MD5. 2018-06-20 09:10:29,692 [http-bio-6080-exec-8] INFO org.apache.ranger.security.listener.SpringEventListener (SpringEventListener.java:70) - Login Successful:admin | Ip Address:128.1.227.103 | sessionId=A311983F0813A5EDE4B4F34FDF558628 | Epoch=1529485829692 2018-06-20 09:10:29,698 [http-bio-6080-exec-8] INFO org.apache.ranger.biz.SessionMgr (SessionMgr.java:232) - UserSession Updated to set new Permissions to User: admin 2018-06-20 09:10:29,698 [http-bio-6080-exec-8] INFO org.apache.ranger.biz.SessionMgr (SessionMgr.java:184) - Login Success: loginId=admin, sessionId=51435, sessionId=A311983F0813A5EDE4B4F34FDF558628, requestId=128.1.227.103, epoch=1529485829698 >>> No Warning or Error CATALINA.OUT log : RemoteUnixLoginModule: RemoteUnixLoginModule::initialize() has been called with callbackhandler: org.springframework.security.authentication.jaas.AbstractJaasAuthenticationProvider$InternalCallbackHandler@12a420aa RemoteUnixLoginModule: Created RemoteUnixLoginModule >>> All good Access_log is good aswell. We don't see errors, in any Ranger log. Do you have some tips for HDFS/Ranger configuration check ? Thanks, Tom ... View more

@Bhanu Pamu I'm using CentOS 7.3 No i don't any user on OS with same name. I'm using AD users. Yes, I'd created asif user directory in /user. I'm running query on internal hive table. ... View more

It's already installed and the issue resolved now, tanx for you response. ... View more

@Felix Albani I tried using putty also. But it also doesn't work for me. Regards, Jay. ... View more

best article I have read on this blog. worth to read it thank you ... View more

@Anpan K Please mark the correct answer 🙂 ... View more

Hi @Dmitro Vasilenko, did u get a chance to look this. @nifi @ExecuteSparkInteractive @spark @Timothy Spann spark.sql("insert into dbname.tablename values('from livy')") is not working spark.sql("insert into dbname.tablename select * from dbname.tablename") is working For more information, please look into my previous posts on same page/tasl/requiement. @nifi @executesparkintactive ... View more

Yes, it is working as a root user Thanks @Vinicius Higa Murakami ... View more