HIVE service not able to start when ranger plugin is enabled

SYMPTOM: Ranger plugin is enabled for HIVE. Restarting HIVE service its not able to start and stucking on below error

ERROR:

2015-10-15 13:02:51,683 - u"File['/var/lib/ambari-agent/data/tmp/ojdbc6.jar']" {'content': DownloadSource('http://sjcservicenode04-prod.xxxinternal.com:8080/resources//oracle-jdbc-driver.jar')}

2015-10-15 13:02:51,796 - Not downloading the file from http://sjcservicenode04-prod.xxxinternal.com:8080/resources//oracle-jdbc-driver.jar, because /var/lib/ambari-agent/data/tmp/oracle-jdbc-driver.jar already exists

2015-10-15 13:02:51,996 - call['hdp-select status hadoop-client'] {'timeout': 20}

ROOT CAUSE:

Ranger Hive policies http url calls were taking forever to return results Ranger makes a lot of calls to urllib2.urlopen(request) that don't have a timeout in Ambari 2.0 Opened Ambari BUG to put time=5 in the ranger_function.py file.

https://hortonworks.jira.com/browse/BUG-46275

RESOLUTION:

1) Edit /usr/lib/python2.6/site-packages/resource-management/libraries/functions/ranger_functions.py and copy to all host to be safe (only Hive nodes)

all urllib2.urlopen(request) do urllib2.urlopen(request, timeout=5)

2) Delete duplicate x_group_users - MYSQL https://hortonworks.jira.com/browse/BUG-43119