I try to create a canvas b using elastic SQL. but i always get failed when do query. i using this query

SELECT layanan,count(awbNumber) AS total_awb FROM "indexname" WHERE layanan is not null GROUP by layanan ORDER BY count(awbNumber) DESC LIMIT 10

and get this error

"error": {
"root_cause": [
"type": "query_phase_execution_exception",
"reason": "Time exceeded"
"type": "search_phase_execution_exception",
"reason": "all shards failed",
"phase": "query",
"grouped": true,
"failed_shards": [
"shard": 0,
"index": "indexname",
"node": "LOC9qAEPQQ-7pK8x0zTblw",
"reason": {
"type": "query_phase_execution_exception",
"reason": "Time exceeded"
"status": 500

what must i do to solve this problem?

Hi @umay_fb,

This is possibly happening due to a large of amount of data going through and it is timing out. Do you have a smaller dataset with a different index to try and see if it fails the same?

You can increase the timeout, see https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-rest-fields.html

Also are you using ES or AWS ES? We only support ES.


This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.