Improved Q9 by moving BuildFlatmapStage to a later stage and adding a Flatmap pushdown

[pashandor789]

Changelog category

• Improvement

[github-actions[bot]]

:white_circle: 2024-11-21 15:47:01 UTC Pre-commit check for e1a37be4dd2a0c79b33b0e7983d5c83cababdeb9 has started. :white_circle: 2024-11-21 15:49:41 UTC Build linux-x86_64-release-asan is running... :green_circle: 2024-11-21 16:14:13 UTC Build successful. :white_circle: 2024-11-21 16:14:29 UTC Tests are running... :red_circle: 2024-11-21 18:22:26 UTC Some tests failed, follow the links below.

Test history	Test log	TESTS	PASSED	ERRORS	FAILED	SKIPPED	MUTED?
11016	10877	0	45	53	41

:yellow_circle: 2024-11-21 18:23:07 UTC ydbd size 5.6 GiB changed* by +163.9 KiB, which is >= 100.0 KiB vs stable-24-3: Warning	ydbd size dash	stable-24-3: 45d8eb2e52eb8efd561854d742d132ad2f5f35d1	merge: e1a37be4dd2a0c79b33b0e7983d5c83cababdeb9	diff	diff %
ydbd size	5 997 071 976 Bytes	5 997 239 760 Bytes	+163.9 KiB	+0.003%
ydbd stripped size	1 502 995 744 Bytes	1 503 022 016 Bytes	+25.7 KiB	+0.002%

^{*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]]

:white_circle: 2024-11-21 15:47:08 UTC Pre-commit check for e1a37be4dd2a0c79b33b0e7983d5c83cababdeb9 has started. :white_circle: 2024-11-21 15:49:47 UTC Build linux-x86_64-release-clang14 is running... :green_circle: 2024-11-21 15:57:36 UTC Build successful.

[github-actions[bot]]

:white_circle: 2024-11-21 15:48:17 UTC Pre-commit check for e1a37be4dd2a0c79b33b0e7983d5c83cababdeb9 has started. :white_circle: 2024-11-21 15:51:28 UTC Build linux-x86_64-relwithdebinfo is running... :green_circle: 2024-11-21 16:33:17 UTC Build successful. :white_circle: 2024-11-21 16:33:35 UTC Tests are running... :red_circle: 2024-11-21 18:51:43 UTC Some tests failed, follow the links below.

Test history	Test log	TESTS	PASSED	ERRORS	FAILED	SKIPPED	MUTED?
72113	58606	0	27	13435	45

:yellow_circle: 2024-11-21 18:52:27 UTC ydbd size 8.3 GiB changed* by +112.2 KiB, which is >= 100.0 KiB vs stable-24-3: Warning	ydbd size dash	stable-24-3: 45d8eb2e52eb8efd561854d742d132ad2f5f35d1	merge: e1a37be4dd2a0c79b33b0e7983d5c83cababdeb9	diff	diff %
ydbd size	8 864 941 528 Bytes	8 865 056 472 Bytes	+112.2 KiB	+0.001%
ydbd stripped size	484 007 048 Bytes	484 014 984 Bytes	+7.8 KiB	+0.002%

^{*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]]

:white_circle: 2024-11-22 12:14:08 UTC Pre-commit check for e658933188030355503891cac0975daef7e94e8b has started. :white_circle: 2024-11-22 12:16:48 UTC Build linux-x86_64-relwithdebinfo is running... :green_circle: 2024-11-22 12:59:17 UTC Build successful. :white_circle: 2024-11-22 12:59:38 UTC Tests are running... :red_circle: 2024-11-22 15:07:12 UTC Some tests failed, follow the links below.

Test history	Test log	TESTS	PASSED	ERRORS	FAILED	SKIPPED	MUTED?
72114	58624	0	18	13433	39

:yellow_circle: 2024-11-22 15:08:08 UTC ydbd size 8.3 GiB changed* by +112.2 KiB, which is >= 100.0 KiB vs stable-24-3: Warning	ydbd size dash	stable-24-3: 0ab8d25ccdeb93fa7f6e62c13edc0c26aa6e50fb	merge: e658933188030355503891cac0975daef7e94e8b	diff	diff %
ydbd size	8 865 263 456 Bytes	8 865 378 392 Bytes	+112.2 KiB	+0.001%
ydbd stripped size	484 011 848 Bytes	484 019 784 Bytes	+7.8 KiB	+0.002%

^{*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]]

:white_circle: 2024-11-22 12:14:14 UTC Pre-commit check for e658933188030355503891cac0975daef7e94e8b has started. :white_circle: 2024-11-22 12:16:53 UTC Build linux-x86_64-release-asan is running... :green_circle: 2024-11-22 12:41:05 UTC Build successful. :white_circle: 2024-11-22 12:41:19 UTC Tests are running... :red_circle: 2024-11-22 14:49:50 UTC Some tests failed, follow the links below.

Test history	Test log	TESTS	PASSED	ERRORS	FAILED	SKIPPED	MUTED?
11024	10891	0	41	50	42

:yellow_circle: 2024-11-22 14:50:47 UTC ydbd size 5.6 GiB changed* by +167.9 KiB, which is >= 100.0 KiB vs stable-24-3: Warning	ydbd size dash	stable-24-3: 0ab8d25ccdeb93fa7f6e62c13edc0c26aa6e50fb	merge: e658933188030355503891cac0975daef7e94e8b	diff	diff %
ydbd size	5 996 910 576 Bytes	5 997 082 456 Bytes	+167.9 KiB	+0.003%
ydbd stripped size	1 503 010 976 Bytes	1 503 041 344 Bytes	+29.7 KiB	+0.002%

^{*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]]

:white_circle: 2024-11-22 12:14:17 UTC Pre-commit check for e658933188030355503891cac0975daef7e94e8b has started. :white_circle: 2024-11-22 12:17:08 UTC Build linux-x86_64-release-clang14 is running... :green_circle: 2024-11-22 12:25:19 UTC Build successful.