Hanging queries - Best practices

[nicole_wong]

I have a customer who is experiencing hanging queries and was wondering if there are any best practices for managing a hanging query.

For example, they have seen a query hang as the cluster itself was hanging for the 90 minutes before the timeout triggered. Is there a better way to diagnose and retry this?

[Anonymous]

Hi Nicole,

Piper here. Welcome back! As usual, we'll give the community a while to respond before we come back around. Thank you for your patience.

[BilalAslamDbrx]

@Nicole Wong​ I'd like more details.

1. What type of query is this?
2. What compute is the query running on? Cluster? SQL endpoint?

More details please 🙂

[Hubert-Dudek · Accepted solution]

Exactly, when it is job maybe stream is better. When SQL maybe loading in chunks. Timeout is also useful - in fact is working in your case so it can be shorten.

[Anonymous]

@Nicole Wong​ - Checking in. If Hubert's answer helped, would you let us know? If not, would you be happy to give bilal more information?

[Anonymous]

Hey there @Nicole Wong​ 

Hope everything is going great.

Just wanted to see if you were able to find an answer to your question and would you like to share the solution with us? It would be really helpful for the other members too.

We'd love to hear from you.

Cheers!