hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Loïc Chanel <loic.cha...@telecomnancy.net>
Subject Re: Hive Query Timeout in hive-jdbc
Date Tue, 02 Feb 2016 10:24:23 GMT
Actually, Hive doesn't support timeout, but Tez and MapReduce does.
Therefore, you can set a timeout on these tools to kill failed queries.
Hope this helps,

Loïc

Loïc CHANEL
System & virtualization engineer
TO - XaaS Ind - Worldline (Villeurbanne, France)

2016-02-02 11:10 GMT+01:00 董亚军 <ric.dong@liulishuo.com>:

> hive does not support timeout on the client side.
>
> and I think it is not recommended that if the client exit with timeout
> exception, the hiveserver side may also running the job. this will result
> in inconsistent state.
>
> On Tue, Feb 2, 2016 at 4:49 PM, Satya Harish Appana <
> satyaharish.appana@gmail.com> wrote:
>
>> Hi Team,
>>
>>   I am trying to connect to hiveServer via hive-jdbc.
>> Can we configure client side timeout at each query executed inside each
>> jdbc connection. (When I looked at HiveStatement.setQueryTimeout method it
>> says operation unsupported).
>> Is there any other way of timing out and cancelling the connection and
>> throwing Exception, if it alive for over a period of 4 mins or so
>> (configurable at client side).
>>
>> PS : Queries that I am executing over jdbc are simple ddl statements.
>> (hive external table create statements and drop table statements).
>>
>>
>> Regards,
>> Satya Harish.
>>
>
>

Mime
View raw message