Problem with query - Elastic Search 7.10

1

Hi everayone:
I can not do a query like:

select 
id
from Index."_doc"
group by id

but can do :

select 
id
from Index."_doc"
where id = '123'
group by id

The error displayed on the page is:

Failure consuming response from Elastic cluster during start search.

I can run normally with a small amount of data. If the amount of data exceeds 10000, I will get the error.

2

I can run on kibana:

GET _sql
{
  "query":
  """
  SELECT id  FROM Index GROUP BY id
  """
}

but can not run on dremio.
What are the possible reasons? Is it my error?

3

Is this the reason for the data type?
The type of id is keyword.
I can group by long and float.

4

@mudong Can you please send us the job profile? We can see who is throwing the exception?