Elasticsearch SQL ERROR

ES total data volume of 1 billion data, we have implemented a sql has been implemented for 15 minutes or no

the SQL is : SELECT * FROM ES_233.dremio_test1.“default” order by _id desc limit 10

and , use sql to query ES when there is need to pay attention to what do?


Is there an error, or is the issue that the query is slow? I suspect that if you removed the ORDER BY the query would execute quickly.

Ultimately the expression pushed down to ES might be slow for ES to execute. Can you share the query plan and we can help take a closer look?

In addition, you might consider using Data Reflections to speed up your analytical queries on ES: https://docs.dremio.com/acceleration/reflections.html

how to export the query plan ?