Skip to content
Backend CI

feat: add "INTERSECT" and "EXCEPT" to HogQL #102253

Sign in to view logs

feat: add "INTERSECT" and "EXCEPT" to HogQL

feat: add "INTERSECT" and "EXCEPT" to HogQL #102253

Triggered via pull request October 24, 2024 23:20
@aspiceraspicer
synchronize #25737
aspicer/intersect
Status Failure
Total duration 31m 39s
Artifacts –

ci-backend.yml

on: pull_request
Determine need to run backend checks
10s
Determine need to run backend checks
Matrix: async-migrations
Matrix: django
Python code quality checks
2m 46s
Python code quality checks
Validate Django and CH migrations
4m 32s
Validate Django and CH migrations
Calculate running time
0s
Calculate running time
Fit to window
Zoom out
Zoom in

Annotations

8 errors and 38 warnings
Python code quality checks: posthog/hogql/resolver.py#L140
List item 0 has incompatible type "SelectQueryType | SelectUnionQueryType | None"; expected "SelectQueryType | SelectUnionQueryType"
Python code quality checks: posthog/hogql/resolver.py#L140
List item 1 has incompatible type "Generator[SelectQueryType | SelectUnionQueryType | None, None, None]"; expected "SelectQueryType | SelectUnionQueryType"
Python code quality checks: posthog/hogql/resolver.py#L141
Unused "type: ignore" comment
Python code quality checks
Process completed with exit code 5.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19 (2/10)
Process completed with exit code 139.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19 (1/10)
Process completed with exit code 1.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19 (8/10)
Process completed with exit code 1.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19 (6/10)
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: n1hility/cancel-previous-runs@v3, 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
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/
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19 (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 (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 (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 (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 (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 (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 (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 (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 (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 (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 (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 off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19 (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 (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 (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 (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 off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19 (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 off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19 (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 (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 (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 (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 (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 (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 (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 (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 (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 (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 (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 (7/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 (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 (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 (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 off), Py 3.11.9, clickhouse/clickhouse-server:23.12.6.19 (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 (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 (5/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.