193 Commits

Author SHA1 Message Date
Birk df53d48e67 Merge branch 'OS-220' of https://gitea.de-infra.servehttp.com/de-infrastructure/DWH into OS-220 2026-01-06 18:22:48 +03:00
Birk a4e637d3a2 Оптимизация MV: замена NOT IN на ANTI JOIN 2026-01-06 18:16:55 +03:00
maxim drozdov 23e4bbf935 Merge branch 'main' into OS-310 2026-01-06 16:02:34 +04:00
dr0zd 88db25d7d5 added safety div with nullif 2026-01-06 16:36:58 +07:00
dr0zd c1d1796679 platform_summary materialized view 2026-01-06 01:41:49 +07:00
elena belykh 9e35fa45cd решение разделу JOIN 2026-01-05 19:45:20 +03:00
dr0zd 1ffc98b49d added round in avg_views_per_user 2026-01-05 22:59:05 +07:00
dr0zd 23bb973ab0 course_summary materialized view 2026-01-05 22:56:56 +07:00
anton 3a09d8463e join leetcode solve 2026-01-05 18:11:27 +03:00
yurij birk 50048f4878 Merge branch 'main' into OS-220 2026-01-05 16:20:54 +04:00
abogatyrev d514c04a88 Merge pull request 'OS-47' (#22) from OS-47 into main
Reviewed-on: https://gitea.de-infra.servehttp.com/de-infrastructure/DWH/pulls/22
Reviewed-by: aleksey bogatyrev <abogatyrev@example.com>
2026-01-05 14:04:41 +04:00
abogatyrev c2c1e852d5 Merge branch 'main' into OS-47 2026-01-05 14:04:32 +04:00
anton dd2fa7be31 filtr tasks 2026-01-05 12:39:00 +03:00
dr0zd 45a59582e0 user_activity_summary materialized view 2026-01-05 03:29:12 +07:00
dr0zd c90c7c2b09 completed stage 1 creation tables and relations 2026-01-04 22:59:36 +07:00
elena belykh 28c5dee5d8 решение задач по фильтрации SQL 2026-01-04 15:57:21 +03:00
elena belykh f94e27893d Решение по базовый SQL 2026-01-04 12:22:40 +03:00
Birk 4f017d0efd миграция таблиц на ReplicatedMergeTree с поддержкой кластера
добавил примеры для проверки
2026-01-03 16:24:51 +03:00
Batirbulat 3297ddb2b5 Исправился по всем замечаниям 2025-12-31 17:51:04 +03:00
anton 6e4b0f693f first leetcode solve 2025-12-31 13:49:54 +03:00
anton ea5463ad3c test commit 2025-12-29 19:04:32 +03:00
abogatyrev a99a7368ae Merge pull request 'added STEP 1, 3, 4.3' (#32) from OS-233 into main
Reviewed-on: https://gitea.de-infra.servehttp.com/de-infrastructure/DWH/pulls/32
Reviewed-by: aleksey bogatyrev <abogatyrev@example.com>
2025-12-29 16:57:30 +04:00
abogatyrev 4a00777da3 Merge branch 'main' into OS-233 2025-12-29 16:57:22 +04:00
SERGEY_KONEV 207c435477 fixed reltive last comments 2025-12-27 17:41:27 +03:00
SERGEY_KONEV ebc2f07fc8 added STEP4.1, STEP4.2, STEP5 2025-12-25 12:25:42 +03:00
SERGEY_KONEV 6b5ae71123 fixed according last comments 2025-12-24 22:52:42 +03:00
Batirbulat e7f7bb8dc6 Комментарии написаны, таблицы приведены в порядок 2025-12-24 21:07:56 +03:00
SERGEY_KONEV b9c57af980 added STEP 1, 3, 4.3 2025-12-23 21:03:02 +03:00
Birk cc04025ade Выполнил миграцию и МВ 2025-12-22 21:16:50 +03:00
abogatyrev b2fc875eba Merge pull request 'Alex' (#31) from Alex into main
Reviewed-on: https://gitea.de-infra.servehttp.com/de-infrastructure/DWH/pulls/31
2025-12-21 18:45:10 +04:00
abogatyrev 37601f0c20 Merge branch 'main' into Alex 2025-12-21 18:45:00 +04:00
Alex d24bceef59 Create table + insert into 2025-12-21 12:08:22 +03:00
Alex c66c5886c7 add table+insert into 2025-12-21 11:33:56 +03:00
abogatyrev 05801b9de9 Merge pull request 'added three data_mart_files' (#30) from OS-227 into main
Reviewed-on: https://gitea.de-infra.servehttp.com/de-infrastructure/DWH/pulls/30
Reviewed-by: aleksey bogatyrev <abogatyrev@example.com>
2025-12-19 16:30:28 +04:00
abogatyrev 2d740442b3 Merge branch 'main' into OS-227 2025-12-19 16:30:20 +04:00
SERGEY_KONEV d7a1b19213 fix course_summary and user_activity files 2025-12-19 11:39:12 +03:00
Alex e7e91cf2d6 test commit 2025-12-18 19:36:45 +03:00
abogatyrev 50fb3cbf02 Merge pull request 'added create_tables and inser_data files' (#29) from OS-226 into main
Reviewed-on: https://gitea.de-infra.servehttp.com/de-infrastructure/DWH/pulls/29
2025-12-18 19:44:05 +04:00
abogatyrev f50712dc43 Merge branch 'main' into OS-226 2025-12-18 19:43:49 +04:00
Batirbulat ad47dd718e Добил клик, написал везде комментарии 2025-12-17 19:35:04 +03:00
Batirbulat 7fb8409941 Не менял ничего 2025-12-17 19:31:06 +03:00
SERGEY_KONEV 18f736dea4 added three data_mart_files 2025-12-17 14:28:42 +03:00
SERGEY_KONEV 4b601522ca added create_tables and inser_data files 2025-12-17 13:29:08 +03:00
Birk 497819c7fd migration to ckickhouse 2025-12-14 20:28:38 +03:00
abogatyrev e16c79f94f Merge pull request 'Polikanov63' (#21) from Polikanov63 into main
Reviewed-on: https://gitea.de-infra.servehttp.com/de-infrastructure/DWH/pulls/21
Reviewed-by: aleksey bogatyrev <abogatyrev@example.com>
2025-12-14 06:27:23 +04:00
abogatyrev c0a486f7a3 Merge pull request 'OS-158' (#23) from OS-158 into main
Reviewed-on: https://gitea.de-infra.servehttp.com/de-infrastructure/DWH/pulls/23
Reviewed-by: aleksey bogatyrev <abogatyrev@example.com>
2025-12-14 06:25:25 +04:00
abogatyrev 445b4b3edb Merge pull request 'OS-253' (#24) from OS-253 into main
Reviewed-on: https://gitea.de-infra.servehttp.com/de-infrastructure/DWH/pulls/24
2025-12-14 06:22:02 +04:00
George aaef806630 Добавил проверку на null в две датамарта 2025-12-13 22:06:10 +03:00
itikhomirov 3fc1900925 Delete .DS_store 2025-12-13 18:02:03 +04:00
itikhomirov 428c4bdd88 Delete .DS_store 2025-12-13 18:01:55 +04:00