Queries I am running over Hive JDBC are ddl statements(none of the queries are select or insert. which will result in an execution engine(tez/mr) job to be launched.. all the queries are create external table .. and drop table .. and alter table add partitions).
On Tue, Feb 2, 2016 at 3:54 PM, Loïc Chanel <[email protected]> wrote: > 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 董亚军 <[email protected]>: > >> 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 < >> [email protected]> 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. >>> >> >> > -- Regards, Satya Harish Appana, Software Development Engineer II, Flipkart,Bangalore, Ph:+91-9538797174.
