193 Commits

Author SHA1 Message Date
abogatyrev c0f5f0dc5e Merge pull request 'add homework2' (#114) from test1232131231232131231 into main
Reviewed-on: https://gitea.de-infra.servehttp.com/de-infrastructure/DWH/pulls/114
2026-03-02 11:27:06 +04:00
Aleksey Bogatyrev 868ea8ca03 fix homework2.sql 2026-03-02 11:26:12 +04:00
Aleksey Bogatyrev e2029b1f74 add homework2 2026-03-02 11:24:16 +04:00
Aleksey Bogatyrev 7d0193e046 add postgresql homework.sql 2026-03-02 11:21:28 +04:00
abogatyrev 13d505ea1c Merge pull request 'SQL Homework' (#52) from sql_homework into main
Reviewed-on: https://gitea.de-infra.servehttp.com/de-infrastructure/DWH/pulls/52
Reviewed-by: aleksey bogatyrev <abogatyrev@example.com>
2026-03-01 13:06:59 +04:00
Alex cd4e5335aa PET task 4 finished 2026-02-28 16:07:09 +03:00
Alex de4a0fa2ec PET task 4 fixed 2026-02-27 15:31:56 +03:00
Alex 5854cdbd21 Name changed to task3 2026-02-26 15:21:31 +03:00
Alex ace9b8b292 Task 2 fixed 2026-02-26 15:17:39 +03:00
Alex c95a867e13 PET Extra Tasks completed 2026-02-24 14:58:16 +03:00
Alex 9dedbfc3eb PET 2nd task fixed 2026-02-23 15:06:03 +03:00
Alex 4d56aa1f5b Pet 6th task completed 2026-02-23 15:02:11 +03:00
Alex a109cadca2 Added LEFT JOIN and NULLIF to Task 5 2026-02-23 13:22:24 +03:00
Alex 1f66082271 PET 5th task completed 2026-02-20 15:13:14 +03:00
Alex 93ae8af223 PET 4th task completed 2026-02-19 14:31:52 +03:00
Alex 1fa2d88bf2 PET project task 3 completed 2026-02-18 14:41:23 +03:00
Alex 0c4ad4965d PET 2nd task completed 2026-02-17 15:08:15 +03:00
Alex e67862e09c Merge branch 'sql_homework' of https://gitea.de-infra.servehttp.com/de-infrastructure/DWH into sql_homework 2026-02-17 06:41:55 +03:00
Alex 0efca05db5 NOT NULL added into users table 2026-02-17 06:41:34 +03:00
abogatyrev 16bf047399 Merge branch 'main' into sql_homework 2026-02-17 02:16:51 +04:00
Alex 0c961319b9 PET-project 1st task completed 2026-02-16 13:16:37 +03:00
abogatyrev ffac63ff37 Merge pull request 'OS-52,53,54' (#51) from OS-52-fix into main
Reviewed-on: https://gitea.de-infra.servehttp.com/de-infrastructure/DWH/pulls/51
2026-02-16 13:17:32 +04:00
Alex 87ba57befe FIXED 2026-02-16 11:05:00 +03:00
Alex 4aa11c0136 All homework SQL2.0 done in one file 2026-02-15 15:30:39 +03:00
Alex df8159a287 deleted old homework 2026-02-13 16:10:48 +03:00
dsolovianov d5c83ba028 Merge branch 'main' into OS-52-fix 2026-02-12 20:46:47 +04:00
Bonifatsiy e4b9437418 Merge branch 'OS-52-fix' of https://gitea.de-infra.servehttp.com/de-infrastructure/DWH into OS-52-fix 2026-02-12 20:35:13 +04:00
Bonifatsiy d7f84de43f Clickhouse - Типы таблиц - Домашки 2026-02-12 20:35:06 +04:00
abogatyrev 53d802bb89 Merge pull request 'OS-319' (#76) from OS-319 into main
Reviewed-on: https://gitea.de-infra.servehttp.com/de-infrastructure/DWH/pulls/76
Reviewed-by: aleksey bogatyrev <abogatyrev@example.com>
2026-02-09 16:58:15 +04:00
Alex 0bdc2ef452 fixed task№4 boolean 2026-02-08 12:55:07 +03:00
abogatyrev 84fd29ea9e Merge branch 'main' into OS-319 2026-02-08 13:10:57 +04:00
Alex edc1e0af19 Merge branch 'sql_homework' of https://gitea.de-infra.servehttp.com/de-infrastructure/DWH into sql_homework 2026-02-07 14:20:16 +03:00
Alex 311f6b259b Pet project DDL&DML done 2026-02-07 14:19:52 +03:00
dr0zd bb70e5a0bd finish pet-project clickhouse 2026-02-06 06:50:41 +07:00
abogatyrev 5faf258f47 Merge branch 'main' into sql_homework 2026-02-05 20:28:35 +04:00
dr0zd ee22e5a28d full solve, but still dont work 2026-02-05 23:24:49 +07:00
Alex b7c7dcf012 WindowFuncs Homework done 2026-02-05 13:44:24 +03:00
dr0zd b5f9e9724e fixed core_dim_lesson table primary key 2026-02-05 01:44:56 +07:00
dr0zd 3a71777fdd fixed comments stage1 pet-project clickhouse 2026-02-04 18:47:38 +07:00
dr0zd e5d51559c9 WIP: pet-project clickhouse MVs 2026-02-02 02:18:43 +07:00
Alex 63f391d689 fixed 2026-02-01 13:17:20 +03:00
Alex 5d31d01875 window function Task 1 completed 2026-02-01 10:04:31 +03:00
abogatyrev 2d94499d1f Merge pull request 'OS-401' (#69) from OS-401 into main
Reviewed-on: https://gitea.de-infra.servehttp.com/de-infrastructure/DWH/pulls/69
Reviewed-by: aleksey bogatyrev <abogatyrev@example.com>
2026-01-31 06:09:10 +04:00
dr0zd 0433c72828 fix comments 2026-01-31 03:29:26 +07:00
dr0zd 73988517db stage 1 tables 2026-01-31 01:16:20 +07:00
dr0zd eca39dbcee indexes 2026-01-29 23:22:44 +07:00
dr0zd 341302725d partitions solutions 2026-01-29 20:36:44 +07:00
dr0zd 0e385bd6d0 task up to arrays 2026-01-29 04:50:55 +07:00
dr0zd 97d55ac267 OS-314 fixes because I've broken full git struct 2026-01-29 04:46:45 +07:00
abogatyrev a093986c15 Merge branch 'main' into OS-52-fix 2026-01-25 15:17:11 +04:00