Community Articles

Find and share helpful community-sourced technical articles.
Labels (1)
avatar
Guru

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).

1,207 Views