@SMACH H You can follow the below: 1. lock down the location in HDFS: set permission 700 to /apps/hive/warehouse 2. add policy to Ranger/Hive for database: *, allowing users to create databases. (note that the ambari-qa user also needs access to database: * to complete the service check) 3. Allow access to individual databases via Ranger/Hive policies. This blog post may be of interest: http://hortonworks.com/blog/best-practices-for-hive-authorization-using-apache-ranger-in-hdp-2-2/ Also you may explore the options with "hive.server2.enable.doAs" ... View more

Thanks @bkosaraju Strict Host Key Checking is set to False. If with target hosts, you mean, the SFTP server (our destination) then it is not in the list of /.ssh/known_hosts) Just tried manual SFTP again and this time received, Connection Reset by Peer. Checking SFTP side in case our Node IP is blacklisted (possibly due to Max Failure condition.) Update -- 12-07-2017 -- The IP for the NIFI Node was blacklisted on the SFTP Side. We've whitelisted the IP and the processor is now functional. Thanks. ... View more

@lgeorge @justin kuspa @Rick Moritz Any further updates on why the R interpreter was removed in 2016? Will functionality differ from RStudio in terms of running R Code through the Livy interpreter in Zeppelin? ... View more

@Manoj A @Neeraj SabharwalCan you post more details on this process? I am trying to build a Sandbox on VSphere 6Thanks. ... View more

@Somya Pandey did this ever get resolved for you. Please share your resolution, if so. thanks. ... View more