Elastic SQL in CANVAS FAILED

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.

Thanks!
Liza