DC2 - Details for Query 76

Details for Query 76

Submitted Time: 2025/11/07 08:58:34
Duration: 2 s
Succeeded Jobs: 109 113 115 119 120

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))\n3 ms (1 ms, 1 ms, 1 ms (stage 162.0: task 383))"; 3 [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 162.0: task 383)) peak memory total (min, med, max (stageId: taskId)) 128.8 MiB (256.0 KiB, 64.3 MiB, 64.3 MiB (stage 162.0: task 383)) number of output rows: 2 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 162.0: task 383))"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 14 shuffle write time total (min, med, max (stageId: taskId)) 207 ms (3 ms, 11 ms, 75 ms (stage 145.0: task 353)) 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 162.0: task 383)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 162.0: task 383)) 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 145.0: task 355)) 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 145.0: task 355))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n1.6 s (5 ms, 119 ms, 223 ms (stage 145.0: task 349))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 232 ms (1 ms, 21 ms, 42 ms (stage 145.0: task 352)) peak memory total (min, med, max (stageId: taskId)) 3.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 145.0: task 344)) 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))\n2.6 s (23 ms, 206 ms, 285 ms (stage 145.0: task 349))"; 12 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 337 ms (0 ms, 30 ms, 37 ms (stage 145.0: task 351)) peak memory total (min, med, max (stageId: taskId)) 832.8 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 145.0: task 344)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 145.0: task 344))"]; } 13 [labelType="html" label=" CustomShuffleReader "]; 14 [labelType="html" label="Exchange shuffle records written: 14,814 shuffle write time total (min, med, max (stageId: taskId)) 1.7 s (40 ms, 141 ms, 187 ms (stage 139.0: task 333)) 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 145.0: task 345)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 145.0: task 344)) 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 139.0: task 335)) 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 139.0: task 335))"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n817 ms (20 ms, 40 ms, 129 ms (stage 139.0: task 322))"; 16 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 56 ms (1 ms, 4 ms, 7 ms (stage 139.0: task 322)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 139.0: task 328)) number of output rows: 14,814 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 139.0: task 328))"]; } 17 [labelType="html" label=" CustomShuffleReader "]; 18 [labelType="html" label="Exchange shuffle records written: 14,814 shuffle write time total (min, med, max (stageId: taskId)) 1.5 s (35 ms, 141 ms, 215 ms (stage 133.0: task 289)) 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 139.0: task 335)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 139.0: task 328)) 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 133.0: task 281)) 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 133.0: task 281))"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n901 ms (32 ms, 83 ms, 127 ms (stage 133.0: task 281))"; 20 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 556 ms (14 ms, 57 ms, 74 ms (stage 133.0: task 281)) peak memory total (min, med, max (stageId: taskId)) 771.0 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 133.0: task 281)) number of output rows: 14,814 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 133.0: task 281))"]; 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))\n594 ms (17 ms, 60 ms, 77 ms (stage 133.0: task 281))"; 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))\n609 ms (18 ms, 61 ms, 80 ms (stage 133.0: task 281))"; 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)) 77 ms (2 ms, 5 ms, 14 ms (stage 133.0: task 285)) 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#22337L], functions=[count(1)])

WholeStageCodegen (7)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L, 200), true, [id=#3094]

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

Project [COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L]

Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L > 1)

WholeStageCodegen (6)

Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, CONST#22136 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119], [CONST#22136 DESC NULLS LAST]

Sort [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119 ASC NULLS FIRST, CONST#22136 DESC NULLS LAST], false, 0

WholeStageCodegen (5)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, 200), true, [id=#2929]

HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055], functions=[])

WholeStageCodegen (4)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055, 200), true, [id=#2491]

Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961), : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055]

WholeStageCodegen (3)

Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21951), [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961]

Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21722 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21723 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, col0#21771 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, str_split(col1#21772, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21951]

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

WholeStageCodegen (2)

Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21724, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21725, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21726, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21727), [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21722, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21723], false, [col0#21771, col1#21772]

Project [CODE_26562#21340 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21722, CLIENT_26563#21339 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21723, ALCYON_26574#21332 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21724, CENTRAVET_26575#21333 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21725, COVETO_26576#21342 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21726, NEFTYS_26577#21352 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21727]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ALCYON_26574#21332,CENTRAVET_26575#21333,CLIENT_26563#21339,CODE_26562#21340,COVETO_26576#21342,NEFTYS_26577#21352] 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#22442L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22452L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22443L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22453L]
      +- Project [COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22429L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22442L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22430L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22443L]
         +- Project [COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22416L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22429L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22415L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22430L]
            +- Project [COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22403L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22415L, COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22404L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22416L]
               +- Project [COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22351L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22403L, COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22378L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22404L]
                  +- Project [COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22351L, COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22378L]
                     +- Aggregate [COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L], [COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22351L, 1 AS NULL_1#22381, count(1) AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22378L]
                        +- Project [COL_8343D674_F7B4_49D3_9485_902B2BAAF953#22334, COL_2276CD98_E802_486D_8515_19B39DABC591#22335, COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#22336, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L]
                           +- Project [cast(UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22318 as string) AS COL_8343D674_F7B4_49D3_9485_902B2BAAF953#22334, cast(UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22319 as string) AS COL_2276CD98_E802_486D_8515_19B39DABC591#22335, cast(UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#22320 as string) AS COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#22336, cast(UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22321L as bigint) AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L]
                              +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22272 AS UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22318, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22273 AS UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22319, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22274 AS UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#22320, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22275L AS UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22321L]
                                 +- SubqueryAlias UNITE_CODE_CENT_36755118
                                    +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22233 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22272, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22234 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22273, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22237 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22274, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22238L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22275L]
                                       +- Filter CASE WHEN isnull((COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22238L > cast(1 as bigint))) THEN false ELSE (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22238L > cast(1 as bigint)) END
                                          +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22211 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22233, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22212 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22234, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22213 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22235, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22214 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22236, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22215 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22237, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22238L]
                                             +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22211, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22212, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22213, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22214, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22215, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L]
                                                +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L]
                                                   +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, CONST#22136, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L]
                                                      +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, CONST#22136, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L]
                                                         +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, CONST#22136 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119], [CONST#22136 DESC NULLS LAST]
                                                            +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, CONST#22136]
                                                               +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, 1 AS CONST#22136]
                                                                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22071 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22072 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22073 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22074 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22075 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119]
                                                                     +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22071, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22072, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22073, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22074, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22075]
                                                                        +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22071, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22072, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22073, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22074, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22075]
                                                                           +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22051, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22052, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22053, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22054, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22051 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22071, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22052 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22072, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22053 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22073, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22054 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22074, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22075, 1 AS NULL_1#22087]
                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22032 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22051, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22033 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22052, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22034 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22053, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22035 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22054, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22017 AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055]
                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22004 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22032, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22005 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22033, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22006 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22034, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22007 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22035, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22017]
                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22004, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22005, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22006, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22007, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22006, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22007), cast( :  as string)) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22017]
                                                                                       +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21988 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22004, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21989 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22005, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21990 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22006, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21991 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22007]
                                                                                          +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21988, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21989, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21990, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21991]
                                                                                             +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21950, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961]
                                                                                                +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21950, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21951, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961]
                                                                                                   +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21951), false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961]
                                                                                                      +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21925 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21926 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21927 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21928 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21950, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21908 AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21951]
                                                                                                         +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21890 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21925, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21891 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21926, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21892 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21927, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21893 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21928, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21908]
                                                                                                            +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21890, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21891, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21892, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21893, str_split(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21893, cast(- as string)) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21908]
                                                                                                               +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21878 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21890, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21879 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21891, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21880 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21892, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21881 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21893]
                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21842 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21878, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21843 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21879, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21844 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21880, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21845 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21881]
                                                                                                                     +- Filter NOT (str_remove_accent(upper(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21845)) <=> )
                                                                                                                        +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21819 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21842, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21820 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21843, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21821 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21844, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21822 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21845]
                                                                                                                           +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21743 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21819, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21744 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21820, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21792 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21821, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21798 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21822]
                                                                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21743, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21744, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21792, col1#21772 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21798]
                                                                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21743, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21744, col0#21771 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21792, col1#21772]
                                                                                                                                    +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21722 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21743, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21723 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21744, col0#21771, col1#21772]
                                                                                                                                       +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21724, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21725, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21726, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21727), false, [col0#21771, col1#21772]
                                                                                                                                          +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21704 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21722, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21705 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21723, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21706 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21724, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21707 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21725, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21708 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21726, COL_254FB614_FB51_4228_B230_A642F782E3FD#21709 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21727]
                                                                                                                                             +- Project [cast(BASE_BOHRINGER_26561_CODE_26562#21601 as string) AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21704, cast(BASE_BOHRINGER_26561_CLIENT_26563#21600 as string) AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21705, cast(BASE_BOHRINGER_26561_ALCYON_26574#21593 as string) AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21706, cast(BASE_BOHRINGER_26561_CENTRAVET_26575#21594 as string) AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21707, cast(BASE_BOHRINGER_26561_COVETO_26576#21603 as string) AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21708, cast(BASE_BOHRINGER_26561_NEFTYS_26577#21613 as string) AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21709]
                                                                                                                                                +- Project [ADRESSE_26564#21331 AS BASE_BOHRINGER_26561_ADRESSE_26564#21592, ALCYON_26574#21332 AS BASE_BOHRINGER_26561_ALCYON_26574#21593, CENTRAVET_26575#21333 AS BASE_BOHRINGER_26561_CENTRAVET_26575#21594, CF_GLOBAL_AV_26589#21334 AS BASE_BOHRINGER_26561_CF_GLOBAL_AV_26589#21595, CF_GLOBAL_EQ_26585#21335 AS BASE_BOHRINGER_26561_CF_GLOBAL_EQ_26585#21596, CF_GLOBAL_PO_26587#21336 AS BASE_BOHRINGER_26561_CF_GLOBAL_PO_26587#21597, CF_GLOBAL_PV_26581#21337 AS BASE_BOHRINGER_26561_CF_GLOBAL_PV_26581#21598, CF_GLOBAL_RU_26583#21338 AS BASE_BOHRINGER_26561_CF_GLOBAL_RU_26583#21599, CLIENT_26563#21339 AS BASE_BOHRINGER_26561_CLIENT_26563#21600, CODE_26562#21340 AS BASE_BOHRINGER_26561_CODE_26562#21601, CODE_ORDINAL_26573#21341 AS BASE_BOHRINGER_26561_CODE_ORDINAL_26573#21602, COVETO_26576#21342 AS BASE_BOHRINGER_26561_COVETO_26576#21603, CP_26565#21343 AS BASE_BOHRINGER_26561_CP_26565#21604, GIE_AV_22_26588#21344 AS BASE_BOHRINGER_26561_GIE_AV_22_26588#21605, GIE_EQ_22_26584#21345 AS BASE_BOHRINGER_26561_GIE_EQ_22_26584#21606, GIE_MAX_26579#21346 AS BASE_BOHRINGER_26561_GIE_MAX_26579#21607, GIE_PO_22_26586#21347 AS BASE_BOHRINGER_26561_GIE_PO_22_26586#21608, GIE_PV_22_26580#21348 AS BASE_BOHRINGER_26561_GIE_PV_22_26580#21609, GIE_RU_22_26582#21349 AS BASE_BOHRINGER_26561_GIE_RU_22_26582#21610, ID_VETFAMILY_26578#21350 AS BASE_BOHRINGER_26561_ID_VETFAMILY_26578#21611, MAIL_26568#21351 AS BASE_BOHRINGER_26561_MAIL_26568#21612, NEFTYS_26577#21352 AS BASE_BOHRINGER_26561_NEFTYS_26577#21613, SIRET_26572#21353 AS BASE_BOHRINGER_26561_SIRET_26572#21614, STATUT_26570#21354 AS BASE_BOHRINGER_26561_STATUT_26570#21615, ... 4 more fields]
                                                                                                                                                   +- SubqueryAlias BASE_BOHRINGER_26561118
                                                                                                                                                      +- Relation[ADRESSE_26564#21331,ALCYON_26574#21332,CENTRAVET_26575#21333,CF_GLOBAL_AV_26589#21334,CF_GLOBAL_EQ_26585#21335,CF_GLOBAL_PO_26587#21336,CF_GLOBAL_PV_26581#21337,CF_GLOBAL_RU_26583#21338,CLIENT_26563#21339,CODE_26562#21340,CODE_ORDINAL_26573#21341,COVETO_26576#21342,CP_26565#21343,GIE_AV_22_26588#21344,GIE_EQ_22_26584#21345,GIE_MAX_26579#21346,GIE_PO_22_26586#21347,GIE_PV_22_26580#21348,GIE_RU_22_26582#21349,ID_VETFAMILY_26578#21350,MAIL_26568#21351,NEFTYS_26577#21352,SIRET_26572#21353,STATUT_26570#21354,... 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#22442L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22452L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22443L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22453L]
      +- Project [COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22429L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22442L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22430L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22443L]
         +- Project [COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22416L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22429L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22415L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22430L]
            +- Project [COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22403L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22415L, COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22404L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22416L]
               +- Project [COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22351L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22403L, COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22378L AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22404L]
                  +- Project [COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22351L, COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22378L]
                     +- Aggregate [COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L], [COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22351L, 1 AS NULL_1#22381, count(1) AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22378L]
                        +- Project [COL_8343D674_F7B4_49D3_9485_902B2BAAF953#22334, COL_2276CD98_E802_486D_8515_19B39DABC591#22335, COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#22336, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L]
                           +- Project [cast(UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22318 as string) AS COL_8343D674_F7B4_49D3_9485_902B2BAAF953#22334, cast(UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22319 as string) AS COL_2276CD98_E802_486D_8515_19B39DABC591#22335, cast(UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#22320 as string) AS COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#22336, cast(UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22321L as bigint) AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L]
                              +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22272 AS UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22318, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22273 AS UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22319, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22274 AS UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#22320, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22275L AS UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22321L]
                                 +- SubqueryAlias UNITE_CODE_CENT_36755118
                                    +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22233 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22272, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22234 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22273, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22237 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22274, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22238L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22275L]
                                       +- Filter CASE WHEN isnull((COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22238L > cast(1 as bigint))) THEN false ELSE (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22238L > cast(1 as bigint)) END
                                          +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22211 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22233, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22212 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22234, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22213 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22235, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22214 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22236, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22215 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22237, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22238L]
                                             +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22211, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22212, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22213, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22214, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22215, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L]
                                                +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L]
                                                   +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, CONST#22136, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L]
                                                      +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, CONST#22136, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L]
                                                         +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, CONST#22136 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119], [CONST#22136 DESC NULLS LAST]
                                                            +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, CONST#22136]
                                                               +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, 1 AS CONST#22136]
                                                                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22071 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22072 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22116, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22073 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22117, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22074 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22118, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22075 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119]
                                                                     +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22071, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22072, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22073, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22074, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22075]
                                                                        +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22071, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22072, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22073, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22074, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22075]
                                                                           +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22051, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22052, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22053, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22054, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22051 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22071, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22052 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22072, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22053 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22073, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22054 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22074, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22075, 1 AS NULL_1#22087]
                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22032 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22051, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22033 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22052, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22034 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22053, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22035 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22054, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22017 AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055]
                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22004 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22032, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22005 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22033, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22006 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22034, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22007 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22035, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22017]
                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22004, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22005, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22006, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22007, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22006, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22007), cast( :  as string)) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22017]
                                                                                       +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21988 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#22004, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21989 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#22005, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21990 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#22006, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21991 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#22007]
                                                                                          +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21988, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21989, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21990, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21991]
                                                                                             +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21950, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961]
                                                                                                +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21950, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21951, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961]
                                                                                                   +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21951), false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961]
                                                                                                      +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21925 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21926 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21927 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21928 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21950, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21908 AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21951]
                                                                                                         +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21890 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21925, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21891 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21926, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21892 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21927, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21893 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21928, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21908]
                                                                                                            +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21890, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21891, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21892, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21893, str_split(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21893, cast(- as string)) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21908]
                                                                                                               +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21878 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21890, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21879 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21891, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21880 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21892, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21881 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21893]
                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21842 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21878, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21843 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21879, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21844 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21880, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21845 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21881]
                                                                                                                     +- Filter NOT (str_remove_accent(upper(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21845)) <=> )
                                                                                                                        +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21819 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21842, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21820 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21843, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21821 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21844, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21822 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21845]
                                                                                                                           +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21743 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21819, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21744 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21820, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21792 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21821, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21798 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21822]
                                                                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21743, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21744, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21792, col1#21772 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21798]
                                                                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21743, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21744, col0#21771 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21792, col1#21772]
                                                                                                                                    +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21722 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21743, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21723 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21744, col0#21771, col1#21772]
                                                                                                                                       +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21724, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21725, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21726, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21727), false, [col0#21771, col1#21772]
                                                                                                                                          +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21704 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21722, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21705 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21723, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21706 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21724, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21707 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21725, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21708 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21726, COL_254FB614_FB51_4228_B230_A642F782E3FD#21709 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21727]
                                                                                                                                             +- Project [cast(BASE_BOHRINGER_26561_CODE_26562#21601 as string) AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21704, cast(BASE_BOHRINGER_26561_CLIENT_26563#21600 as string) AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21705, cast(BASE_BOHRINGER_26561_ALCYON_26574#21593 as string) AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21706, cast(BASE_BOHRINGER_26561_CENTRAVET_26575#21594 as string) AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21707, cast(BASE_BOHRINGER_26561_COVETO_26576#21603 as string) AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21708, cast(BASE_BOHRINGER_26561_NEFTYS_26577#21613 as string) AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21709]
                                                                                                                                                +- Project [ADRESSE_26564#21331 AS BASE_BOHRINGER_26561_ADRESSE_26564#21592, ALCYON_26574#21332 AS BASE_BOHRINGER_26561_ALCYON_26574#21593, CENTRAVET_26575#21333 AS BASE_BOHRINGER_26561_CENTRAVET_26575#21594, CF_GLOBAL_AV_26589#21334 AS BASE_BOHRINGER_26561_CF_GLOBAL_AV_26589#21595, CF_GLOBAL_EQ_26585#21335 AS BASE_BOHRINGER_26561_CF_GLOBAL_EQ_26585#21596, CF_GLOBAL_PO_26587#21336 AS BASE_BOHRINGER_26561_CF_GLOBAL_PO_26587#21597, CF_GLOBAL_PV_26581#21337 AS BASE_BOHRINGER_26561_CF_GLOBAL_PV_26581#21598, CF_GLOBAL_RU_26583#21338 AS BASE_BOHRINGER_26561_CF_GLOBAL_RU_26583#21599, CLIENT_26563#21339 AS BASE_BOHRINGER_26561_CLIENT_26563#21600, CODE_26562#21340 AS BASE_BOHRINGER_26561_CODE_26562#21601, CODE_ORDINAL_26573#21341 AS BASE_BOHRINGER_26561_CODE_ORDINAL_26573#21602, COVETO_26576#21342 AS BASE_BOHRINGER_26561_COVETO_26576#21603, CP_26565#21343 AS BASE_BOHRINGER_26561_CP_26565#21604, GIE_AV_22_26588#21344 AS BASE_BOHRINGER_26561_GIE_AV_22_26588#21605, GIE_EQ_22_26584#21345 AS BASE_BOHRINGER_26561_GIE_EQ_22_26584#21606, GIE_MAX_26579#21346 AS BASE_BOHRINGER_26561_GIE_MAX_26579#21607, GIE_PO_22_26586#21347 AS BASE_BOHRINGER_26561_GIE_PO_22_26586#21608, GIE_PV_22_26580#21348 AS BASE_BOHRINGER_26561_GIE_PV_22_26580#21609, GIE_RU_22_26582#21349 AS BASE_BOHRINGER_26561_GIE_RU_22_26582#21610, ID_VETFAMILY_26578#21350 AS BASE_BOHRINGER_26561_ID_VETFAMILY_26578#21611, MAIL_26568#21351 AS BASE_BOHRINGER_26561_MAIL_26568#21612, NEFTYS_26577#21352 AS BASE_BOHRINGER_26561_NEFTYS_26577#21613, SIRET_26572#21353 AS BASE_BOHRINGER_26561_SIRET_26572#21614, STATUT_26570#21354 AS BASE_BOHRINGER_26561_STATUT_26570#21615, ... 4 more fields]
                                                                                                                                                   +- SubqueryAlias BASE_BOHRINGER_26561118
                                                                                                                                                      +- Relation[ADRESSE_26564#21331,ALCYON_26574#21332,CENTRAVET_26575#21333,CF_GLOBAL_AV_26589#21334,CF_GLOBAL_EQ_26585#21335,CF_GLOBAL_PO_26587#21336,CF_GLOBAL_PV_26581#21337,CF_GLOBAL_RU_26583#21338,CLIENT_26563#21339,CODE_26562#21340,CODE_ORDINAL_26573#21341,COVETO_26576#21342,CP_26565#21343,GIE_AV_22_26588#21344,GIE_EQ_22_26584#21345,GIE_MAX_26579#21346,GIE_PO_22_26586#21347,GIE_PV_22_26580#21348,GIE_RU_22_26582#21349,ID_VETFAMILY_26578#21350,MAIL_26568#21351,NEFTYS_26577#21352,SIRET_26572#21353,STATUT_26570#21354,... 4 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Aggregate [COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L], [count(1) AS COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22452L, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L AS COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22453L]
      +- Project [COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L]
         +- Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L > 1)
            +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, CONST#22136 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119], [CONST#22136 DESC NULLS LAST]
               +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, 1 AS CONST#22136]
                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961),  : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055]
                     +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21951), [3], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961]
                        +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21722 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21723 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, col0#21771 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, str_split(col1#21772, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21951]
                           +- Filter NOT (str_remove_accent(upper(col1#21772)) <=> )
                              +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21724, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21725, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21726, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21727), [2, 3, 4, 5], false, [col0#21771, col1#21772]
                                 +- Project [CODE_26562#21340 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21722, CLIENT_26563#21339 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21723, ALCYON_26574#21332 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21724, CENTRAVET_26575#21333 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21725, COVETO_26576#21342 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21726, NEFTYS_26577#21352 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21727]
                                    +- Relation[ADRESSE_26564#21331,ALCYON_26574#21332,CENTRAVET_26575#21333,CF_GLOBAL_AV_26589#21334,CF_GLOBAL_EQ_26585#21335,CF_GLOBAL_PO_26587#21336,CF_GLOBAL_PV_26581#21337,CF_GLOBAL_RU_26583#21338,CLIENT_26563#21339,CODE_26562#21340,CODE_ORDINAL_26573#21341,COVETO_26576#21342,CP_26565#21343,GIE_AV_22_26588#21344,GIE_EQ_22_26584#21345,GIE_MAX_26579#21346,GIE_PO_22_26586#21347,GIE_PV_22_26580#21348,GIE_RU_22_26582#21349,ID_VETFAMILY_26578#21350,MAIL_26568#21351,NEFTYS_26577#21352,SIRET_26572#21353,STATUT_26570#21354,... 4 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(7) HashAggregate(keys=[COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L], functions=[count(1)], output=[COL_5DEB9CE0_957E_4504_9B05_FF6048FAFD1E#22452L, COL_7C874283_224D_4E61_B24E_374A7DF50F8C#22453L])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 2
            +- Exchange hashpartitioning(COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L, 200), true, [id=#3094]
               +- *(6) HashAggregate(keys=[COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L], functions=[partial_count(1)], output=[COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L, count#22567L])
                  +- *(6) Project [COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22337L]
                     +- *(6) Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L > 1)
                        +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, CONST#22136 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22159L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119], [CONST#22136 DESC NULLS LAST]
                           +- *(5) Sort [COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119 ASC NULLS FIRST, CONST#22136 DESC NULLS LAST], false, 0
                              +- CustomShuffleReader coalesced
                                 +- ShuffleQueryStage 1
                                    +- Exchange hashpartitioning(COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, 200), true, [id=#2929]
                                       +- *(4) HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055], functions=[], output=[COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22115, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22119, CONST#22136])
                                          +- CustomShuffleReader coalesced
                                             +- ShuffleQueryStage 0
                                                +- Exchange hashpartitioning(COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055, 200), true, [id=#2491]
                                                   +- *(3) HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055], functions=[], output=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055])
                                                      +- *(3) Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961),  : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#22055]
                                                         +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21951), [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21961]
                                                            +- *(2) Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21722 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21947, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21723 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21948, col0#21771 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21949, str_split(col1#21772, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21951]
                                                               +- *(2) Filter NOT (str_remove_accent(upper(col1#21772)) <=> )
                                                                  +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21724, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21725, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21726, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21727), [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21722, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21723], false, [col0#21771, col1#21772]
                                                                     +- *(1) Project [CODE_26562#21340 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21722, CLIENT_26563#21339 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21723, ALCYON_26574#21332 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21724, CENTRAVET_26575#21333 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21725, COVETO_26576#21342 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21726, NEFTYS_26577#21352 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21727]
                                                                        +- *(1) ColumnarToRow
                                                                           +- FileScan parquet [ALCYON_26574#21332,CENTRAVET_26575#21333,CLIENT_26563#21339,CODE_26562#21340,COVETO_26576#21342,NEFTYS_26577#21352] 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...