Details
-
Bug
-
Resolution: Fixed
-
Major
-
Columnar 1.0.0
-
1.0.0-2230
-
Untriaged
-
-
0
-
Yes
-
Analytics Sprint 47
Description
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"}} ; |
Attachments
Issue Links
- links to