Support Questions
Find answers, ask questions, and share your expertise

Hive View ambari throwing error.

We are facing error when we open Hive View from ambari. It gives the below errors alternatively.

org.apache.hadoop.ipc.StandbyException: Operation category READ is not supported in state standby
java.io.IOException: Unexpected HTTP response: code=404 != 200, op=GETFILESTATUS, message=Not Found

Below error comes up when ever we try to execute a query.

E090 HDFS030 Error in creation /user/user/hive/jobs/... [HdfsApiException]

6 REPLIES 6

Re: Hive View ambari throwing error.

Rising Star

@KheraIs your namenode configured on HA ?

Re: Hive View ambari throwing error.

Yes it is configured on HA.

Re: Hive View ambari throwing error.

@Khera

E090 HDFS030 Error in creation /user/user/hive/jobs/... [HdfsApiException]

In your above output i see two "user" => /user/user/hive

Is that a typo mistake? Also have you created the user directory properly? as mentioned in : https://docs.hortonworks.com/HDPDocuments/Ambari-2.2.2.0/bk_ambari_views_guide/content/troubleshooti...

The Hive View stores user metadata in HDFS. By default, the location in HDFS for this metadata is /user/${username} where ${username} is the username of the currently logged in user that is accessing the Hive View.

Re: Hive View ambari throwing error.

Yes that was a typo. the location is /user/${username}

Re: Hive View ambari throwing error.

@Khera

Use nameservice id i.e. dfs.nameservices property value in cluster configuration for views:

For example if in your HDFS --> Config --> dfs.nameservices= mycluster

Then change below cluster configurations for the views as follow:

WebHDFS FileSystem URI* = webhdfs://mycluster

Logical name of the NameNode cluster=mycluster

Re: Hive View ambari throwing error.

@SBandaru This is exactly how the cluster config for the view look like at present.

WebHDFS FileSystem URI* = webhdfs://mycluster:50070

Logical name of the NameNode cluster=mycluster