Like the attached photo
The query is not responding.
In this case, where do you usually look?
Could you give me some advice?
Can you share a query profile?
87623a97-7024-4559-aa80-0d93fee8d260.zip (6.8 KB)
Sure, I’ve attach a query profile.
Thank you.
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.