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
Honored Contributor III
Honored Contributor III

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

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!