Community Articles
Find and share helpful community-sourced technical articles
Labels (1)

H100 Unable to submit statement show databases like '*': org.apache.thrift.transport.TTransportException: Broken pipe"

The Ambari view throws the following error: H100 Unable to submit statement show databases like '*': Read timed out And I can no longer view database or run queries in the Ambari view. The problem appears to resolve itself after some time, but then will reappear after running a sequence of queries in the Hive view.

1) This should be fixed in Ambari 2.2

2) Browser Refresh fixed it: When connection was open for too long then 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.

0 Kudos

I tried many things, the only thing fixed the issue is rebooting the sandbox VM.

Hi - I am having the same problem and have restarted my VM to no success. My tables have still not reappeared even though it has been some time. Can anyone help?


Any fix for the issue yet ? I still have this issue . Is restarting ambari the only option ?

Ambari server and Hive restart worked for me

Please restart the Ambari and it will solve your issue. It worked for me.



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


Harshit Shah

Don't have an account?
Version history
Revision #:
1 of 1
Last update:
‎02-09-2016 10:11 PM
Updated by:
Top Kudoed Authors