Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Query seems executing despite it is finished

avatar
Contributor

Hi,

 

I am running a query and despite the fact that it reached the limit in (8 mins) and it seems FINISHED inside the query details in CM, it stops at (19 mins). Whys it this happening? I saw the below information in query details:

 

First row fetched: 7.9m (75ms)
Last row fetched: 8.0m (7.21s)
Released admission control resources: 19.5m (11.6m)
Unregister query: 19.5m (103ms)

2 REPLIES 2

avatar
Master Collaborator

Hi @drgenious ,

 

1. can you attach the full query profile of it to take a look?

2. You mean query is finished in 8 minutes but why Unregister query has took 19 min am i correct ? if not please elaborate the issue.

3. How you are running the queries from impala-shell or Hue?

4. what is the session timeouts you have in the cluster for impala queries?

 

Regards,

Chethan YM

avatar
Contributor

Hi @ChethanYM,

 

1)Unfortunately I  haven't keep the full log from the query.

2)Exactly, this is my issue.

3)From impala shell.

3)If QUERY_TIMEOUT_S it is then it has the default value.

 

Regards ,

Teo