Trino / Iceberg catalog export bucket bug
- Dominant language
- Rust
- Stars
- 20.8k
- Forks
- 2.1k
- Avg merge
- 1d 2h
- Merged PRs (30d)
- 181
Description
**Describe the bug**
Trino / Iceberg / GCP export bucket bug
**To Reproduce**
Steps to reproduce the behavior:
1. Trino source configured with Iceberg catalog
2. Configure https://cube.dev/docs/product/configuration/data-sources/trino#google-cloud-storage
**Expected behavior**
Pre aggregations don't fail with exception
**Screenshots**
```
Error: line 1:140: Catalog 'iceberg' table property 'external_location' does not exist
at toError (/cube/node_modules/@cubejs-backend/prestodb-driver/src/PrestoDriver.ts:160:37)
at error (/cube/node_modules/@cubejs-backend/prestodb-driver/src/PrestoDriver.ts:211:20)
at /cube/node_modules/presto-client/lib/presto-client/index.js:387:21
at IncomingMessage. (/cube/node_modules/presto-client/lib/presto-client/index.js:153:13)
at IncomingMessage.emit (node:events:531:35)
at endReadableNT (node:internal/streams/readable:1698:12)
at processTicksAndRejections (node:internal/process/task_queues:90:21)
```
https://github.com/cube-js/cube/blob/3bfe8121be684fb08e22e27efb59877734276dba/packages/cubejs-prestodb-driver/src/PrestoDriver.ts#L378
**Minimally reproducible Cube Schema**
In case your bug report is data modelling related please put your minimally reproducible Cube Schema here.
You can use selects without tables in order to achieve that as follows.
```javascript
cube(`Orders`, {
sql: `
select 1 as id, 100 as amount, 'new' status
UNION ALL
select 2 as id, 200 as amount, 'new' status
UNION ALL
select 3 as id, 300 as amount, 'processed' status
UNION ALL
select 4 as id, 500 as amount, 'processed' status
UNION ALL
select 5 as id, 600 as amount, 'shipped' status
`,
measures: {
count: {
type: `count`,
},
totalAmount: {
sql: `amount`,
type: `sum`,
},
toRemove: {
type: `count`,
},
},
dimensions: {
status: {
sql: `status`,
type: `string`,
},
},
});
```
**Version:**
1.6.30
**Additional context**
Contributor guide
Assessment
This issue has not been assessed yet.