Problems with Impala. “Query waiting to be closed”
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have a little problems with my Impala´s Platform. We I try to do a query, sometimes I get a time out, and when reviewed the logs, I saw that I got almost 4000 querys waiting to be closed.
I am using CDH 5.14 and impala 2.11.
Someone know if are there any bugs on the system, about queries?. Or Do I need to configure any parameters on the system to solve it?
cloudera impala
asked Nov 16 '18 at 13:31
SkielSkiel
285
add a comment |
I have a little problems with my Impala´s Platform. We I try to do a query, sometimes I get a time out, and when reviewed the logs, I saw that I got almost 4000 querys waiting to be closed.
I am using CDH 5.14 and impala 2.11.
Someone know if are there any bugs on the system, about queries?. Or Do I need to configure any parameters on the system to solve it?
cloudera impala
asked Nov 16 '18 at 13:31
SkielSkiel
285
add a comment |
I have a little problems with my Impala´s Platform. We I try to do a query, sometimes I get a time out, and when reviewed the logs, I saw that I got almost 4000 querys waiting to be closed.
I am using CDH 5.14 and impala 2.11.
Someone know if are there any bugs on the system, about queries?. Or Do I need to configure any parameters on the system to solve it?
cloudera impala
asked Nov 16 '18 at 13:31
SkielSkiel
285
I have a little problems with my Impala´s Platform. We I try to do a query, sometimes I get a time out, and when reviewed the logs, I saw that I got almost 4000 querys waiting to be closed.
I am using CDH 5.14 and impala 2.11.
Someone know if are there any bugs on the system, about queries?. Or Do I need to configure any parameters on the system to solve it?
cloudera impala
cloudera impala
asked Nov 16 '18 at 13:31
SkielSkiel
285
asked Nov 16 '18 at 13:31
SkielSkiel
285
asked Nov 16 '18 at 13:31
SkielSkiel
285
asked Nov 16 '18 at 13:31
SkielSkiel
285
asked Nov 16 '18 at 13:31
SkielSkiel
285
285
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Can you decrease
--idle_query_timeout and --idle_session_timeout
Comment: I get this same behavior from HUE. Some connections are not closed when the tab is closed. I don't recall the exact state, but we have the idle_query_timeout and idle_session_timeout set to 1 hour and these are closed after that time. So if idle_query isn't working try idle_session. If that doesn't work, there maybe something going one with your specific setup.
Ref: https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Query-Cancel-and-idle-query-timeout-is-not-working/td-p/58104
answered Nov 19 '18 at 10:15
Hadoop-GuyHadoop-Guy
965
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53338892%2fproblems-with-impala-query-waiting-to-be-closed%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Can you decrease
--idle_query_timeout and --idle_session_timeout
Comment: I get this same behavior from HUE. Some connections are not closed when the tab is closed. I don't recall the exact state, but we have the idle_query_timeout and idle_session_timeout set to 1 hour and these are closed after that time. So if idle_query isn't working try idle_session. If that doesn't work, there maybe something going one with your specific setup.
Ref: https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Query-Cancel-and-idle-query-timeout-is-not-working/td-p/58104
answered Nov 19 '18 at 10:15
Hadoop-GuyHadoop-Guy
965
add a comment |
Can you decrease
--idle_query_timeout and --idle_session_timeout
Comment: I get this same behavior from HUE. Some connections are not closed when the tab is closed. I don't recall the exact state, but we have the idle_query_timeout and idle_session_timeout set to 1 hour and these are closed after that time. So if idle_query isn't working try idle_session. If that doesn't work, there maybe something going one with your specific setup.
Ref: https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Query-Cancel-and-idle-query-timeout-is-not-working/td-p/58104
answered Nov 19 '18 at 10:15
Hadoop-GuyHadoop-Guy
965
add a comment |
Can you decrease
--idle_query_timeout and --idle_session_timeout
Comment: I get this same behavior from HUE. Some connections are not closed when the tab is closed. I don't recall the exact state, but we have the idle_query_timeout and idle_session_timeout set to 1 hour and these are closed after that time. So if idle_query isn't working try idle_session. If that doesn't work, there maybe something going one with your specific setup.
Ref: https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Query-Cancel-and-idle-query-timeout-is-not-working/td-p/58104
answered Nov 19 '18 at 10:15
Hadoop-GuyHadoop-Guy
965
Can you decrease
--idle_query_timeout and --idle_session_timeout
Comment: I get this same behavior from HUE. Some connections are not closed when the tab is closed. I don't recall the exact state, but we have the idle_query_timeout and idle_session_timeout set to 1 hour and these are closed after that time. So if idle_query isn't working try idle_session. If that doesn't work, there maybe something going one with your specific setup.
Ref: https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Query-Cancel-and-idle-query-timeout-is-not-working/td-p/58104
answered Nov 19 '18 at 10:15
Hadoop-GuyHadoop-Guy
965
answered Nov 19 '18 at 10:15
Hadoop-GuyHadoop-Guy
965
answered Nov 19 '18 at 10:15
Hadoop-GuyHadoop-Guy
965
answered Nov 19 '18 at 10:15
Hadoop-GuyHadoop-Guy
965
965
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53338892%2fproblems-with-impala-query-waiting-to-be-closed%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
