Query not response

#1

Like the attached photo
The query is not responding.

In this case, where do you usually look?
Could you give me some advice?

0 Likes

#2

Can you share a query profile?

0 Likes

#3

87623a97-7024-4559-aa80-0d93fee8d260.zip (6.8 KB)

Sure, I’ve attach a query profile.
Thank you.

0 Likes

#4

Looks like you’re doing a simple SELECT * on an index on Elasticsearch, which is being rewritten as:

{
“from” : 0,
“size” : 4000,
“query” : {
“match_all” : {
“boost” : 1.0
}
}
}

And it looks like Dremio is waiting on your Elasticsearch cluster to return results. How big is this index?

It also looks like the environment you’re using for Dremio is a single node? This may be underprovisioned, depending on what you’re trying to accomplish.

0 Likes