Creating View for Hive Interactive

[#1]

Goal

Create a new Ambari view for Hive Interactive. Use this link to get detailed information on configuring views.

https://docs.hortonworks.com/HDPDocuments/Ambari-2.5.1.0/bk_ambari-views/content/settings_and_cluste...

Steps

• Navigate to Ambari page with admin privileges and click on the username dropdown icon

39585-screen-shot-2017-09-27-at-31345-pm.png

• Select the views link to explore all the views available in Ambari

39586-screen-shot-2017-09-27-at-31459-pm.png

• Collapse the "Hive" dropdown and click on "Create Instance" to create a new view for LLAP/Interactive

39587-screen-shot-2017-09-27-at-31638-pm.png

• Give the name of this instance per your requirement

39589-screen-shot-2017-09-27-at-31929-pm.png

• Ensure that under "Settings" tab, "User Interactive Mode" is set to true

39590-screen-shot-2017-09-27-at-32054-pm.png

• If the cluster is kerberized, use proper auth method and principal name

39591-screen-shot-2017-09-27-at-32220-pm.png

• Also update the proper JDBC URL with principal name

39592-screen-shot-2017-09-27-at-32431-pm.png

NOTE: If ranger is enabled, ensure that the user trying to access the database objects does have the permissions to browse the contents of the database(s).