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

rushikesh_veni · ‎05-25-2016

I get same error and cannot see Hive Tables. Any fix for this yet ?

bandarusridhar1 · ‎05-25-2016

@Rushi

This link might help you:

https://community.hortonworks.com/questions/35060/issue-with-hive-view-made-all-the-changes-related....

harshit_t_shah · ‎06-16-2016

Hi,

I also had the same issue, ambari-server restart could resolve my issue.

Regards,

Harshit Shah

matthias_diekst · ‎06-29-2016

I still have this kind of problem with the broken pipe. I use the Ambari 2.2.2 and HDP 2.4.2.

I get this error at regular intervals and only ambari restart solves this issue.

Aree there some new findings?

hevertoncss · ‎07-21-2016

Hi , I solved the problem by creating a test database.

After doing this the hive view back to normal.
" Create database test ; "
and
" Drop database test ; "

jpetro416 · ‎10-06-2016

We are having the same issue, any answers that work?

jankytara · ‎09-21-2017

Any solutions that work long term?

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"?