Support Questions

hkropp · ‎10-12-2015

This an simlar exception come up with Hive View. Also see:

https://hortonworks.com/community/forums/topic/amabari-hive-view-error-broken-pipe/ How to resolve and best debug such an issue?

nsabharwal · ‎02-09-2016

@hkropp

Details from support:

It should be fixed in Ambari 2.2

also

We think what probably happened was the connection was open for too long which is why it said there was a broken pipe when you tried to access the hive view. When you did a restart to opened a fresh connection and was able to connect. Probably just a refresh of the ambari page would have reset the connection as well.

View solution in original post

aervits · ‎02-03-2016

@hkropp are you still having issues with this? Can you accept best answer or provide your own solution?

mikeskali · ‎02-03-2016

Have you found any solution? I experience it as well.

james_denman · ‎02-08-2016

+1 I am experiencing this issue as well, without Kerberos.

hkropp · ‎02-09-2016

Hi, I can't remember how or if I solved it 😉 but could you try to configure the Hive View with manual configuration instead of the option to get the cluster configuration? Let me know if this works. Thanks!

nsabharwal · ‎02-09-2016

@hkropp

Details from support:

It should be fixed in Ambari 2.2

also

We think what probably happened was the connection was open for too long which is why it said there was a broken pipe when you tried to access the hive view. When you did a restart to opened a fresh connection and was able to connect. Probably just a refresh of the ambari page would have reset the connection as well.

marko_kole · ‎02-15-2016

What I had to do was restart ambari-server to get rid of this error.

rachel_wijsmull · ‎04-07-2016

My ambari version: 2.2.1.0, problem not fixed in version 2.2.

Not kerberised.

Page refresh doesn't solve.

This works:

ambari-server restart

amittewari_5 · ‎04-13-2016

I too am facing this issue frequently both on HDP 2.3 as well as 2.4 cluster setups. As @R Wys mentioned, above suggested steps not working.

@Neeraj Sabharwal any suggestions, workarounds would be highly appreciated.

Ambari Version: 2.2.1.1

Thanks Amit

rgeorge123 · ‎04-20-2016

I'm facing issue in Ambari Version2.2.1.0 in HDP Sandbox. Restart is not working. Everything was working fine until couple of hours ago. Suddenly Hive tables disappeared from view with error. Please advise.

rgeorge123 · ‎04-23-2016

I'm facing issue in Ambari Version2.2.1.0 in HDP Sandbox. Restart is not working. Everything was working fine until couple of hours ago. Suddenly Hive tables disappeared from view with error. Please advise.

Cloudera Community

Support Questions

With Hive View what causes: "H100 Unable to submit statement show databases like '*': org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe"?