question Re: Facing issue while uploading data in Hive in Archives of Support Questions (Read Only)

Facing issue while uploading data in Hive

prasantk2live — Tue, 03 Jan 2017 18:56:15 GMT

Hi All,

We are getting error message while accessing Hive, "H100 Unable to submit statement show databases like '*': org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe" Also while uploading data using CSV from local, it says "Cannot read property errors of undefined". Kindly please guide me to resolve the same.

Thanks in advance.

Re: Facing issue while uploading data in Hive

ssubhas — Tue, 03 Jan 2017 19:01:33 GMT

@Prasant Kesavakumaran

There is known issue in Ambari 2.2 which is addressed in latest versions. Try restarting Ambari server as below and then check:

ambari-server restart

Re: Facing issue while uploading data in Hive

prasantk2live — Tue, 03 Jan 2017 19:59:20 GMT

Hi Sindhu, Thanks for your reply.

Is there any option to restart via UI? since am not using ssh to access the env.

Re: Facing issue while uploading data in Hive

ssubhas — Wed, 04 Jan 2017 01:37:08 GMT

@Prasant Kesavakumaran

The ambari-server restart is to be done from the command line, there is no UI option for the same.

Re: Facing issue while uploading data in Hive

prasantk2live — Wed, 04 Jan 2017 18:28:09 GMT

Hi Sindhu, thanks again.

I just restarted the vm and it worked. 🙂

Re: Facing issue while uploading data in Hive

ssubhas — Fri, 06 Jan 2017 00:34:03 GMT

@Prasant Kesavakumaran

Please mark the answer to close the discussion.