cube-js / cube-js/cube

Trino / Iceberg catalog export bucket bug

Open
#10,627 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.