Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Subject: Re: Connection between TempletonJob and Worker Nodes remains in
 FIN_WAIT_2 state for long time
MIME-Version: 1.0
From: Eugene Koifman <ekoifman@hortonworks.com>
To: "user@hive.apache.org" <user@hive.apache.org>
Thread-Topic: Connection between TempletonJob and Worker Nodes remains in
 FIN_WAIT_2 state for long time
Thread-Index: AQHRNHF5RQxbIltxs0i70WbVClc0nJ7K3XuA
Date: Mon, 14 Dec 2015 19:11:08 +0000
Message-ID: <D2945419.39DAB%ekoifman@hortonworks.com>
In-Reply-To: <BLU436-SMTP1280889A34D63B3217A147B92EB0@phx.gbl>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-messagesentrepresentingtype: 1
x-ms-exchange-transport-fromentityheader: Hosted
x-originating-ip: [192.175.27.10]
x-source-routing-agent: Processed
Content-Type: text/plain; charset="us-ascii"
Content-ID: <F4795EF6BCB052408F1E17E53C74B1AF@exch080.serverpod.net>
Content-Transfer-Encoding: quoted-printable

https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+Hive
lets you submit a file with SQL statements


Eugene

On 12/11/15, 4:09 PM, "mahender bigdata" <Mahender.BigData@outlook.com>
wrote:

>Hi,
>We have submitted too many jobs to webhcat (templeton) reason is our HQL
>has multiple hive statements,each hive statement is submitted as a job
>causing too many job, after some times all the submitted job are in
>pending state. later after waiting for 2 hrs, all the pending jobs got
>completed. But we were not able to submit  jobs to WEBHCAT, When we
>remote head node and run netstat -a, I see too many ports open
>(incremental manner ) to templeton port. All the Connections are in
>FIN_WAIT_2, where client is not sending 'FIN' token to server. Is there
>a way to set time out for server to close this connection after some hr
>or mins. So that we dont have too many connection or ports opened and
>get into hang state.
>
>Another Question, can we run all the hive statements in HQL file in
>single shot rather than each individual hive statement has hive job.
>
>Thanks in advance.
>
>
>