Service 'webhcat' check failed: RA080 Can't determine WebHCat hostname neither by associated cluster nor by webhcat.hostname property

[#1]

I have created a PIG view in Ambari Server and cannot access it due to error "Service 'webhcat' check failed: RA080 Can't determine WebHCat hostname neither by associated cluster nor by webhcat.hostname property"

I used also the below configuration:

• a.Go to Services > HDFS > Configs
• b.Under the Advanced tab, navigate to the Custom core-site section
• c.Click Add Property with the following inputs:

hadoop.proxyuser.hcat.groups=*

hadoop.proxyuser.hcat.hosts=*

webhcat.proxyuser.root.groups=*

webhcat.proxyuser.root.hosts=*

But, I have still problem. How can I resolve it?

[#2]

@Mike Bit

Can you share your Pig View configurations and HDP version ?

[#3]

Dear Dinesh,

HDP version is 2.6. Pig View Configuration is in the below figures:

[#4 · Accepted solution]

@Mike Bit

This appears to be a config issue.Check if you have followed all steps listed here:

https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.0.0/bk_ambari-views/content/configuring_pig_vie...

[#5]

Thanks for link. One step is about Hive configuration, but I do not want it. Or is it mandatory for Pig View? this link: https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.0.0/bk_ambari-views/content/setup_WebHCat_proxy...

[#6]

You need to do that step. That is the one which configures the proxy for your ambari principal.