SP1 - Details for Query 349

Submitted Time: 2026/06/25 16:02:31
Duration: 1.0 s
Succeeded Jobs: 434 435 436 437 438 439 440

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" TakeOrderedAndProject "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 2 ms"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 16.3 MiB number of output rows: 32 number of sort fallback tasks: 0 avg hash probes per key: 1"]; } 4 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1397.0 B number of coalesced partitions: 1"]; 5 [labelType="html" label="Exchange shuffle records written: 32 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: 32 local bytes read: 1335.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: 1248.0 B 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: 1335.0 B"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 112 ms"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 103 ms peak memory: 256.0 KiB number of output rows: 32 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 554"]; 10 [labelType="html" label="SortMergeJoin number of output rows: 1,455 spill size: 0.0 B"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 243 ms"; 12 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 13 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 568.3 KiB number of coalesced partitions: 1"]; 14 [labelType="html" label="Exchange shuffle records written: 1,455 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,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 cluster15 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 27 ms"; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label=" Project "]; 18 [labelType="html" label="SortMergeJoin number of output rows: 1,455 spill size: 0.0 B"]; } subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 29 ms"; 20 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 21 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 393.7 KiB number of coalesced partitions: 1"]; 22 [labelType="html" label="Exchange shuffle records written: 1,455 local merged chunks fetched: 0 shuffle write time: 6 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 cluster23 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 40 ms"; 24 [labelType="html" label=" Project "]; 25 [labelType="html" label="Filter number of output rows: 1,455"]; 26 [labelType="html" label="ColumnarToRow number of output rows: 1,455 number of input batches: 1"]; } 27 [labelType="html" label="Scan parquet number of files read: 1 scan time: 7 ms metadata time: 0 ms size of files read: 173.8 KiB number of output rows: 1,455"]; subgraph cluster28 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 27 ms"; 29 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 30 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 93.1 KiB number of coalesced partitions: 1"]; 31 [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 (1 ms, 1 ms, 4 ms (stage 695.0: task 656)) 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 695.0: task 656)) 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 695.0: task 656))"]; subgraph cluster32 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n169 ms (18 ms, 32 ms, 37 ms (stage 695.0: task 656))"; 33 [labelType="html" label=" Project "]; 34 [labelType="html" label=" Project "]; 35 [labelType="html" label="Filter number of output rows: 1,104"]; 36 [labelType="html" label="ColumnarToRow number of output rows: 1,104 number of input batches: 12"]; } 37 [labelType="html" label="Scan parquet number of files read: 12 scan time total (min, med, max (stageId: taskId)) 64 ms (6 ms, 12 ms, 13 ms (stage 695.0: task 659)) metadata time: 0 ms size of files read: 60.3 KiB number of output rows: 1,104"]; subgraph cluster38 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 241 ms"; 39 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 40 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 51.9 KiB number of coalesced partitions: 1"]; 41 [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 cluster42 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 4 ms"; 43 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 1 ms peak memory: 256.0 KiB number of output rows: 1,000 number of sort fallback tasks: 0 avg hash probes per key: 0"]; } 44 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 53.2 KiB number of coalesced partitions: 1"]; 45 [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.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 cluster46 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 21 ms"; 47 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 17 ms peak memory: 256.0 KiB number of output rows: 1,000 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 48 [labelType="html" label=" Project "]; 49 [labelType="html" label="Filter number of output rows: 1,440"]; } 50 [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"]; 1->0; 3->1; 4->3; 5->4; 7->5; 8->7; 9->8; 10->9; 12->10; 13->12; 14->13; 16->14; 17->16; 18->17; 20->18; 21->20; 22->21; 24->22; 25->24; 26->25; 27->26; 29->18; 30->29; 31->30; 33->31; 34->33; 35->34; 36->35; 37->36; 39->10; 40->39; 41->40; 43->41; 44->43; 45->44; 47->45; 48->47; 49->48; 50->49; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=70, orderBy=[COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#123912L DESC NULLS LAST], output=[COL_0798550D_6632_4F18_8CE3_72BAF75D68CC1#123865,COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#123912L])

HashAggregate(keys=[COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932], functions=[count(1)])

WholeStageCodegen (11)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, 10), ENSURE_REQUIREMENTS, [plan_id=17966]

HashAggregate(keys=[COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932], functions=[partial_count(1)])

Project [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]

Filter (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932)), MAISON) END)

SortMergeJoin [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588], [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635], LeftOuter

WholeStageCodegen (10)

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

WholeStageCodegen (8)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, 10), ENSURE_REQUIREMENTS, [plan_id=17823]

Project [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, ... 18 more fields]

Project [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, ... 15 more fields]

SortMergeJoin [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907], [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973], LeftOuter

WholeStageCodegen (6)

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

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, 10), ENSURE_REQUIREMENTS, [plan_id=17600]

Project [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#121860 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#121861 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#121862 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#121863 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#121864 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#121865 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#121866 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#121867 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#121868 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#121869 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#121870 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#121871 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#121872 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#121873 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#121874 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#121875 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#121876 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#121877 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#121878 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_D6895B92_8213_46E8_95DE_5711D209346E#121879 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_A06CD743_975B_480F_890C_78685E530CD1#121880 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_814180A7_65B9_4C68_A945_79F72A870824#121881 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_6126101C_76C5_4C25_A5F2_987862B98C80#121882 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_32583C88_3290_4A7F_A097_95297001B6D6#121883 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, ... 3 more fields]

Filter isnotnull(COL_EB3E9294_C63E_4108_AB19_81F98873297C#121886)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#121860,COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#121861,COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#121862,COL_5650E892_33D9_479C_80EA_2B2525AC4A45#121863,COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#121864,COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#121865,COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#121866,COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#121867,COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#121868,COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#121869,COL_F187B9B8_0063_41CE_9385_F751840CD2EB#121870,COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#121871,COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#121872,COL_B697D958_0150_4D9A_9824_47CA5DE6D555#121873,COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#121874,COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#121875,COL_2292659F_7091_49C8_ABBD_97FCDEADA803#121876,COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#121877,COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#121878,COL_D6895B92_8213_46E8_95DE_5711D209346E#121879,COL_A06CD743_975B_480F_890C_78685E530CD1#121880,COL_814180A7_65B9_4C68_A945_79F72A870824#121881,COL_6126101C_76C5_4C25_A5F2_987862B98C80#121882,COL_32583C88_3290_4A7F_A097_95297001B6D6#121883,... 3 more fields] Batched: true, DataFilters: [isnotnull(COL_EB3E9294_C63E_4108_AB19_81F98873297C#121886)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/PATRIMOINE_NT_405178], PartitionFilters: [], PushedFilters: [IsNotNull(COL_EB3E9294_C63E_4108_AB19_81F98873297C)], ReadSchema: struct<COL_4EBCB649_BD59_44D4_93D8_0190857315F0:string,COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D:s...

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

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, 10), ENSURE_REQUIREMENTS, [plan_id=17623]

Project [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122671 AS PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122970, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122672 AS PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122971, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122673 AS PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122972, COL_84669589_3EDF_4867_8128_B2F334719709#122674 AS PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122675 AS PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122974, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122676 AS PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122975, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122683 AS PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122976, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122691 AS PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122977, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122700 AS PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122978, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122691, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122700), ) AS PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979]

Project [Portefeuille#122525 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122671, Civilit%C3%A9#122526 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122672, Nom#122527 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122673, Id+Mandat#122528 AS COL_84669589_3EDF_4867_8128_B2F334719709#122674, N%C2%B0+Registre#122529 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122675, Taux+Honoraire#122530 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122676, str_if_with_rule(CASE WHEN isnull(Contains(Taux+Honoraire#122530, - 0)) THEN false ELSE Contains(Taux+Honoraire#122530, - 0) END, Absence Taux, ) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122683, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(Civilit%C3%A9#122526, Madame, equal, [Madame], [], true, MME, , null), RANKING_STRING(Civilit%C3%A9#122526, Monsieur, equal, [MONSIEUR], [], true, MR, , null), RANKING_STRING(Civilit%C3%A9#122526, M et Mme, equal, [M ET MME], [], true, M_ET_MME, , null), RANKING_STRING(Civilit%C3%A9#122526, Succession, equal, [Succession], [], true, SUCCESSION, , null), RANKING_STRING(Civilit%C3%A9#122526, Ind., equal, [IND.], [], true, IND., , null), RANKING_STRING(Civilit%C3%A9#122526, Consorts, equal, [CONSORTS], [], true, CONSORT, , null), RANKING_STRING(Civilit%C3%A9#122526, SCI, equal, [SCI], [], true, SCI, , null), RANKING_STRING(Civilit%C3%A9#122526, SARL, equal, [SARL], [], true, SARL, , null), RANKING_STRING(Civilit%C3%A9#122526, Indivision, equal, [INDIVISION], [], true, INDIVISION, , null), RANKING_STRING(Civilit%C3%A9#122526, M ou Mme, equal, [M OU MME], [], true, M_OU_MME, , null), RANKING_STRING(Civilit%C3%A9#122526, Messieurs, equal, [MESSIEURS], [], true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122691, str_remove_space(str_remove_accent(str_transform_case(Nom#122527, UPPER)), ONLY_ONE) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122700]

Filter isnotnull(Id+Mandat#122528)

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [Portefeuille#122525,Civilit%C3%A9#122526,Nom#122527,Id+Mandat#122528,N%C2%B0+Registre#122529,Taux+Honoraire#122530] Batched: true, DataFilters: [isnotnull(Id+Mandat#122528)], 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#123635 ASC NULLS FIRST], false, 0

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, 10), ENSURE_REQUIREMENTS, [plan_id=17853]

HashAggregate(keys=[COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445], functions=[])

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445, 10), ENSURE_REQUIREMENTS, [plan_id=17647]

HashAggregate(keys=[COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445], functions=[])

Project [str_remove_space(Adresse-Source#121933, ONLY_ONE) AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, longitude#121935 AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, latitude#121936 AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]

Filter (isnotnull(longitude#121935) AND isnotnull(str_remove_space(Adresse-Source#121933, ONLY_ONE)))

WholeStageCodegen (3)

FileScan csv [Adresse-Source#121933,longitude#121935,latitude#121936] Batched: false, DataFilters: [isnotnull(longitude#121935), isnotnull(str_remove_space(Adresse-Source#121933, 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 (74)
+- == Final Plan ==
   TakeOrderedAndProject (45)
   +- * HashAggregate (44)
      +- AQEShuffleRead (43)
         +- ShuffleQueryStage (42), Statistics(sizeInBytes=1248.0 B, rowCount=32)
            +- Exchange (41)
               +- * HashAggregate (40)
                  +- * Project (39)
                     +- * Filter (38)
                        +- * SortMergeJoin LeftOuter (37)
                           :- * Sort (24)
                           :  +- AQEShuffleRead (23)
                           :     +- ShuffleQueryStage (22), Statistics(sizeInBytes=1166.6 KiB, rowCount=1.46E+3)
                           :        +- Exchange (21)
                           :           +- * Project (20)
                           :              +- * Project (19)
                           :                 +- * SortMergeJoin LeftOuter (18)
                           :                    :- * Sort (8)
                           :                    :  +- AQEShuffleRead (7)
                           :                    :     +- ShuffleQueryStage (6), Statistics(sizeInBytes=720.5 KiB, rowCount=1.46E+3)
                           :                    :        +- Exchange (5)
                           :                    :           +- * Project (4)
                           :                    :              +- * Filter (3)
                           :                    :                 +- * ColumnarToRow (2)
                           :                    :                    +- Scan parquet  (1)
                           :                    +- * Sort (17)
                           :                       +- AQEShuffleRead (16)
                           :                          +- ShuffleQueryStage (15), Statistics(sizeInBytes=210.0 KiB, rowCount=1.10E+3)
                           :                             +- Exchange (14)
                           :                                +- * Project (13)
                           :                                   +- * Project (12)
                           :                                      +- * Filter (11)
                           :                                         +- * ColumnarToRow (10)
                           :                                            +- Scan parquet  (9)
                           +- * Sort (36)
                              +- AQEShuffleRead (35)
                                 +- ShuffleQueryStage (34), Statistics(sizeInBytes=97.0 KiB, rowCount=1.00E+3)
                                    +- Exchange (33)
                                       +- * HashAggregate (32)
                                          +- AQEShuffleRead (31)
                                             +- ShuffleQueryStage (30), Statistics(sizeInBytes=97.0 KiB, rowCount=1.00E+3)
                                                +- Exchange (29)
                                                   +- * HashAggregate (28)
                                                      +- * Project (27)
                                                         +- * Filter (26)
                                                            +- Scan csv  (25)
+- == Initial Plan ==
   TakeOrderedAndProject (73)
   +- HashAggregate (72)
      +- Exchange (71)
         +- HashAggregate (70)
            +- Project (69)
               +- Filter (68)
                  +- SortMergeJoin LeftOuter (67)
                     :- Sort (59)
                     :  +- Exchange (58)
                     :     +- Project (57)
                     :        +- Project (56)
                     :           +- SortMergeJoin LeftOuter (55)
                     :              :- Sort (49)
                     :              :  +- Exchange (48)
                     :              :     +- Project (47)
                     :              :        +- Filter (46)
                     :              :           +- Scan parquet  (1)
                     :              +- Sort (54)
                     :                 +- Exchange (53)
                     :                    +- Project (52)
                     :                       +- Project (51)
                     :                          +- Filter (50)
                     :                             +- Scan parquet  (9)
                     +- Sort (66)
                        +- Exchange (65)
                           +- HashAggregate (64)
                              +- Exchange (63)
                                 +- HashAggregate (62)
                                    +- Project (61)
                                       +- Filter (60)
                                          +- Scan csv  (25)


(1) Scan parquet 
Output [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#121860, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#121861, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#121862, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#121863, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#121864, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#121865, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#121866, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#121867, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#121868, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#121869, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#121870, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#121871, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#121872, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#121873, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#121874, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#121875, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#121876, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#121877, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#121878, COL_D6895B92_8213_46E8_95DE_5711D209346E#121879, COL_A06CD743_975B_480F_890C_78685E530CD1#121880, COL_814180A7_65B9_4C68_A945_79F72A870824#121881, COL_6126101C_76C5_4C25_A5F2_987862B98C80#121882, COL_32583C88_3290_4A7F_A097_95297001B6D6#121883, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#121884, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#121885, COL_EB3E9294_C63E_4108_AB19_81F98873297C#121886]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/PATRIMOINE_NT_405178]
PushedFilters: [IsNotNull(COL_EB3E9294_C63E_4108_AB19_81F98873297C)]
ReadSchema: struct<COL_4EBCB649_BD59_44D4_93D8_0190857315F0:string,COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D:string,COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982:string,COL_5650E892_33D9_479C_80EA_2B2525AC4A45:string,COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E:string,COL_A43814C6_7077_46AF_835B_D0B18EDC70A4:string,COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8:string,COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01:string,COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7:string,COL_89DC6301_086A_4E9C_8672_8F2751FE3B89:string,COL_F187B9B8_0063_41CE_9385_F751840CD2EB:string,COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D:string,COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE:string,COL_B697D958_0150_4D9A_9824_47CA5DE6D555:string,COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3:string,COL_437E7927_9755_4EE7_B335_1FE4CA5F9327:string,COL_2292659F_7091_49C8_ABBD_97FCDEADA803:string,COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A:string,COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6:string,COL_D6895B92_8213_46E8_95DE_5711D209346E:string,COL_A06CD743_975B_480F_890C_78685E530CD1:string,COL_814180A7_65B9_4C68_A945_79F72A870824:string,COL_6126101C_76C5_4C25_A5F2_987862B98C80:string,COL_32583C88_3290_4A7F_A097_95297001B6D6:string,COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86:string,COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B:string,COL_EB3E9294_C63E_4108_AB19_81F98873297C:string>

(2) ColumnarToRow [codegen id : 1]
Input [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#121860, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#121861, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#121862, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#121863, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#121864, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#121865, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#121866, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#121867, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#121868, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#121869, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#121870, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#121871, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#121872, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#121873, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#121874, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#121875, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#121876, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#121877, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#121878, COL_D6895B92_8213_46E8_95DE_5711D209346E#121879, COL_A06CD743_975B_480F_890C_78685E530CD1#121880, COL_814180A7_65B9_4C68_A945_79F72A870824#121881, COL_6126101C_76C5_4C25_A5F2_987862B98C80#121882, COL_32583C88_3290_4A7F_A097_95297001B6D6#121883, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#121884, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#121885, COL_EB3E9294_C63E_4108_AB19_81F98873297C#121886]

(3) Filter [codegen id : 1]
Input [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#121860, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#121861, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#121862, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#121863, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#121864, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#121865, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#121866, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#121867, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#121868, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#121869, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#121870, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#121871, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#121872, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#121873, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#121874, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#121875, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#121876, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#121877, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#121878, COL_D6895B92_8213_46E8_95DE_5711D209346E#121879, COL_A06CD743_975B_480F_890C_78685E530CD1#121880, COL_814180A7_65B9_4C68_A945_79F72A870824#121881, COL_6126101C_76C5_4C25_A5F2_987862B98C80#121882, COL_32583C88_3290_4A7F_A097_95297001B6D6#121883, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#121884, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#121885, COL_EB3E9294_C63E_4108_AB19_81F98873297C#121886]
Condition : isnotnull(COL_EB3E9294_C63E_4108_AB19_81F98873297C#121886)

(4) Project [codegen id : 1]
Output [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#121860 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#121861 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#121862 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#121863 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#121864 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#121865 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#121866 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#121867 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#121868 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#121869 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#121870 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#121871 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#121872 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#121873 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#121874 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#121875 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#121876 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#121877 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#121878 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_D6895B92_8213_46E8_95DE_5711D209346E#121879 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_A06CD743_975B_480F_890C_78685E530CD1#121880 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_814180A7_65B9_4C68_A945_79F72A870824#121881 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_6126101C_76C5_4C25_A5F2_987862B98C80#121882 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_32583C88_3290_4A7F_A097_95297001B6D6#121883 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#121884 AS COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#121885 AS COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_EB3E9294_C63E_4108_AB19_81F98873297C#121886 AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Input [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#121860, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#121861, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#121862, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#121863, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#121864, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#121865, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#121866, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#121867, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#121868, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#121869, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#121870, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#121871, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#121872, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#121873, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#121874, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#121875, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#121876, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#121877, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#121878, COL_D6895B92_8213_46E8_95DE_5711D209346E#121879, COL_A06CD743_975B_480F_890C_78685E530CD1#121880, COL_814180A7_65B9_4C68_A945_79F72A870824#121881, COL_6126101C_76C5_4C25_A5F2_987862B98C80#121882, COL_32583C88_3290_4A7F_A097_95297001B6D6#121883, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#121884, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#121885, COL_EB3E9294_C63E_4108_AB19_81F98873297C#121886]

(5) Exchange
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Arguments: hashpartitioning(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, 10), ENSURE_REQUIREMENTS, [plan_id=17600]

(6) ShuffleQueryStage
Output [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Arguments: 0

(7) AQEShuffleRead
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Arguments: coalesced

(8) Sort [codegen id : 4]
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Arguments: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907 ASC NULLS FIRST], false, 0

(9) Scan parquet 
Output [6]: [Portefeuille#122525, Civilit%C3%A9#122526, Nom#122527, Id+Mandat#122528, N%C2%B0+Registre#122529, Taux+Honoraire#122530]
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>

(10) ColumnarToRow [codegen id : 2]
Input [6]: [Portefeuille#122525, Civilit%C3%A9#122526, Nom#122527, Id+Mandat#122528, N%C2%B0+Registre#122529, Taux+Honoraire#122530]

(11) Filter [codegen id : 2]
Input [6]: [Portefeuille#122525, Civilit%C3%A9#122526, Nom#122527, Id+Mandat#122528, N%C2%B0+Registre#122529, Taux+Honoraire#122530]
Condition : isnotnull(Id+Mandat#122528)

(12) Project [codegen id : 2]
Output [9]: [Portefeuille#122525 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122671, Civilit%C3%A9#122526 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122672, Nom#122527 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122673, Id+Mandat#122528 AS COL_84669589_3EDF_4867_8128_B2F334719709#122674, N%C2%B0+Registre#122529 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122675, Taux+Honoraire#122530 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122676, str_if_with_rule(CASE WHEN isnull(Contains(Taux+Honoraire#122530, - 0)) THEN false ELSE Contains(Taux+Honoraire#122530, - 0) END, Absence Taux, ) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122683, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(Civilit%C3%A9#122526, Madame, equal, [Madame], [], true, MME, , null), RANKING_STRING(Civilit%C3%A9#122526, Monsieur, equal, [MONSIEUR], [], true, MR, , null), RANKING_STRING(Civilit%C3%A9#122526, M et Mme, equal, [M ET MME], [], true, M_ET_MME, , null), RANKING_STRING(Civilit%C3%A9#122526, Succession, equal, [Succession], [], true, SUCCESSION, , null), RANKING_STRING(Civilit%C3%A9#122526, Ind., equal, [IND.], [], true, IND., , null), RANKING_STRING(Civilit%C3%A9#122526, Consorts, equal, [CONSORTS], [], true, CONSORT, , null), RANKING_STRING(Civilit%C3%A9#122526, SCI, equal, [SCI], [], true, SCI, , null), RANKING_STRING(Civilit%C3%A9#122526, SARL, equal, [SARL], [], true, SARL, , null), RANKING_STRING(Civilit%C3%A9#122526, Indivision, equal, [INDIVISION], [], true, INDIVISION, , null), RANKING_STRING(Civilit%C3%A9#122526, M ou Mme, equal, [M OU MME], [], true, M_OU_MME, , null), RANKING_STRING(Civilit%C3%A9#122526, Messieurs, equal, [MESSIEURS], [], true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122691, str_remove_space(str_remove_accent(str_transform_case(Nom#122527, UPPER)), ONLY_ONE) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122700]
Input [6]: [Portefeuille#122525, Civilit%C3%A9#122526, Nom#122527, Id+Mandat#122528, N%C2%B0+Registre#122529, Taux+Honoraire#122530]

(13) Project [codegen id : 2]
Output [10]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122671 AS PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122970, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122672 AS PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122971, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122673 AS PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122972, COL_84669589_3EDF_4867_8128_B2F334719709#122674 AS PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122675 AS PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122974, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122676 AS PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122975, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122683 AS PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122976, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122691 AS PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122977, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122700 AS PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122978, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122691, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122700),  ) AS PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979]
Input [9]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122671, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122672, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122673, COL_84669589_3EDF_4867_8128_B2F334719709#122674, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122675, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122676, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122683, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122691, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122700]

(14) Exchange
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122970, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122971, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122972, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122974, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122975, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122976, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122977, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122978, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979]
Arguments: hashpartitioning(PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, 10), ENSURE_REQUIREMENTS, [plan_id=17623]

(15) ShuffleQueryStage
Output [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122970, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122971, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122972, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122974, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122975, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122976, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122977, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122978, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979]
Arguments: 1

(16) AQEShuffleRead
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122970, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122971, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122972, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122974, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122975, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122976, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122977, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122978, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979]
Arguments: coalesced

(17) Sort [codegen id : 5]
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122970, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122971, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122972, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122974, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122975, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122976, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122977, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122978, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979]
Arguments: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973 ASC NULLS FIRST], false, 0

(18) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907]
Right keys [1]: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973]
Join type: LeftOuter
Join condition: None

(19) Project [codegen id : 6]
Output [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122970 AS COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122971 AS COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122972 AS COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973 AS COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122974 AS COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122975 AS COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122976 AS COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122977 AS COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122978 AS COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979 AS COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979)) THEN false ELSE StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979) END, 1, 0) AS COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, str_diff(PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931) AS COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298]
Input [37]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122970, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122971, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122972, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122974, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122975, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122976, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122977, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122978, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979]

(20) Project [codegen id : 6]
Output [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298, str_if_with_rule((COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298 <=> ), Matching Total, str_join(array(Différence sur, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298),  )) AS COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586, str_if_with_rule(isnull(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213), str_join(array(Absence de Propriétaire pour le Mandat , COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907),  ), ) AS COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587, str_remove_space(str_join(array(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912),  ), ONLY_ONE) AS COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Input [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298]

(21) Exchange
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Arguments: hashpartitioning(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, 10), ENSURE_REQUIREMENTS, [plan_id=17823]

(22) ShuffleQueryStage
Output [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Arguments: 3

(23) AQEShuffleRead
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Arguments: coalesced

(24) Sort [codegen id : 8]
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Arguments: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588 ASC NULLS FIRST], false, 0

(25) Scan csv 
Output [3]: [Adresse-Source#121933, longitude#121935, latitude#121936]
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>

(26) Filter [codegen id : 3]
Input [3]: [Adresse-Source#121933, longitude#121935, latitude#121936]
Condition : (isnotnull(longitude#121935) AND isnotnull(str_remove_space(Adresse-Source#121933, ONLY_ONE)))

(27) Project [codegen id : 3]
Output [3]: [str_remove_space(Adresse-Source#121933, ONLY_ONE) AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, longitude#121935 AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, latitude#121936 AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Input [3]: [Adresse-Source#121933, longitude#121935, latitude#121936]

(28) HashAggregate [codegen id : 3]
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]

(29) Exchange
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Arguments: hashpartitioning(COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445, 10), ENSURE_REQUIREMENTS, [plan_id=17647]

(30) ShuffleQueryStage
Output [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Arguments: 2

(31) AQEShuffleRead
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Arguments: coalesced

(32) HashAggregate [codegen id : 7]
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442 AS GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444 AS GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445 AS GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637]

(33) Exchange
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637]
Arguments: hashpartitioning(GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, 10), ENSURE_REQUIREMENTS, [plan_id=17853]

(34) ShuffleQueryStage
Output [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637]
Arguments: 4

(35) AQEShuffleRead
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637]
Arguments: coalesced

(36) Sort [codegen id : 9]
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637]
Arguments: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635 ASC NULLS FIRST], false, 0

(37) SortMergeJoin [codegen id : 10]
Left keys [1]: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588]
Right keys [1]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635]
Join type: LeftOuter
Join condition: None

(38) Filter [codegen id : 10]
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932)), MAISON) END)

(39) Project [codegen id : 10]
Output [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637]

(40) HashAggregate [codegen id : 10]
Input [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Keys [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#123919L]
Results [2]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, count#123920L]

(41) Exchange
Input [2]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, count#123920L]
Arguments: hashpartitioning(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, 10), ENSURE_REQUIREMENTS, [plan_id=17966]

(42) ShuffleQueryStage
Output [2]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, count#123920L]
Arguments: 5

(43) AQEShuffleRead
Input [2]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, count#123920L]
Arguments: coalesced

(44) HashAggregate [codegen id : 11]
Input [2]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, count#123920L]
Keys [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#123910L]
Results [2]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932 AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC1#123865, count(1)#123910L AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#123912L]

(45) TakeOrderedAndProject
Input [2]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC1#123865, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#123912L]
Arguments: 70, [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#123912L DESC NULLS LAST], [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC1#123865, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#123912L]

(46) Filter
Input [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#121860, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#121861, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#121862, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#121863, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#121864, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#121865, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#121866, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#121867, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#121868, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#121869, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#121870, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#121871, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#121872, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#121873, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#121874, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#121875, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#121876, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#121877, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#121878, COL_D6895B92_8213_46E8_95DE_5711D209346E#121879, COL_A06CD743_975B_480F_890C_78685E530CD1#121880, COL_814180A7_65B9_4C68_A945_79F72A870824#121881, COL_6126101C_76C5_4C25_A5F2_987862B98C80#121882, COL_32583C88_3290_4A7F_A097_95297001B6D6#121883, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#121884, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#121885, COL_EB3E9294_C63E_4108_AB19_81F98873297C#121886]
Condition : isnotnull(COL_EB3E9294_C63E_4108_AB19_81F98873297C#121886)

(47) Project
Output [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#121860 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#121861 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#121862 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#121863 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#121864 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#121865 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#121866 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#121867 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#121868 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#121869 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#121870 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#121871 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#121872 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#121873 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#121874 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#121875 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#121876 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#121877 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#121878 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_D6895B92_8213_46E8_95DE_5711D209346E#121879 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_A06CD743_975B_480F_890C_78685E530CD1#121880 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_814180A7_65B9_4C68_A945_79F72A870824#121881 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_6126101C_76C5_4C25_A5F2_987862B98C80#121882 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_32583C88_3290_4A7F_A097_95297001B6D6#121883 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#121884 AS COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#121885 AS COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_EB3E9294_C63E_4108_AB19_81F98873297C#121886 AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Input [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#121860, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#121861, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#121862, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#121863, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#121864, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#121865, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#121866, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#121867, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#121868, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#121869, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#121870, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#121871, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#121872, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#121873, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#121874, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#121875, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#121876, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#121877, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#121878, COL_D6895B92_8213_46E8_95DE_5711D209346E#121879, COL_A06CD743_975B_480F_890C_78685E530CD1#121880, COL_814180A7_65B9_4C68_A945_79F72A870824#121881, COL_6126101C_76C5_4C25_A5F2_987862B98C80#121882, COL_32583C88_3290_4A7F_A097_95297001B6D6#121883, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#121884, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#121885, COL_EB3E9294_C63E_4108_AB19_81F98873297C#121886]

(48) Exchange
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Arguments: hashpartitioning(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, 10), ENSURE_REQUIREMENTS, [plan_id=17511]

(49) Sort
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Arguments: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907 ASC NULLS FIRST], false, 0

(50) Filter
Input [6]: [Portefeuille#122525, Civilit%C3%A9#122526, Nom#122527, Id+Mandat#122528, N%C2%B0+Registre#122529, Taux+Honoraire#122530]
Condition : isnotnull(Id+Mandat#122528)

(51) Project
Output [9]: [Portefeuille#122525 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122671, Civilit%C3%A9#122526 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122672, Nom#122527 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122673, Id+Mandat#122528 AS COL_84669589_3EDF_4867_8128_B2F334719709#122674, N%C2%B0+Registre#122529 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122675, Taux+Honoraire#122530 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122676, str_if_with_rule(CASE WHEN isnull(Contains(Taux+Honoraire#122530, - 0)) THEN false ELSE Contains(Taux+Honoraire#122530, - 0) END, Absence Taux, ) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122683, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(Civilit%C3%A9#122526, Madame, equal, [Madame], [], true, MME, , null), RANKING_STRING(Civilit%C3%A9#122526, Monsieur, equal, [MONSIEUR], [], true, MR, , null), RANKING_STRING(Civilit%C3%A9#122526, M et Mme, equal, [M ET MME], [], true, M_ET_MME, , null), RANKING_STRING(Civilit%C3%A9#122526, Succession, equal, [Succession], [], true, SUCCESSION, , null), RANKING_STRING(Civilit%C3%A9#122526, Ind., equal, [IND.], [], true, IND., , null), RANKING_STRING(Civilit%C3%A9#122526, Consorts, equal, [CONSORTS], [], true, CONSORT, , null), RANKING_STRING(Civilit%C3%A9#122526, SCI, equal, [SCI], [], true, SCI, , null), RANKING_STRING(Civilit%C3%A9#122526, SARL, equal, [SARL], [], true, SARL, , null), RANKING_STRING(Civilit%C3%A9#122526, Indivision, equal, [INDIVISION], [], true, INDIVISION, , null), RANKING_STRING(Civilit%C3%A9#122526, M ou Mme, equal, [M OU MME], [], true, M_OU_MME, , null), RANKING_STRING(Civilit%C3%A9#122526, Messieurs, equal, [MESSIEURS], [], true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122691, str_remove_space(str_remove_accent(str_transform_case(Nom#122527, UPPER)), ONLY_ONE) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122700]
Input [6]: [Portefeuille#122525, Civilit%C3%A9#122526, Nom#122527, Id+Mandat#122528, N%C2%B0+Registre#122529, Taux+Honoraire#122530]

(52) Project
Output [10]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122671 AS PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122970, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122672 AS PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122971, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122673 AS PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122972, COL_84669589_3EDF_4867_8128_B2F334719709#122674 AS PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122675 AS PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122974, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122676 AS PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122975, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122683 AS PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122976, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122691 AS PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122977, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122700 AS PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122978, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122691, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122700),  ) AS PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979]
Input [9]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122671, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122672, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122673, COL_84669589_3EDF_4867_8128_B2F334719709#122674, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122675, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122676, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122683, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122691, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122700]

(53) Exchange
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122970, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122971, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122972, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122974, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122975, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122976, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122977, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122978, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979]
Arguments: hashpartitioning(PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, 10), ENSURE_REQUIREMENTS, [plan_id=17512]

(54) Sort
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122970, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122971, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122972, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122974, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122975, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122976, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122977, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122978, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979]
Arguments: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973 ASC NULLS FIRST], false, 0

(55) SortMergeJoin
Left keys [1]: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907]
Right keys [1]: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973]
Join type: LeftOuter
Join condition: None

(56) Project
Output [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122970 AS COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122971 AS COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122972 AS COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973 AS COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122974 AS COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122975 AS COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122976 AS COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122977 AS COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122978 AS COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979 AS COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979)) THEN false ELSE StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979) END, 1, 0) AS COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, str_diff(PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931) AS COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298]
Input [37]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#122970, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#122971, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#122972, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#122973, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#122974, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#122975, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#122976, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#122977, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#122978, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#122979]

(57) Project
Output [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298, str_if_with_rule((COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298 <=> ), Matching Total, str_join(array(Différence sur, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298),  )) AS COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586, str_if_with_rule(isnull(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213), str_join(array(Absence de Propriétaire pour le Mandat , COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907),  ), ) AS COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587, str_remove_space(str_join(array(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912),  ), ONLY_ONE) AS COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Input [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298]

(58) Exchange
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Arguments: hashpartitioning(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, 10), ENSURE_REQUIREMENTS, [plan_id=17524]

(59) Sort
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Arguments: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588 ASC NULLS FIRST], false, 0

(60) Filter
Input [3]: [Adresse-Source#121933, longitude#121935, latitude#121936]
Condition : (isnotnull(longitude#121935) AND isnotnull(str_remove_space(Adresse-Source#121933, ONLY_ONE)))

(61) Project
Output [3]: [str_remove_space(Adresse-Source#121933, ONLY_ONE) AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, longitude#121935 AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, latitude#121936 AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Input [3]: [Adresse-Source#121933, longitude#121935, latitude#121936]

(62) HashAggregate
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]

(63) Exchange
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Arguments: hashpartitioning(COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445, 10), ENSURE_REQUIREMENTS, [plan_id=17518]

(64) HashAggregate
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#122442 AS GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#122444 AS GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#122445 AS GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637]

(65) Exchange
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637]
Arguments: hashpartitioning(GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, 10), ENSURE_REQUIREMENTS, [plan_id=17525]

(66) Sort
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637]
Arguments: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635 ASC NULLS FIRST], false, 0

(67) SortMergeJoin
Left keys [1]: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588]
Right keys [1]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635]
Join type: LeftOuter
Join condition: None

(68) Filter
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932)), MAISON) END)

(69) Project
Output [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#122906, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#122907, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#122908, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#122909, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#122910, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#122911, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#122912, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#122930, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#122913, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#122914, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#122915, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#122916, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#122917, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#122918, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#122919, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#122920, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#122921, COL_0DB61D05_5348_40DB_8F16_C7916849A669#122922, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#122923, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#122924, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#122925, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#122926, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#122927, COL_33CEA792_75B9_44A1_896B_B422BD28B923#122928, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#122929, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#123210, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#123211, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#123212, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#123213, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#123214, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#123215, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#123216, COL_924860D6_14C4_4F33_B84C_E428E89E2817#123217, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#123218, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#123219, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#122931, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#123259, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#123298, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#123586, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#123587, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#123588, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#123635, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#123636, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#123637]

(70) HashAggregate
Input [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Keys [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#123919L]
Results [2]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, count#123920L]

(71) Exchange
Input [2]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, count#123920L]
Arguments: hashpartitioning(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, 10), ENSURE_REQUIREMENTS, [plan_id=17533]

(72) HashAggregate
Input [2]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932, count#123920L]
Keys [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#123910L]
Results [2]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#122932 AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC1#123865, count(1)#123910L AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#123912L]

(73) TakeOrderedAndProject
Input [2]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC1#123865, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#123912L]
Arguments: 70, [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#123912L DESC NULLS LAST], [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC1#123865, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#123912L]

(74) AdaptiveSparkPlan
Output [2]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC1#123865, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#123912L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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