Skip to content
Backend CI

feat(data-warehouse): use materialized view in hogql #99827

Sign in to view logs

feat(data-warehouse): use materialized view in hogql

feat(data-warehouse): use materialized view in hogql #99827

Triggered via pull request October 2, 2024 20:40
@posthog-botposthog-bot
synchronize #25187
dw-materialized-use-new-tables
Status Failure
Total duration 33m 40s
Artifacts 1

ci-backend.yml

on: pull_request
Determine need to run backend checks
8s
Determine need to run backend checks
Matrix: async-migrations
Matrix: django
Python code quality checks
2m 44s
Python code quality checks
Validate Django and CH migrations
3m 19s
Validate Django and CH migrations
Calculate running time
6s
Calculate running time
Fit to window
Zoom out
Zoom in

Annotations

2 errors and 47 warnings
Python code quality checks: posthog/warehouse/data_load/create_table.py#L55
Incompatible types in assignment (expression has type "Any | None", variable has type "str | int | Combinable")
Python code quality checks
Process completed with exit code 1.
Determine need to run backend checks
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, dorny/paths-filter@v2. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Python code quality checks
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Validate Django and CH migrations
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Async migrations tests - clickhouse/clickhouse-server:23.12.6.19-alpine
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (7/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (10/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (4/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (9/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (5/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (8/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (2/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (1/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (6/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (3/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (9/10)
No files were found with the provided path: .test_durations. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (9/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (9/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (2/10)
No files were found with the provided path: .test_durations. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (2/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (2/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (1/10)
No files were found with the provided path: .test_durations. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (1/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (1/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (3/10)
No files were found with the provided path: .test_durations. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (3/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (3/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (10/10)
No files were found with the provided path: .test_durations. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (10/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (10/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (8/10)
No files were found with the provided path: .test_durations. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (8/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (7/10)
No files were found with the provided path: .test_durations. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (7/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (7/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (4/10)
No files were found with the provided path: .test_durations. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (4/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (4/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (5/10)
No files were found with the provided path: .test_durations. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (5/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (5/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Temporal (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (1/1)
No files were found with the provided path: .test_durations. No artifacts will be uploaded.
Django tests – Temporal (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (1/1)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (6/10)
No files were found with the provided path: .test_durations. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (6/10)
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19-alpine (6/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Calculate running time
The following actions use a deprecated Node.js version and will be forced to run on node20: PostHog/[email protected]. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Deprecation notice: v1, v2, and v3 of the artifact actions
The following artifacts were uploaded using a version of actions/upload-artifact that is scheduled for deprecation: "email_renders". Please update your workflow to use v4 of the artifact actions. Learn more: https://github.blog/changelog/2024-04-16-deprecation-notice-v3-of-the-artifact-actions/

Artifacts

Produced during runtime
Name Size
email_renders Expired
59.4 KB