getting this issue after adding preaggregations #10217
Description
my error :
Performing query completed: scheduler-4ecb3da5-cef8-4ed4-b10e-d45907c428ae (2ms)
cubejs-1 | Performing query: scheduler-4ecb3da5-cef8-4ed4-b10e-d45907c428ae
cubejs-1 | Executing Load Pre Aggregation SQL: scheduler-4ecb3da5-cef8-4ed4-b10e-d45907c428ae
cubejs-1 | --
cubejs-1 | SELECT
cubejs-1 | `comp_alerts_mg`.alert `comp_alerts_mg__alert`, `comp_alerts_mg`.alert_status `comp_alerts_mg__alert_status`, `comp_alerts_mg`.company_id `comp_alerts_mg__company_id`, `comp_alerts_mg`.component `comp_alerts_mg__component`, `comp_alerts_mg`.division_id `comp_alerts_mg__division_id`, `comp_alerts_mg`.site_id `comp_alerts_mg__site_id`, CAST(DATE_FORMAT(CONVERT_TZ(`comp_alerts_mg`.alert_time, @@session.time_zone, '+00:00'), '%Y-%m-%dT00:00:00.000') AS DATETIME) `comp_alerts_mg__alert_open_time_day`, count(*) `comp_alerts_mg__alerts_count`
cubejs-1 | FROM
cubejs-1 | notification_report_generic_component_alert_data AS `comp_alerts_mg` GROUP BY 1, 2, 3, 4, 5, 6, 7
cubejs-1 | --
cubejs-1 | **Uploading external pre-aggregation error: scheduler-4ecb3da5-cef8-4ed4-b10e-d45907c428ae**
cubejs-1 | --
cubejs-1 | SELECT
cubejs-1 | `comp_alerts_mg`.alert `comp_alerts_mg__alert`, `comp_alerts_mg`.alert_status `comp_alerts_mg__alert_status`, `comp_alerts_mg`.company_id `comp_alerts_mg__company_id`, `comp_alerts_mg`.component `comp_alerts_mg__component`, `comp_alerts_mg`.division_id `comp_alerts_mg__division_id`, `comp_alerts_mg`.site_id `comp_alerts_mg__site_id`, CAST(DATE_FORMAT(CONVERT_TZ(`comp_alerts_mg`.alert_time, @@session.time_zone, '+00:00'), '%Y-%m-%dT00:00:00.000') AS DATETIME) `comp_alerts_mg__alert_open_time_day`, count(*) `comp_alerts_mg__alerts_count`
cubejs-1 | FROM
cubejs-1 | notification_report_generic_component_alert_data AS `comp_alerts_mg` GROUP BY 1, 2, 3, 4, 5, 6, 7
cubejs-1 | --
cubejs-1 | {
cubejs-1 | "queryKey": [
cubejs-1 | [
cubejs-1 | "CREATE TABLE dev_pre_aggregations.comp_alerts_mg_alert_details AS SELECT\n `comp_alerts_mg`.alert `comp_alerts_mg__alert`, `comp_alerts_mg`.alert_status `comp_alerts_mg__alert_status`, `comp_alerts_mg`.company_id `comp_alerts_mg__company_id`, `comp_alerts_mg`.component `comp_alerts_mg__component`, `comp_alerts_mg`.division_id `comp_alerts_mg__division_id`, `comp_alerts_mg`.site_id `comp_alerts_mg__site_id`, CAST(DATE_FORMAT(CONVERT_TZ(`comp_alerts_mg`.alert_time, @@session.time_zone, '+00:00'), '%Y-%m-%dT00:00:00.000') AS DATETIME) `comp_alerts_mg__alert_open_time_day`, count(*) `comp_alerts_mg__alerts_count`\n FROM\n notification_report_generic_component_alert_data AS `comp_alerts_mg` GROUP BY 1, 2, 3, 4, 5, 6, 7",
cubejs-1 | []
cubejs-1 | ],
cubejs-1 | [
cubejs-1 | [
cubejs-1 | {
cubejs-1 | "refresh_key": "2941389"
cubejs-1 | }
cubejs-1 | ]
cubejs-1 | ]
cubejs-1 | ],
cubejs-1 | "targetTableName": "dev_pre_aggregations.comp_alerts_mg_alert_details_0lfucaap_4yn0b2zk_1kj2e7n",
cubejs-1 | "newVersionEntry": {
cubejs-1 | "table_name": "dev_pre_aggregations.comp_alerts_mg_alert_details",
cubejs-1 | "structure_version": "4yn0b2zk",
cubejs-1 | "content_version": "0lfucaap",
cubejs-1 | "last_updated_at": 1764833527636,
cubejs-1 | "naming_version": 2
cubejs-1 | }
cubejs-1 | }
I see the temp-uploads in the .cubestore/data
env:
I use windows Laptop
cube store hosted in s3
mysql db