@Lian Jiang Looks like default python version is 3.0, you might want to change to 2.7.x. Please refer supported python release: https://docs.hortonworks.com/HDPDocuments/Ambari-2.7.0.0/bk_ambari-installation/content/mmsr_software_reqs.html ... View more

@Shashank V C All the plugins that use Ranger as an authorization module will cache local policy and use the same for authorization purpose. Below is an excerpt from Apache Ranger overview: Plugins are lightweight Java programs which embed within processes of each cluster component. For example, the Apache Ranger plugin for Apache Hive is embedded within Hiveserver2. These plugins pull in policies from a central server and store them locally in a file. When a user request comes through the component, these plugins intercept the request and evaluate it against the security policy. Plugins also collect data from the user request and follow a separate thread to send this data back to the audit server. Reference: https://hortonworks.com/apache/ranger/#section_2 PS: Please mark the answer if you find it correct 🙂 ... View more

You can use below command to install hive and use beeline brew install hive Or you can get all the required jars used by beeline command. to find the same you can launch beeline in you HDP cluster and run lsof -p <beelineclientpid> to find jars loaded and copy to local Mac. A better solution would be to use JDBC Client tool such as DBeaver or DBVisualizer for Mac ... View more

When you connect using below connect string beeline -u "jdbc:hive2://aisvr.uildomain.com:2181/default;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" Username and Password will not be prompted, if you wish to pass Username and password you can use -n for Username and -p for Password, for example. beeline -u "jdbc:hive2://aisvr.uildomain.com:2181/default;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" -n testuser -p passwordusertest For more information you can refer Beeline doc: https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients ... View more