question Re: Hive issue. in Archives of Support Questions (Read Only)

Hive issue.

ashneesharma88 — Mon, 03 Oct 2016 18:18:21 GMT

I am using HDP-2.1, Hive version:-0.13.0.2.1. And we are getting error intermediate. When we restart the hive then is gets resolved. Why this issue is coming. Any idea:-

Error:- FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.thrift.transport.TTransportException java.net.SocketException: Broken pipe).

Re: Hive issue.

aervits — Mon, 03 Oct 2016 18:24:03 GMT

You should investigate network issues. also you must upgrade your cluster as soon as possible. HDP 2.1 is no longer supported and 2.2 is on the verge. you will miss your chance of safe upgrade if you don't consider doing so soon.

Re: Hive issue.

ashneesharma88 — Mon, 03 Oct 2016 18:58:51 GMT

@ Artem Ervits

I am able to login on hive shell but when I ran any query that time I am getting error. After restart its works then how it will be network issue?

Re: Hive issue.

aervits — Mon, 03 Oct 2016 19:46:14 GMT

@Ashnee Sharma "broken pipe" is an indication of some network disruption. It could be many different things, Ambari 2.4 with latest version of Hive view 1.5 improves on the stability of Hive view as opposed to what you're using. If this error is directly related to Hive view 1.0 and not network issue, then you will absolutely benefit from upgrading. Good luck.