topic Re: Hanging queries - Best practices in Get Started Discussions

Hanging queries - Best practices

nicole_wong — Wed, 12 Jan 2022 21:46:58 GMT

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?

Re: Hanging queries - Best practices

Anonymous — Thu, 13 Jan 2022 00:45:37 GMT

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.

Re: Hanging queries - Best practices

BilalAslamDbrx — Fri, 14 Jan 2022 10:22:33 GMT

@Nicole Wong I'd like more details.

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

More details please 🙂

Re: Hanging queries - Best practices

Hubert-Dudek — Fri, 14 Jan 2022 14:46:47 GMT

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.

Re: Hanging queries - Best practices

Anonymous — Wed, 26 Jan 2022 16:30:47 GMT

@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?

Re: Hanging queries - Best practices

Anonymous — Fri, 13 May 2022 12:28:40 GMT

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!