digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
1 [labelType="html" label="<br><b>TakeOrderedAndProject</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 1 ms";
3 [labelType="html" label="<b>HashAggregate</b><br><br>spill size: 0.0 B<br>time in aggregation build: 0 ms<br>peak memory: 16.3 MiB<br>number of output rows: 32<br>number of sort fallback tasks: 0<br>avg hash probes per key: 1"];
}
4 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 1397.0 B<br>number of coalesced partitions: 1"];
5 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 32<br>local merged chunks fetched: 0<br>shuffle write time: 1 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 32<br>local bytes read: 1335.0 B<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 1248.0 B<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 1335.0 B"];
subgraph cluster6 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 261 ms";
7 [labelType="html" label="<b>HashAggregate</b><br><br>spill size: 0.0 B<br>time in aggregation build: 235 ms<br>peak memory: 256.0 KiB<br>number of output rows: 32<br>number of sort fallback tasks: 0<br>avg hash probes per key: 0"];
8 [labelType="html" label="<br><b>Project</b><br><br>"];
9 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 554"];
10 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 1,455<br>number of input batches: 1"];
}
11 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 9 ms<br>metadata time: 0 ms<br>size of files read: 276.8 KiB<br>number of output rows: 1,455"];
1->0;
3->1;
4->3;
5->4;
7->5;
8->7;
9->8;
10->9;
11->10;
}
12
AdaptiveSparkPlan isFinalPlan=true
TakeOrderedAndProject(limit=10, orderBy=[COL_5CDC74F0_3D28_463C_9042_237BDAB525402#151823L DESC NULLS LAST], output=[COL_5CDC74F0_3D28_463C_9042_237BDAB525401#151765,COL_5CDC74F0_3D28_463C_9042_237BDAB525402#151823L])
HashAggregate(keys=[COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731], functions=[count(1)])
WholeStageCodegen (2)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731, 10), ENSURE_REQUIREMENTS, [plan_id=20253]
HashAggregate(keys=[COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731], functions=[partial_count(1)])
Project [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379 AS COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731]
Filter ((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#150336)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#150336)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#150337)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#150337)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#150338)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#150338)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#150339)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#150339)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#150340)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#150340)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#150341)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#150341)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#150342)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#150342)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#150343)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#150343)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#150344)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#150344)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#150345)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#150345)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#150346)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#150346)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#150347)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#150347)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#150349)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#150349)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#150351)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#150351)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#150355)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#150355)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#150356)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#150356)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#150357)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#150357)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#150358)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#150358)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#150359)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#150359)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#150360)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#150360)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#150361)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#150361)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#150362)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#150362)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#150363)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#150363)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#150364)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#150364)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#150365)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#150365)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#150367)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#150367)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#150368)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#150368)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#150369)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#150369)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#150370)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#150370)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#150371)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#150371)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#150372)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#150372)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#150373)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#150373)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#150374)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#150374)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#150375)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#150375)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#150376)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#150376)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#150377)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#150377)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#150378)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#150378)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 08 - NR, is_null, [null], [0.0], 08 - NR, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 08 - NR, is_null, [null], [0.0], 08 - NR, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MEUBLE) END, Meublé, Non Meublé))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MEUBLE) END, Meublé, Non Meublé))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_get(str_extract_by_regex(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348, T\d+), 0))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(str_list_get(str_extract_by_regex(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348, T\d+), 0))), MAISON) END) AND isnotnull(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379))
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#150336,COL_EC7474ED_A0A6_401C_BA97_20D63A467807#150337,COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#150338,COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#150339,COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#150340,COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#150341,COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#150342,COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#150343,COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#150344,COL_D4E1F01A_72C8_4621_905A_881FB0249F81#150345,COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#150346,COL_871E0000_AA32_4679_83B0_C8AA49007BCF#150347,COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348,COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#150349,COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350,COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#150351,COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353,COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#150355,COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#150356,COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#150357,COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#150358,COL_33CEA792_75B9_44A1_896B_B422BD28B923#150359,COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#150360,COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#150361,... 18 more fields] Batched: true, DataFilters: [(((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405206], PartitionFilters: [], PushedFilters: [IsNotNull(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC)], ReadSchema: struct<COL_BA552F89_FE8A_4EC3_A09E_640A661C9019:string,COL_EC7474ED_A0A6_401C_BA97_20D63A467807:s...
== Physical Plan ==
AdaptiveSparkPlan (17)
+- == Final Plan ==
TakeOrderedAndProject (10)
+- * HashAggregate (9)
+- AQEShuffleRead (8)
+- ShuffleQueryStage (7), Statistics(sizeInBytes=1248.0 B, rowCount=32)
+- Exchange (6)
+- * HashAggregate (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
+- == Initial Plan ==
TakeOrderedAndProject (16)
+- HashAggregate (15)
+- Exchange (14)
+- HashAggregate (13)
+- Project (12)
+- Filter (11)
+- Scan parquet (1)
(1) Scan parquet
Output [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#150336, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#150337, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#150338, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#150339, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#150340, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#150341, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#150342, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#150343, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#150344, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#150345, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#150346, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#150347, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#150349, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#150351, COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#150355, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#150356, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#150357, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#150358, COL_33CEA792_75B9_44A1_896B_B422BD28B923#150359, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#150360, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#150361, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#150362, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#150363, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#150364, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#150365, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#150367, COL_924860D6_14C4_4F33_B84C_E428E89E2817#150368, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#150369, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#150370, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#150371, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#150372, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#150373, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#150374, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#150375, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#150376, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#150377, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#150378, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405206]
PushedFilters: [IsNotNull(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC)]
ReadSchema: struct<COL_BA552F89_FE8A_4EC3_A09E_640A661C9019:string,COL_EC7474ED_A0A6_401C_BA97_20D63A467807:string,COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB:string,COL_8467C1BB_F0A2_44E6_88D6_8477052876CA:string,COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929:string,COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B:string,COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E:string,COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93:string,COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355:string,COL_D4E1F01A_72C8_4621_905A_881FB0249F81:string,COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED:string,COL_871E0000_AA32_4679_83B0_C8AA49007BCF:string,COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8:string,COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C:string,COL_9263F342_2220_4C7C_BA3D_B7B7386988B7:string,COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB:string,COL_0DB61D05_5348_40DB_8F16_C7916849A669:string,COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C:string,COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38:string,COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB:string,COL_BBEA900F_6FE8_40DA_B278_36CA822C312A:string,COL_33CEA792_75B9_44A1_896B_B422BD28B923:string,COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48:string,COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25:string,COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5:string,COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267:string,COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27:string,COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2:string,COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23:string,COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC:string,COL_924860D6_14C4_4F33_B84C_E428E89E2817:string,COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C:string,COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF:string,COL_730C7D9D_95B5_4388_983E_C4F260C553BD:string,COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D:string,COL_90791789_DD87_40BC_92F0_F5FB1BD5126F:string,COL_FB26292A_034B_4B72_8403_8A7AE83CFC56:string,COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E:string,COL_FC403537_BB94_4C83_AC18_B668C51A4E0A:string,COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142:string,COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4:string,COL_0798550D_6632_4F18_8CE3_72BAF75D68CC:string>
(2) ColumnarToRow [codegen id : 1]
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#150336, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#150337, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#150338, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#150339, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#150340, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#150341, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#150342, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#150343, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#150344, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#150345, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#150346, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#150347, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#150349, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#150351, COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#150355, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#150356, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#150357, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#150358, COL_33CEA792_75B9_44A1_896B_B422BD28B923#150359, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#150360, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#150361, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#150362, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#150363, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#150364, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#150365, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#150367, COL_924860D6_14C4_4F33_B84C_E428E89E2817#150368, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#150369, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#150370, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#150371, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#150372, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#150373, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#150374, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#150375, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#150376, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#150377, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#150378, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379]
(3) Filter [codegen id : 1]
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#150336, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#150337, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#150338, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#150339, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#150340, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#150341, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#150342, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#150343, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#150344, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#150345, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#150346, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#150347, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#150349, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#150351, COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#150355, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#150356, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#150357, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#150358, COL_33CEA792_75B9_44A1_896B_B422BD28B923#150359, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#150360, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#150361, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#150362, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#150363, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#150364, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#150365, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#150367, COL_924860D6_14C4_4F33_B84C_E428E89E2817#150368, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#150369, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#150370, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#150371, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#150372, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#150373, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#150374, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#150375, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#150376, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#150377, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#150378, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379]
Condition : ((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#150336)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#150336)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#150337)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#150337)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#150338)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#150338)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#150339)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#150339)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#150340)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#150340)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#150341)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#150341)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#150342)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#150342)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#150343)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#150343)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#150344)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#150344)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#150345)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#150345)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#150346)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#150346)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#150347)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#150347)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#150349)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#150349)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#150351)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#150351)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#150355)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#150355)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#150356)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#150356)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#150357)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#150357)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#150358)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#150358)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#150359)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#150359)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#150360)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#150360)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#150361)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#150361)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#150362)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#150362)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#150363)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#150363)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#150364)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#150364)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#150365)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#150365)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#150367)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#150367)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#150368)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#150368)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#150369)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#150369)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#150370)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#150370)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#150371)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#150371)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#150372)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#150372)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#150373)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#150373)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#150374)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#150374)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#150375)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#150375)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#150376)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#150376)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#150377)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#150377)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#150378)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#150378)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 08 - NR, is_null, [null], [0.0], 08 - NR, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 08 - NR, is_null, [null], [0.0], 08 - NR, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MEUBLE) END, Meublé, Non Meublé))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MEUBLE) END, Meublé, Non Meublé))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_get(str_extract_by_regex(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348, T\d+), 0))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(str_list_get(str_extract_by_regex(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348, T\d+), 0))), MAISON) END) AND isnotnull(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379))
(4) Project [codegen id : 1]
Output [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379 AS COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731]
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#150336, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#150337, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#150338, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#150339, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#150340, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#150341, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#150342, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#150343, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#150344, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#150345, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#150346, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#150347, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#150349, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#150351, COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#150355, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#150356, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#150357, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#150358, COL_33CEA792_75B9_44A1_896B_B422BD28B923#150359, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#150360, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#150361, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#150362, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#150363, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#150364, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#150365, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#150367, COL_924860D6_14C4_4F33_B84C_E428E89E2817#150368, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#150369, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#150370, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#150371, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#150372, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#150373, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#150374, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#150375, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#150376, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#150377, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#150378, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379]
(5) HashAggregate [codegen id : 1]
Input [1]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731]
Keys [1]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#151830L]
Results [2]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731, count#151831L]
(6) Exchange
Input [2]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731, count#151831L]
Arguments: hashpartitioning(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731, 10), ENSURE_REQUIREMENTS, [plan_id=20253]
(7) ShuffleQueryStage
Output [2]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731, count#151831L]
Arguments: 0
(8) AQEShuffleRead
Input [2]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731, count#151831L]
Arguments: coalesced
(9) HashAggregate [codegen id : 2]
Input [2]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731, count#151831L]
Keys [1]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#151821L]
Results [2]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731 AS COL_5CDC74F0_3D28_463C_9042_237BDAB525401#151765, count(1)#151821L AS COL_5CDC74F0_3D28_463C_9042_237BDAB525402#151823L]
(10) TakeOrderedAndProject
Input [2]: [COL_5CDC74F0_3D28_463C_9042_237BDAB525401#151765, COL_5CDC74F0_3D28_463C_9042_237BDAB525402#151823L]
Arguments: 10, [COL_5CDC74F0_3D28_463C_9042_237BDAB525402#151823L DESC NULLS LAST], [COL_5CDC74F0_3D28_463C_9042_237BDAB525401#151765, COL_5CDC74F0_3D28_463C_9042_237BDAB525402#151823L]
(11) Filter
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#150336, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#150337, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#150338, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#150339, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#150340, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#150341, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#150342, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#150343, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#150344, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#150345, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#150346, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#150347, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#150349, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#150351, COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#150355, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#150356, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#150357, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#150358, COL_33CEA792_75B9_44A1_896B_B422BD28B923#150359, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#150360, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#150361, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#150362, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#150363, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#150364, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#150365, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#150367, COL_924860D6_14C4_4F33_B84C_E428E89E2817#150368, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#150369, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#150370, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#150371, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#150372, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#150373, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#150374, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#150375, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#150376, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#150377, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#150378, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379]
Condition : ((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#150336)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#150336)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#150337)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#150337)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#150338)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#150338)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#150339)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#150339)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#150340)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#150340)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#150341)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#150341)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#150342)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#150342)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#150343)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#150343)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#150344)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#150344)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#150345)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#150345)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#150346)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#150346)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#150347)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#150347)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#150349)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#150349)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#150351)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#150351)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#150355)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#150355)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#150356)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#150356)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#150357)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#150357)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#150358)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#150358)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#150359)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#150359)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#150360)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#150360)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#150361)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#150361)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#150362)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#150362)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#150363)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#150363)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#150364)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#150364)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#150365)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#150365)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#150367)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#150367)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#150368)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#150368)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#150369)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#150369)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#150370)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#150370)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#150371)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#150371)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#150372)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#150372)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#150373)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#150373)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#150374)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#150374)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#150375)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#150375)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#150376)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#150376)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#150377)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#150377)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#150378)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#150378)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, ##,##), 12.0)), 2), > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 08 - NR, is_null, [null], [0.0], 08 - NR, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, ##.##), 08 - NR, is_null, [null], [0.0], 08 - NR, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, ##.##), 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MEUBLE) END, Meublé, Non Meublé))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348)), MEUBLE) END, Meublé, Non Meublé))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_get(str_extract_by_regex(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348, T\d+), 0))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(str_list_get(str_extract_by_regex(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348, T\d+), 0))), MAISON) END) AND isnotnull(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379))
(12) Project
Output [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379 AS COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731]
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#150336, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#150337, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#150338, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#150339, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#150340, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#150341, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#150342, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#150343, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#150344, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#150345, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#150346, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#150347, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#150348, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#150349, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#150350, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#150351, COL_0DB61D05_5348_40DB_8F16_C7916849A669#150353, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#150355, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#150356, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#150357, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#150358, COL_33CEA792_75B9_44A1_896B_B422BD28B923#150359, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#150360, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#150361, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#150362, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#150363, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#150364, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#150365, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#150366, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#150367, COL_924860D6_14C4_4F33_B84C_E428E89E2817#150368, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#150369, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#150370, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#150371, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#150372, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#150373, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#150374, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#150375, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#150376, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#150377, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#150378, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#150379]
(13) HashAggregate
Input [1]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731]
Keys [1]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#151830L]
Results [2]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731, count#151831L]
(14) Exchange
Input [2]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731, count#151831L]
Arguments: hashpartitioning(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731, 10), ENSURE_REQUIREMENTS, [plan_id=20230]
(15) HashAggregate
Input [2]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731, count#151831L]
Keys [1]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#151821L]
Results [2]: [COL_5CDC74F0_3D28_463C_9042_237BDAB52540#150731 AS COL_5CDC74F0_3D28_463C_9042_237BDAB525401#151765, count(1)#151821L AS COL_5CDC74F0_3D28_463C_9042_237BDAB525402#151823L]
(16) TakeOrderedAndProject
Input [2]: [COL_5CDC74F0_3D28_463C_9042_237BDAB525401#151765, COL_5CDC74F0_3D28_463C_9042_237BDAB525402#151823L]
Arguments: 10, [COL_5CDC74F0_3D28_463C_9042_237BDAB525402#151823L DESC NULLS LAST], [COL_5CDC74F0_3D28_463C_9042_237BDAB525401#151765, COL_5CDC74F0_3D28_463C_9042_237BDAB525402#151823L]
(17) AdaptiveSparkPlan
Output [2]: [COL_5CDC74F0_3D28_463C_9042_237BDAB525401#151765, COL_5CDC74F0_3D28_463C_9042_237BDAB525402#151823L]
Arguments: isFinalPlan=true