For Hive View to access HDFS, the Ambari Server daemon hosting the view needs to act as the proxy user for HDFS. This allows Ambari to submit requests to HDFS on behalf of Hive View users. This is critical since the Hive View will store metadata about their user Hive queries in HDFS. This also means users that access Hive View must have a user directory setup in HDFS.

If you are running views in an operational Ambari server (one that is operating the cluster) Ambari does this setup by default. You should verify that the HDFS proxy user and user directory settings are correct. If you are running views on a standalone server, you must set up proxy user settings manually.

Important

For clusters with wire encryption enabled: You must configure a Hive session parameter to use Hive View: Click the drop-down menu of your username profile (top right corner of window). Click Manage Ambari > Views > Hive > Hive View or Hive View 2.0. Click the Edit icon in the Settings part of the window. In the the Hive Session Parameters field, enter sslTrustStore=/etc/security/serverKeys/hivetruststore.jks;trustStorePassword=your_password, inserting a real password in place of your_password. If you do not specify a password, the default password that gets assigned is changeit. Click Save.

More Information

Set up HDFS Proxy User

Set up HDFS User Directory