== Physical Plan ==
AdaptiveSparkPlan (69)
+- == Final Plan ==
SortAggregate (42)
+- ShuffleQueryStage (41), Statistics(sizeInBytes=64.0 B, rowCount=1)
+- Exchange (40)
+- SortAggregate (39)
+- * Project (38)
+- * Filter (37)
+- * SortMergeJoin LeftOuter (36)
:- * Sort (23)
: +- AQEShuffleRead (22)
: +- ShuffleQueryStage (21), Statistics(sizeInBytes=1166.6 KiB, rowCount=1.46E+3)
: +- Exchange (20)
: +- * Project (19)
: +- * Project (18)
: +- * SortMergeJoin LeftOuter (17)
: :- * Sort (7)
: : +- AQEShuffleRead (6)
: : +- ShuffleQueryStage (5), Statistics(sizeInBytes=720.5 KiB, rowCount=1.46E+3)
: : +- Exchange (4)
: : +- * Project (3)
: : +- * ColumnarToRow (2)
: : +- Scan parquet (1)
: +- * Sort (16)
: +- AQEShuffleRead (15)
: +- ShuffleQueryStage (14), Statistics(sizeInBytes=210.0 KiB, rowCount=1.10E+3)
: +- Exchange (13)
: +- * Project (12)
: +- * Project (11)
: +- * Filter (10)
: +- * ColumnarToRow (9)
: +- Scan parquet (8)
+- * Sort (35)
+- AQEShuffleRead (34)
+- ShuffleQueryStage (33), Statistics(sizeInBytes=97.0 KiB, rowCount=1.00E+3)
+- Exchange (32)
+- * HashAggregate (31)
+- AQEShuffleRead (30)
+- ShuffleQueryStage (29), Statistics(sizeInBytes=97.0 KiB, rowCount=1.00E+3)
+- Exchange (28)
+- * HashAggregate (27)
+- * Project (26)
+- * Filter (25)
+- Scan csv (24)
+- == Initial Plan ==
SortAggregate (68)
+- Exchange (67)
+- SortAggregate (66)
+- Project (65)
+- Filter (64)
+- SortMergeJoin LeftOuter (63)
:- Sort (55)
: +- Exchange (54)
: +- Project (53)
: +- Project (52)
: +- SortMergeJoin LeftOuter (51)
: :- Sort (45)
: : +- Exchange (44)
: : +- Project (43)
: : +- Scan parquet (1)
: +- Sort (50)
: +- Exchange (49)
: +- Project (48)
: +- Project (47)
: +- Filter (46)
: +- Scan parquet (8)
+- Sort (62)
+- Exchange (61)
+- HashAggregate (60)
+- Exchange (59)
+- HashAggregate (58)
+- Project (57)
+- Filter (56)
+- Scan csv (24)
(1) Scan parquet
Output [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#119692, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#119693, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#119694, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#119695, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#119696, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#119697, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#119698, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#119699, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#119700, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#119701, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#119702, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#119703, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#119704, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#119705, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#119706, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#119707, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#119708, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#119709, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#119710, COL_D6895B92_8213_46E8_95DE_5711D209346E#119711, COL_A06CD743_975B_480F_890C_78685E530CD1#119712, COL_814180A7_65B9_4C68_A945_79F72A870824#119713, COL_6126101C_76C5_4C25_A5F2_987862B98C80#119714, COL_32583C88_3290_4A7F_A097_95297001B6D6#119715, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#119716, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#119717, COL_EB3E9294_C63E_4108_AB19_81F98873297C#119718]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/PATRIMOINE_NT_405178]
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#119692, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#119693, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#119694, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#119695, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#119696, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#119697, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#119698, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#119699, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#119700, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#119701, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#119702, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#119703, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#119704, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#119705, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#119706, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#119707, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#119708, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#119709, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#119710, COL_D6895B92_8213_46E8_95DE_5711D209346E#119711, COL_A06CD743_975B_480F_890C_78685E530CD1#119712, COL_814180A7_65B9_4C68_A945_79F72A870824#119713, COL_6126101C_76C5_4C25_A5F2_987862B98C80#119714, COL_32583C88_3290_4A7F_A097_95297001B6D6#119715, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#119716, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#119717, COL_EB3E9294_C63E_4108_AB19_81F98873297C#119718]
(3) Project [codegen id : 1]
Output [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#119692 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#119693 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#119694 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#119695 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#119696 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#119697 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#119698 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#119699 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#119700 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#119701 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#119702 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#119703 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#119704 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#119705 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#119706 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#119707 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#119708 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#119709 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#119710 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_D6895B92_8213_46E8_95DE_5711D209346E#119711 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_A06CD743_975B_480F_890C_78685E530CD1#119712 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_814180A7_65B9_4C68_A945_79F72A870824#119713 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_6126101C_76C5_4C25_A5F2_987862B98C80#119714 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_32583C88_3290_4A7F_A097_95297001B6D6#119715 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#119716 AS COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#119717 AS COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_EB3E9294_C63E_4108_AB19_81F98873297C#119718 AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Input [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#119692, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#119693, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#119694, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#119695, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#119696, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#119697, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#119698, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#119699, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#119700, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#119701, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#119702, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#119703, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#119704, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#119705, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#119706, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#119707, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#119708, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#119709, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#119710, COL_D6895B92_8213_46E8_95DE_5711D209346E#119711, COL_A06CD743_975B_480F_890C_78685E530CD1#119712, COL_814180A7_65B9_4C68_A945_79F72A870824#119713, COL_6126101C_76C5_4C25_A5F2_987862B98C80#119714, COL_32583C88_3290_4A7F_A097_95297001B6D6#119715, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#119716, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#119717, COL_EB3E9294_C63E_4108_AB19_81F98873297C#119718]
(4) Exchange
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Arguments: hashpartitioning(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, 10), ENSURE_REQUIREMENTS, [plan_id=16985]
(5) ShuffleQueryStage
Output [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Arguments: 0
(6) AQEShuffleRead
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Arguments: coalesced
(7) Sort [codegen id : 4]
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Arguments: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739 ASC NULLS FIRST], false, 0
(8) Scan parquet
Output [6]: [Portefeuille#120357, Civilit%C3%A9#120358, Nom#120359, Id+Mandat#120360, N%C2%B0+Registre#120361, Taux+Honoraire#120362]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/1210D38A_30A1_417E_AC30_A633AB773A43_79471ac0595e0f84c440113d58d8281c/PROPRIETAIRES_Laneco_Base.xls_afce3e2f319a0b3bd204c24dc83c5faa]
PushedFilters: [IsNotNull(`Id+Mandat`)]
ReadSchema: struct<Portefeuille:string,Civilit%C3%A9:string,Nom:string,Id+Mandat:string,N%C2%B0+Registre:string,Taux+Honoraire:string>
(9) ColumnarToRow [codegen id : 2]
Input [6]: [Portefeuille#120357, Civilit%C3%A9#120358, Nom#120359, Id+Mandat#120360, N%C2%B0+Registre#120361, Taux+Honoraire#120362]
(10) Filter [codegen id : 2]
Input [6]: [Portefeuille#120357, Civilit%C3%A9#120358, Nom#120359, Id+Mandat#120360, N%C2%B0+Registre#120361, Taux+Honoraire#120362]
Condition : isnotnull(Id+Mandat#120360)
(11) Project [codegen id : 2]
Output [9]: [Portefeuille#120357 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120503, Civilit%C3%A9#120358 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120504, Nom#120359 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120505, Id+Mandat#120360 AS COL_84669589_3EDF_4867_8128_B2F334719709#120506, N%C2%B0+Registre#120361 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120507, Taux+Honoraire#120362 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120508, str_if_with_rule(CASE WHEN isnull(Contains(Taux+Honoraire#120362, - 0)) THEN false ELSE Contains(Taux+Honoraire#120362, - 0) END, Absence Taux, ) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120515, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(Civilit%C3%A9#120358, Madame, equal, [Madame], [], true, MME, , null), RANKING_STRING(Civilit%C3%A9#120358, Monsieur, equal, [MONSIEUR], [], true, MR, , null), RANKING_STRING(Civilit%C3%A9#120358, M et Mme, equal, [M ET MME], [], true, M_ET_MME, , null), RANKING_STRING(Civilit%C3%A9#120358, Succession, equal, [Succession], [], true, SUCCESSION, , null), RANKING_STRING(Civilit%C3%A9#120358, Ind., equal, [IND.], [], true, IND., , null), RANKING_STRING(Civilit%C3%A9#120358, Consorts, equal, [CONSORTS], [], true, CONSORT, , null), RANKING_STRING(Civilit%C3%A9#120358, SCI, equal, [SCI], [], true, SCI, , null), RANKING_STRING(Civilit%C3%A9#120358, SARL, equal, [SARL], [], true, SARL, , null), RANKING_STRING(Civilit%C3%A9#120358, Indivision, equal, [INDIVISION], [], true, INDIVISION, , null), RANKING_STRING(Civilit%C3%A9#120358, M ou Mme, equal, [M OU MME], [], true, M_OU_MME, , null), RANKING_STRING(Civilit%C3%A9#120358, Messieurs, equal, [MESSIEURS], [], true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120523, str_remove_space(str_remove_accent(str_transform_case(Nom#120359, UPPER)), ONLY_ONE) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120532]
Input [6]: [Portefeuille#120357, Civilit%C3%A9#120358, Nom#120359, Id+Mandat#120360, N%C2%B0+Registre#120361, Taux+Honoraire#120362]
(12) Project [codegen id : 2]
Output [10]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120503 AS PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120802, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120504 AS PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120803, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120505 AS PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120804, COL_84669589_3EDF_4867_8128_B2F334719709#120506 AS PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120507 AS PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120806, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120508 AS PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120807, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120515 AS PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120808, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120523 AS PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120809, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120532 AS PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120810, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120523, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120532), ) AS PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811]
Input [9]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120503, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120504, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120505, COL_84669589_3EDF_4867_8128_B2F334719709#120506, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120507, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120508, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120515, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120523, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120532]
(13) Exchange
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120802, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120803, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120804, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120806, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120807, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120808, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120809, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120810, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811]
Arguments: hashpartitioning(PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805, 10), ENSURE_REQUIREMENTS, [plan_id=17006]
(14) ShuffleQueryStage
Output [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120802, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120803, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120804, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120806, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120807, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120808, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120809, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120810, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811]
Arguments: 1
(15) AQEShuffleRead
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120802, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120803, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120804, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120806, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120807, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120808, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120809, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120810, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811]
Arguments: coalesced
(16) Sort [codegen id : 5]
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120802, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120803, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120804, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120806, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120807, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120808, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120809, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120810, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811]
Arguments: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805 ASC NULLS FIRST], false, 0
(17) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739]
Right keys [1]: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805]
Join type: LeftOuter
Join condition: None
(18) Project [codegen id : 6]
Output [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120802 AS COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120803 AS COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120804 AS COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805 AS COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120806 AS COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120807 AS COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120808 AS COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120809 AS COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120810 AS COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811 AS COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811)) THEN false ELSE StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811) END, 1, 0) AS COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, str_diff(PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763) AS COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130]
Input [37]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120802, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120803, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120804, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120806, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120807, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120808, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120809, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120810, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811]
(19) Project [codegen id : 6]
Output [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130, str_if_with_rule((COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130 <=> ), Matching Total, str_join(array(Différence sur, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130), )) AS COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418, str_if_with_rule(isnull(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045), str_join(array(Absence de Propriétaire pour le Mandat , COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739), ), ) AS COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419, str_remove_space(str_join(array(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744), ), ONLY_ONE) AS COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Input [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130]
(20) Exchange
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Arguments: hashpartitioning(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, 10), ENSURE_REQUIREMENTS, [plan_id=17198]
(21) ShuffleQueryStage
Output [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Arguments: 3
(22) AQEShuffleRead
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Arguments: coalesced
(23) Sort [codegen id : 8]
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Arguments: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420 ASC NULLS FIRST], false, 0
(24) Scan csv
Output [3]: [Adresse-Source#119765, longitude#119767, latitude#119768]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/359356B1_1158_424C_96CE_4656C0BF7CAB/current/Adresses_geocodees_(1).csv]
PushedFilters: [IsNotNull(longitude)]
ReadSchema: struct<Adresse-Source:string,longitude:string,latitude:string>
(25) Filter [codegen id : 3]
Input [3]: [Adresse-Source#119765, longitude#119767, latitude#119768]
Condition : (isnotnull(longitude#119767) AND isnotnull(str_remove_space(Adresse-Source#119765, ONLY_ONE)))
(26) Project [codegen id : 3]
Output [3]: [str_remove_space(Adresse-Source#119765, ONLY_ONE) AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, longitude#119767 AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, latitude#119768 AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Input [3]: [Adresse-Source#119765, longitude#119767, latitude#119768]
(27) HashAggregate [codegen id : 3]
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
(28) Exchange
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Arguments: hashpartitioning(COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277, 10), ENSURE_REQUIREMENTS, [plan_id=17030]
(29) ShuffleQueryStage
Output [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Arguments: 2
(30) AQEShuffleRead
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Arguments: coalesced
(31) HashAggregate [codegen id : 7]
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274 AS GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276 AS GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277 AS GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469]
(32) Exchange
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469]
Arguments: hashpartitioning(GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, 10), ENSURE_REQUIREMENTS, [plan_id=17273]
(33) ShuffleQueryStage
Output [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469]
Arguments: 4
(34) AQEShuffleRead
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469]
Arguments: coalesced
(35) Sort [codegen id : 9]
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469]
Arguments: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467 ASC NULLS FIRST], false, 0
(36) SortMergeJoin [codegen id : 10]
Left keys [1]: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420]
Right keys [1]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467]
Join type: LeftOuter
Join condition: None
(37) Filter [codegen id : 10]
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)), MAISON) END)
(38) Project [codegen id : 10]
Output [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469]
(39) SortAggregate
Input [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Keys: []
Functions [4]: [partial_count(1), partial_count(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764), partial_min(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764), partial_max(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)]
Aggregate Attributes [4]: [count#121761L, count#121762L, min#121763, max#121764]
Results [4]: [count#121765L, count#121766L, min#121767, max#121768]
(40) Exchange
Input [4]: [count#121765L, count#121766L, min#121767, max#121768]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=17376]
(41) ShuffleQueryStage
Output [4]: [count#121765L, count#121766L, min#121767, max#121768]
Arguments: 5
(42) SortAggregate
Input [4]: [count#121765L, count#121766L, min#121767, max#121768]
Keys: []
Functions [4]: [count(1), count(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764), min(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764), max(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)]
Aggregate Attributes [4]: [count(1)#121697L, count(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)#121700L, min(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)#121703, max(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)#121705]
Results [4]: [count(1)#121697L AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC1#121699L, count(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)#121700L AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#121702L, min(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)#121703 AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC4#121704, max(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)#121705 AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC5#121706]
(43) Project
Output [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#119692 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#119693 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#119694 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#119695 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#119696 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#119697 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#119698 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#119699 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#119700 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#119701 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#119702 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#119703 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#119704 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#119705 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#119706 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#119707 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#119708 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#119709 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#119710 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_D6895B92_8213_46E8_95DE_5711D209346E#119711 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_A06CD743_975B_480F_890C_78685E530CD1#119712 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_814180A7_65B9_4C68_A945_79F72A870824#119713 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_6126101C_76C5_4C25_A5F2_987862B98C80#119714 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_32583C88_3290_4A7F_A097_95297001B6D6#119715 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#119716 AS COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#119717 AS COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_EB3E9294_C63E_4108_AB19_81F98873297C#119718 AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Input [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#119692, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#119693, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#119694, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#119695, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#119696, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#119697, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#119698, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#119699, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#119700, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#119701, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#119702, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#119703, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#119704, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#119705, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#119706, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#119707, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#119708, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#119709, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#119710, COL_D6895B92_8213_46E8_95DE_5711D209346E#119711, COL_A06CD743_975B_480F_890C_78685E530CD1#119712, COL_814180A7_65B9_4C68_A945_79F72A870824#119713, COL_6126101C_76C5_4C25_A5F2_987862B98C80#119714, COL_32583C88_3290_4A7F_A097_95297001B6D6#119715, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#119716, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#119717, COL_EB3E9294_C63E_4108_AB19_81F98873297C#119718]
(44) Exchange
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Arguments: hashpartitioning(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, 10), ENSURE_REQUIREMENTS, [plan_id=16902]
(45) Sort
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Arguments: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739 ASC NULLS FIRST], false, 0
(46) Filter
Input [6]: [Portefeuille#120357, Civilit%C3%A9#120358, Nom#120359, Id+Mandat#120360, N%C2%B0+Registre#120361, Taux+Honoraire#120362]
Condition : isnotnull(Id+Mandat#120360)
(47) Project
Output [9]: [Portefeuille#120357 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120503, Civilit%C3%A9#120358 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120504, Nom#120359 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120505, Id+Mandat#120360 AS COL_84669589_3EDF_4867_8128_B2F334719709#120506, N%C2%B0+Registre#120361 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120507, Taux+Honoraire#120362 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120508, str_if_with_rule(CASE WHEN isnull(Contains(Taux+Honoraire#120362, - 0)) THEN false ELSE Contains(Taux+Honoraire#120362, - 0) END, Absence Taux, ) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120515, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(Civilit%C3%A9#120358, Madame, equal, [Madame], [], true, MME, , null), RANKING_STRING(Civilit%C3%A9#120358, Monsieur, equal, [MONSIEUR], [], true, MR, , null), RANKING_STRING(Civilit%C3%A9#120358, M et Mme, equal, [M ET MME], [], true, M_ET_MME, , null), RANKING_STRING(Civilit%C3%A9#120358, Succession, equal, [Succession], [], true, SUCCESSION, , null), RANKING_STRING(Civilit%C3%A9#120358, Ind., equal, [IND.], [], true, IND., , null), RANKING_STRING(Civilit%C3%A9#120358, Consorts, equal, [CONSORTS], [], true, CONSORT, , null), RANKING_STRING(Civilit%C3%A9#120358, SCI, equal, [SCI], [], true, SCI, , null), RANKING_STRING(Civilit%C3%A9#120358, SARL, equal, [SARL], [], true, SARL, , null), RANKING_STRING(Civilit%C3%A9#120358, Indivision, equal, [INDIVISION], [], true, INDIVISION, , null), RANKING_STRING(Civilit%C3%A9#120358, M ou Mme, equal, [M OU MME], [], true, M_OU_MME, , null), RANKING_STRING(Civilit%C3%A9#120358, Messieurs, equal, [MESSIEURS], [], true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120523, str_remove_space(str_remove_accent(str_transform_case(Nom#120359, UPPER)), ONLY_ONE) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120532]
Input [6]: [Portefeuille#120357, Civilit%C3%A9#120358, Nom#120359, Id+Mandat#120360, N%C2%B0+Registre#120361, Taux+Honoraire#120362]
(48) Project
Output [10]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120503 AS PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120802, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120504 AS PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120803, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120505 AS PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120804, COL_84669589_3EDF_4867_8128_B2F334719709#120506 AS PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120507 AS PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120806, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120508 AS PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120807, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120515 AS PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120808, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120523 AS PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120809, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120532 AS PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120810, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120523, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120532), ) AS PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811]
Input [9]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120503, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120504, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120505, COL_84669589_3EDF_4867_8128_B2F334719709#120506, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120507, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120508, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120515, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120523, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120532]
(49) Exchange
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120802, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120803, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120804, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120806, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120807, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120808, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120809, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120810, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811]
Arguments: hashpartitioning(PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805, 10), ENSURE_REQUIREMENTS, [plan_id=16903]
(50) Sort
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120802, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120803, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120804, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120806, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120807, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120808, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120809, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120810, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811]
Arguments: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805 ASC NULLS FIRST], false, 0
(51) SortMergeJoin
Left keys [1]: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739]
Right keys [1]: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805]
Join type: LeftOuter
Join condition: None
(52) Project
Output [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120802 AS COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120803 AS COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120804 AS COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805 AS COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120806 AS COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120807 AS COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120808 AS COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120809 AS COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120810 AS COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811 AS COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811)) THEN false ELSE StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811) END, 1, 0) AS COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, str_diff(PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763) AS COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130]
Input [37]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#120802, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#120803, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#120804, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#120805, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#120806, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#120807, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#120808, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#120809, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#120810, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#120811]
(53) Project
Output [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130, str_if_with_rule((COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130 <=> ), Matching Total, str_join(array(Différence sur, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130), )) AS COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418, str_if_with_rule(isnull(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045), str_join(array(Absence de Propriétaire pour le Mandat , COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739), ), ) AS COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419, str_remove_space(str_join(array(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744), ), ONLY_ONE) AS COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Input [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130]
(54) Exchange
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Arguments: hashpartitioning(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, 10), ENSURE_REQUIREMENTS, [plan_id=16915]
(55) Sort
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Arguments: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420 ASC NULLS FIRST], false, 0
(56) Filter
Input [3]: [Adresse-Source#119765, longitude#119767, latitude#119768]
Condition : (isnotnull(longitude#119767) AND isnotnull(str_remove_space(Adresse-Source#119765, ONLY_ONE)))
(57) Project
Output [3]: [str_remove_space(Adresse-Source#119765, ONLY_ONE) AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, longitude#119767 AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, latitude#119768 AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Input [3]: [Adresse-Source#119765, longitude#119767, latitude#119768]
(58) HashAggregate
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
(59) Exchange
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Arguments: hashpartitioning(COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277, 10), ENSURE_REQUIREMENTS, [plan_id=16909]
(60) HashAggregate
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#120274 AS GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#120276 AS GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#120277 AS GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469]
(61) Exchange
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469]
Arguments: hashpartitioning(GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, 10), ENSURE_REQUIREMENTS, [plan_id=16916]
(62) Sort
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469]
Arguments: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467 ASC NULLS FIRST], false, 0
(63) SortMergeJoin
Left keys [1]: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420]
Right keys [1]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467]
Join type: LeftOuter
Join condition: None
(64) Filter
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)), MAISON) END)
(65) Project
Output [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#120738, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#120739, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#120740, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#120741, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#120742, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#120743, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#120744, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#120762, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#120745, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#120746, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#120747, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#120748, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#120749, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#120750, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#120751, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#120752, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#120753, COL_0DB61D05_5348_40DB_8F16_C7916849A669#120754, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#120755, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#120756, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#120757, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#120758, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#120759, COL_33CEA792_75B9_44A1_896B_B422BD28B923#120760, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#120761, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#121042, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#121043, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#121044, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#121045, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#121046, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#121047, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#121048, COL_924860D6_14C4_4F33_B84C_E428E89E2817#121049, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#121050, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#121051, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#120763, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#121091, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#121130, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#121418, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#121419, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#121420, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#121467, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#121468, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#121469]
(66) SortAggregate
Input [1]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764]
Keys: []
Functions [4]: [partial_count(1), partial_count(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764), partial_min(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764), partial_max(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)]
Aggregate Attributes [4]: [count#121761L, count#121762L, min#121763, max#121764]
Results [4]: [count#121765L, count#121766L, min#121767, max#121768]
(67) Exchange
Input [4]: [count#121765L, count#121766L, min#121767, max#121768]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=16924]
(68) SortAggregate
Input [4]: [count#121765L, count#121766L, min#121767, max#121768]
Keys: []
Functions [4]: [count(1), count(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764), min(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764), max(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)]
Aggregate Attributes [4]: [count(1)#121697L, count(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)#121700L, min(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)#121703, max(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)#121705]
Results [4]: [count(1)#121697L AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC1#121699L, count(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)#121700L AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#121702L, min(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)#121703 AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC4#121704, max(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#120764)#121705 AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC5#121706]
(69) AdaptiveSparkPlan
Output [4]: [COL_0798550D_6632_4F18_8CE3_72BAF75D68CC1#121699L, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC2#121702L, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC4#121704, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC5#121706]
Arguments: isFinalPlan=true