DC2 - Details for Query 78

Details for Query 78

Submitted Time: 2025/11/07 08:58:34
Duration: 2 s
Succeeded Jobs: 108 111 114 116 118

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: total (min, med, max (stageId: taskId))\n61 ms (2 ms, 2 ms, 17 ms (stage 154.0: task 378))"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 29 ms (1 ms, 1 ms, 15 ms (stage 154.0: task 378)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 142.0: task 329)) number of output rows: 46 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 142.0: task 329))"]; 4 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 142.0: task 329)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 142.0: task 329)) number of output rows: 46 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 142.0: task 329))"]; 5 [labelType="html" label=" Project "]; } 6 [labelType="html" label=" Window "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n106 ms (4 ms, 4 ms, 29 ms (stage 142.0: task 329))"; 8 [labelType="html" label=" Project "]; } 9 [labelType="html" label=" Window "]; subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n242 ms (4 ms, 11 ms, 90 ms (stage 142.0: task 329))"; 11 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 142.0: task 329)) peak memory total (min, med, max (stageId: taskId)) 832.8 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 142.0: task 329)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 142.0: task 329))"]; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 94"]; } 14 [labelType="html" label=" Window "]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n544 ms (6 ms, 14 ms, 266 ms (stage 142.0: task 329))"; 16 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 62 ms (0 ms, 1 ms, 43 ms (stage 142.0: task 329)) peak memory total (min, med, max (stageId: taskId)) 832.8 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 142.0: task 329)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 142.0: task 329))"]; } 17 [labelType="html" label=" CustomShuffleReader "]; 18 [labelType="html" label="Exchange shuffle records written: 14,814 shuffle write time total (min, med, max (stageId: taskId)) 1.7 s (79 ms, 107 ms, 214 ms (stage 135.0: task 296)) records read: 14,814 local bytes read total (min, med, max (stageId: taskId)) 1035.8 KiB (26.7 KiB, 84.1 KiB, 86.4 KiB (stage 148.0: task 362)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 142.0: task 329)) remote bytes read: 0.0 B local blocks read: 169 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 1462.4 KiB (45.3 KiB, 117.6 KiB, 121.5 KiB (stage 135.0: task 313)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 1035.8 KiB (41.3 KiB, 82.6 KiB, 84.5 KiB (stage 135.0: task 313))"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n436 ms (24 ms, 29 ms, 71 ms (stage 135.0: task 296))"; 20 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 57 ms (2 ms, 4 ms, 9 ms (stage 135.0: task 298)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 135.0: task 297)) number of output rows: 14,814 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 135.0: task 297))"]; } 21 [labelType="html" label=" CustomShuffleReader "]; 22 [labelType="html" label="Exchange shuffle records written: 14,814 shuffle write time total (min, med, max (stageId: taskId)) 1.9 s (47 ms, 179 ms, 253 ms (stage 131.0: task 272)) records read: 14,814 local bytes read total (min, med, max (stageId: taskId)) 1144.5 KiB (35.1 KiB, 92.1 KiB, 95.5 KiB (stage 135.0: task 313)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 135.0: task 297)) remote bytes read: 0.0 B local blocks read: 155 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 1852.9 KiB (9.8 KiB, 96.0 KiB, 325.3 KiB (stage 131.0: task 268)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 1144.5 KiB (11.2 KiB, 64.3 KiB, 184.0 KiB (stage 131.0: task 268))"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n3.9 s (302 ms, 331 ms, 350 ms (stage 131.0: task 271))"; 24 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 2.5 s (159 ms, 211 ms, 239 ms (stage 131.0: task 269)) peak memory total (min, med, max (stageId: taskId)) 771.0 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 131.0: task 277)) number of output rows: 14,814 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 131.0: task 277))"]; 25 [labelType="html" label=" Project "]; } 26 [labelType="html" label="Generate number of output rows: 19,130"]; subgraph cluster27 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n3.0 s (201 ms, 253 ms, 281 ms (stage 131.0: task 271))"; 28 [labelType="html" label=" Project "]; 29 [labelType="html" label="Filter number of output rows: 14,912"]; } 30 [labelType="html" label="Generate number of output rows: 182,224"]; subgraph cluster31 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n3.2 s (220 ms, 274 ms, 304 ms (stage 131.0: task 269))"; 32 [labelType="html" label=" Project "]; 33 [labelType="html" label="ColumnarToRow number of output rows: 45,556 number of input batches: 12"]; } 34 [labelType="html" label="Scan parquet number of files read: 12 scan time total (min, med, max (stageId: taskId)) 91 ms (3 ms, 5 ms, 20 ms (stage 131.0: task 278)) metadata time: 0 ms size of files read: 3.3 MiB number of output rows: 45,556"]; 1->0; 3->1; 4->3; 5->4; 6->5; 8->6; 9->8; 11->9; 12->11; 13->12; 14->13; 16->14; 17->16; 18->17; 20->18; 21->20; 22->21; 24->22; 25->24; 26->25; 28->26; 29->28; 30->29; 32->30; 33->32; 34->33; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

HashAggregate(keys=[COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L], functions=[])

Project [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482]

WholeStageCodegen (8)

Window [collect_list(COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393], [1 DESC NULLS LAST]

Project [COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445]

WholeStageCodegen (7)

Window [collect_list(COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393], [1 DESC NULLS LAST]

Sort [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L]

Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L > 1)

WholeStageCodegen (6)

Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, CONST#22157 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129], [CONST#22157 DESC NULLS LAST]

Sort [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129 ASC NULLS FIRST, CONST#22157 DESC NULLS LAST], false, 0

WholeStageCodegen (5)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, 200), true, [id=#2789]

HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045], functions=[])

WholeStageCodegen (4)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045, 200), true, [id=#2695]

Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953), : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045]

WholeStageCodegen (3)

Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21924), [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953]

Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21537 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21538 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, col0#21629 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, str_split(col1#21630, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21924]

Filter NOT (str_remove_accent(upper(col1#21630)) <=> )

WholeStageCodegen (2)

Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21539, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21540, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21541, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21542), [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21537, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21538], false, [col0#21629, col1#21630]

Project [CODE_26562#21256 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21537, CLIENT_26563#21255 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21538, ALCYON_26574#21248 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21539, CENTRAVET_26575#21249 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21540, COVETO_26576#21258 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21541, NEFTYS_26577#21268 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21542]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ALCYON_26574#21248,CENTRAVET_26575#21249,CLIENT_26563#21255,CODE_26562#21256,COVETO_26576#21258,NEFTYS_26577#21268] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/uet/BASE_BOHRINGER_26561], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ALCYON_26574:string,CENTRAVET_26575:string,CLIENT_26563:string,CODE_26562:string,COVETO_26...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#22548 AS COL_27B025C8_0688_4168_B098_AC51690C660E#22556, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22549 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22557, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22550 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22558, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22551L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22559L]
      +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#22540 AS COL_27B025C8_0688_4168_B098_AC51690C660E#22548, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22541 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22549, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22542 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22550, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22543L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22551L]
         +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#22520 AS COL_27B025C8_0688_4168_B098_AC51690C660E#22540, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22521 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22541, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22522 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22542, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22523L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22543L]
            +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#22520, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22521, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22522, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22523L]
               +- Aggregate [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22510, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22512, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22513, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22511L], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22510 AS COL_27B025C8_0688_4168_B098_AC51690C660E#22520, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22512 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22521, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22513 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22522, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22511L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22523L, 1 AS NULL_1#22530]
                  +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22496 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#22508, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22497 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22509, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22498 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22510, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22499L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22511L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22500 AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22512, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22501 AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22513]
                     +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#22496, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22497, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22498, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22499L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445 AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22500, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482 AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22501]
                        +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482]
                           +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, CONST#22474, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482]
                              +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, CONST#22474, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482]
                                 +- Window [collect_list(COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, CONST#22474 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393], [CONST#22474 DESC NULLS LAST]
                                    +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, CONST#22474]
                                       +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, 1 AS CONST#22474]
                                          +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445]
                                             +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, CONST#22426, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445]
                                                +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, CONST#22426, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445]
                                                   +- Window [collect_list(COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, CONST#22426 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393], [CONST#22426 DESC NULLS LAST]
                                                      +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, CONST#22426]
                                                         +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, 1 AS CONST#22426]
                                                            +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L]
                                                               +- Project [cast(UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22373 as string) AS COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, cast(UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22374 as string) AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, cast(UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#22375 as string) AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, cast(UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22376L as bigint) AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L]
                                                                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22290 AS UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22373, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22291 AS UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22374, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22292 AS UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#22375, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22293L AS UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22376L]
                                                                     +- SubqueryAlias UNITE_CODE_CENT_36755115
                                                                        +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22266 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22290, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22267 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22291, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22270 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22292, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22271L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22293L]
                                                                           +- Filter CASE WHEN isnull((COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22271L > cast(1 as bigint))) THEN false ELSE (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22271L > cast(1 as bigint)) END
                                                                              +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22245 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22266, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22246 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22267, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22247 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22268, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22248 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22269, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22249 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22270, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22271L]
                                                                                 +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22245, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22246, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22247, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22248, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22249, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L]
                                                                                    +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L]
                                                                                       +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, CONST#22157, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L]
                                                                                          +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, CONST#22157, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L]
                                                                                             +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, CONST#22157 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129], [CONST#22157 DESC NULLS LAST]
                                                                                                +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, CONST#22157]
                                                                                                   +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, 1 AS CONST#22157]
                                                                                                      +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22061 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22062 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22063 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22064 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22065 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129]
                                                                                                         +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22061, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22062, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22063, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22064, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22065]
                                                                                                            +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22061, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22062, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22063, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22064, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22065]
                                                                                                               +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22041, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22042, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22043, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22044, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22041 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22061, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22042 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22062, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22043 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22063, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22044 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22064, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22065, 1 AS NULL_1#22086]
                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22023 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22041, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22024 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22042, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22025 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22043, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22026 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22044, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22012 AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045]
                                                                                                                     +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21996 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22023, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21997 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22024, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21998 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22025, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21999 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22026, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22012]
                                                                                                                        +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21996, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21997, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21998, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21999, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21998, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21999), cast( :  as string)) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22012]
                                                                                                                           +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21973 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21996, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21974 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21997, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21975 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21998, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21976 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21999]
                                                                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21973, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21974, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21975, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21976]
                                                                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21923, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953]
                                                                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21923, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21924, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953]
                                                                                                                                       +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21924), false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953]
                                                                                                                                          +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21904 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21905 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21906 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21907 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21923, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21894 AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21924]
                                                                                                                                             +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21873 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21904, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21874 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21905, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21875 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21906, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21876 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21907, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21894]
                                                                                                                                                +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21873, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21874, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21875, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21876, str_split(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21876, cast(- as string)) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21894]
                                                                                                                                                   +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21860 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21873, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21861 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21874, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21862 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21875, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21863 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21876]
                                                                                                                                                      +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21803 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21860, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21804 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21861, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21805 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21862, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21806 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21863]
                                                                                                                                                         +- Filter NOT (str_remove_accent(upper(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21806)) <=> )
                                                                                                                                                            +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21767 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21803, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21768 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21804, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21769 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21805, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21770 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21806]
                                                                                                                                                               +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21555 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21767, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21556 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21768, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21671 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21769, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21714 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21770]
                                                                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21555, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21556, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21671, col1#21630 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21714]
                                                                                                                                                                     +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21555, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21556, col0#21629 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21671, col1#21630]
                                                                                                                                                                        +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21537 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21555, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21538 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21556, col0#21629, col1#21630]
                                                                                                                                                                           +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21539, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21540, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21541, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21542), false, [col0#21629, col1#21630]
                                                                                                                                                                              +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21515 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21537, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21516 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21538, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21517 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21539, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21518 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21540, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21519 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21541, COL_254FB614_FB51_4228_B230_A642F782E3FD#21520 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21542]
                                                                                                                                                                                 +- Project [cast(BASE_BOHRINGER_26561_CODE_26562#21436 as string) AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21515, cast(BASE_BOHRINGER_26561_CLIENT_26563#21435 as string) AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21516, cast(BASE_BOHRINGER_26561_ALCYON_26574#21428 as string) AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21517, cast(BASE_BOHRINGER_26561_CENTRAVET_26575#21429 as string) AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21518, cast(BASE_BOHRINGER_26561_COVETO_26576#21438 as string) AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21519, cast(BASE_BOHRINGER_26561_NEFTYS_26577#21448 as string) AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21520]
                                                                                                                                                                                    +- Project [ADRESSE_26564#21247 AS BASE_BOHRINGER_26561_ADRESSE_26564#21427, ALCYON_26574#21248 AS BASE_BOHRINGER_26561_ALCYON_26574#21428, CENTRAVET_26575#21249 AS BASE_BOHRINGER_26561_CENTRAVET_26575#21429, CF_GLOBAL_AV_26589#21250 AS BASE_BOHRINGER_26561_CF_GLOBAL_AV_26589#21430, CF_GLOBAL_EQ_26585#21251 AS BASE_BOHRINGER_26561_CF_GLOBAL_EQ_26585#21431, CF_GLOBAL_PO_26587#21252 AS BASE_BOHRINGER_26561_CF_GLOBAL_PO_26587#21432, CF_GLOBAL_PV_26581#21253 AS BASE_BOHRINGER_26561_CF_GLOBAL_PV_26581#21433, CF_GLOBAL_RU_26583#21254 AS BASE_BOHRINGER_26561_CF_GLOBAL_RU_26583#21434, CLIENT_26563#21255 AS BASE_BOHRINGER_26561_CLIENT_26563#21435, CODE_26562#21256 AS BASE_BOHRINGER_26561_CODE_26562#21436, CODE_ORDINAL_26573#21257 AS BASE_BOHRINGER_26561_CODE_ORDINAL_26573#21437, COVETO_26576#21258 AS BASE_BOHRINGER_26561_COVETO_26576#21438, CP_26565#21259 AS BASE_BOHRINGER_26561_CP_26565#21439, GIE_AV_22_26588#21260 AS BASE_BOHRINGER_26561_GIE_AV_22_26588#21440, GIE_EQ_22_26584#21261 AS BASE_BOHRINGER_26561_GIE_EQ_22_26584#21441, GIE_MAX_26579#21262 AS BASE_BOHRINGER_26561_GIE_MAX_26579#21442, GIE_PO_22_26586#21263 AS BASE_BOHRINGER_26561_GIE_PO_22_26586#21443, GIE_PV_22_26580#21264 AS BASE_BOHRINGER_26561_GIE_PV_22_26580#21444, GIE_RU_22_26582#21265 AS BASE_BOHRINGER_26561_GIE_RU_22_26582#21445, ID_VETFAMILY_26578#21266 AS BASE_BOHRINGER_26561_ID_VETFAMILY_26578#21446, MAIL_26568#21267 AS BASE_BOHRINGER_26561_MAIL_26568#21447, NEFTYS_26577#21268 AS BASE_BOHRINGER_26561_NEFTYS_26577#21448, SIRET_26572#21269 AS BASE_BOHRINGER_26561_SIRET_26572#21449, STATUT_26570#21270 AS BASE_BOHRINGER_26561_STATUT_26570#21450, ... 4 more fields]
                                                                                                                                                                                       +- SubqueryAlias BASE_BOHRINGER_26561115
                                                                                                                                                                                          +- Relation[ADRESSE_26564#21247,ALCYON_26574#21248,CENTRAVET_26575#21249,CF_GLOBAL_AV_26589#21250,CF_GLOBAL_EQ_26585#21251,CF_GLOBAL_PO_26587#21252,CF_GLOBAL_PV_26581#21253,CF_GLOBAL_RU_26583#21254,CLIENT_26563#21255,CODE_26562#21256,CODE_ORDINAL_26573#21257,COVETO_26576#21258,CP_26565#21259,GIE_AV_22_26588#21260,GIE_EQ_22_26584#21261,GIE_MAX_26579#21262,GIE_PO_22_26586#21263,GIE_PV_22_26580#21264,GIE_RU_22_26582#21265,ID_VETFAMILY_26578#21266,MAIL_26568#21267,NEFTYS_26577#21268,SIRET_26572#21269,STATUT_26570#21270,... 4 more fields] parquet

== Analyzed Logical Plan ==
COL_27B025C8_0688_4168_B098_AC51690C660E: string, COL_42FD4DF1_8363_4A15_AB55_3293650409B5: array<string>, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5: array<string>, COL_26B6810C_DBD7_45A1_9949_04C696BFE445: bigint
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#22548 AS COL_27B025C8_0688_4168_B098_AC51690C660E#22556, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22549 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22557, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22550 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22558, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22551L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22559L]
      +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#22540 AS COL_27B025C8_0688_4168_B098_AC51690C660E#22548, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22541 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22549, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22542 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22550, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22543L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22551L]
         +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#22520 AS COL_27B025C8_0688_4168_B098_AC51690C660E#22540, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22521 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22541, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22522 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22542, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22523L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22543L]
            +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#22520, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22521, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22522, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22523L]
               +- Aggregate [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22510, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22512, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22513, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22511L], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22510 AS COL_27B025C8_0688_4168_B098_AC51690C660E#22520, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22512 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22521, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22513 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22522, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22511L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22523L, 1 AS NULL_1#22530]
                  +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22496 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#22508, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22497 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22509, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22498 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22510, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22499L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22511L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22500 AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22512, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22501 AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22513]
                     +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#22496, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22497, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22498, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22499L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445 AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22500, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482 AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22501]
                        +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482]
                           +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, CONST#22474, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482]
                              +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, CONST#22474, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482]
                                 +- Window [collect_list(COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, CONST#22474 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393], [CONST#22474 DESC NULLS LAST]
                                    +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, CONST#22474]
                                       +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, 1 AS CONST#22474]
                                          +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445]
                                             +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, CONST#22426, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445]
                                                +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, CONST#22426, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445]
                                                   +- Window [collect_list(COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, CONST#22426 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393], [CONST#22426 DESC NULLS LAST]
                                                      +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, CONST#22426]
                                                         +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, 1 AS CONST#22426]
                                                            +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L]
                                                               +- Project [cast(UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22373 as string) AS COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, cast(UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22374 as string) AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, cast(UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#22375 as string) AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, cast(UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22376L as bigint) AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L]
                                                                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22290 AS UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22373, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22291 AS UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22374, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22292 AS UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#22375, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22293L AS UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22376L]
                                                                     +- SubqueryAlias UNITE_CODE_CENT_36755115
                                                                        +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22266 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22290, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22267 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22291, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22270 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22292, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22271L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22293L]
                                                                           +- Filter CASE WHEN isnull((COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22271L > cast(1 as bigint))) THEN false ELSE (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22271L > cast(1 as bigint)) END
                                                                              +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22245 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22266, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22246 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22267, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22247 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22268, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22248 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22269, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22249 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22270, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22271L]
                                                                                 +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22245, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22246, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22247, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22248, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22249, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L]
                                                                                    +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L]
                                                                                       +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, CONST#22157, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L]
                                                                                          +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, CONST#22157, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L]
                                                                                             +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, CONST#22157 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129], [CONST#22157 DESC NULLS LAST]
                                                                                                +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, CONST#22157]
                                                                                                   +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, 1 AS CONST#22157]
                                                                                                      +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22061 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22062 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22063 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22127, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22064 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22128, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22065 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129]
                                                                                                         +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22061, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22062, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22063, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22064, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22065]
                                                                                                            +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22061, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22062, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22063, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22064, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22065]
                                                                                                               +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22041, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22042, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22043, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22044, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22041 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22061, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22042 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22062, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22043 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22063, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22044 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22064, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22065, 1 AS NULL_1#22086]
                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22023 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22041, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22024 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22042, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22025 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22043, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22026 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22044, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22012 AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045]
                                                                                                                     +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21996 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22023, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21997 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22024, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21998 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22025, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21999 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22026, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22012]
                                                                                                                        +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21996, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21997, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21998, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21999, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21998, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21999), cast( :  as string)) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22012]
                                                                                                                           +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21973 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21996, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21974 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21997, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21975 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21998, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21976 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21999]
                                                                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21973, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21974, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21975, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21976]
                                                                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21923, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953]
                                                                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21923, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21924, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953]
                                                                                                                                       +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21924), false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953]
                                                                                                                                          +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21904 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21905 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21906 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21907 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21923, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21894 AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21924]
                                                                                                                                             +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21873 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21904, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21874 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21905, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21875 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21906, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21876 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21907, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21894]
                                                                                                                                                +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21873, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21874, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21875, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21876, str_split(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21876, cast(- as string)) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21894]
                                                                                                                                                   +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21860 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21873, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21861 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21874, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21862 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21875, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21863 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21876]
                                                                                                                                                      +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21803 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21860, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21804 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21861, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21805 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21862, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21806 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21863]
                                                                                                                                                         +- Filter NOT (str_remove_accent(upper(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21806)) <=> )
                                                                                                                                                            +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21767 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21803, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21768 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21804, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21769 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21805, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21770 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21806]
                                                                                                                                                               +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21555 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21767, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21556 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21768, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21671 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21769, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21714 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21770]
                                                                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21555, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21556, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21671, col1#21630 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21714]
                                                                                                                                                                     +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21555, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21556, col0#21629 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21671, col1#21630]
                                                                                                                                                                        +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21537 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21555, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21538 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21556, col0#21629, col1#21630]
                                                                                                                                                                           +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21539, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21540, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21541, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21542), false, [col0#21629, col1#21630]
                                                                                                                                                                              +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21515 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21537, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21516 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21538, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21517 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21539, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21518 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21540, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21519 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21541, COL_254FB614_FB51_4228_B230_A642F782E3FD#21520 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21542]
                                                                                                                                                                                 +- Project [cast(BASE_BOHRINGER_26561_CODE_26562#21436 as string) AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21515, cast(BASE_BOHRINGER_26561_CLIENT_26563#21435 as string) AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21516, cast(BASE_BOHRINGER_26561_ALCYON_26574#21428 as string) AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21517, cast(BASE_BOHRINGER_26561_CENTRAVET_26575#21429 as string) AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21518, cast(BASE_BOHRINGER_26561_COVETO_26576#21438 as string) AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21519, cast(BASE_BOHRINGER_26561_NEFTYS_26577#21448 as string) AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21520]
                                                                                                                                                                                    +- Project [ADRESSE_26564#21247 AS BASE_BOHRINGER_26561_ADRESSE_26564#21427, ALCYON_26574#21248 AS BASE_BOHRINGER_26561_ALCYON_26574#21428, CENTRAVET_26575#21249 AS BASE_BOHRINGER_26561_CENTRAVET_26575#21429, CF_GLOBAL_AV_26589#21250 AS BASE_BOHRINGER_26561_CF_GLOBAL_AV_26589#21430, CF_GLOBAL_EQ_26585#21251 AS BASE_BOHRINGER_26561_CF_GLOBAL_EQ_26585#21431, CF_GLOBAL_PO_26587#21252 AS BASE_BOHRINGER_26561_CF_GLOBAL_PO_26587#21432, CF_GLOBAL_PV_26581#21253 AS BASE_BOHRINGER_26561_CF_GLOBAL_PV_26581#21433, CF_GLOBAL_RU_26583#21254 AS BASE_BOHRINGER_26561_CF_GLOBAL_RU_26583#21434, CLIENT_26563#21255 AS BASE_BOHRINGER_26561_CLIENT_26563#21435, CODE_26562#21256 AS BASE_BOHRINGER_26561_CODE_26562#21436, CODE_ORDINAL_26573#21257 AS BASE_BOHRINGER_26561_CODE_ORDINAL_26573#21437, COVETO_26576#21258 AS BASE_BOHRINGER_26561_COVETO_26576#21438, CP_26565#21259 AS BASE_BOHRINGER_26561_CP_26565#21439, GIE_AV_22_26588#21260 AS BASE_BOHRINGER_26561_GIE_AV_22_26588#21440, GIE_EQ_22_26584#21261 AS BASE_BOHRINGER_26561_GIE_EQ_22_26584#21441, GIE_MAX_26579#21262 AS BASE_BOHRINGER_26561_GIE_MAX_26579#21442, GIE_PO_22_26586#21263 AS BASE_BOHRINGER_26561_GIE_PO_22_26586#21443, GIE_PV_22_26580#21264 AS BASE_BOHRINGER_26561_GIE_PV_22_26580#21444, GIE_RU_22_26582#21265 AS BASE_BOHRINGER_26561_GIE_RU_22_26582#21445, ID_VETFAMILY_26578#21266 AS BASE_BOHRINGER_26561_ID_VETFAMILY_26578#21446, MAIL_26568#21267 AS BASE_BOHRINGER_26561_MAIL_26568#21447, NEFTYS_26577#21268 AS BASE_BOHRINGER_26561_NEFTYS_26577#21448, SIRET_26572#21269 AS BASE_BOHRINGER_26561_SIRET_26572#21449, STATUT_26570#21270 AS BASE_BOHRINGER_26561_STATUT_26570#21450, ... 4 more fields]
                                                                                                                                                                                       +- SubqueryAlias BASE_BOHRINGER_26561115
                                                                                                                                                                                          +- Relation[ADRESSE_26564#21247,ALCYON_26574#21248,CENTRAVET_26575#21249,CF_GLOBAL_AV_26589#21250,CF_GLOBAL_EQ_26585#21251,CF_GLOBAL_PO_26587#21252,CF_GLOBAL_PV_26581#21253,CF_GLOBAL_RU_26583#21254,CLIENT_26563#21255,CODE_26562#21256,CODE_ORDINAL_26573#21257,COVETO_26576#21258,CP_26565#21259,GIE_AV_22_26588#21260,GIE_EQ_22_26584#21261,GIE_MAX_26579#21262,GIE_PO_22_26586#21263,GIE_PV_22_26580#21264,GIE_RU_22_26582#21265,ID_VETFAMILY_26578#21266,MAIL_26568#21267,NEFTYS_26577#21268,SIRET_26572#21269,STATUT_26570#21270,... 4 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Aggregate [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393 AS COL_27B025C8_0688_4168_B098_AC51690C660E#22556, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22557, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22558, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22559L]
      +- Project [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482]
         +- Window [collect_list(COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393], [1 DESC NULLS LAST]
            +- Project [COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445]
               +- Window [collect_list(COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393], [1 DESC NULLS LAST]
                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L]
                     +- Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L > 1)
                        +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, CONST#22157 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129], [CONST#22157 DESC NULLS LAST]
                           +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, 1 AS CONST#22157]
                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953),  : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045]
                                 +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21924), [3], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953]
                                    +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21537 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21538 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, col0#21629 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, str_split(col1#21630, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21924]
                                       +- Filter NOT (str_remove_accent(upper(col1#21630)) <=> )
                                          +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21539, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21540, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21541, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21542), [2, 3, 4, 5], false, [col0#21629, col1#21630]
                                             +- Project [CODE_26562#21256 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21537, CLIENT_26563#21255 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21538, ALCYON_26574#21248 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21539, CENTRAVET_26575#21249 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21540, COVETO_26576#21258 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21541, NEFTYS_26577#21268 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21542]
                                                +- Relation[ADRESSE_26564#21247,ALCYON_26574#21248,CENTRAVET_26575#21249,CF_GLOBAL_AV_26589#21250,CF_GLOBAL_EQ_26585#21251,CF_GLOBAL_PO_26587#21252,CF_GLOBAL_PV_26581#21253,CF_GLOBAL_RU_26583#21254,CLIENT_26563#21255,CODE_26562#21256,CODE_ORDINAL_26573#21257,COVETO_26576#21258,CP_26565#21259,GIE_AV_22_26588#21260,GIE_EQ_22_26584#21261,GIE_MAX_26579#21262,GIE_PO_22_26586#21263,GIE_PV_22_26580#21264,GIE_RU_22_26582#21265,ID_VETFAMILY_26578#21266,MAIL_26568#21267,NEFTYS_26577#21268,SIRET_26572#21269,STATUT_26570#21270,... 4 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(8) HashAggregate(keys=[COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L], functions=[], output=[COL_27B025C8_0688_4168_B098_AC51690C660E#22556, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#22557, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#22558, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#22559L])
      +- *(8) HashAggregate(keys=[COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L], functions=[], output=[COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L])
         +- *(8) Project [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482]
            +- Window [collect_list(COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#22482], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393], [1 DESC NULLS LAST]
               +- *(7) Project [COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445]
                  +- Window [collect_list(COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#22445], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393], [1 DESC NULLS LAST]
                     +- *(6) Sort [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
                        +- *(6) Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#22391, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#22392, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#22393, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#22394L]
                           +- *(6) Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L > 1)
                              +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, CONST#22157 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22179L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129], [CONST#22157 DESC NULLS LAST]
                                 +- *(5) Sort [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129 ASC NULLS FIRST, CONST#22157 DESC NULLS LAST], false, 0
                                    +- CustomShuffleReader coalesced
                                       +- ShuffleQueryStage 1
                                          +- Exchange hashpartitioning(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, 200), true, [id=#2789]
                                             +- *(4) HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045], functions=[], output=[COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22125, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22126, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22129, CONST#22157])
                                                +- CustomShuffleReader coalesced
                                                   +- ShuffleQueryStage 0
                                                      +- Exchange hashpartitioning(COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045, 200), true, [id=#2695]
                                                         +- *(3) HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045], functions=[], output=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045])
                                                            +- *(3) Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953),  : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22045]
                                                               +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21924), [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21953]
                                                                  +- *(2) Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21537 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21920, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21538 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21921, col0#21629 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21922, str_split(col1#21630, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21924]
                                                                     +- *(2) Filter NOT (str_remove_accent(upper(col1#21630)) <=> )
                                                                        +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21539, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21540, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21541, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21542), [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21537, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21538], false, [col0#21629, col1#21630]
                                                                           +- *(1) Project [CODE_26562#21256 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21537, CLIENT_26563#21255 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21538, ALCYON_26574#21248 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21539, CENTRAVET_26575#21249 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21540, COVETO_26576#21258 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21541, NEFTYS_26577#21268 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21542]
                                                                              +- *(1) ColumnarToRow
                                                                                 +- FileScan parquet [ALCYON_26574#21248,CENTRAVET_26575#21249,CLIENT_26563#21255,CODE_26562#21256,COVETO_26576#21258,NEFTYS_26577#21268] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/uet/BASE_BOHRINGER_26561], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ALCYON_26574:string,CENTRAVET_26575:string,CLIENT_26563:string,CODE_26562:string,COVETO_26...