@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

Hi @Sunile Manjee please ask the follow on as a separate question. ... View more

No it can be the same metadata repository. You have two different MySQL instances for two different metadata repositories if you wish ... View more

@Sunile Manjee ... View more

Additional resources https://cwiki.apache.org/confluence/display/AMBARI/Alerts https://cwiki.apache.org/confluence/display/AMBARI/Creating+a+Script+Alert ... View more

@Sunile Manjee You may want to fide the public IP in the screenshot ... View more

@Sunile Manjee See this https://parquet.apache.org/downloads/ On internal note: Search in wiki and you will find lot of information on it. ... View more

More information.. It may not be direct answer because your question is very broad. http://hortonworks.com/blog/announcing-apache-hive-1-2/ Performance and Optimizer Improvements Grace hash join algorithm for Hive so that Map Joins use disk on overflow instead of failing (HIVE-9277) Predicate PushDown enhancements (HIVE-9069) Improvements in stats for better MapJoin selection, Reducer Parallelism (HIVE-9392, HIVE-10107) Count Distinct Performance Improvements (HIVE-10568) CBO – Better Windowing support (HIVE-10627, HIVE-10686) Changes to comply with SQL:2011 standard for reserved/non-reserved keywords (HIVE-6617) Caching of statistics in HiveServer2 (HIVE-10382) Improve performance of Vector Map Join by using more vectorization techniques (HIVE-9937, HIVE-9824) https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12329345&styleName=Text&projectId=12310843 ... View more