question Re: With Hive View what causes: "H100 Unable to submit statement show databases like '*': org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe"? in 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"?

hkropp — Mon, 12 Oct 2015 21:46:29 GMT

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?

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

jstraub — Mon, 12 Oct 2015 21:54:46 GMT

Is the cluster kerberized?

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

deepesh1 — Mon, 12 Oct 2015 23:36:16 GMT

There is an open intermittent issue where Hive View fails handling submission of multiple statements in a single query/submit. Is that the case here?

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

jstraub — Tue, 13 Oct 2015 00:25:45 GMT

If the cluster is kerberized, please be aware that we are currently facing some issues with Hive and HDFS view in secure environments.

"Hive and file view are not working after enabling kerberos." (Internally tracked via EAR-2412)

Jonas

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

bhagan — Wed, 14 Oct 2015 03:00:41 GMT

Deepash, can you provide us with a link to the open issue?

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

vjiang — Tue, 20 Oct 2015 05:15:47 GMT

I'm seeing this too. Haven't found any JIRA on this.

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

vjiang — Tue, 20 Oct 2015 05:26:17 GMT

Is there any bug filed? There are quite some users are hitting this issue I think.

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

deepesh1 — Tue, 20 Oct 2015 07:41:28 GMT

There is an internal bug that is tracking this at Hortonworks.

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

aervits — Thu, 04 Feb 2016 00:10:39 GMT

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

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

mikeskali — Thu, 04 Feb 2016 05:27:08 GMT

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

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

james_denman — Tue, 09 Feb 2016 03:08:45 GMT

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

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

hkropp — Wed, 10 Feb 2016 04:36:40 GMT

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!

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

hkropp — Wed, 10 Feb 2016 04:36:59 GMT

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

nsabharwal — Wed, 10 Feb 2016 06:01:28 GMT

@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.

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

marko_kole — Mon, 15 Feb 2016 15:58:03 GMT

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

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

rachel_wijsmull — Thu, 07 Apr 2016 18:38:37 GMT

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

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

amittewari_5 — Wed, 13 Apr 2016 13:37:21 GMT

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

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

rgeorge123 — Mon, 19 Aug 2019 12:58:31 GMT

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.

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

rgeorge123 — Mon, 19 Aug 2019 12:58:22 GMT

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

rushikesh_veni — Wed, 25 May 2016 07:00:34 GMT

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