DC2 - Details for Query 32

Details for Query 32

Submitted Time: 2026/03/05 07:13:37
Duration: 3 s
Succeeded Jobs: 45 48 51 54 55

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 (7)\n \nduration: total (min, med, max (stageId: taskId))\n4 ms (1 ms, 1 ms, 2 ms (stage 88.0: task 236))"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 1 ms (0 ms, 0 ms, 1 ms (stage 88.0: task 236)) peak memory total (min, med, max (stageId: taskId)) 128.8 MiB (256.0 KiB, 64.3 MiB, 64.3 MiB (stage 88.0: task 237)) number of output rows: 2 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 88.0: task 237))"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 14 shuffle write time total (min, med, max (stageId: taskId)) 127 ms (2 ms, 4 ms, 25 ms (stage 74.0: task 213)) records read: 14 local bytes read total (min, med, max (stageId: taskId)) 876.0 B (60.0 B, 816.0 B, 816.0 B (stage 88.0: task 236)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 88.0: task 237)) remote bytes read: 0.0 B local blocks read: 14 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 336.0 B (24.0 B, 24.0 B, 48.0 B (stage 74.0: task 219)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 876.0 B (60.0 B, 63.0 B, 123.0 B (stage 74.0: task 219))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n2.6 s (20 ms, 225 ms, 248 ms (stage 74.0: task 218))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 868 ms (3 ms, 91 ms, 123 ms (stage 74.0: task 219)) peak memory total (min, med, max (stageId: taskId)) 3.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 74.0: task 208)) number of output rows: 14 avg hash probe bucket list iters: 0"]; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 94"]; } 10 [labelType="html" label=" Window "]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n4.2 s (13 ms, 311 ms, 497 ms (stage 74.0: task 205))"; 12 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 524 ms (0 ms, 45 ms, 77 ms (stage 74.0: task 205)) peak memory total (min, med, max (stageId: taskId)) 832.8 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 74.0: task 208)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 74.0: task 208))"]; } 13 [labelType="html" label=" CustomShuffleReader "]; 14 [labelType="html" label="Exchange shuffle records written: 14,814 shuffle write time total (min, med, max (stageId: taskId)) 2.4 s (103 ms, 171 ms, 264 ms (stage 67.0: task 175)) records read: 14,814 local bytes read total (min, med, max (stageId: taskId)) 620.2 KiB (19.0 KiB, 49.7 KiB, 51.6 KiB (stage 74.0: task 206)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 74.0: task 208)) remote bytes read: 0.0 B local blocks read: 169 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 965.8 KiB (29.9 KiB, 77.5 KiB, 80.2 KiB (stage 67.0: task 178)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 620.2 KiB (27.4 KiB, 49.2 KiB, 50.1 KiB (stage 67.0: task 178))"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n479 ms (19 ms, 26 ms, 83 ms (stage 67.0: task 161))"; 16 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 46 ms (1 ms, 3 ms, 6 ms (stage 67.0: task 163)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 67.0: task 165)) number of output rows: 14,814 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 67.0: task 165))"]; } 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.2 s (14 ms, 152 ms, 377 ms (stage 63.0: task 134)) 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 67.0: task 178)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 67.0: task 165)) 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 63.0: task 133)) 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 63.0: task 133))"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n5.4 s (307 ms, 508 ms, 542 ms (stage 63.0: task 134))"; 20 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 4.0 s (268 ms, 337 ms, 412 ms (stage 63.0: task 133)) peak memory total (min, med, max (stageId: taskId)) 771.0 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 63.0: task 144)) number of output rows: 14,814 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 63.0: task 144))"]; 21 [labelType="html" label=" Project "]; } 22 [labelType="html" label="Generate number of output rows: 19,130"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n4.6 s (315 ms, 384 ms, 459 ms (stage 63.0: task 133))"; 24 [labelType="html" label=" Project "]; 25 [labelType="html" label="Filter number of output rows: 14,912"]; } 26 [labelType="html" label="Generate number of output rows: 182,224"]; subgraph cluster27 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n4.9 s (346 ms, 415 ms, 490 ms (stage 63.0: task 133))"; 28 [labelType="html" label=" Project "]; 29 [labelType="html" label="ColumnarToRow number of output rows: 45,556 number of input batches: 12"]; } 30 [labelType="html" label="Scan parquet number of files read: 12 scan time total (min, med, max (stageId: taskId)) 167 ms (6 ms, 13 ms, 26 ms (stage 63.0: task 137)) 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; 7->5; 8->7; 9->8; 10->9; 12->10; 13->12; 14->13; 16->14; 17->16; 18->17; 20->18; 21->20; 22->21; 24->22; 25->24; 26->25; 28->26; 29->28; 30->29; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

HashAggregate(keys=[COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L], functions=[count(1)])

WholeStageCodegen (7)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L, 200), true, [id=#1489]

HashAggregate(keys=[COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L], functions=[partial_count(1)])

Project [COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L]

Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L > 1)

WholeStageCodegen (6)

Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, CONST#5359 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344], [CONST#5359 DESC NULLS LAST]

Sort [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344 ASC NULLS FIRST, CONST#5359 DESC NULLS LAST], false, 0

WholeStageCodegen (5)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, 200), true, [id=#1268]

HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262], functions=[])

WholeStageCodegen (4)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262, 200), true, [id=#986]

Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190), : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262]

WholeStageCodegen (3)

Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5157), [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190]

Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4873 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4874 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, col0#4888 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, str_split(col1#4889, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5157]

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

WholeStageCodegen (2)

Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4875, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4876, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4877, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#4878), [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4873, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4874], false, [col0#4888, col1#4889]

Project [CODE_26562#4578 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4873, CLIENT_26563#4577 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4874, ALCYON_26574#4570 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4875, CENTRAVET_26575#4571 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4876, COVETO_26576#4580 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4877, NEFTYS_26577#4590 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4878]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ALCYON_26574#4570,CENTRAVET_26575#4571,CLIENT_26563#4577,CODE_26562#4578,COVETO_26576#4580,NEFTYS_26577#4590] 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_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5681L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5691L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5682L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5692L]
      +- Project [COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5673L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5681L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5674L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5682L]
         +- Project [COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5666L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5673L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5665L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5674L]
            +- Project [COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5653L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5665L, COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5654L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5666L]
               +- Project [COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5631L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5653L, COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5638L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5654L]
                  +- Project [COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5631L, COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5638L]
                     +- Aggregate [COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L], [COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5631L, 1 AS NULL_1#5639, count(1) AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5638L]
                        +- Project [COL_8343D674_F7B4_49D3_9485_902B2BAAF953#5611, COL_2276CD98_E802_486D_8515_19B39DABC591#5612, COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#5613, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L]
                           +- Project [cast(UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5599 as string) AS COL_8343D674_F7B4_49D3_9485_902B2BAAF953#5611, cast(UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5600 as string) AS COL_2276CD98_E802_486D_8515_19B39DABC591#5612, cast(UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#5601 as string) AS COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#5613, cast(UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5602L as bigint) AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L]
                              +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5517 AS UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5599, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5518 AS UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5600, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5519 AS UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#5601, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5520L AS UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5602L]
                                 +- SubqueryAlias UNITE_CODE_CENT_36755117
                                    +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5461 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5517, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5462 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5518, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5465 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5519, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5466L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5520L]
                                       +- Filter CASE WHEN isnull((COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5466L > cast(1 as bigint))) THEN false ELSE (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5466L > cast(1 as bigint)) END
                                          +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5446 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5461, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5447 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5462, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5448 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5463, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5449 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5464, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5450 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5465, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5466L]
                                             +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5446, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5447, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5448, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5449, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5450, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L]
                                                +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L]
                                                   +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, CONST#5359, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L]
                                                      +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, CONST#5359, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L]
                                                         +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, CONST#5359 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344], [CONST#5359 DESC NULLS LAST]
                                                            +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, CONST#5359]
                                                               +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, 1 AS CONST#5359]
                                                                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5281 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5282 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5283 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5284 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5285 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344]
                                                                     +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5281, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5282, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5283, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5284, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5285]
                                                                        +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5281, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5282, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5283, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5284, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5285]
                                                                           +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5258, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5259, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5260, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5261, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5258 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5281, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5259 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5282, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5260 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5283, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5261 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5284, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5285, 1 AS NULL_1#5301]
                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5244 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5258, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5245 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5259, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5246 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5260, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5247 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5261, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5226 AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262]
                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5214 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5244, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5215 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5245, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5216 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5246, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5217 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5247, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5226]
                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5214, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5215, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5216, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5217, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5216, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5217), cast( :  as string)) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5226]
                                                                                       +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5206 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5214, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5207 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5215, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5208 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5216, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5209 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5217]
                                                                                          +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5206, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5207, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5208, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5209]
                                                                                             +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5156, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190]
                                                                                                +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5156, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5157, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190]
                                                                                                   +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5157), false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190]
                                                                                                      +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5134 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5135 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5136 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5137 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5156, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5117 AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5157]
                                                                                                         +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5084 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5134, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5085 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5135, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5086 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5136, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5087 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5137, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5117]
                                                                                                            +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5084, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5085, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5086, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5087, str_split(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5087, cast(- as string)) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5117]
                                                                                                               +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5054 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5084, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5055 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5085, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5056 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5086, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5057 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5087]
                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4986 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5054, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4987 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5055, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4988 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5056, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4989 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5057]
                                                                                                                     +- Filter NOT (str_remove_accent(upper(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4989)) <=> )
                                                                                                                        +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4922 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4986, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4923 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4987, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4924 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4988, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4925 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4989]
                                                                                                                           +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4886 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4922, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4887 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4923, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4901 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4924, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4908 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4925]
                                                                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4886, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4887, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4901, col1#4889 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4908]
                                                                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4886, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4887, col0#4888 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4901, col1#4889]
                                                                                                                                    +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4873 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4886, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4874 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4887, col0#4888, col1#4889]
                                                                                                                                       +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4875, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4876, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4877, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#4878), false, [col0#4888, col1#4889]
                                                                                                                                          +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4856 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4873, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4857 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4874, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4858 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4875, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4859 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4876, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4860 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4877, COL_254FB614_FB51_4228_B230_A642F782E3FD#4861 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4878]
                                                                                                                                             +- Project [cast(BASE_BOHRINGER_26561_CODE_26562#4760 as string) AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4856, cast(BASE_BOHRINGER_26561_CLIENT_26563#4759 as string) AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4857, cast(BASE_BOHRINGER_26561_ALCYON_26574#4752 as string) AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4858, cast(BASE_BOHRINGER_26561_CENTRAVET_26575#4753 as string) AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4859, cast(BASE_BOHRINGER_26561_COVETO_26576#4762 as string) AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4860, cast(BASE_BOHRINGER_26561_NEFTYS_26577#4772 as string) AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4861]
                                                                                                                                                +- Project [ADRESSE_26564#4569 AS BASE_BOHRINGER_26561_ADRESSE_26564#4751, ALCYON_26574#4570 AS BASE_BOHRINGER_26561_ALCYON_26574#4752, CENTRAVET_26575#4571 AS BASE_BOHRINGER_26561_CENTRAVET_26575#4753, CF_GLOBAL_AV_26589#4572 AS BASE_BOHRINGER_26561_CF_GLOBAL_AV_26589#4754, CF_GLOBAL_EQ_26585#4573 AS BASE_BOHRINGER_26561_CF_GLOBAL_EQ_26585#4755, CF_GLOBAL_PO_26587#4574 AS BASE_BOHRINGER_26561_CF_GLOBAL_PO_26587#4756, CF_GLOBAL_PV_26581#4575 AS BASE_BOHRINGER_26561_CF_GLOBAL_PV_26581#4757, CF_GLOBAL_RU_26583#4576 AS BASE_BOHRINGER_26561_CF_GLOBAL_RU_26583#4758, CLIENT_26563#4577 AS BASE_BOHRINGER_26561_CLIENT_26563#4759, CODE_26562#4578 AS BASE_BOHRINGER_26561_CODE_26562#4760, CODE_ORDINAL_26573#4579 AS BASE_BOHRINGER_26561_CODE_ORDINAL_26573#4761, COVETO_26576#4580 AS BASE_BOHRINGER_26561_COVETO_26576#4762, CP_26565#4581 AS BASE_BOHRINGER_26561_CP_26565#4763, GIE_AV_22_26588#4582 AS BASE_BOHRINGER_26561_GIE_AV_22_26588#4764, GIE_EQ_22_26584#4583 AS BASE_BOHRINGER_26561_GIE_EQ_22_26584#4765, GIE_MAX_26579#4584 AS BASE_BOHRINGER_26561_GIE_MAX_26579#4766, GIE_PO_22_26586#4585 AS BASE_BOHRINGER_26561_GIE_PO_22_26586#4767, GIE_PV_22_26580#4586 AS BASE_BOHRINGER_26561_GIE_PV_22_26580#4768, GIE_RU_22_26582#4587 AS BASE_BOHRINGER_26561_GIE_RU_22_26582#4769, ID_VETFAMILY_26578#4588 AS BASE_BOHRINGER_26561_ID_VETFAMILY_26578#4770, MAIL_26568#4589 AS BASE_BOHRINGER_26561_MAIL_26568#4771, NEFTYS_26577#4590 AS BASE_BOHRINGER_26561_NEFTYS_26577#4772, SIRET_26572#4591 AS BASE_BOHRINGER_26561_SIRET_26572#4773, STATUT_26570#4592 AS BASE_BOHRINGER_26561_STATUT_26570#4774, ... 4 more fields]
                                                                                                                                                   +- SubqueryAlias BASE_BOHRINGER_26561117
                                                                                                                                                      +- Relation[ADRESSE_26564#4569,ALCYON_26574#4570,CENTRAVET_26575#4571,CF_GLOBAL_AV_26589#4572,CF_GLOBAL_EQ_26585#4573,CF_GLOBAL_PO_26587#4574,CF_GLOBAL_PV_26581#4575,CF_GLOBAL_RU_26583#4576,CLIENT_26563#4577,CODE_26562#4578,CODE_ORDINAL_26573#4579,COVETO_26576#4580,CP_26565#4581,GIE_AV_22_26588#4582,GIE_EQ_22_26584#4583,GIE_MAX_26579#4584,GIE_PO_22_26586#4585,GIE_PV_22_26580#4586,GIE_RU_22_26582#4587,ID_VETFAMILY_26578#4588,MAIL_26568#4589,NEFTYS_26577#4590,SIRET_26572#4591,STATUT_26570#4592,... 4 more fields] parquet

== Analyzed Logical Plan ==
COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E: bigint, COL_7C874283_224D_4E61_B24E_374A7DF50F8C: bigint
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5681L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5691L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5682L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5692L]
      +- Project [COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5673L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5681L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5674L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5682L]
         +- Project [COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5666L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5673L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5665L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5674L]
            +- Project [COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5653L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5665L, COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5654L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5666L]
               +- Project [COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5631L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5653L, COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5638L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5654L]
                  +- Project [COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5631L, COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5638L]
                     +- Aggregate [COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L], [COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5631L, 1 AS NULL_1#5639, count(1) AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5638L]
                        +- Project [COL_8343D674_F7B4_49D3_9485_902B2BAAF953#5611, COL_2276CD98_E802_486D_8515_19B39DABC591#5612, COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#5613, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L]
                           +- Project [cast(UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5599 as string) AS COL_8343D674_F7B4_49D3_9485_902B2BAAF953#5611, cast(UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5600 as string) AS COL_2276CD98_E802_486D_8515_19B39DABC591#5612, cast(UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#5601 as string) AS COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#5613, cast(UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5602L as bigint) AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L]
                              +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5517 AS UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5599, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5518 AS UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5600, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5519 AS UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#5601, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5520L AS UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5602L]
                                 +- SubqueryAlias UNITE_CODE_CENT_36755117
                                    +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5461 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5517, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5462 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5518, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5465 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5519, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5466L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5520L]
                                       +- Filter CASE WHEN isnull((COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5466L > cast(1 as bigint))) THEN false ELSE (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5466L > cast(1 as bigint)) END
                                          +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5446 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5461, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5447 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5462, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5448 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5463, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5449 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5464, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5450 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5465, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5466L]
                                             +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5446, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5447, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5448, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5449, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5450, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L]
                                                +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L]
                                                   +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, CONST#5359, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L]
                                                      +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, CONST#5359, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L]
                                                         +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, CONST#5359 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344], [CONST#5359 DESC NULLS LAST]
                                                            +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, CONST#5359]
                                                               +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, 1 AS CONST#5359]
                                                                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5281 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5282 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5341, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5283 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5342, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5284 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5343, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5285 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344]
                                                                     +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5281, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5282, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5283, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5284, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5285]
                                                                        +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5281, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5282, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5283, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5284, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5285]
                                                                           +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5258, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5259, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5260, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5261, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5258 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5281, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5259 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5282, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5260 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5283, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5261 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5284, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5285, 1 AS NULL_1#5301]
                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5244 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5258, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5245 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5259, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5246 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5260, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5247 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5261, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5226 AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262]
                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5214 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5244, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5215 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5245, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5216 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5246, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5217 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5247, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5226]
                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5214, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5215, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5216, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5217, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5216, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5217), cast( :  as string)) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5226]
                                                                                       +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5206 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5214, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5207 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5215, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5208 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5216, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5209 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5217]
                                                                                          +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5206, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5207, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5208, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5209]
                                                                                             +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5156, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190]
                                                                                                +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5156, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5157, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190]
                                                                                                   +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5157), false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190]
                                                                                                      +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5134 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5135 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5136 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5137 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5156, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5117 AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5157]
                                                                                                         +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5084 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5134, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5085 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5135, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5086 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5136, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5087 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5137, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5117]
                                                                                                            +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5084, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5085, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5086, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5087, str_split(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5087, cast(- as string)) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5117]
                                                                                                               +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5054 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5084, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5055 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5085, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5056 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5086, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5057 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5087]
                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4986 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5054, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4987 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5055, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4988 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5056, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4989 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#5057]
                                                                                                                     +- Filter NOT (str_remove_accent(upper(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4989)) <=> )
                                                                                                                        +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4922 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4986, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4923 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4987, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4924 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4988, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4925 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4989]
                                                                                                                           +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4886 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4922, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4887 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4923, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4901 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4924, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4908 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4925]
                                                                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4886, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4887, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4901, col1#4889 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4908]
                                                                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4886, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4887, col0#4888 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4901, col1#4889]
                                                                                                                                    +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4873 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4886, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4874 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4887, col0#4888, col1#4889]
                                                                                                                                       +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4875, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4876, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4877, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#4878), false, [col0#4888, col1#4889]
                                                                                                                                          +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4856 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4873, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4857 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4874, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4858 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4875, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4859 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4876, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4860 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4877, COL_254FB614_FB51_4228_B230_A642F782E3FD#4861 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4878]
                                                                                                                                             +- Project [cast(BASE_BOHRINGER_26561_CODE_26562#4760 as string) AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4856, cast(BASE_BOHRINGER_26561_CLIENT_26563#4759 as string) AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4857, cast(BASE_BOHRINGER_26561_ALCYON_26574#4752 as string) AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4858, cast(BASE_BOHRINGER_26561_CENTRAVET_26575#4753 as string) AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4859, cast(BASE_BOHRINGER_26561_COVETO_26576#4762 as string) AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4860, cast(BASE_BOHRINGER_26561_NEFTYS_26577#4772 as string) AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4861]
                                                                                                                                                +- Project [ADRESSE_26564#4569 AS BASE_BOHRINGER_26561_ADRESSE_26564#4751, ALCYON_26574#4570 AS BASE_BOHRINGER_26561_ALCYON_26574#4752, CENTRAVET_26575#4571 AS BASE_BOHRINGER_26561_CENTRAVET_26575#4753, CF_GLOBAL_AV_26589#4572 AS BASE_BOHRINGER_26561_CF_GLOBAL_AV_26589#4754, CF_GLOBAL_EQ_26585#4573 AS BASE_BOHRINGER_26561_CF_GLOBAL_EQ_26585#4755, CF_GLOBAL_PO_26587#4574 AS BASE_BOHRINGER_26561_CF_GLOBAL_PO_26587#4756, CF_GLOBAL_PV_26581#4575 AS BASE_BOHRINGER_26561_CF_GLOBAL_PV_26581#4757, CF_GLOBAL_RU_26583#4576 AS BASE_BOHRINGER_26561_CF_GLOBAL_RU_26583#4758, CLIENT_26563#4577 AS BASE_BOHRINGER_26561_CLIENT_26563#4759, CODE_26562#4578 AS BASE_BOHRINGER_26561_CODE_26562#4760, CODE_ORDINAL_26573#4579 AS BASE_BOHRINGER_26561_CODE_ORDINAL_26573#4761, COVETO_26576#4580 AS BASE_BOHRINGER_26561_COVETO_26576#4762, CP_26565#4581 AS BASE_BOHRINGER_26561_CP_26565#4763, GIE_AV_22_26588#4582 AS BASE_BOHRINGER_26561_GIE_AV_22_26588#4764, GIE_EQ_22_26584#4583 AS BASE_BOHRINGER_26561_GIE_EQ_22_26584#4765, GIE_MAX_26579#4584 AS BASE_BOHRINGER_26561_GIE_MAX_26579#4766, GIE_PO_22_26586#4585 AS BASE_BOHRINGER_26561_GIE_PO_22_26586#4767, GIE_PV_22_26580#4586 AS BASE_BOHRINGER_26561_GIE_PV_22_26580#4768, GIE_RU_22_26582#4587 AS BASE_BOHRINGER_26561_GIE_RU_22_26582#4769, ID_VETFAMILY_26578#4588 AS BASE_BOHRINGER_26561_ID_VETFAMILY_26578#4770, MAIL_26568#4589 AS BASE_BOHRINGER_26561_MAIL_26568#4771, NEFTYS_26577#4590 AS BASE_BOHRINGER_26561_NEFTYS_26577#4772, SIRET_26572#4591 AS BASE_BOHRINGER_26561_SIRET_26572#4773, STATUT_26570#4592 AS BASE_BOHRINGER_26561_STATUT_26570#4774, ... 4 more fields]
                                                                                                                                                   +- SubqueryAlias BASE_BOHRINGER_26561117
                                                                                                                                                      +- Relation[ADRESSE_26564#4569,ALCYON_26574#4570,CENTRAVET_26575#4571,CF_GLOBAL_AV_26589#4572,CF_GLOBAL_EQ_26585#4573,CF_GLOBAL_PO_26587#4574,CF_GLOBAL_PV_26581#4575,CF_GLOBAL_RU_26583#4576,CLIENT_26563#4577,CODE_26562#4578,CODE_ORDINAL_26573#4579,COVETO_26576#4580,CP_26565#4581,GIE_AV_22_26588#4582,GIE_EQ_22_26584#4583,GIE_MAX_26579#4584,GIE_PO_22_26586#4585,GIE_PV_22_26580#4586,GIE_RU_22_26582#4587,ID_VETFAMILY_26578#4588,MAIL_26568#4589,NEFTYS_26577#4590,SIRET_26572#4591,STATUT_26570#4592,... 4 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Aggregate [COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L], [count(1) AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5691L, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5692L]
      +- Project [COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L]
         +- Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L > 1)
            +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, CONST#5359 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344], [CONST#5359 DESC NULLS LAST]
               +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, 1 AS CONST#5359]
                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190),  : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262]
                     +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5157), [3], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190]
                        +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4873 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4874 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, col0#4888 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, str_split(col1#4889, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5157]
                           +- Filter NOT (str_remove_accent(upper(col1#4889)) <=> )
                              +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4875, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4876, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4877, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#4878), [2, 3, 4, 5], false, [col0#4888, col1#4889]
                                 +- Project [CODE_26562#4578 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4873, CLIENT_26563#4577 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4874, ALCYON_26574#4570 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4875, CENTRAVET_26575#4571 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4876, COVETO_26576#4580 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4877, NEFTYS_26577#4590 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4878]
                                    +- Relation[ADRESSE_26564#4569,ALCYON_26574#4570,CENTRAVET_26575#4571,CF_GLOBAL_AV_26589#4572,CF_GLOBAL_EQ_26585#4573,CF_GLOBAL_PO_26587#4574,CF_GLOBAL_PV_26581#4575,CF_GLOBAL_RU_26583#4576,CLIENT_26563#4577,CODE_26562#4578,CODE_ORDINAL_26573#4579,COVETO_26576#4580,CP_26565#4581,GIE_AV_22_26588#4582,GIE_EQ_22_26584#4583,GIE_MAX_26579#4584,GIE_PO_22_26586#4585,GIE_PV_22_26580#4586,GIE_RU_22_26582#4587,ID_VETFAMILY_26578#4588,MAIL_26568#4589,NEFTYS_26577#4590,SIRET_26572#4591,STATUT_26570#4592,... 4 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(7) HashAggregate(keys=[COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L], functions=[count(1)], output=[COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#5691L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#5692L])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 2
            +- Exchange hashpartitioning(COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L, 200), true, [id=#1489]
               +- *(6) HashAggregate(keys=[COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L], functions=[partial_count(1)], output=[COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L, count#5807L])
                  +- *(6) Project [COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5614L]
                     +- *(6) Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L > 1)
                        +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, CONST#5359 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5381L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344], [CONST#5359 DESC NULLS LAST]
                           +- *(5) Sort [COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344 ASC NULLS FIRST, CONST#5359 DESC NULLS LAST], false, 0
                              +- CustomShuffleReader coalesced
                                 +- ShuffleQueryStage 1
                                    +- Exchange hashpartitioning(COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, 200), true, [id=#1268]
                                       +- *(4) HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262], functions=[], output=[COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5340, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5344, CONST#5359])
                                          +- CustomShuffleReader coalesced
                                             +- ShuffleQueryStage 0
                                                +- Exchange hashpartitioning(COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262, 200), true, [id=#986]
                                                   +- *(3) HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262], functions=[], output=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262])
                                                      +- *(3) Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190),  : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#5262]
                                                         +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5157), [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#5190]
                                                            +- *(2) Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4873 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#5153, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4874 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#5154, col0#4888 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#5155, str_split(col1#4889, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#5157]
                                                               +- *(2) Filter NOT (str_remove_accent(upper(col1#4889)) <=> )
                                                                  +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4875, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4876, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4877, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#4878), [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4873, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4874], false, [col0#4888, col1#4889]
                                                                     +- *(1) Project [CODE_26562#4578 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4873, CLIENT_26563#4577 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4874, ALCYON_26574#4570 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4875, CENTRAVET_26575#4571 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4876, COVETO_26576#4580 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4877, NEFTYS_26577#4590 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4878]
                                                                        +- *(1) ColumnarToRow
                                                                           +- FileScan parquet [ALCYON_26574#4570,CENTRAVET_26575#4571,CLIENT_26563#4577,CODE_26562#4578,COVETO_26576#4580,NEFTYS_26577#4590] 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...