question Re: HS2 may be unavailable, check server status in Archives of Support Questions (Read Only)

HS2 may be unavailable, check server status

Former Member — Fri, 16 Sep 2022 11:25:39 GMT

Getting following error when hive batch sql is triggered via oozie. Works fine when run from edge nod.

HS2 may be unavailable, check server status
Error: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe (state=08S01,code=0)
Closing: 0: jdbc:hive2://node:10000/hive_instance
HS2 may be unavailable, check server status
Error: Error while cleaning up the server resources (state=,code=0)
Intercepting System.exit(2)
Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.Hive2Main], exit code [2]

Re: HS2 may be unavailable, check server status

Former Member — Sun, 09 Apr 2017 10:16:04 GMT

Recently our cloudera was upgraded from CDH 5.7.1 to CDH 5.9.1. Prior to the migration it was working flawless.

Re: HS2 may be unavailable, check server status

mbigelow — Mon, 10 Apr 2017 21:56:08 GMT

Is this the name of your HS2 node, node:10000?

You probably need to provide the hive-site.xml to the Oozie job. I don't know why it would've worked before but not now though.

I know the Hive script action in Oozie provide a field for the XML file. What type of action are you using?

Re: HS2 may be unavailable, check server status

Former Member — Mon, 10 Apr 2017 22:32:50 GMT

Actually it is different,in order to mask details i have pasted it as jdbc:hive2://node:10000/hive_instance.

hive-site.xml was added at <job-xml> hive2 action as well in the <file>. Batch sql fails after some of the queries in it being executed succesfully.

I am using hive2 as action.

Re: HS2 may be unavailable, check server status

mbigelow — Mon, 10 Apr 2017 22:42:02 GMT

Helps to pay attention to the error. The connection was interrupted. Check the HS2 logs to try to get more info? Anything in the job logs since either ran some queries?

Re: HS2 may be unavailable, check server status

Former Member — Fri, 21 Apr 2017 10:10:39 GMT

Issue ssems to be resolved, once our admin found out the reason of hiveserver2 restarting frequently.