SP1 - Details for Query 246

Submitted Time: 2026/06/25 15:49:18
Duration: 2 s
Succeeded Jobs: 307 308 309 310 311 313 315

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 16.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 116 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 115 ms peak memory: 0.0 B number of output rows: 1 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 555"]; 8 [labelType="html" label="SortMergeJoin number of output rows: 1,455 spill size: 0.0 B"]; } subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 302 ms"; 10 [labelType="html" label="Sort sort time: 3 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 11 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 568.3 KiB number of coalesced partitions: 1"]; 12 [labelType="html" label="Exchange shuffle records written: 1,455 local merged chunks fetched: 0 shuffle write time: 3 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1,455 local bytes read: 534.2 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 1166.6 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 534.2 KiB"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 67 ms"; 14 [labelType="html" label=" Project "]; 15 [labelType="html" label=" Project "]; 16 [labelType="html" label="SortMergeJoin number of output rows: 1,455 spill size: 0.0 B"]; } subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 199 ms"; 18 [labelType="html" label="Sort sort time: 2 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 19 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 393.7 KiB number of coalesced partitions: 1"]; 20 [labelType="html" label="Exchange shuffle records written: 1,455 local merged chunks fetched: 0 shuffle write time: 3 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1,455 local bytes read: 376.5 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 720.5 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 376.5 KiB"]; subgraph cluster21 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 97 ms"; 22 [labelType="html" label=" Project "]; 23 [labelType="html" label="ColumnarToRow number of output rows: 1,455 number of input batches: 1"]; } 24 [labelType="html" label="Scan parquet number of files read: 1 scan time: 37 ms metadata time: 0 ms size of files read: 148.0 KiB number of output rows: 1,455"]; subgraph cluster25 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 150 ms"; 26 [labelType="html" label="Sort sort time: 1 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 27 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 93.1 KiB number of coalesced partitions: 1"]; 28 [labelType="html" label="Exchange shuffle records written: 1,104 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 14 ms (2 ms, 2 ms, 2 ms (stage 474.0: task 494)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1,104 local bytes read: 89.1 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 6 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 210.0 KiB (34.4 KiB, 34.9 KiB, 36.6 KiB (stage 474.0: task 494)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 89.1 KiB (14.0 KiB, 14.4 KiB, 17.4 KiB (stage 474.0: task 494))"]; subgraph cluster29 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n342 ms (53 ms, 55 ms, 70 ms (stage 474.0: task 497))"; 30 [labelType="html" label=" Project "]; 31 [labelType="html" label=" Project "]; 32 [labelType="html" label="Filter number of output rows: 1,104"]; 33 [labelType="html" label="ColumnarToRow number of output rows: 1,104 number of input batches: 12"]; } 34 [labelType="html" label="Scan parquet number of files read: 12 scan time total (min, med, max (stageId: taskId)) 76 ms (11 ms, 12 ms, 18 ms (stage 474.0: task 497)) metadata time: 0 ms size of files read: 60.3 KiB number of output rows: 1,104"]; subgraph cluster35 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 254 ms"; 36 [labelType="html" label="Sort sort time: 1 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 37 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 51.9 KiB number of coalesced partitions: 1"]; 38 [labelType="html" label="Exchange shuffle records written: 1,000 local merged chunks fetched: 0 shuffle write time: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1,000 local bytes read: 50.4 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 97.0 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 50.4 KiB"]; subgraph cluster39 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 31 ms"; 40 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 3 ms peak memory: 256.0 KiB number of output rows: 1,000 number of sort fallback tasks: 0 avg hash probes per key: 0"]; } 41 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 53.2 KiB number of coalesced partitions: 1"]; 42 [labelType="html" label="Exchange shuffle records written: 1,000 local merged chunks fetched: 0 shuffle write time: 2 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1,000 local bytes read: 50.5 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 97.0 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 50.5 KiB"]; subgraph cluster43 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 134 ms"; 44 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 87 ms peak memory: 256.0 KiB number of output rows: 1,000 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 45 [labelType="html" label=" Project "]; 46 [labelType="html" label="Filter number of output rows: 1,440"]; } 47 [labelType="html" label="Scan csv number of output rows: 1,440 number of files read: 1 metadata time: 0 ms size of files read: 480.8 KiB"]; 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; 10->8; 11->10; 12->11; 14->12; 15->14; 16->15; 18->16; 19->18; 20->19; 22->20; 23->22; 24->23; 26->16; 27->26; 28->27; 30->28; 31->30; 32->31; 33->32; 34->33; 36->8; 37->36; 38->37; 40->38; 41->40; 42->41; 44->42; 45->44; 46->45; 47->46; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(1)])

WholeStageCodegen (11)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=13029]

HashAggregate(keys=[], functions=[partial_count(1)])

Project

Filter (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207)), MAIS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233)), MAIS) END)

SortMergeJoin [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889], [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936], LeftOuter

WholeStageCodegen (10)

Sort [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889 ASC NULLS FIRST], false, 0

WholeStageCodegen (8)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, 10), ENSURE_REQUIREMENTS, [plan_id=12853]

Project [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, ... 18 more fields]

Project [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, ... 15 more fields]

SortMergeJoin [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208], [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274], LeftOuter

WholeStageCodegen (6)

Sort [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208 ASC NULLS FIRST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, 10), ENSURE_REQUIREMENTS, [plan_id=12641]

Project [Proprietaire#77011 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, idMandat#77012 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, Code+immeuble#77013 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, Nom+Immeuble#77014 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, Adresse+Immeuble#77015 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, Code+Postal+Immeuble#77016 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, Ville+Immeuble#77017 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, Etage#77018 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, idLot#77019 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, N%C2%B0+Identifiant+Fiscal#77020 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, Numero+lot+syndic#77021 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, TypeLot#77022 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, Porte#77023 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, Surface#77024 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, NomLocataire#77025 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, DepotGar+%28euro%29#77026 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, Loyer%2Fan+%28euro%29#77027 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, Prov.+sur+charges%2Fan+%28euro%29#77028 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, idBail#77029 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, DPE#77030 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, GES#77031 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, Classe+Commune#77032 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, Classe+DPE#77033 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, Classe+GES#77034 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, ... 3 more fields]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [Proprietaire#77011,idMandat#77012,Code+immeuble#77013,Nom+Immeuble#77014,Adresse+Immeuble#77015,Code+Postal+Immeuble#77016,Ville+Immeuble#77017,Etage#77018,idLot#77019,N%C2%B0+Identifiant+Fiscal#77020,Numero+lot+syndic#77021,TypeLot#77022,Porte#77023,Surface#77024,NomLocataire#77025,DepotGar+%28euro%29#77026,Loyer%2Fan+%28euro%29#77027,Prov.+sur+charges%2Fan+%28euro%29#77028,idBail#77029,DPE#77030,GES#77031,Classe+Commune#77032,Classe+DPE#77033,Classe+GES#77034] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/C475E2AA_35EA_48B3_8BCD_DEA3CE02A60..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Proprietaire:string,idMandat:string,Code+immeuble:string,Nom+Immeuble:string,Adresse+Immeu...

Sort [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, 10), ENSURE_REQUIREMENTS, [plan_id=12662]

Project [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#78972 AS PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#79271, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#78973 AS PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#79272, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#78974 AS PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#79273, COL_84669589_3EDF_4867_8128_B2F334719709#78975 AS PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#78976 AS PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#79275, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#78977 AS PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#79276, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#78984 AS PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#79277, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#78992 AS PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#79278, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79001 AS PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79279, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#78992, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79001), ) AS PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280]

Project [Portefeuille#78826 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#78972, Civilit%C3%A9#78827 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#78973, Nom#78828 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#78974, Id+Mandat#78829 AS COL_84669589_3EDF_4867_8128_B2F334719709#78975, N%C2%B0+Registre#78830 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#78976, Taux+Honoraire#78831 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#78977, str_if_with_rule(CASE WHEN isnull(Contains(Taux+Honoraire#78831, - 0)) THEN false ELSE Contains(Taux+Honoraire#78831, - 0) END, Absence Taux, ) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#78984, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(Civilit%C3%A9#78827, Madame, equal, [Madame], [], true, MME, , null), RANKING_STRING(Civilit%C3%A9#78827, Monsieur, equal, [MONSIEUR], [], true, MR, , null), RANKING_STRING(Civilit%C3%A9#78827, M et Mme, equal, [M ET MME], [], true, M_ET_MME, , null), RANKING_STRING(Civilit%C3%A9#78827, Succession, equal, [Succession], [], true, SUCCESSION, , null), RANKING_STRING(Civilit%C3%A9#78827, Ind., equal, [IND.], [], true, IND., , null), RANKING_STRING(Civilit%C3%A9#78827, Consorts, equal, [CONSORTS], [], true, CONSORT, , null), RANKING_STRING(Civilit%C3%A9#78827, SCI, equal, [SCI], [], true, SCI, , null), RANKING_STRING(Civilit%C3%A9#78827, SARL, equal, [SARL], [], true, SARL, , null), RANKING_STRING(Civilit%C3%A9#78827, Indivision, equal, [INDIVISION], [], true, INDIVISION, , null), RANKING_STRING(Civilit%C3%A9#78827, M ou Mme, equal, [M OU MME], [], true, M_OU_MME, , null), RANKING_STRING(Civilit%C3%A9#78827, Messieurs, equal, [MESSIEURS], [], true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#78992, str_remove_space(str_remove_accent(str_transform_case(Nom#78828, UPPER)), ONLY_ONE) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79001]

Filter isnotnull(Id+Mandat#78829)

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [Portefeuille#78826,Civilit%C3%A9#78827,Nom#78828,Id+Mandat#78829,N%C2%B0+Registre#78830,Taux+Honoraire#78831] Batched: true, DataFilters: [isnotnull(Id+Mandat#78829)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/1210D38A_30A1_417E_AC30_A633AB773A4..., PartitionFilters: [], PushedFilters: [IsNotNull(`Id+Mandat`)], ReadSchema: struct<Portefeuille:string,Civilit%C3%A9:string,Nom:string,Id+Mandat:string,N%C2%B0+Registre:stri...

Sort [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936 ASC NULLS FIRST], false, 0

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, 10), ENSURE_REQUIREMENTS, [plan_id=12927]

HashAggregate(keys=[COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746], functions=[])

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746, 10), ENSURE_REQUIREMENTS, [plan_id=12686]

HashAggregate(keys=[COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746], functions=[])

Project [str_remove_space(Adresse-Source#78234, ONLY_ONE) AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, longitude#78236 AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, latitude#78237 AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]

Filter (isnotnull(longitude#78236) AND isnotnull(str_remove_space(Adresse-Source#78234, ONLY_ONE)))

WholeStageCodegen (3)

FileScan csv [Adresse-Source#78234,longitude#78236,latitude#78237] Batched: false, DataFilters: [isnotnull(longitude#78236), isnotnull(str_remove_space(Adresse-Source#78234, ONLY_ONE))], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/359356B1_1158_424C_96CE_4656C0BF7..., PartitionFilters: [], PushedFilters: [IsNotNull(longitude)], ReadSchema: struct<Adresse-Source:string,longitude:string,latitude:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (69)
+- == Final Plan ==
   * HashAggregate (42)
   +- ShuffleQueryStage (41), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (40)
         +- * HashAggregate (39)
            +- * Project (38)
               +- * Filter (37)
                  +- * SortMergeJoin LeftOuter (36)
                     :- * Sort (23)
                     :  +- AQEShuffleRead (22)
                     :     +- ShuffleQueryStage (21), Statistics(sizeInBytes=1166.6 KiB, rowCount=1.46E+3)
                     :        +- Exchange (20)
                     :           +- * Project (19)
                     :              +- * Project (18)
                     :                 +- * SortMergeJoin LeftOuter (17)
                     :                    :- * Sort (7)
                     :                    :  +- AQEShuffleRead (6)
                     :                    :     +- ShuffleQueryStage (5), Statistics(sizeInBytes=720.5 KiB, rowCount=1.46E+3)
                     :                    :        +- Exchange (4)
                     :                    :           +- * Project (3)
                     :                    :              +- * ColumnarToRow (2)
                     :                    :                 +- Scan parquet  (1)
                     :                    +- * Sort (16)
                     :                       +- AQEShuffleRead (15)
                     :                          +- ShuffleQueryStage (14), Statistics(sizeInBytes=210.0 KiB, rowCount=1.10E+3)
                     :                             +- Exchange (13)
                     :                                +- * Project (12)
                     :                                   +- * Project (11)
                     :                                      +- * Filter (10)
                     :                                         +- * ColumnarToRow (9)
                     :                                            +- Scan parquet  (8)
                     +- * Sort (35)
                        +- AQEShuffleRead (34)
                           +- ShuffleQueryStage (33), Statistics(sizeInBytes=97.0 KiB, rowCount=1.00E+3)
                              +- Exchange (32)
                                 +- * HashAggregate (31)
                                    +- AQEShuffleRead (30)
                                       +- ShuffleQueryStage (29), Statistics(sizeInBytes=97.0 KiB, rowCount=1.00E+3)
                                          +- Exchange (28)
                                             +- * HashAggregate (27)
                                                +- * Project (26)
                                                   +- * Filter (25)
                                                      +- Scan csv  (24)
+- == Initial Plan ==
   HashAggregate (68)
   +- Exchange (67)
      +- HashAggregate (66)
         +- Project (65)
            +- Filter (64)
               +- SortMergeJoin LeftOuter (63)
                  :- Sort (55)
                  :  +- Exchange (54)
                  :     +- Project (53)
                  :        +- Project (52)
                  :           +- SortMergeJoin LeftOuter (51)
                  :              :- Sort (45)
                  :              :  +- Exchange (44)
                  :              :     +- Project (43)
                  :              :        +- Scan parquet  (1)
                  :              +- Sort (50)
                  :                 +- Exchange (49)
                  :                    +- Project (48)
                  :                       +- Project (47)
                  :                          +- Filter (46)
                  :                             +- Scan parquet  (8)
                  +- Sort (62)
                     +- Exchange (61)
                        +- HashAggregate (60)
                           +- Exchange (59)
                              +- HashAggregate (58)
                                 +- Project (57)
                                    +- Filter (56)
                                       +- Scan csv  (24)


(1) Scan parquet 
Output [24]: [Proprietaire#77011, idMandat#77012, Code+immeuble#77013, Nom+Immeuble#77014, Adresse+Immeuble#77015, Code+Postal+Immeuble#77016, Ville+Immeuble#77017, Etage#77018, idLot#77019, N%C2%B0+Identifiant+Fiscal#77020, Numero+lot+syndic#77021, TypeLot#77022, Porte#77023, Surface#77024, NomLocataire#77025, DepotGar+%28euro%29#77026, Loyer%2Fan+%28euro%29#77027, Prov.+sur+charges%2Fan+%28euro%29#77028, idBail#77029, DPE#77030, GES#77031, Classe+Commune#77032, Classe+DPE#77033, Classe+GES#77034]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/C475E2AA_35EA_48B3_8BCD_DEA3CE02A605_b3d3c08a1f8d703e76a5dcfb9ccd2460/Patrimoine_au_20-4-2026_corrige_Laneco.xlsx_d2ddcf90463fc652b910349ac81c7390]
ReadSchema: struct<Proprietaire:string,idMandat:string,Code+immeuble:string,Nom+Immeuble:string,Adresse+Immeuble:string,Code+Postal+Immeuble:string,Ville+Immeuble:string,Etage:string,idLot:string,N%C2%B0+Identifiant+Fiscal:string,Numero+lot+syndic:string,TypeLot:string,Porte:string,Surface:string,NomLocataire:string,DepotGar+%28euro%29:string,Loyer%2Fan+%28euro%29:string,Prov.+sur+charges%2Fan+%28euro%29:string,idBail:string,DPE:string,GES:string,Classe+Commune:string,Classe+DPE:string,Classe+GES:string>

(2) ColumnarToRow [codegen id : 1]
Input [24]: [Proprietaire#77011, idMandat#77012, Code+immeuble#77013, Nom+Immeuble#77014, Adresse+Immeuble#77015, Code+Postal+Immeuble#77016, Ville+Immeuble#77017, Etage#77018, idLot#77019, N%C2%B0+Identifiant+Fiscal#77020, Numero+lot+syndic#77021, TypeLot#77022, Porte#77023, Surface#77024, NomLocataire#77025, DepotGar+%28euro%29#77026, Loyer%2Fan+%28euro%29#77027, Prov.+sur+charges%2Fan+%28euro%29#77028, idBail#77029, DPE#77030, GES#77031, Classe+Commune#77032, Classe+DPE#77033, Classe+GES#77034]

(3) Project [codegen id : 1]
Output [27]: [Proprietaire#77011 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, idMandat#77012 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, Code+immeuble#77013 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, Nom+Immeuble#77014 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, Adresse+Immeuble#77015 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, Code+Postal+Immeuble#77016 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, Ville+Immeuble#77017 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, Etage#77018 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, idLot#77019 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, N%C2%B0+Identifiant+Fiscal#77020 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, Numero+lot+syndic#77021 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, TypeLot#77022 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, Porte#77023 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, Surface#77024 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, NomLocataire#77025 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, DepotGar+%28euro%29#77026 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, Loyer%2Fan+%28euro%29#77027 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, Prov.+sur+charges%2Fan+%28euro%29#77028 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, idBail#77029 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, DPE#77030 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, GES#77031 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, Classe+Commune#77032 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, Classe+DPE#77033 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, Classe+GES#77034 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, str_extract(Code+Postal+Immeuble#77016, LEFT, 2) AS COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, str_remove_space(str_remove_accent(str_transform_case(Proprietaire#77011, UPPER)), ONLY_ONE) AS COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(str_replace_extend(Ville+Immeuble#77017, [ST ,ST-], [SAINT ,SAINT-]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER) AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Input [24]: [Proprietaire#77011, idMandat#77012, Code+immeuble#77013, Nom+Immeuble#77014, Adresse+Immeuble#77015, Code+Postal+Immeuble#77016, Ville+Immeuble#77017, Etage#77018, idLot#77019, N%C2%B0+Identifiant+Fiscal#77020, Numero+lot+syndic#77021, TypeLot#77022, Porte#77023, Surface#77024, NomLocataire#77025, DepotGar+%28euro%29#77026, Loyer%2Fan+%28euro%29#77027, Prov.+sur+charges%2Fan+%28euro%29#77028, idBail#77029, DPE#77030, GES#77031, Classe+Commune#77032, Classe+DPE#77033, Classe+GES#77034]

(4) Exchange
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Arguments: hashpartitioning(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, 10), ENSURE_REQUIREMENTS, [plan_id=12641]

(5) ShuffleQueryStage
Output [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Arguments: 0

(6) AQEShuffleRead
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Arguments: coalesced

(7) Sort [codegen id : 4]
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Arguments: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208 ASC NULLS FIRST], false, 0

(8) Scan parquet 
Output [6]: [Portefeuille#78826, Civilit%C3%A9#78827, Nom#78828, Id+Mandat#78829, N%C2%B0+Registre#78830, Taux+Honoraire#78831]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/1210D38A_30A1_417E_AC30_A633AB773A43_79471ac0595e0f84c440113d58d8281c/PROPRIETAIRES_Laneco_Base.xls_afce3e2f319a0b3bd204c24dc83c5faa]
PushedFilters: [IsNotNull(`Id+Mandat`)]
ReadSchema: struct<Portefeuille:string,Civilit%C3%A9:string,Nom:string,Id+Mandat:string,N%C2%B0+Registre:string,Taux+Honoraire:string>

(9) ColumnarToRow [codegen id : 2]
Input [6]: [Portefeuille#78826, Civilit%C3%A9#78827, Nom#78828, Id+Mandat#78829, N%C2%B0+Registre#78830, Taux+Honoraire#78831]

(10) Filter [codegen id : 2]
Input [6]: [Portefeuille#78826, Civilit%C3%A9#78827, Nom#78828, Id+Mandat#78829, N%C2%B0+Registre#78830, Taux+Honoraire#78831]
Condition : isnotnull(Id+Mandat#78829)

(11) Project [codegen id : 2]
Output [9]: [Portefeuille#78826 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#78972, Civilit%C3%A9#78827 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#78973, Nom#78828 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#78974, Id+Mandat#78829 AS COL_84669589_3EDF_4867_8128_B2F334719709#78975, N%C2%B0+Registre#78830 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#78976, Taux+Honoraire#78831 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#78977, str_if_with_rule(CASE WHEN isnull(Contains(Taux+Honoraire#78831, - 0)) THEN false ELSE Contains(Taux+Honoraire#78831, - 0) END, Absence Taux, ) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#78984, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(Civilit%C3%A9#78827, Madame, equal, [Madame], [], true, MME, , null), RANKING_STRING(Civilit%C3%A9#78827, Monsieur, equal, [MONSIEUR], [], true, MR, , null), RANKING_STRING(Civilit%C3%A9#78827, M et Mme, equal, [M ET MME], [], true, M_ET_MME, , null), RANKING_STRING(Civilit%C3%A9#78827, Succession, equal, [Succession], [], true, SUCCESSION, , null), RANKING_STRING(Civilit%C3%A9#78827, Ind., equal, [IND.], [], true, IND., , null), RANKING_STRING(Civilit%C3%A9#78827, Consorts, equal, [CONSORTS], [], true, CONSORT, , null), RANKING_STRING(Civilit%C3%A9#78827, SCI, equal, [SCI], [], true, SCI, , null), RANKING_STRING(Civilit%C3%A9#78827, SARL, equal, [SARL], [], true, SARL, , null), RANKING_STRING(Civilit%C3%A9#78827, Indivision, equal, [INDIVISION], [], true, INDIVISION, , null), RANKING_STRING(Civilit%C3%A9#78827, M ou Mme, equal, [M OU MME], [], true, M_OU_MME, , null), RANKING_STRING(Civilit%C3%A9#78827, Messieurs, equal, [MESSIEURS], [], true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#78992, str_remove_space(str_remove_accent(str_transform_case(Nom#78828, UPPER)), ONLY_ONE) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79001]
Input [6]: [Portefeuille#78826, Civilit%C3%A9#78827, Nom#78828, Id+Mandat#78829, N%C2%B0+Registre#78830, Taux+Honoraire#78831]

(12) Project [codegen id : 2]
Output [10]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#78972 AS PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#79271, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#78973 AS PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#79272, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#78974 AS PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#79273, COL_84669589_3EDF_4867_8128_B2F334719709#78975 AS PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#78976 AS PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#79275, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#78977 AS PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#79276, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#78984 AS PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#79277, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#78992 AS PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#79278, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79001 AS PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79279, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#78992, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79001),  ) AS PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280]
Input [9]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#78972, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#78973, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#78974, COL_84669589_3EDF_4867_8128_B2F334719709#78975, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#78976, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#78977, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#78984, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#78992, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79001]

(13) Exchange
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#79271, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#79272, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#79273, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#79275, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#79276, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#79277, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#79278, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79279, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280]
Arguments: hashpartitioning(PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, 10), ENSURE_REQUIREMENTS, [plan_id=12662]

(14) ShuffleQueryStage
Output [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#79271, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#79272, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#79273, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#79275, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#79276, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#79277, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#79278, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79279, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280]
Arguments: 1

(15) AQEShuffleRead
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#79271, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#79272, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#79273, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#79275, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#79276, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#79277, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#79278, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79279, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280]
Arguments: coalesced

(16) Sort [codegen id : 5]
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#79271, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#79272, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#79273, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#79275, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#79276, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#79277, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#79278, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79279, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280]
Arguments: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274 ASC NULLS FIRST], false, 0

(17) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208]
Right keys [1]: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274]
Join type: LeftOuter
Join condition: None

(18) Project [codegen id : 6]
Output [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#79271 AS COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#79272 AS COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#79273 AS COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274 AS COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#79275 AS COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#79276 AS COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#79277 AS COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#79278 AS COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79279 AS COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280 AS COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280)) THEN false ELSE StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280) END, 1, 0) AS COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, str_diff(PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232) AS COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599]
Input [37]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#79271, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#79272, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#79273, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#79275, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#79276, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#79277, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#79278, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79279, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280]

(19) Project [codegen id : 6]
Output [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599, str_if_with_rule((COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599 <=> ), Matching Total, str_join(array(Différence sur, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599),  )) AS COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887, str_if_with_rule(isnull(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514), str_join(array(Absence de Propriétaire pour le Mandat , COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208),  ), ) AS COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888, str_remove_space(str_join(array(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213),  ), ONLY_ONE) AS COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Input [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599]

(20) Exchange
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Arguments: hashpartitioning(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, 10), ENSURE_REQUIREMENTS, [plan_id=12853]

(21) ShuffleQueryStage
Output [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Arguments: 3

(22) AQEShuffleRead
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Arguments: coalesced

(23) Sort [codegen id : 8]
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Arguments: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889 ASC NULLS FIRST], false, 0

(24) Scan csv 
Output [3]: [Adresse-Source#78234, longitude#78236, latitude#78237]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/359356B1_1158_424C_96CE_4656C0BF7CAB/current/Adresses_geocodees_(1).csv]
PushedFilters: [IsNotNull(longitude)]
ReadSchema: struct<Adresse-Source:string,longitude:string,latitude:string>

(25) Filter [codegen id : 3]
Input [3]: [Adresse-Source#78234, longitude#78236, latitude#78237]
Condition : (isnotnull(longitude#78236) AND isnotnull(str_remove_space(Adresse-Source#78234, ONLY_ONE)))

(26) Project [codegen id : 3]
Output [3]: [str_remove_space(Adresse-Source#78234, ONLY_ONE) AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, longitude#78236 AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, latitude#78237 AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Input [3]: [Adresse-Source#78234, longitude#78236, latitude#78237]

(27) HashAggregate [codegen id : 3]
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]

(28) Exchange
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Arguments: hashpartitioning(COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746, 10), ENSURE_REQUIREMENTS, [plan_id=12686]

(29) ShuffleQueryStage
Output [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Arguments: 2

(30) AQEShuffleRead
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Arguments: coalesced

(31) HashAggregate [codegen id : 7]
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743 AS GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745 AS GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746 AS GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938]

(32) Exchange
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938]
Arguments: hashpartitioning(GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, 10), ENSURE_REQUIREMENTS, [plan_id=12927]

(33) ShuffleQueryStage
Output [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938]
Arguments: 4

(34) AQEShuffleRead
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938]
Arguments: coalesced

(35) Sort [codegen id : 9]
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938]
Arguments: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936 ASC NULLS FIRST], false, 0

(36) SortMergeJoin [codegen id : 10]
Left keys [1]: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889]
Right keys [1]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936]
Join type: LeftOuter
Join condition: None

(37) Filter [codegen id : 10]
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207)), MAIS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233)), MAIS) END)

(38) Project [codegen id : 10]
Output: []
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938]

(39) HashAggregate [codegen id : 10]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#80213L]
Results [1]: [count#80214L]

(40) Exchange
Input [1]: [count#80214L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=13029]

(41) ShuffleQueryStage
Output [1]: [count#80214L]
Arguments: 5

(42) HashAggregate [codegen id : 11]
Input [1]: [count#80214L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#80210L]
Results [1]: [count(1)#80210L AS count#80211L]

(43) Project
Output [27]: [Proprietaire#77011 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, idMandat#77012 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, Code+immeuble#77013 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, Nom+Immeuble#77014 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, Adresse+Immeuble#77015 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, Code+Postal+Immeuble#77016 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, Ville+Immeuble#77017 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, Etage#77018 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, idLot#77019 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, N%C2%B0+Identifiant+Fiscal#77020 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, Numero+lot+syndic#77021 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, TypeLot#77022 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, Porte#77023 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, Surface#77024 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, NomLocataire#77025 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, DepotGar+%28euro%29#77026 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, Loyer%2Fan+%28euro%29#77027 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, Prov.+sur+charges%2Fan+%28euro%29#77028 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, idBail#77029 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, DPE#77030 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, GES#77031 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, Classe+Commune#77032 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, Classe+DPE#77033 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, Classe+GES#77034 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, str_extract(Code+Postal+Immeuble#77016, LEFT, 2) AS COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, str_remove_space(str_remove_accent(str_transform_case(Proprietaire#77011, UPPER)), ONLY_ONE) AS COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(str_replace_extend(Ville+Immeuble#77017, [ST ,ST-], [SAINT ,SAINT-]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER) AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Input [24]: [Proprietaire#77011, idMandat#77012, Code+immeuble#77013, Nom+Immeuble#77014, Adresse+Immeuble#77015, Code+Postal+Immeuble#77016, Ville+Immeuble#77017, Etage#77018, idLot#77019, N%C2%B0+Identifiant+Fiscal#77020, Numero+lot+syndic#77021, TypeLot#77022, Porte#77023, Surface#77024, NomLocataire#77025, DepotGar+%28euro%29#77026, Loyer%2Fan+%28euro%29#77027, Prov.+sur+charges%2Fan+%28euro%29#77028, idBail#77029, DPE#77030, GES#77031, Classe+Commune#77032, Classe+DPE#77033, Classe+GES#77034]

(44) Exchange
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Arguments: hashpartitioning(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, 10), ENSURE_REQUIREMENTS, [plan_id=12559]

(45) Sort
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Arguments: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208 ASC NULLS FIRST], false, 0

(46) Filter
Input [6]: [Portefeuille#78826, Civilit%C3%A9#78827, Nom#78828, Id+Mandat#78829, N%C2%B0+Registre#78830, Taux+Honoraire#78831]
Condition : isnotnull(Id+Mandat#78829)

(47) Project
Output [9]: [Portefeuille#78826 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#78972, Civilit%C3%A9#78827 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#78973, Nom#78828 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#78974, Id+Mandat#78829 AS COL_84669589_3EDF_4867_8128_B2F334719709#78975, N%C2%B0+Registre#78830 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#78976, Taux+Honoraire#78831 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#78977, str_if_with_rule(CASE WHEN isnull(Contains(Taux+Honoraire#78831, - 0)) THEN false ELSE Contains(Taux+Honoraire#78831, - 0) END, Absence Taux, ) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#78984, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(Civilit%C3%A9#78827, Madame, equal, [Madame], [], true, MME, , null), RANKING_STRING(Civilit%C3%A9#78827, Monsieur, equal, [MONSIEUR], [], true, MR, , null), RANKING_STRING(Civilit%C3%A9#78827, M et Mme, equal, [M ET MME], [], true, M_ET_MME, , null), RANKING_STRING(Civilit%C3%A9#78827, Succession, equal, [Succession], [], true, SUCCESSION, , null), RANKING_STRING(Civilit%C3%A9#78827, Ind., equal, [IND.], [], true, IND., , null), RANKING_STRING(Civilit%C3%A9#78827, Consorts, equal, [CONSORTS], [], true, CONSORT, , null), RANKING_STRING(Civilit%C3%A9#78827, SCI, equal, [SCI], [], true, SCI, , null), RANKING_STRING(Civilit%C3%A9#78827, SARL, equal, [SARL], [], true, SARL, , null), RANKING_STRING(Civilit%C3%A9#78827, Indivision, equal, [INDIVISION], [], true, INDIVISION, , null), RANKING_STRING(Civilit%C3%A9#78827, M ou Mme, equal, [M OU MME], [], true, M_OU_MME, , null), RANKING_STRING(Civilit%C3%A9#78827, Messieurs, equal, [MESSIEURS], [], true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#78992, str_remove_space(str_remove_accent(str_transform_case(Nom#78828, UPPER)), ONLY_ONE) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79001]
Input [6]: [Portefeuille#78826, Civilit%C3%A9#78827, Nom#78828, Id+Mandat#78829, N%C2%B0+Registre#78830, Taux+Honoraire#78831]

(48) Project
Output [10]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#78972 AS PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#79271, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#78973 AS PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#79272, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#78974 AS PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#79273, COL_84669589_3EDF_4867_8128_B2F334719709#78975 AS PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#78976 AS PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#79275, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#78977 AS PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#79276, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#78984 AS PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#79277, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#78992 AS PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#79278, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79001 AS PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79279, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#78992, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79001),  ) AS PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280]
Input [9]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#78972, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#78973, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#78974, COL_84669589_3EDF_4867_8128_B2F334719709#78975, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#78976, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#78977, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#78984, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#78992, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79001]

(49) Exchange
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#79271, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#79272, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#79273, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#79275, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#79276, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#79277, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#79278, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79279, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280]
Arguments: hashpartitioning(PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, 10), ENSURE_REQUIREMENTS, [plan_id=12560]

(50) Sort
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#79271, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#79272, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#79273, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#79275, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#79276, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#79277, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#79278, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79279, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280]
Arguments: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274 ASC NULLS FIRST], false, 0

(51) SortMergeJoin
Left keys [1]: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208]
Right keys [1]: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274]
Join type: LeftOuter
Join condition: None

(52) Project
Output [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#79271 AS COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#79272 AS COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#79273 AS COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274 AS COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#79275 AS COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#79276 AS COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#79277 AS COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#79278 AS COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79279 AS COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280 AS COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280)) THEN false ELSE StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280) END, 1, 0) AS COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, str_diff(PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232) AS COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599]
Input [37]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#79271, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#79272, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#79273, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#79274, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#79275, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#79276, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#79277, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#79278, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#79279, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#79280]

(53) Project
Output [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599, str_if_with_rule((COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599 <=> ), Matching Total, str_join(array(Différence sur, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599),  )) AS COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887, str_if_with_rule(isnull(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514), str_join(array(Absence de Propriétaire pour le Mandat , COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208),  ), ) AS COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888, str_remove_space(str_join(array(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213),  ), ONLY_ONE) AS COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Input [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599]

(54) Exchange
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Arguments: hashpartitioning(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, 10), ENSURE_REQUIREMENTS, [plan_id=12572]

(55) Sort
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233]
Arguments: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889 ASC NULLS FIRST], false, 0

(56) Filter
Input [3]: [Adresse-Source#78234, longitude#78236, latitude#78237]
Condition : (isnotnull(longitude#78236) AND isnotnull(str_remove_space(Adresse-Source#78234, ONLY_ONE)))

(57) Project
Output [3]: [str_remove_space(Adresse-Source#78234, ONLY_ONE) AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, longitude#78236 AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, latitude#78237 AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Input [3]: [Adresse-Source#78234, longitude#78236, latitude#78237]

(58) HashAggregate
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]

(59) Exchange
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Arguments: hashpartitioning(COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746, 10), ENSURE_REQUIREMENTS, [plan_id=12566]

(60) HashAggregate
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#78743 AS GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#78745 AS GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#78746 AS GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938]

(61) Exchange
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938]
Arguments: hashpartitioning(GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, 10), ENSURE_REQUIREMENTS, [plan_id=12573]

(62) Sort
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938]
Arguments: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936 ASC NULLS FIRST], false, 0

(63) SortMergeJoin
Left keys [1]: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889]
Right keys [1]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936]
Join type: LeftOuter
Join condition: None

(64) Filter
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207)), MAIS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233)), MAIS) END)

(65) Project
Output: []
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#79207, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#79208, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#79209, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#79210, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#79211, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#79212, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#79213, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#79231, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#79214, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#79215, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#79216, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#79217, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#79218, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#79219, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#79220, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#79221, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#79222, COL_0DB61D05_5348_40DB_8F16_C7916849A669#79223, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#79224, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#79225, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#79226, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#79227, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#79228, COL_33CEA792_75B9_44A1_896B_B422BD28B923#79229, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#79230, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#79511, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#79512, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#79513, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#79514, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#79515, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#79516, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#79517, COL_924860D6_14C4_4F33_B84C_E428E89E2817#79518, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#79519, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#79520, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#79232, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#79560, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#79599, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#79887, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#79888, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#79889, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#79233, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#79936, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#79937, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#79938]

(66) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#80213L]
Results [1]: [count#80214L]

(67) Exchange
Input [1]: [count#80214L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=12581]

(68) HashAggregate
Input [1]: [count#80214L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#80210L]
Results [1]: [count(1)#80210L AS count#80211L]

(69) AdaptiveSparkPlan
Output [1]: [count#80211L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet