DC2 - Details for Query 33

Details for Query 33

Submitted Time: 2026/03/05 07:13:37
Duration: 3 s
Succeeded Jobs: 46 49 52 58 59

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))\n72 ms (2 ms, 4 ms, 21 ms (stage 77.0: task 220))"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 34 ms (1 ms, 2 ms, 11 ms (stage 99.0: task 244)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 102.0: task 254)) number of output rows: 46 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 102.0: task 254))"]; 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 102.0: task 254)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 102.0: task 254)) number of output rows: 46 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 102.0: task 254))"]; 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))\n144 ms (4 ms, 8 ms, 50 ms (stage 77.0: task 220))"; 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))\n355 ms (6 ms, 22 ms, 126 ms (stage 77.0: task 220))"; 11 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 102.0: task 254)) peak memory total (min, med, max (stageId: taskId)) 832.8 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 102.0: task 254)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 102.0: task 254))"]; 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))\n522 ms (10 ms, 27 ms, 227 ms (stage 77.0: task 220))"; 16 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 89 ms (1 ms, 6 ms, 18 ms (stage 102.0: task 251)) peak memory total (min, med, max (stageId: taskId)) 832.8 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 102.0: task 254)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 102.0: task 254))"]; } 17 [labelType="html" label=" CustomShuffleReader "]; 18 [labelType="html" label="Exchange shuffle records written: 14,814 shuffle write time total (min, med, max (stageId: taskId)) 2.1 s (34 ms, 157 ms, 253 ms (stage 69.0: task 185)) 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 99.0: task 246)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 102.0: task 254)) 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 69.0: task 198)) 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 69.0: task 198))"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n576 ms (22 ms, 48 ms, 68 ms (stage 69.0: task 183))"; 20 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 80 ms (3 ms, 4 ms, 17 ms (stage 69.0: task 204)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 69.0: task 182)) number of output rows: 14,814 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 69.0: task 182))"]; } 21 [labelType="html" label=" CustomShuffleReader "]; 22 [labelType="html" label="Exchange shuffle records written: 14,814 shuffle write time total (min, med, max (stageId: taskId)) 2.3 s (19 ms, 212 ms, 323 ms (stage 64.0: task 149)) 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 69.0: task 198)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 69.0: task 182)) 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 64.0: task 145)) 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 64.0: task 145))"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.1 s (24 ms, 93 ms, 187 ms (stage 64.0: task 145))"; 24 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 573 ms (14 ms, 40 ms, 124 ms (stage 64.0: task 145)) peak memory total (min, med, max (stageId: taskId)) 771.0 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 64.0: task 145)) number of output rows: 14,814 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 64.0: task 145))"]; 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))\n631 ms (17 ms, 44 ms, 128 ms (stage 64.0: task 145))"; 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))\n646 ms (18 ms, 45 ms, 129 ms (stage 64.0: task 145))"; 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)) 96 ms (4 ms, 6 ms, 20 ms (stage 64.0: task 152)) 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#5669, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L], functions=[])

Project [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722]

WholeStageCodegen (8)

Window [collect_list(COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669], [1 DESC NULLS LAST]

Project [COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701]

WholeStageCodegen (7)

Window [collect_list(COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669], [1 DESC NULLS LAST]

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

Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L]

Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L > 1)

WholeStageCodegen (6)

Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, CONST#5515 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499], [CONST#5515 DESC NULLS LAST]

Sort [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499 ASC NULLS FIRST, CONST#5515 DESC NULLS LAST], false, 0

WholeStageCodegen (5)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, 200), true, [id=#1340]

HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412], functions=[])

WholeStageCodegen (4)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412, 200), true, [id=#1178]

Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308), : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412]

WholeStageCodegen (3)

Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5300), [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308]

Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5040 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_A7246A72_2676_467D_80BD_2A058C09CA95#5041 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, col0#5088 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, str_split(col1#5089, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5300]

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

WholeStageCodegen (2)

Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5042, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5043, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#5044, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#5045), [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5040, COL_A7246A72_2676_467D_80BD_2A058C09CA95#5041], false, [col0#5088, col1#5089]

Project [CODE_26562#4698 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5040, CLIENT_26563#4697 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#5041, ALCYON_26574#4690 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5042, CENTRAVET_26575#4691 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5043, COVETO_26576#4700 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#5044, NEFTYS_26577#4710 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#5045]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ALCYON_26574#4690,CENTRAVET_26575#4691,CLIENT_26563#4697,CODE_26562#4698,COVETO_26576#4700,NEFTYS_26577#4710] 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#5788 AS COL_27B025C8_0688_4168_B098_AC51690C660E#5796, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5789 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5797, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5790 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5798, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5791L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5799L]
      +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#5780 AS COL_27B025C8_0688_4168_B098_AC51690C660E#5788, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5781 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5789, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5782 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5790, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5783L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5791L]
         +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#5760 AS COL_27B025C8_0688_4168_B098_AC51690C660E#5780, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5761 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5781, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5762 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5782, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5763L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5783L]
            +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#5760, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5761, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5762, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5763L]
               +- Aggregate [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5750, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5752, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5753, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5751L], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5750 AS COL_27B025C8_0688_4168_B098_AC51690C660E#5760, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5752 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5761, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5753 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5762, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5751L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5763L, 1 AS NULL_1#5770]
                  +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5736 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#5748, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5737 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5749, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5738 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5750, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5739L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5751L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5740 AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5752, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5741 AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5753]
                     +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#5736, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5737, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5738, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5739L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701 AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5740, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722 AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5741]
                        +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722]
                           +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, CONST#5714, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722]
                              +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, CONST#5714, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722]
                                 +- Window [collect_list(COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, CONST#5714 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669], [CONST#5714 DESC NULLS LAST]
                                    +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, CONST#5714]
                                       +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, 1 AS CONST#5714]
                                          +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701]
                                             +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, CONST#5688, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701]
                                                +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, CONST#5688, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701]
                                                   +- Window [collect_list(COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, CONST#5688 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669], [CONST#5688 DESC NULLS LAST]
                                                      +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, CONST#5688]
                                                         +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, 1 AS CONST#5688]
                                                            +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L]
                                                               +- Project [cast(UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5647 as string) AS COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, cast(UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5648 as string) AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, cast(UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#5649 as string) AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, cast(UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5650L as bigint) AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L]
                                                                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5615 AS UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5647, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5616 AS UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5648, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5617 AS UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#5649, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5618L AS UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5650L]
                                                                     +- SubqueryAlias UNITE_CODE_CENT_36755114
                                                                        +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5577 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5615, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5578 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5616, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5581 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5617, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5582L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5618L]
                                                                           +- Filter CASE WHEN isnull((COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5582L > cast(1 as bigint))) THEN false ELSE (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5582L > cast(1 as bigint)) END
                                                                              +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5562 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5577, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5563 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5578, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5564 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5579, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5565 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5580, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5566 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5581, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5582L]
                                                                                 +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5562, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5563, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5564, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5565, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5566, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L]
                                                                                    +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L]
                                                                                       +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, CONST#5515, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L]
                                                                                          +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, CONST#5515, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L]
                                                                                             +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, CONST#5515 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499], [CONST#5515 DESC NULLS LAST]
                                                                                                +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, CONST#5515]
                                                                                                   +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, 1 AS CONST#5515]
                                                                                                      +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5429 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5430 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5431 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5432 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5433 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499]
                                                                                                         +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5429, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5430, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5431, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5432, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5433]
                                                                                                            +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5429, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5430, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5431, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5432, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5433]
                                                                                                               +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5408, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5409, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5410, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5411, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5408 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5429, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5409 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5430, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5410 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5431, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5411 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5432, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5433, 1 AS NULL_1#5445]
                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5387 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5408, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5388 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5409, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5389 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5410, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5390 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5411, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5371 AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412]
                                                                                                                     +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5349 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5387, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5350 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5388, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5351 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5389, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5352 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5390, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5371]
                                                                                                                        +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5349, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5350, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5351, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5352, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5351, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5352), cast( :  as string)) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5371]
                                                                                                                           +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5336 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5349, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5337 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5350, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5338 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5351, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5339 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5352]
                                                                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5336, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5337, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5338, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5339]
                                                                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5299, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308]
                                                                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5299, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5300, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308]
                                                                                                                                       +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5300), false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308]
                                                                                                                                          +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5272 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5273 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5274 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5275 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5299, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5252 AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5300]
                                                                                                                                             +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5231 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5272, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5232 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5273, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5233 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5274, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5234 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5275, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5252]
                                                                                                                                                +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5231, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5232, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5233, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5234, str_split(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5234, cast(- as string)) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5252]
                                                                                                                                                   +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5222 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5231, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5223 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5232, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5224 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5233, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5225 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5234]
                                                                                                                                                      +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5186 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5222, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5187 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5223, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5188 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5224, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5189 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5225]
                                                                                                                                                         +- Filter NOT (str_remove_accent(upper(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5189)) <=> )
                                                                                                                                                            +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5166 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5186, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5167 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5187, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5168 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5188, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5169 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5189]
                                                                                                                                                               +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5052 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5166, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5053 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5167, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5116 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5168, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5122 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5169]
                                                                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5052, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5053, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5116, col1#5089 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5122]
                                                                                                                                                                     +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5052, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5053, col0#5088 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5116, col1#5089]
                                                                                                                                                                        +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5040 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5052, COL_A7246A72_2676_467D_80BD_2A058C09CA95#5041 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5053, col0#5088, col1#5089]
                                                                                                                                                                           +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5042, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5043, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#5044, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#5045), false, [col0#5088, col1#5089]
                                                                                                                                                                              +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5028 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5040, COL_A7246A72_2676_467D_80BD_2A058C09CA95#5029 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#5041, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5030 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5042, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5031 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5043, COL_849E3089_5C66_4628_8089_C7A14A3915D9#5032 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#5044, COL_254FB614_FB51_4228_B230_A642F782E3FD#5033 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#5045]
                                                                                                                                                                                 +- Project [cast(BASE_BOHRINGER_26561_CODE_26562#4963 as string) AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5028, cast(BASE_BOHRINGER_26561_CLIENT_26563#4962 as string) AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#5029, cast(BASE_BOHRINGER_26561_ALCYON_26574#4955 as string) AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5030, cast(BASE_BOHRINGER_26561_CENTRAVET_26575#4956 as string) AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5031, cast(BASE_BOHRINGER_26561_COVETO_26576#4965 as string) AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#5032, cast(BASE_BOHRINGER_26561_NEFTYS_26577#4975 as string) AS COL_254FB614_FB51_4228_B230_A642F782E3FD#5033]
                                                                                                                                                                                    +- Project [ADRESSE_26564#4689 AS BASE_BOHRINGER_26561_ADRESSE_26564#4954, ALCYON_26574#4690 AS BASE_BOHRINGER_26561_ALCYON_26574#4955, CENTRAVET_26575#4691 AS BASE_BOHRINGER_26561_CENTRAVET_26575#4956, CF_GLOBAL_AV_26589#4692 AS BASE_BOHRINGER_26561_CF_GLOBAL_AV_26589#4957, CF_GLOBAL_EQ_26585#4693 AS BASE_BOHRINGER_26561_CF_GLOBAL_EQ_26585#4958, CF_GLOBAL_PO_26587#4694 AS BASE_BOHRINGER_26561_CF_GLOBAL_PO_26587#4959, CF_GLOBAL_PV_26581#4695 AS BASE_BOHRINGER_26561_CF_GLOBAL_PV_26581#4960, CF_GLOBAL_RU_26583#4696 AS BASE_BOHRINGER_26561_CF_GLOBAL_RU_26583#4961, CLIENT_26563#4697 AS BASE_BOHRINGER_26561_CLIENT_26563#4962, CODE_26562#4698 AS BASE_BOHRINGER_26561_CODE_26562#4963, CODE_ORDINAL_26573#4699 AS BASE_BOHRINGER_26561_CODE_ORDINAL_26573#4964, COVETO_26576#4700 AS BASE_BOHRINGER_26561_COVETO_26576#4965, CP_26565#4701 AS BASE_BOHRINGER_26561_CP_26565#4966, GIE_AV_22_26588#4702 AS BASE_BOHRINGER_26561_GIE_AV_22_26588#4967, GIE_EQ_22_26584#4703 AS BASE_BOHRINGER_26561_GIE_EQ_22_26584#4968, GIE_MAX_26579#4704 AS BASE_BOHRINGER_26561_GIE_MAX_26579#4969, GIE_PO_22_26586#4705 AS BASE_BOHRINGER_26561_GIE_PO_22_26586#4970, GIE_PV_22_26580#4706 AS BASE_BOHRINGER_26561_GIE_PV_22_26580#4971, GIE_RU_22_26582#4707 AS BASE_BOHRINGER_26561_GIE_RU_22_26582#4972, ID_VETFAMILY_26578#4708 AS BASE_BOHRINGER_26561_ID_VETFAMILY_26578#4973, MAIL_26568#4709 AS BASE_BOHRINGER_26561_MAIL_26568#4974, NEFTYS_26577#4710 AS BASE_BOHRINGER_26561_NEFTYS_26577#4975, SIRET_26572#4711 AS BASE_BOHRINGER_26561_SIRET_26572#4976, STATUT_26570#4712 AS BASE_BOHRINGER_26561_STATUT_26570#4977, ... 4 more fields]
                                                                                                                                                                                       +- SubqueryAlias BASE_BOHRINGER_26561114
                                                                                                                                                                                          +- Relation[ADRESSE_26564#4689,ALCYON_26574#4690,CENTRAVET_26575#4691,CF_GLOBAL_AV_26589#4692,CF_GLOBAL_EQ_26585#4693,CF_GLOBAL_PO_26587#4694,CF_GLOBAL_PV_26581#4695,CF_GLOBAL_RU_26583#4696,CLIENT_26563#4697,CODE_26562#4698,CODE_ORDINAL_26573#4699,COVETO_26576#4700,CP_26565#4701,GIE_AV_22_26588#4702,GIE_EQ_22_26584#4703,GIE_MAX_26579#4704,GIE_PO_22_26586#4705,GIE_PV_22_26580#4706,GIE_RU_22_26582#4707,ID_VETFAMILY_26578#4708,MAIL_26568#4709,NEFTYS_26577#4710,SIRET_26572#4711,STATUT_26570#4712,... 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#5788 AS COL_27B025C8_0688_4168_B098_AC51690C660E#5796, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5789 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5797, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5790 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5798, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5791L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5799L]
      +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#5780 AS COL_27B025C8_0688_4168_B098_AC51690C660E#5788, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5781 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5789, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5782 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5790, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5783L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5791L]
         +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#5760 AS COL_27B025C8_0688_4168_B098_AC51690C660E#5780, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5761 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5781, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5762 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5782, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5763L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5783L]
            +- Project [COL_27B025C8_0688_4168_B098_AC51690C660E#5760, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5761, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5762, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5763L]
               +- Aggregate [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5750, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5752, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5753, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5751L], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5750 AS COL_27B025C8_0688_4168_B098_AC51690C660E#5760, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5752 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5761, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5753 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5762, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5751L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5763L, 1 AS NULL_1#5770]
                  +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5736 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#5748, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5737 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5749, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5738 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5750, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5739L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5751L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5740 AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5752, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5741 AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5753]
                     +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#5736, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5737, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5738, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5739L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701 AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5740, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722 AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5741]
                        +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722]
                           +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, CONST#5714, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722]
                              +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, CONST#5714, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722]
                                 +- Window [collect_list(COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, CONST#5714 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669], [CONST#5714 DESC NULLS LAST]
                                    +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, CONST#5714]
                                       +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, 1 AS CONST#5714]
                                          +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701]
                                             +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, CONST#5688, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701]
                                                +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, CONST#5688, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701]
                                                   +- Window [collect_list(COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, CONST#5688 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669], [CONST#5688 DESC NULLS LAST]
                                                      +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, CONST#5688]
                                                         +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, 1 AS CONST#5688]
                                                            +- Project [COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L]
                                                               +- Project [cast(UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5647 as string) AS COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, cast(UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5648 as string) AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, cast(UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#5649 as string) AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, cast(UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5650L as bigint) AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L]
                                                                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5615 AS UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5647, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5616 AS UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5648, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5617 AS UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#5649, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5618L AS UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5650L]
                                                                     +- SubqueryAlias UNITE_CODE_CENT_36755114
                                                                        +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5577 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5615, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5578 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5616, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5581 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5617, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5582L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5618L]
                                                                           +- Filter CASE WHEN isnull((COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5582L > cast(1 as bigint))) THEN false ELSE (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5582L > cast(1 as bigint)) END
                                                                              +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5562 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5577, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5563 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5578, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5564 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5579, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5565 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5580, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5566 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5581, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5582L]
                                                                                 +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5562, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5563, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5564, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5565, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5566, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L]
                                                                                    +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L]
                                                                                       +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, CONST#5515, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L]
                                                                                          +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, CONST#5515, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L]
                                                                                             +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, CONST#5515 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499], [CONST#5515 DESC NULLS LAST]
                                                                                                +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, CONST#5515]
                                                                                                   +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, 1 AS CONST#5515]
                                                                                                      +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5429 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5430 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5431 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5493, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5432 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5498, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5433 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499]
                                                                                                         +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5429, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5430, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5431, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5432, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5433]
                                                                                                            +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5429, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5430, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5431, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5432, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5433]
                                                                                                               +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5408, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5409, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5410, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5411, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5408 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5429, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5409 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5430, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5410 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5431, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5411 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5432, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5433, 1 AS NULL_1#5445]
                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5387 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5408, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5388 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5409, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5389 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5410, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5390 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5411, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5371 AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412]
                                                                                                                     +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5349 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5387, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5350 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5388, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5351 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5389, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5352 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5390, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5371]
                                                                                                                        +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5349, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5350, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5351, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5352, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5351, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5352), cast( :  as string)) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5371]
                                                                                                                           +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5336 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5349, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5337 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5350, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5338 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5351, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5339 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5352]
                                                                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5336, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5337, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5338, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5339]
                                                                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5299, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308]
                                                                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5299, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5300, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308]
                                                                                                                                       +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5300), false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308]
                                                                                                                                          +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5272 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5273 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5274 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5275 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5299, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5252 AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5300]
                                                                                                                                             +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5231 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5272, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5232 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5273, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5233 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5274, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5234 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5275, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5252]
                                                                                                                                                +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5231, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5232, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5233, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5234, str_split(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5234, cast(- as string)) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5252]
                                                                                                                                                   +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5222 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5231, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5223 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5232, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5224 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5233, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5225 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5234]
                                                                                                                                                      +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5186 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5222, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5187 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5223, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5188 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5224, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5189 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5225]
                                                                                                                                                         +- Filter NOT (str_remove_accent(upper(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5189)) <=> )
                                                                                                                                                            +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5166 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5186, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5167 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5187, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5168 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5188, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5169 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5189]
                                                                                                                                                               +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5052 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5166, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5053 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5167, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5116 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5168, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5122 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5169]
                                                                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5052, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5053, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5116, col1#5089 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5122]
                                                                                                                                                                     +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5052, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5053, col0#5088 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5116, col1#5089]
                                                                                                                                                                        +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5040 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5052, COL_A7246A72_2676_467D_80BD_2A058C09CA95#5041 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5053, col0#5088, col1#5089]
                                                                                                                                                                           +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5042, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5043, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#5044, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#5045), false, [col0#5088, col1#5089]
                                                                                                                                                                              +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5028 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5040, COL_A7246A72_2676_467D_80BD_2A058C09CA95#5029 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#5041, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5030 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5042, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5031 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5043, COL_849E3089_5C66_4628_8089_C7A14A3915D9#5032 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#5044, COL_254FB614_FB51_4228_B230_A642F782E3FD#5033 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#5045]
                                                                                                                                                                                 +- Project [cast(BASE_BOHRINGER_26561_CODE_26562#4963 as string) AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5028, cast(BASE_BOHRINGER_26561_CLIENT_26563#4962 as string) AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#5029, cast(BASE_BOHRINGER_26561_ALCYON_26574#4955 as string) AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5030, cast(BASE_BOHRINGER_26561_CENTRAVET_26575#4956 as string) AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5031, cast(BASE_BOHRINGER_26561_COVETO_26576#4965 as string) AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#5032, cast(BASE_BOHRINGER_26561_NEFTYS_26577#4975 as string) AS COL_254FB614_FB51_4228_B230_A642F782E3FD#5033]
                                                                                                                                                                                    +- Project [ADRESSE_26564#4689 AS BASE_BOHRINGER_26561_ADRESSE_26564#4954, ALCYON_26574#4690 AS BASE_BOHRINGER_26561_ALCYON_26574#4955, CENTRAVET_26575#4691 AS BASE_BOHRINGER_26561_CENTRAVET_26575#4956, CF_GLOBAL_AV_26589#4692 AS BASE_BOHRINGER_26561_CF_GLOBAL_AV_26589#4957, CF_GLOBAL_EQ_26585#4693 AS BASE_BOHRINGER_26561_CF_GLOBAL_EQ_26585#4958, CF_GLOBAL_PO_26587#4694 AS BASE_BOHRINGER_26561_CF_GLOBAL_PO_26587#4959, CF_GLOBAL_PV_26581#4695 AS BASE_BOHRINGER_26561_CF_GLOBAL_PV_26581#4960, CF_GLOBAL_RU_26583#4696 AS BASE_BOHRINGER_26561_CF_GLOBAL_RU_26583#4961, CLIENT_26563#4697 AS BASE_BOHRINGER_26561_CLIENT_26563#4962, CODE_26562#4698 AS BASE_BOHRINGER_26561_CODE_26562#4963, CODE_ORDINAL_26573#4699 AS BASE_BOHRINGER_26561_CODE_ORDINAL_26573#4964, COVETO_26576#4700 AS BASE_BOHRINGER_26561_COVETO_26576#4965, CP_26565#4701 AS BASE_BOHRINGER_26561_CP_26565#4966, GIE_AV_22_26588#4702 AS BASE_BOHRINGER_26561_GIE_AV_22_26588#4967, GIE_EQ_22_26584#4703 AS BASE_BOHRINGER_26561_GIE_EQ_22_26584#4968, GIE_MAX_26579#4704 AS BASE_BOHRINGER_26561_GIE_MAX_26579#4969, GIE_PO_22_26586#4705 AS BASE_BOHRINGER_26561_GIE_PO_22_26586#4970, GIE_PV_22_26580#4706 AS BASE_BOHRINGER_26561_GIE_PV_22_26580#4971, GIE_RU_22_26582#4707 AS BASE_BOHRINGER_26561_GIE_RU_22_26582#4972, ID_VETFAMILY_26578#4708 AS BASE_BOHRINGER_26561_ID_VETFAMILY_26578#4973, MAIL_26568#4709 AS BASE_BOHRINGER_26561_MAIL_26568#4974, NEFTYS_26577#4710 AS BASE_BOHRINGER_26561_NEFTYS_26577#4975, SIRET_26572#4711 AS BASE_BOHRINGER_26561_SIRET_26572#4976, STATUT_26570#4712 AS BASE_BOHRINGER_26561_STATUT_26570#4977, ... 4 more fields]
                                                                                                                                                                                       +- SubqueryAlias BASE_BOHRINGER_26561114
                                                                                                                                                                                          +- Relation[ADRESSE_26564#4689,ALCYON_26574#4690,CENTRAVET_26575#4691,CF_GLOBAL_AV_26589#4692,CF_GLOBAL_EQ_26585#4693,CF_GLOBAL_PO_26587#4694,CF_GLOBAL_PV_26581#4695,CF_GLOBAL_RU_26583#4696,CLIENT_26563#4697,CODE_26562#4698,CODE_ORDINAL_26573#4699,COVETO_26576#4700,CP_26565#4701,GIE_AV_22_26588#4702,GIE_EQ_22_26584#4703,GIE_MAX_26579#4704,GIE_PO_22_26586#4705,GIE_PV_22_26580#4706,GIE_RU_22_26582#4707,ID_VETFAMILY_26578#4708,MAIL_26568#4709,NEFTYS_26577#4710,SIRET_26572#4711,STATUT_26570#4712,... 4 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Aggregate [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669 AS COL_27B025C8_0688_4168_B098_AC51690C660E#5796, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701 AS COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5797, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722 AS COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5798, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L AS COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5799L]
      +- Project [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722]
         +- Window [collect_list(COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669], [1 DESC NULLS LAST]
            +- Project [COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701]
               +- Window [collect_list(COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669], [1 DESC NULLS LAST]
                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L]
                     +- Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L > 1)
                        +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, CONST#5515 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499], [CONST#5515 DESC NULLS LAST]
                           +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, 1 AS CONST#5515]
                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308),  : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412]
                                 +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5300), [3], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308]
                                    +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5040 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_A7246A72_2676_467D_80BD_2A058C09CA95#5041 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, col0#5088 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, str_split(col1#5089, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5300]
                                       +- Filter NOT (str_remove_accent(upper(col1#5089)) <=> )
                                          +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5042, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5043, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#5044, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#5045), [2, 3, 4, 5], false, [col0#5088, col1#5089]
                                             +- Project [CODE_26562#4698 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5040, CLIENT_26563#4697 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#5041, ALCYON_26574#4690 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5042, CENTRAVET_26575#4691 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5043, COVETO_26576#4700 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#5044, NEFTYS_26577#4710 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#5045]
                                                +- Relation[ADRESSE_26564#4689,ALCYON_26574#4690,CENTRAVET_26575#4691,CF_GLOBAL_AV_26589#4692,CF_GLOBAL_EQ_26585#4693,CF_GLOBAL_PO_26587#4694,CF_GLOBAL_PV_26581#4695,CF_GLOBAL_RU_26583#4696,CLIENT_26563#4697,CODE_26562#4698,CODE_ORDINAL_26573#4699,COVETO_26576#4700,CP_26565#4701,GIE_AV_22_26588#4702,GIE_EQ_22_26584#4703,GIE_MAX_26579#4704,GIE_PO_22_26586#4705,GIE_PV_22_26580#4706,GIE_RU_22_26582#4707,ID_VETFAMILY_26578#4708,MAIL_26568#4709,NEFTYS_26577#4710,SIRET_26572#4711,STATUT_26570#4712,... 4 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(8) HashAggregate(keys=[COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L], functions=[], output=[COL_27B025C8_0688_4168_B098_AC51690C660E#5796, COL_42FD4DF1_8363_4A15_AB55_3293650409B5#5797, COL_2B25E587_69E0_4FCA_ACAC_90C186C272E5#5798, COL_26B6810C_DBD7_45A1_9949_04C696BFE445#5799L])
      +- *(8) HashAggregate(keys=[COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L], functions=[], output=[COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L])
         +- *(8) Project [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701, COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722]
            +- Window [collect_list(COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A8DCAEAB_A2F9_444D_9D11_AB584A73799B#5722], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669], [1 DESC NULLS LAST]
               +- *(7) Project [COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L, COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701]
                  +- Window [collect_list(COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, 0, 0) windowspecdefinition(COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_341CC7D2_611B_4D18_82ED_6DB86B530CF2#5701], [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669], [1 DESC NULLS LAST]
                     +- *(6) Sort [COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
                        +- *(6) Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490 AS COL_1473609E_D46C_49FE_84BC_E590552DB625#5667, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491 AS COL_ABF6F9E0_A78F_4264_96AB_1DCAD1750171#5668, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499 AS COL_2FBE66F5_4F75_4551_90EA_39A37B242F81#5669, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L AS COL_4719DD4F_CE35_4D27_BF22_EECCAC813907#5670L]
                           +- *(6) Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L > 1)
                              +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, CONST#5515 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5529L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499], [CONST#5515 DESC NULLS LAST]
                                 +- *(5) Sort [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499 ASC NULLS FIRST, CONST#5515 DESC NULLS LAST], false, 0
                                    +- CustomShuffleReader coalesced
                                       +- ShuffleQueryStage 1
                                          +- Exchange hashpartitioning(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, 200), true, [id=#1340]
                                             +- *(4) HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412], functions=[], output=[COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5490, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5491, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5499, CONST#5515])
                                                +- CustomShuffleReader coalesced
                                                   +- ShuffleQueryStage 0
                                                      +- Exchange hashpartitioning(COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412, 200), true, [id=#1178]
                                                         +- *(3) HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412], functions=[], output=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412])
                                                            +- *(3) Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308),  : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5412]
                                                               +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5300), [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5308]
                                                                  +- *(2) Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5040 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5296, COL_A7246A72_2676_467D_80BD_2A058C09CA95#5041 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5297, col0#5088 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5298, str_split(col1#5089, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5300]
                                                                     +- *(2) Filter NOT (str_remove_accent(upper(col1#5089)) <=> )
                                                                        +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5042, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5043, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#5044, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#5045), [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5040, COL_A7246A72_2676_467D_80BD_2A058C09CA95#5041], false, [col0#5088, col1#5089]
                                                                           +- *(1) Project [CODE_26562#4698 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#5040, CLIENT_26563#4697 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#5041, ALCYON_26574#4690 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#5042, CENTRAVET_26575#4691 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#5043, COVETO_26576#4700 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#5044, NEFTYS_26577#4710 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#5045]
                                                                              +- *(1) ColumnarToRow
                                                                                 +- FileScan parquet [ALCYON_26574#4690,CENTRAVET_26575#4691,CLIENT_26563#4697,CODE_26562#4698,COVETO_26576#4700,NEFTYS_26577#4710] 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...