cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Get Started Discussions
Start your journey with Databricks by joining discussions on getting started guides, tutorials, and introductory topics. Connect with beginners and experts alike to kickstart your Databricks experience.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Hanging queries - Best practices

nicole_wong
New Contributor II

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Hubert-Dudek
Esteemed Contributor III

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.

View solution in original post

5 REPLIES 5

Anonymous
Not applicable

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
Databricks Employee
Databricks Employee

@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
Esteemed Contributor III

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
Not applicable

@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
Not applicable

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!

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group