java.net:UnknownhostException:Namenode , While trigger hive job in HDinsight cluster,Can any one help me to out of this great appreciated.

[#1]

hd-hive.pngI am new to HDinsight hadoop cluster , when i have open and Ambari ->hive view>query and execute any hive query(show tables etc..) i am getting error: java.net:UnknowhostException: namenode

Note: I am able to trigger hive query in HIVE cli .

HDP 2.7

hive 1.2

[#2]

Thanks you@jss

I could not find dfs.namenode.http-address property too..i have share my hdfs_site screen short please help me to locate

advanced-hdfs.png

[#3]

@rama

Please use the search filter to find the property mentioned.

Search for "dfs.namenode.http-address" in the "Properties Filter" text box which is present in the

HDFS > Configs > Advanced (In this page) you will find a search box beside the "Manage Config Groups" just put the property "dfs.namenode.http-address" there to search.

[#4]

Thanks you so much@jss

i could able to find the properties(attached screen short) ,so i need to edit properties ?hfds-http.png

[#5]

@rama

Hope the following article will help:

https://community.hortonworks.com/articles/49434/ambari-hive-view-webhdfs-filesystem-uri-in-hdfs-nn....

You do not need to edit the "dfs.namenode.http-address' instead you need to refer to that value so that it can be used inside your Hive View.

Manage Ambai --> Views --> HiveView (check its property "WebHDFS FileSystem URI*") this value need to be changed.

When it comes to setting WebHDFS FileSystem URI* , make sure you set to webhdfs://${dfs.nameservices}   where ${dfs.nameservices} is the value defined in the "hdfs-site.xml"   With *NO* Port to be specified.  (When NameNode HA is configured)

Restart ambari-server  

[#6]

Thanks @jss

I will check and let you know the result..

[#7]

HI @jss

I could find some configuration difference here

In PROD cluster ->managed ambari->views>hive->hive views->cluster configuration is set to "Local Ambari Managed Cluster" and its working fine

IN Dev cluster ->managed ambari->views>hive->hive views->cluster configuration is set to " custom" here it is not working

So should i change to "Local Ambari Managed Cluster"

if you want to me do this one , after save this should i need to restart the ambari server?

please suggest me