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

[#1]

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

The Ambari view throws the following error: H100 Unable to submit statement show databases like '*': org.apache.thrift.transport.TTransportException:java.net.SocketTimeoutException: 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.

[#2]

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

[#3]

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?

Thanks

[#4]

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

[#5]

Ambari server and Hive restart worked for me

[#6]

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

-Ashutosh

[#7]

Hi,

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

Regards,

Harshit Shah