Support Questions

Find answers, ask questions, and share your expertise

Query seems executing despite it is finished

Explorer

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

Expert Contributor

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

Explorer

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

 

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.