Internal error while running analytics query

Internal error is observed while running query -

{{2024-06-30 18:19:46,343 | infra | DEBUG | ThreadPool_3 | [Rest_Connection:_urllib_request:284] POST https://svc-da-node-004.hqhgqppn5-7blfco.sandbox.nonprod-project-avengers.com:18095/analytics/service body: {"statement": "SET `compiler.external.field.pushdown` \"false\"; SELECT COUNT from QesYo8b1YzDK7sgrly5.bc1S6Ubagy9QyxXioaBaUDY5.QuuzXt9JkFL0a8NMcAz5wT0VkaiG", "pretty": "true", "client_context_id": null, "timeout": "300s"} headers: {'Content-Type': 'application/json', 'Authorization': 'Basic Y291Y2hiYXNlLWNsb3VkLXFlOjI5RERXZGYzamtRNEFBQTQhamZHcWhqVzEzTTFlTkpYaGNVV0JLTkQ1M0ZhQzFoVldZVVF5bSEjWDc1YTVFenY=', 'Connection': 'close', 'Accept': '/'} error: 500 reason: [\{'code': 25000, 'msg': 'Internal error'}] {
"requestID": "1307267e-f31c-4ebb-a71d-faba23c523bc",
"clientContextID": "null",
"errors": [

],
"status": "fatal",
"metrics": {
"elapsedTime": "53.839206102s",
"executionTime": "53.838581663s",
"compileTime": "0ns",
"queueWaitTime": "0ns",
"resultCount": 0,
"resultSize": 0,
"processedObjects": 0,
"bufferCacheHitRatio": "0.00%",
"bufferCachePageReadCount": 0,
"errorCount": 1
}
}}}

Instance:

https://ui.qe-10.sandbox.nonprod-project-avengers.com/columnar/workbench?oid=979f8997-f1aa-495a-b06c-429dc6345dae&pid=7476f002-4cbf-44e2-a1f4-ad00d8b021c8&dbid=10d21b28-34a2-4b3f-990f-3a98e95ae11a

Steps -
1. create a 16 node 4vCPUs+16GB cluster.
2. create 10 remote datasets.
3. ingest 43219415 docs in each dataset.
4. scale cluster down to 1 node.
5. Run queries.

logs - s3://cb-customers-secure/my-organization/2024-06-30/collectinfo-2024-06-30t131052-ns_1@svc-da-node-004.hqhgqppn5-7blfco.sandbox.nonprod-project-avengers.com-redacted-7ead76ba848c0f6d.zip