https://community.cloudera.com/t5/Archives-of-Support-Questions/Can-I-set-a-maximum-query-time-with-Hive-JDBC/m-p/119918#M55255 <P>I recently had a hive query (executed via a JDBC connection) hang for several hours due to a metastore issue. Is there a way that I set a maximum query time with my JDBC connection? This query should take just a few seconds, so I'd rather kill it after a few minutes than let it block for hours.</P><P>Some searching of the Hive JIRA suggests that this isn't possible, but asking here if anyone has advice.</P> Thu, 23 Feb 2017 01:07:50 GMT Aaron_Dossett 2017-02-23T01:07:50Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Can-I-set-a-maximum-query-time-with-Hive-JDBC/m-p/119918#M55255 <P>I recently had a hive query (executed via a JDBC connection) hang for several hours due to a metastore issue. Is there a way that I set a maximum query time with my JDBC connection? This query should take just a few seconds, so I'd rather kill it after a few minutes than let it block for hours.</P><P>Some searching of the Hive JIRA suggests that this isn't possible, but asking here if anyone has advice.</P> Thu, 23 Feb 2017 01:07:50 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Can-I-set-a-maximum-query-time-with-Hive-JDBC/m-p/119918#M55255 Aaron_Dossett 2017-02-23T01:07:50Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Can-I-set-a-maximum-query-time-with-Hive-JDBC/m-p/119919#M55256 <P>I have not tried this</P><UL><LI>hive.server2.idle.operation.timeoutWith <A href="https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.server2.session.check.interval"><STRONG>hive.server2.session.check.interval</STRONG></A> set to a positive time value, operation will be closed when it's not accessed for this duration of time, which can be disabled by setting to zero value. With positive value, it's checked for operations in terminal state only (FINISHED, CANCELED, CLOSED, ERROR). With negative value, it's checked for all of the operations regardless of state.</LI><LI>hive.server2.idle.session.timeoutWith <A href="https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.server2.session.check.interval"><STRONG>hive.server2.session.check.interval</STRONG></A> set to a positive time value, session will be closed when it's not accessed for this duration of time, which can be disabled by setting to zero or negative value.</LI></UL><P>and if it was metastore issue, did you try:</P><UL><LI>hive.metastore.client.socket.timeoutMetaStore Client socket timeout in seconds.</LI></UL> Sat, 25 Feb 2017 12:17:13 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Can-I-set-a-maximum-query-time-with-Hive-JDBC/m-p/119919#M55256 sunile_manjee 2017-02-25T12:17:13Z