Then indeed Tez and MR timeout won't be any help, sorry. I would be very interested in your solution though. Regards,
Loïc Loïc CHANEL System & virtualization engineer TO - XaaS Ind - Worldline (Villeurbanne, France) 2016-02-02 11:27 GMT+01:00 Satya Harish Appana <[email protected] >: > 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. >
