question Re: This issue With ambari Hive View what causes: "H100 Unable to submit statement show databases like '*': org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe (write failed)"? in Archives of Support Questions (Read Only)

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

saisandeepdevop — Sun, 18 Aug 2019 02:40:13 GMT

Able to connect to HIVE through Beeline for User but unable to connect to HIVE through Ambari even after cleared History and Cookies for user and even after using different bowers.

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

asirna — Thu, 12 Oct 2017 23:45:36 GMT

@Sai Sandeep,

There are multiple reasons for which this may happen. You can try below

1) Try refreshing the page and check if it works.

2) Restart ambari server and hive service

3) If above 2 doesn't work, try restarting yarn

To restart ambari server, run the below in ambari server host

ambari-server restart

Additional reference:

https://community.hortonworks.com/questions/1288/with-hive-view-what-causes-h100-unable-to-submit-s.html

Thanks,

Aditya

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

saisandeepdevop — Thu, 12 Oct 2017 23:52:50 GMT

Is there any alternate way to resolve this error, without doing any restart the ambari- server or yarn server?

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

asirna — Fri, 13 Oct 2017 00:00:54 GMT

@Sai Sandeep,

I'm not sure of any other solution right now. I will definitely post it if I find any. Meanwhile, can you please give this a try and see if it works.

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

Shelton — Fri, 13 Oct 2017 00:01:48 GMT

@Sai Sandeep,

Can you paste the error stack in hive20-view.log located in /var/log/ambari-server/hive20-view

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

saisandeepdevop — Fri, 13 Oct 2017 01:20:35 GMT

could you be more specific, As I am unable to fine that file.

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

Shelton — Fri, 13 Oct 2017 04:14:02 GMT

@Sai Sandeep,

See the location in the attached screenshot! You can navigate to those directories for the hive view ,file view errors 🙂

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

saisandeepdevop — Fri, 13 Oct 2017 22:03:23 GMT

Sorry unable to find it.