Steps to reproduce -
- Create a remote capella cluster and create a bucket and load data into it.
- Create a 2 node columnar instance.
- Create remote and external links.
- Create remote and external collections.
- Run a copy to s3 query such that it copies result of a query that utilizes 2 collections.
2024-07-23 14:38:51,982 | infra | DEBUG | cbas_worker_5 | [Rest_Connection:_urllib_request:284] POST https://cb.auuaxppxxwlvwpp.sandbox.nonprod-project-avengers.com:18095/analytics/service body: {"statement": "COPY ( select * from Default.Default.YsGI1SpfMrJDfUiu as a, Default.Default.SJACSvLYSsfirBwP8pXdU as b where a.avg_rating > 0.4 and b.avg_rating > 0.4 ) AS ally TO `copy-to-s3-14465` AT FyCresRdNwjH PATH(\"copy_dataset_8\") ", "pretty": "true", "client_context_id": null, "timeout": "3600s"} headers: {'Content-Type': 'application/json', 'Authorization': 'Basic Y291Y2hiYXNlLWNsb3VkLXFlOjdYWUBtelZPSUlHdTg2NDlEQzF4TFpIdWEhdVk5anhkSTVJeHRVV1VKTWltM0lYSE4jd0NsS29DU21QNCVnUGc=', 'Connection': 'close', 'Accept': '*/*'} error: 500 reason: [{'code': 25000, 'msg': 'Internal error'}] {
|
"requestID": "b7ad7f70-224d-4e04-917c-97b7ea24c56f",
|
"clientContextID": "null",
|
"errors": [{
|
"code": 25000, "msg": "Internal error" }
|
],
|
"status": "fatal",
|
"metrics": {
|
"elapsedTime": "1420.466715985s",
|
"executionTime": "1420.464883701s",
|
"compileTime": "0ns",
|
"queueWaitTime": "0ns",
|
"resultCount": 0,
|
"resultSize": 0,
|
"processedObjects": 0,
|
"bufferCacheHitRatio": "0.00%",
|
"bufferCachePageReadCount": 0,
|
"errorCount": 1
|
}
|
}
|
Analytics collections used in the query above were created as follows -
CREATE EXTERNAL DATASET Default.Default.YsGI1SpfMrJDfUiu ON `columnar-functional-sanity-test-data` AT FyCresRdNwjH WITH {"format": "json", "include": ["*.json"]};
|
CREATE COLLECTION Default.Default.SJACSvLYSsfirBwP8pXdU PRIMARY KEY(name: string, email: string) with {"storage-format": {"format": "column"}} ;
|