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

@Sunile Manjee @Shishir Saxena ADMIN user creates policies based on departments "policy at root level" and delegate admin to particular user or groups to manage the policies and that's how you seggrate the admin roles ... View more

@Sunile Manjee Did you see the link that I shared and extra information added in my reply? I mentioned "See this https://issues.apache.org/jira/browse/RANGER-202 and it has more information on the issues related to this particular issue Take a look on the subtasks." One of the subtasks is https://issues.apache.org/jira/browse/RANGER-228 ... View more

@Mark Thorson /etc/ambari-agent/conf/ambari-agent.ini The ini file in 3rd server. What step are you on now? ... View more

https://streever.atlassian.net/wiki/display/HADOOP/Phoenix+JDBC+Client+Setup Follow this ... View more

@Mark Thorson Good news!!! 🙂 We have agent there already modify ini file and add ambar server address then ambari-server start ... View more

@Rosaura Maria Fran Mongardini We need to have ambari agent in ambari server. It's completely normal to have ambari server and agent in the same node. I won't remove agent from the ambari server host. Ambari does pretty good job on segregating the services across different nodes. ... View more