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

[#1]

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?

[#2]

Is the cluster kerberized?

[#3]

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?

[#4]

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

[#5]

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

[#6]

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

[#7]

Do you have more info on this internal bug? Restarting Hive and Ambari-Server are temporary fixes, but need a permanent one.

[#8]

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

[#9]

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

[#10]

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!