Describe the bug
Trino / Iceberg / GCP export bucket bug
To Reproduce
Steps to reproduce the behavior:
- Trino source configured with Iceberg catalog
- 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.<anonymous> (/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)
|
const withParams = `( external_location = '${externalLocation}', format = 'CSV')`; |
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.
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
Describe the bug
Trino / Iceberg / GCP export bucket bug
To Reproduce
Steps to reproduce the behavior:
Expected behavior
Pre aggregations don't fail with exception
Screenshots
cube/packages/cubejs-prestodb-driver/src/PrestoDriver.ts
Line 378 in 3bfe812
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.
Version:
1.6.30
Additional context