[jira] [Commented] (HIVE-10146) Not count session as idle if query is running
[ https://issues.apache.org/jira/browse/HIVE-10146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14580091#comment-14580091 ] Lefty Leverenz commented on HIVE-10146: --- The default for *hive.server2.idle.session.check.operation* is changed in 1.2.1 by HIVE-9842. Not count session as idle if query is running - Key: HIVE-10146 URL: https://issues.apache.org/jira/browse/HIVE-10146 Project: Hive Issue Type: Improvement Reporter: Jimmy Xiang Assignee: Jimmy Xiang Priority: Minor Labels: TODOC1.2 Fix For: 1.2.0 Attachments: HIVE-10146.1.patch, HIVE-10146.2.patch, HIVE-10146.3.patch, HIVE-10146.4.patch Currently, as long as there is no activity, we think the HS2 session is idle. This makes it very hard to set HIVE_SERVER2_IDLE_SESSION_TIMEOUT. If we don't set it long enough, an unattended query could be killed. We should provide an option to not to count the session as idle if some query is still running. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10146) Not count session as idle if query is running
[ https://issues.apache.org/jira/browse/HIVE-10146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14482546#comment-14482546 ] Lefty Leverenz commented on HIVE-10146: --- Doc note: This adds *hive.server2.idle.session.check.operation* to HiveConf.java, so it needs to be documented in the HiveServer2 section of Configuration Properties for release 1.2.0. It could go either at the end of the section or after *hive.server2.idle.session.timeout* (which could include a reference to it). * [Configuration Properties -- HiveServer2 | https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-HiveServer2] * [Configuration Properties -- HiveServer2 -- hive.server2.idle.session.timeout | https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.server2.idle.session.timeout] Not count session as idle if query is running - Key: HIVE-10146 URL: https://issues.apache.org/jira/browse/HIVE-10146 Project: Hive Issue Type: Improvement Reporter: Jimmy Xiang Assignee: Jimmy Xiang Priority: Minor Labels: TODOC1.2 Fix For: 1.2.0 Attachments: HIVE-10146.1.patch, HIVE-10146.2.patch, HIVE-10146.3.patch, HIVE-10146.4.patch Currently, as long as there is no activity, we think the HS2 session is idle. This makes it very hard to set HIVE_SERVER2_IDLE_SESSION_TIMEOUT. If we don't set it long enough, an unattended query could be killed. We should provide an option to not to count the session as idle if some query is still running. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10146) Not count session as idle if query is running
[ https://issues.apache.org/jira/browse/HIVE-10146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14395015#comment-14395015 ] Lefty Leverenz commented on HIVE-10146: --- Sweet. +1 Not count session as idle if query is running - Key: HIVE-10146 URL: https://issues.apache.org/jira/browse/HIVE-10146 Project: Hive Issue Type: Improvement Reporter: Jimmy Xiang Assignee: Jimmy Xiang Priority: Minor Labels: TODOC1.2 Fix For: 1.2.0 Attachments: HIVE-10146.1.patch, HIVE-10146.2.patch, HIVE-10146.3.patch, HIVE-10146.4.patch Currently, as long as there is no activity, we think the HS2 session is idle. This makes it very hard to set HIVE_SERVER2_IDLE_SESSION_TIMEOUT. If we don't set it long enough, an unattended query could be killed. We should provide an option to not to count the session as idle if some query is still running. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10146) Not count session as idle if query is running
[ https://issues.apache.org/jira/browse/HIVE-10146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14393610#comment-14393610 ] Szehon Ho commented on HIVE-10146: -- Talked to Jimmy, should add a sentence indicating its dependent on the other session timeout flag. Not count session as idle if query is running - Key: HIVE-10146 URL: https://issues.apache.org/jira/browse/HIVE-10146 Project: Hive Issue Type: Improvement Reporter: Jimmy Xiang Assignee: Jimmy Xiang Priority: Minor Fix For: 1.2.0 Attachments: HIVE-10146.1.patch Currently, as long as there is no activity, we think the HS2 session is idle. This makes it very hard to set HIVE_SERVER2_IDLE_SESSION_TIMEOUT. If we don't set it long enough, an unattended query could be killed. We should provide an option to not to count the session as idle if some query is still running. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10146) Not count session as idle if query is running
[ https://issues.apache.org/jira/browse/HIVE-10146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14394036#comment-14394036 ] Lefty Leverenz commented on HIVE-10146: --- If you're doing another patch, you could remove the leading spaces in the second line of the parameter description: {code} + HIVE_SERVER2_IDLE_SESSION_CHECK_OPERATION(hive.server2.idle.session.check.operation, false, +Session will be considered to be idle only if there is no activity, and there is no pending operation.\n + + This setting takes effect only if session idle timeout and checking are enabled.), {code} (It's too trivial for a patch of its own.) Also, it might help to be explicit about the parameters for session idle timeout and checking -- hive.server2.idle.session.timeout hive.server2.session.check.interval. Not count session as idle if query is running - Key: HIVE-10146 URL: https://issues.apache.org/jira/browse/HIVE-10146 Project: Hive Issue Type: Improvement Reporter: Jimmy Xiang Assignee: Jimmy Xiang Priority: Minor Labels: TODOC1.2 Fix For: 1.2.0 Attachments: HIVE-10146.1.patch, HIVE-10146.2.patch, HIVE-10146.3.patch Currently, as long as there is no activity, we think the HS2 session is idle. This makes it very hard to set HIVE_SERVER2_IDLE_SESSION_TIMEOUT. If we don't set it long enough, an unattended query could be killed. We should provide an option to not to count the session as idle if some query is still running. -- This message was sent by Atlassian JIRA (v6.3.4#6332)