Hive view is no longer available in Ambari 2.7.x version (required for HDP 3). And is deprecated in support of DAS/DAS lite.    Alternatively you can use the JDBC tools like DBvisulaizer or Squirrel or Hue.  ... View more

Knox admin ui is SSO enabled by default. Accessing api /gateway/manager/admin-ui/ will redirect to SSO page where you should give the matching credentials (as per ldap/shiro configured in knoxsso.xml).   Access admin-ui from browser and verify.  ... View more

@nagaiik  We dont have ranger plugin for Hive metastore. Ranger plugin is configured for Hive Server2 and runs as part of HS2 JVM.    If it is Hive metastore that hangs then it is not related to ranger. Heap dump of the process must be analyzed  to identify what is causing high memory usage.    HIVE-20568 is the fix to not convert special characters in the table/db names. Due to the conversion of names, ranger authorization was not enforced as names are not same as the one set in policies. This doesnt have any workaround can be fixed on with upgrade to HDP-3.1.4 or contact cloudera hotfix. Refer the release notes for fixed issues.    https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.4/release-notes/content/fixed_issues.html     ... View more

Dashboards used by Activity explorer will use phoenix interpreter configured to connect ams-hbase. Verify if AMS hbase is accessible using sqlline.py    #export HBASE_CONF_PATH=/etc/ams-hbase/conf #<PathTo>/sqlline.py <ams-fqdn>:61181:/ams-hbase-secure (if AMS is running in embedded mode> ... View more

hive cli is deprecated in HDP3.x version and  executing it would take you to the same process of beeline. A new variable is set in script USE_BEELINE_FOR_HIVE_CLI=true which will make hive cli  session to go use beeline.    It is no longer recommended to use hive cli. Please use beeline session in HDP 3.x   If you understand the risks of using hive CLI and still want to use, then change the script to set USE_BEELINE_FOR_HIVE_CLI=false which we don't recommend, but this is one way of making hive cli to work in HDP 3.   Without authentication configured on hive, you can give any name and password at beeline prompt and beeline will allow the access. Even blank username/password is accepted, but this would set user name as 'anonymous' . ... View more