Sure, please accept the answer is satisfied ... View more

@Sunile Manjee I guess I can't avoid readming docs today :), thank you. ... View more

@Sunile Manjee We ran into a similar issue with a customer. To clean up you need to do the followin Stop all services and run the cleanup script https://cwiki.apache.org/confluence/display/AMBARI/Host+Cleanup+for+Ambari+and+Stack python /usr/lib/python2. 6 /site-packages/ambari_agent/HostCleanup.py You have elected to remove all users as well. If it is not intended then use option --skip "users" . Do you want to continue [y/n] (n) Run the above on each hosts. Next you would want to do a ambari reset and follow the steps that Scott mentioned. ... View more

I feel that this wasn't answered clearly. I stumbled across this recently and tested with various configurations and full packet captures with tcpdump. There are 3 possibilities when hive.server2.thrift.sasl.qop is set to auth-conf: Client connects with ;saslQop=auth-conf - traffic is encrypted Client tries to connect with ;saslQop=auth - connection is refused with javax.security.sasl.SaslException: No common protection layer between client and server exception Client connects without any saslQop parameter set (this is especially the case with ODBC drivers and software such as Tableau where you cannot - easily - set the JDBC parameters) - traffic is still encrypted. I'm mentioning this as some documentation asks to explicitly set saslQop in the client, but this isn't required, unless you want to enforce this so it doesn't go over unencrypted connections if the server setting changes. ... View more

@Mark Thorson for you ... View more

thanks, hbase is started 🙂 ... View more

@subhash parise Docs to understand more on Phoenix. http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.0/bk_installing_manually_book/content/ch_install_phoenix_chapter.html ... View more

That is a good point David Hwang. Thanks for sharing 🙂 ... View more

We had to add this to custom hive-site (custom hive-env does not work). Once added to custom hive-site, this worked fine. James ... View more

thank you both. yes at ambari-server setup. ... View more