You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2022/09/08 08:41:00 UTC
[jira] [Work logged] (HIVE-26523) Hive job stuck for a long time
[ https://issues.apache.org/jira/browse/HIVE-26523?focusedWorklogId=806931&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-806931 ]
ASF GitHub Bot logged work on HIVE-26523:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 08/Sep/22 08:40
Start Date: 08/Sep/22 08:40
Worklog Time Spent: 10m
Work Description: mayankkunwar opened a new pull request, #3581:
URL: https://github.com/apache/hive/pull/3581
### What changes were proposed in this pull request?
The proposed change is to increase the default value of "hive.server2.tez.sessions.per.default.queue" in case when tez session is enabled, so that multiple queries could run in parallel and the execution could be more faster. See the JIRA for more information.
### Why are the changes needed?
The hive query execution is slow when multiple queries are executed simultaneously.
### Does this PR introduce _any_ user-facing change?
It should not (except faster multiple query execution)
### How was this patch tested?
Issue Time Tracking
-------------------
Worklog Id: (was: 806931)
Remaining Estimate: 0h
Time Spent: 10m
> Hive job stuck for a long time
> ------------------------------
>
> Key: HIVE-26523
> URL: https://issues.apache.org/jira/browse/HIVE-26523
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2
> Affects Versions: 4.0.0-alpha-1
> Reporter: Mayank Kunwar
> Assignee: Mayank Kunwar
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> The default value of "hive.server2.tez.initialize.default.sessions" is true, due to which query was stuck on waiting to choose a session from default queue pool as the default queue pool size is set as 1.
> [https://github.com/apache/hive/blob/master/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java#L3963-L3971]
> 2022-07-10 16:34:23,831 INFO org.apache.hadoop.hive.ql.exec.tez.TezSessionPoolManager: [HiveServer2-Background-Pool: Thread-184167]: Choosing a session from the defaultQueuePool
> 2022-07-10 18:15:48,295 INFO org.apache.hadoop.hive.ql.exec.tez.TezTask: [HiveServer2-Background-Pool: Thread-184167]: Subscribed to counters: [] for queryId: hive_20220710163423_c3f3deed-7a41-4865-9ce6-756fc7e6fbb8
> 2022-07-10 18:15:48,295 INFO org.apache.hadoop.hive.ql.exec.tez.TezTask: [HiveServer2-Background-Pool: Thread-184167]: Session is already open
>
> A possible work around is to increase the default value of "hive.server2.tez.sessions.per.default.queue"
--
This message was sent by Atlassian Jira
(v8.20.10#820010)