ydb-platform / ydb

YDB is an open source Distributed SQL Database that combines high availability and scalability with strong consistency and ACID transactions
https://ydb.tech
Apache License 2.0
3.5k stars 491 forks source link

Fuse ExtractMembers and Aggregate via Aggregate setting #6050

Closed nepal closed 3 days ago

nepal commented 3 days ago

Changelog entry

Changelog category

Additional information

...

github-actions[bot] commented 3 days ago

:white_circle: 2024-06-27 18:18:12 UTC Pre-commit check for ef35bff15f944a5ca0eaa600c5e2b2e85b3dadd7 has started. :white_circle: 2024-06-27 18:21:37 UTC Build linux-x86_64-release-asan is running... :green_circle: 2024-06-27 18:49:18 UTC Build successful. :white_circle: 2024-06-27 18:49:32 UTC Tests are running... :red_circle: 2024-06-27 21:04:35 UTC Some tests failed, follow the links below.

Test history Test log TESTS PASSED ERRORS FAILED SKIPPED MUTED?
12225 11585 0 112 353 175
:green_circle: 2024-06-27 21:05:24 UTC ydbd size 5.5 GiB changed* by -144.2 KiB, which is <= 0 Bytes vs main: OK ydbd size dash main: b62f2473003d50acd89dbe9bd11eb99a3f3adbdd merge: ef35bff15f944a5ca0eaa600c5e2b2e85b3dadd7 diff diff %
ydbd size 5 918 171 288 Bytes 5 918 023 576 Bytes -144.2 KiB -0.002%
ydbd stripped size 1 271 363 592 Bytes 1 271 356 808 Bytes -6.6 KiB -0.001%

*please be aware that the difference is based on comparing your commit and the last completed build from the post-commit, check comparation

nepal commented 3 days ago

Добавляем настройку output_columns в Aggregate - это позволяет склеить ExtractMembers over Aggregate и улучшить работу оптимизаторов (например pushodown фильтров через агрегацию)

github-actions[bot] commented 3 days ago

:white_circle: 2024-06-27 18:18:53 UTC Pre-commit check for ef35bff15f944a5ca0eaa600c5e2b2e85b3dadd7 has started. :white_circle: 2024-06-27 18:21:26 UTC Build linux-x86_64-release-clang14 is running... :green_circle: 2024-06-27 19:26:47 UTC Build successful.

github-actions[bot] commented 3 days ago

:white_circle: 2024-06-27 18:25:50 UTC Pre-commit check for ef35bff15f944a5ca0eaa600c5e2b2e85b3dadd7 has started. :white_circle: 2024-06-27 18:28:55 UTC Build linux-x86_64-relwithdebinfo is running... :green_circle: 2024-06-27 19:09:00 UTC Build successful. :white_circle: 2024-06-27 19:09:14 UTC Tests are running... :red_circle: 2024-06-27 21:28:16 UTC Some tests failed, follow the links below.

Test history Test log TESTS PASSED ERRORS FAILED SKIPPED MUTED?
73139 59742 0 4 13377 16
:green_circle: 2024-06-27 21:28:57 UTC ydbd size 8.4 GiB changed* by -254.1 KiB, which is <= 0 Bytes vs main: OK ydbd size dash main: b62f2473003d50acd89dbe9bd11eb99a3f3adbdd merge: ef35bff15f944a5ca0eaa600c5e2b2e85b3dadd7 diff diff %
ydbd size 9 024 324 960 Bytes 9 024 064 776 Bytes -254.1 KiB -0.003%
ydbd stripped size 492 866 504 Bytes 492 862 088 Bytes -4.3 KiB -0.001%

*please be aware that the difference is based on comparing your commit and the last completed build from the post-commit, check comparation

github-actions[bot] commented 3 days ago

:white_circle: 2024-06-28 12:30:36 UTC Pre-commit check for f7d9d48f3089ccfbe9f2083f77591fd5e054a524 has started. :white_circle: 2024-06-28 12:33:15 UTC Build linux-x86_64-release-asan is running... :green_circle: 2024-06-28 12:59:22 UTC Build successful. :white_circle: 2024-06-28 12:59:36 UTC Tests are running... :red_circle: 2024-06-28 15:09:32 UTC Some tests failed, follow the links below.

Test history Test log TESTS PASSED ERRORS FAILED SKIPPED MUTED?
12226 11602 0 102 351 171
:green_circle: 2024-06-28 15:10:17 UTC ydbd size 5.5 GiB changed* by -140.3 KiB, which is <= 0 Bytes vs main: OK ydbd size dash main: c426e834cb85687004bbee6e80d054ee4fcf9de2 merge: f7d9d48f3089ccfbe9f2083f77591fd5e054a524 diff diff %
ydbd size 5 901 830 304 Bytes 5 901 686 624 Bytes -140.3 KiB -0.002%
ydbd stripped size 1 268 873 416 Bytes 1 268 870 664 Bytes -2.7 KiB -0.000%

*please be aware that the difference is based on comparing your commit and the last completed build from the post-commit, check comparation

github-actions[bot] commented 3 days ago

:white_circle: 2024-06-28 12:34:25 UTC Pre-commit check for f7d9d48f3089ccfbe9f2083f77591fd5e054a524 has started. :white_circle: 2024-06-28 12:37:01 UTC Build linux-x86_64-release-clang14 is running... :green_circle: 2024-06-28 13:26:10 UTC Build successful.

github-actions[bot] commented 3 days ago

:white_circle: 2024-06-28 12:34:47 UTC Pre-commit check for f7d9d48f3089ccfbe9f2083f77591fd5e054a524 has started. :white_circle: 2024-06-28 12:37:23 UTC Build linux-x86_64-relwithdebinfo is running... :green_circle: 2024-06-28 13:19:24 UTC Build successful. :white_circle: 2024-06-28 13:19:35 UTC Tests are running... :red_circle: 2024-06-28 15:47:22 UTC Some tests failed, follow the links below.

Test history Test log TESTS PASSED ERRORS FAILED SKIPPED MUTED?
73129 59736 0 4 13376 13
:green_circle: 2024-06-28 15:48:05 UTC ydbd size 8.4 GiB changed* by -250.1 KiB, which is <= 0 Bytes vs main: OK ydbd size dash main: c426e834cb85687004bbee6e80d054ee4fcf9de2 merge: f7d9d48f3089ccfbe9f2083f77591fd5e054a524 diff diff %
ydbd size 8 998 134 872 Bytes 8 997 878 728 Bytes -250.1 KiB -0.003%
ydbd stripped size 492 071 304 Bytes 492 070 984 Bytes -320 Bytes -0.000%

*please be aware that the difference is based on comparing your commit and the last completed build from the post-commit, check comparation