DC2 - Details for Query 77

Details for Query 77

Submitted Time: 2025/11/07 08:58:34
Duration: 2 s
Succeeded Jobs: 110 112 117 121 122

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))\n6 ms (1 ms, 1 ms, 2 ms (stage 166.0: task 385))"; 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 170.0: task 386)) peak memory total (min, med, max (stageId: taskId)) 257.3 MiB (256.0 KiB, 64.3 MiB, 64.3 MiB (stage 170.0: task 388)) number of output rows: 4 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 170.0: task 388))"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 23 shuffle write time total (min, med, max (stageId: taskId)) 240 ms (3 ms, 12 ms, 36 ms (stage 151.0: task 373)) records read: 23 local bytes read total (min, med, max (stageId: taskId)) 1741.0 B (71.0 B, 568.0 B, 960.0 B (stage 170.0: task 387)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 170.0: task 388)) remote bytes read: 0.0 B local blocks read: 23 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 832.0 B (32.0 B, 72.0 B, 72.0 B (stage 151.0: task 363)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 1741.0 B (71.0 B, 151.0 B, 151.0 B (stage 151.0: task 363))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n295 ms (5 ms, 22 ms, 38 ms (stage 151.0: task 369))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 30 ms (0 ms, 1 ms, 11 ms (stage 151.0: task 363)) peak memory total (min, med, max (stageId: taskId)) 3.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 151.0: task 357)) number of output rows: 23 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))\n266 ms (8 ms, 18 ms, 44 ms (stage 151.0: task 357))"; 12 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 22 ms (0 ms, 1 ms, 6 ms (stage 151.0: task 359)) peak memory total (min, med, max (stageId: taskId)) 832.8 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 151.0: task 357)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 151.0: task 357))"]; } 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.9 s (42 ms, 150 ms, 199 ms (stage 137.0: task 330)) 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 151.0: task 359)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 151.0: task 357)) 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 137.0: task 338)) 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 137.0: task 338))"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n980 ms (30 ms, 67 ms, 135 ms (stage 137.0: task 318))"; 16 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 61 ms (2 ms, 5 ms, 8 ms (stage 137.0: task 318)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 137.0: task 317)) number of output rows: 14,814 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 137.0: task 317))"]; } 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 (43 ms, 155 ms, 206 ms (stage 132.0: task 288)) 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 137.0: task 338)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 137.0: task 317)) 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 132.0: task 280)) 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 132.0: task 280))"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n889 ms (25 ms, 82 ms, 116 ms (stage 132.0: task 282))"; 20 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 521 ms (14 ms, 49 ms, 76 ms (stage 132.0: task 284)) peak memory total (min, med, max (stageId: taskId)) 771.0 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 132.0: task 280)) number of output rows: 14,814 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 132.0: task 280))"]; 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))\n579 ms (18 ms, 52 ms, 79 ms (stage 132.0: task 284))"; 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))\n595 ms (19 ms, 53 ms, 80 ms (stage 132.0: task 284))"; 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)) 61 ms (3 ms, 4 ms, 16 ms (stage 132.0: task 293)) 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_FD05C767_4723_493B_BD22_13134A191D26#22342], functions=[count(1)])

WholeStageCodegen (7)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_FD05C767_4723_493B_BD22_13134A191D26#22342, 200), true, [id=#3175]

HashAggregate(keys=[COL_FD05C767_4723_493B_BD22_13134A191D26#22342], functions=[partial_count(1)])

Project [str_extract_by_str(COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, :, LEFT) AS COL_FD05C767_4723_493B_BD22_13134A191D26#22342]

Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L > 1)

WholeStageCodegen (6)

Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, CONST#21914 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859], [CONST#21914 DESC NULLS LAST]

Sort [COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859 ASC NULLS FIRST, CONST#21914 DESC NULLS LAST], false, 0

WholeStageCodegen (5)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, 200), true, [id=#2861]

HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762], functions=[])

WholeStageCodegen (4)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762, 200), true, [id=#2494]

Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557), : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762]

WholeStageCodegen (3)

Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21530), [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557]

Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21233 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21234 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, col0#21303 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, str_split(col1#21304, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21530]

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

WholeStageCodegen (2)

Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21235, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21236, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21237, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21238), [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21233, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21234], false, [col0#21303, col1#21304]

Project [CODE_26562#21084 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21233, CLIENT_26563#21083 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21234, ALCYON_26574#21076 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21235, CENTRAVET_26575#21077 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21236, COVETO_26576#21086 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21237, NEFTYS_26577#21096 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21238]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ALCYON_26574#21076,CENTRAVET_26575#21077,CLIENT_26563#21083,CODE_26562#21084,COVETO_26576#21086,NEFTYS_26577#21096] 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_9BC25268_349F_4392_9581_3228F517B390#22448 AS COL_9BC25268_349F_4392_9581_3228F517B390#22456, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22449L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22457L]
      +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#22438 AS COL_9BC25268_349F_4392_9581_3228F517B390#22448, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22439L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22449L]
         +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#22419 AS COL_9BC25268_349F_4392_9581_3228F517B390#22438, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22420L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22439L]
            +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#22411 AS COL_9BC25268_349F_4392_9581_3228F517B390#22419, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22412L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22420L]
               +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#22361 AS COL_9BC25268_349F_4392_9581_3228F517B390#22411, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22380L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22412L]
                  +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#22361, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22380L]
                     +- Aggregate [COL_FD05C767_4723_493B_BD22_13134A191D26#22342], [COL_FD05C767_4723_493B_BD22_13134A191D26#22342 AS COL_9BC25268_349F_4392_9581_3228F517B390#22361, 1 AS NULL_1#22382, count(1) AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22380L]
                        +- Project [COL_8343D674_F7B4_49D3_9485_902B2BAAF953#22310, COL_2276CD98_E802_486D_8515_19B39DABC591#22311, COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#22312, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22313L, str_extract_by_str(COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#22312, cast(: as string), cast(LEFT as string)) AS COL_FD05C767_4723_493B_BD22_13134A191D26#22342]
                           +- Project [COL_8343D674_F7B4_49D3_9485_902B2BAAF953#22310, COL_2276CD98_E802_486D_8515_19B39DABC591#22311, COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#22312, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22313L]
                              +- Project [cast(UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22294 as string) AS COL_8343D674_F7B4_49D3_9485_902B2BAAF953#22310, cast(UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22295 as string) AS COL_2276CD98_E802_486D_8515_19B39DABC591#22311, cast(UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#22296 as string) AS COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#22312, cast(UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22297L as bigint) AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22313L]
                                 +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22229 AS UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22294, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22230 AS UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22295, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22231 AS UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#22296, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22232L AS UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22297L]
                                    +- SubqueryAlias UNITE_CODE_CENT_36755117
                                       +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22186 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22229, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22187 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22230, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22190 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22231, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22191L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22232L]
                                          +- Filter CASE WHEN isnull((COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22191L > cast(1 as bigint))) THEN false ELSE (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22191L > cast(1 as bigint)) END
                                             +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22166 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22186, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22167 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22187, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22168 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22188, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22169 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22189, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22170 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22190, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22191L]
                                                +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22166, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22167, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22168, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22169, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22170, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L]
                                                   +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L]
                                                      +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, CONST#21914, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L]
                                                         +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, CONST#21914, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L]
                                                            +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, CONST#21914 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859], [CONST#21914 DESC NULLS LAST]
                                                               +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, CONST#21914]
                                                                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, 1 AS CONST#21914]
                                                                     +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21778 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21779 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21780 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21781 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21782 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859]
                                                                        +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21778, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21779, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21780, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21781, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21782]
                                                                           +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21778, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21779, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21780, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21781, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21782]
                                                                              +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21758, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21759, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21760, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21761, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21758 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21778, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21759 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21779, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21760 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21780, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21761 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21781, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#21782, 1 AS NULL_1#21793]
                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21733 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21758, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21734 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21759, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21735 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21760, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21736 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21761, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21715 AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762]
                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21635 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21733, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21636 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21734, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21637 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21735, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21638 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21736, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21715]
                                                                                       +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21635, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21636, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21637, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21638, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21637, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21638), cast( :  as string)) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21715]
                                                                                          +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21625 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21635, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21626 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21636, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21627 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21637, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21628 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21638]
                                                                                             +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21625, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21626, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21627, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21628]
                                                                                                +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21529, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557]
                                                                                                   +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21529, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21530, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557]
                                                                                                      +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21530), false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557]
                                                                                                         +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21511 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21512 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21513 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21514 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21529, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21503 AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21530]
                                                                                                            +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21495 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21511, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21496 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21512, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21497 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21513, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21498 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21514, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21503]
                                                                                                               +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21495, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21496, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21497, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21498, str_split(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21498, cast(- as string)) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21503]
                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21455 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21495, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21456 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21496, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21457 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21497, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21458 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21498]
                                                                                                                     +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21363 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21455, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21364 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21456, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21365 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21457, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21366 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21458]
                                                                                                                        +- Filter NOT (str_remove_accent(upper(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21366)) <=> )
                                                                                                                           +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21327 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21363, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21328 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21364, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21329 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21365, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21330 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21366]
                                                                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21245 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21327, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21246 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21328, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21309 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21329, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21314 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21330]
                                                                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21245, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21246, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21309, col1#21304 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21314]
                                                                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21245, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21246, col0#21303 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21309, col1#21304]
                                                                                                                                       +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21233 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21245, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21234 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21246, col0#21303, col1#21304]
                                                                                                                                          +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21235, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21236, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21237, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21238), false, [col0#21303, col1#21304]
                                                                                                                                             +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21221 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21233, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21222 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21234, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21223 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21235, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21224 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21236, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21225 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21237, COL_254FB614_FB51_4228_B230_A642F782E3FD#21226 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21238]
                                                                                                                                                +- Project [cast(BASE_BOHRINGER_26561_CODE_26562#21168 as string) AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21221, cast(BASE_BOHRINGER_26561_CLIENT_26563#21167 as string) AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21222, cast(BASE_BOHRINGER_26561_ALCYON_26574#21160 as string) AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21223, cast(BASE_BOHRINGER_26561_CENTRAVET_26575#21161 as string) AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21224, cast(BASE_BOHRINGER_26561_COVETO_26576#21170 as string) AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21225, cast(BASE_BOHRINGER_26561_NEFTYS_26577#21180 as string) AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21226]
                                                                                                                                                   +- Project [ADRESSE_26564#21075 AS BASE_BOHRINGER_26561_ADRESSE_26564#21159, ALCYON_26574#21076 AS BASE_BOHRINGER_26561_ALCYON_26574#21160, CENTRAVET_26575#21077 AS BASE_BOHRINGER_26561_CENTRAVET_26575#21161, CF_GLOBAL_AV_26589#21078 AS BASE_BOHRINGER_26561_CF_GLOBAL_AV_26589#21162, CF_GLOBAL_EQ_26585#21079 AS BASE_BOHRINGER_26561_CF_GLOBAL_EQ_26585#21163, CF_GLOBAL_PO_26587#21080 AS BASE_BOHRINGER_26561_CF_GLOBAL_PO_26587#21164, CF_GLOBAL_PV_26581#21081 AS BASE_BOHRINGER_26561_CF_GLOBAL_PV_26581#21165, CF_GLOBAL_RU_26583#21082 AS BASE_BOHRINGER_26561_CF_GLOBAL_RU_26583#21166, CLIENT_26563#21083 AS BASE_BOHRINGER_26561_CLIENT_26563#21167, CODE_26562#21084 AS BASE_BOHRINGER_26561_CODE_26562#21168, CODE_ORDINAL_26573#21085 AS BASE_BOHRINGER_26561_CODE_ORDINAL_26573#21169, COVETO_26576#21086 AS BASE_BOHRINGER_26561_COVETO_26576#21170, CP_26565#21087 AS BASE_BOHRINGER_26561_CP_26565#21171, GIE_AV_22_26588#21088 AS BASE_BOHRINGER_26561_GIE_AV_22_26588#21172, GIE_EQ_22_26584#21089 AS BASE_BOHRINGER_26561_GIE_EQ_22_26584#21173, GIE_MAX_26579#21090 AS BASE_BOHRINGER_26561_GIE_MAX_26579#21174, GIE_PO_22_26586#21091 AS BASE_BOHRINGER_26561_GIE_PO_22_26586#21175, GIE_PV_22_26580#21092 AS BASE_BOHRINGER_26561_GIE_PV_22_26580#21176, GIE_RU_22_26582#21093 AS BASE_BOHRINGER_26561_GIE_RU_22_26582#21177, ID_VETFAMILY_26578#21094 AS BASE_BOHRINGER_26561_ID_VETFAMILY_26578#21178, MAIL_26568#21095 AS BASE_BOHRINGER_26561_MAIL_26568#21179, NEFTYS_26577#21096 AS BASE_BOHRINGER_26561_NEFTYS_26577#21180, SIRET_26572#21097 AS BASE_BOHRINGER_26561_SIRET_26572#21181, STATUT_26570#21098 AS BASE_BOHRINGER_26561_STATUT_26570#21182, ... 4 more fields]
                                                                                                                                                      +- SubqueryAlias BASE_BOHRINGER_26561117
                                                                                                                                                         +- Relation[ADRESSE_26564#21075,ALCYON_26574#21076,CENTRAVET_26575#21077,CF_GLOBAL_AV_26589#21078,CF_GLOBAL_EQ_26585#21079,CF_GLOBAL_PO_26587#21080,CF_GLOBAL_PV_26581#21081,CF_GLOBAL_RU_26583#21082,CLIENT_26563#21083,CODE_26562#21084,CODE_ORDINAL_26573#21085,COVETO_26576#21086,CP_26565#21087,GIE_AV_22_26588#21088,GIE_EQ_22_26584#21089,GIE_MAX_26579#21090,GIE_PO_22_26586#21091,GIE_PV_22_26580#21092,GIE_RU_22_26582#21093,ID_VETFAMILY_26578#21094,MAIL_26568#21095,NEFTYS_26577#21096,SIRET_26572#21097,STATUT_26570#21098,... 4 more fields] parquet

== Analyzed Logical Plan ==
COL_9BC25268_349F_4392_9581_3228F517B390: string, COL_56C6B496_B95B_4192_9CA3_E29527B922BA: bigint
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#22448 AS COL_9BC25268_349F_4392_9581_3228F517B390#22456, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22449L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22457L]
      +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#22438 AS COL_9BC25268_349F_4392_9581_3228F517B390#22448, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22439L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22449L]
         +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#22419 AS COL_9BC25268_349F_4392_9581_3228F517B390#22438, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22420L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22439L]
            +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#22411 AS COL_9BC25268_349F_4392_9581_3228F517B390#22419, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22412L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22420L]
               +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#22361 AS COL_9BC25268_349F_4392_9581_3228F517B390#22411, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22380L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22412L]
                  +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#22361, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22380L]
                     +- Aggregate [COL_FD05C767_4723_493B_BD22_13134A191D26#22342], [COL_FD05C767_4723_493B_BD22_13134A191D26#22342 AS COL_9BC25268_349F_4392_9581_3228F517B390#22361, 1 AS NULL_1#22382, count(1) AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22380L]
                        +- Project [COL_8343D674_F7B4_49D3_9485_902B2BAAF953#22310, COL_2276CD98_E802_486D_8515_19B39DABC591#22311, COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#22312, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22313L, str_extract_by_str(COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#22312, cast(: as string), cast(LEFT as string)) AS COL_FD05C767_4723_493B_BD22_13134A191D26#22342]
                           +- Project [COL_8343D674_F7B4_49D3_9485_902B2BAAF953#22310, COL_2276CD98_E802_486D_8515_19B39DABC591#22311, COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#22312, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22313L]
                              +- Project [cast(UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22294 as string) AS COL_8343D674_F7B4_49D3_9485_902B2BAAF953#22310, cast(UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22295 as string) AS COL_2276CD98_E802_486D_8515_19B39DABC591#22311, cast(UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#22296 as string) AS COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#22312, cast(UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22297L as bigint) AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#22313L]
                                 +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22229 AS UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22294, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22230 AS UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22295, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22231 AS UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#22296, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22232L AS UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22297L]
                                    +- SubqueryAlias UNITE_CODE_CENT_36755117
                                       +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22186 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22229, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22187 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22230, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22190 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22231, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22191L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22232L]
                                          +- Filter CASE WHEN isnull((COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22191L > cast(1 as bigint))) THEN false ELSE (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22191L > cast(1 as bigint)) END
                                             +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22166 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22186, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22167 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22187, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22168 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22188, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22169 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22189, COL_163AF726_C329_42A2_AFC0_E42939FD4852#22170 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22190, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#22191L]
                                                +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#22166, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#22167, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#22168, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#22169, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#22170, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L]
                                                   +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L]
                                                      +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, CONST#21914, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L]
                                                         +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, CONST#21914, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L]
                                                            +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, CONST#21914 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859], [CONST#21914 DESC NULLS LAST]
                                                               +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, CONST#21914]
                                                                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, 1 AS CONST#21914]
                                                                     +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21778 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21779 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21856, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21780 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21857, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21781 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21858, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21782 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859]
                                                                        +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21778, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21779, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21780, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21781, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21782]
                                                                           +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21778, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21779, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21780, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21781, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21782]
                                                                              +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21758, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21759, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21760, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21761, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21758 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21778, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21759 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#21779, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21760 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#21780, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21761 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#21781, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#21782, 1 AS NULL_1#21793]
                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21733 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21758, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21734 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21759, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21735 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21760, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21736 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21761, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21715 AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762]
                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21635 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21733, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21636 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21734, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21637 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21735, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21638 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21736, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21715]
                                                                                       +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21635, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21636, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21637, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21638, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21637, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21638), cast( :  as string)) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21715]
                                                                                          +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21625 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21635, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21626 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21636, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21627 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21637, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21628 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21638]
                                                                                             +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21625, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21626, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21627, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21628]
                                                                                                +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21529, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557]
                                                                                                   +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21529, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21530, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557]
                                                                                                      +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21530), false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557]
                                                                                                         +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21511 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21512 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21513 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21514 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21529, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21503 AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21530]
                                                                                                            +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21495 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21511, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21496 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21512, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21497 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21513, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21498 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21514, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21503]
                                                                                                               +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21495, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21496, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21497, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21498, str_split(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21498, cast(- as string)) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21503]
                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21455 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21495, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21456 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21496, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21457 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21497, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21458 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21498]
                                                                                                                     +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21363 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21455, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21364 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21456, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21365 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21457, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21366 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21458]
                                                                                                                        +- Filter NOT (str_remove_accent(upper(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21366)) <=> )
                                                                                                                           +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21327 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21363, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21328 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21364, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21329 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21365, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21330 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21366]
                                                                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21245 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21327, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21246 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21328, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21309 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21329, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21314 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21330]
                                                                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21245, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21246, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21309, col1#21304 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#21314]
                                                                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21245, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21246, col0#21303 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21309, col1#21304]
                                                                                                                                       +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21233 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21245, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21234 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21246, col0#21303, col1#21304]
                                                                                                                                          +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21235, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21236, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21237, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21238), false, [col0#21303, col1#21304]
                                                                                                                                             +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21221 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21233, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21222 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21234, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21223 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21235, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21224 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21236, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21225 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21237, COL_254FB614_FB51_4228_B230_A642F782E3FD#21226 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21238]
                                                                                                                                                +- Project [cast(BASE_BOHRINGER_26561_CODE_26562#21168 as string) AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21221, cast(BASE_BOHRINGER_26561_CLIENT_26563#21167 as string) AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21222, cast(BASE_BOHRINGER_26561_ALCYON_26574#21160 as string) AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21223, cast(BASE_BOHRINGER_26561_CENTRAVET_26575#21161 as string) AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21224, cast(BASE_BOHRINGER_26561_COVETO_26576#21170 as string) AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21225, cast(BASE_BOHRINGER_26561_NEFTYS_26577#21180 as string) AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21226]
                                                                                                                                                   +- Project [ADRESSE_26564#21075 AS BASE_BOHRINGER_26561_ADRESSE_26564#21159, ALCYON_26574#21076 AS BASE_BOHRINGER_26561_ALCYON_26574#21160, CENTRAVET_26575#21077 AS BASE_BOHRINGER_26561_CENTRAVET_26575#21161, CF_GLOBAL_AV_26589#21078 AS BASE_BOHRINGER_26561_CF_GLOBAL_AV_26589#21162, CF_GLOBAL_EQ_26585#21079 AS BASE_BOHRINGER_26561_CF_GLOBAL_EQ_26585#21163, CF_GLOBAL_PO_26587#21080 AS BASE_BOHRINGER_26561_CF_GLOBAL_PO_26587#21164, CF_GLOBAL_PV_26581#21081 AS BASE_BOHRINGER_26561_CF_GLOBAL_PV_26581#21165, CF_GLOBAL_RU_26583#21082 AS BASE_BOHRINGER_26561_CF_GLOBAL_RU_26583#21166, CLIENT_26563#21083 AS BASE_BOHRINGER_26561_CLIENT_26563#21167, CODE_26562#21084 AS BASE_BOHRINGER_26561_CODE_26562#21168, CODE_ORDINAL_26573#21085 AS BASE_BOHRINGER_26561_CODE_ORDINAL_26573#21169, COVETO_26576#21086 AS BASE_BOHRINGER_26561_COVETO_26576#21170, CP_26565#21087 AS BASE_BOHRINGER_26561_CP_26565#21171, GIE_AV_22_26588#21088 AS BASE_BOHRINGER_26561_GIE_AV_22_26588#21172, GIE_EQ_22_26584#21089 AS BASE_BOHRINGER_26561_GIE_EQ_22_26584#21173, GIE_MAX_26579#21090 AS BASE_BOHRINGER_26561_GIE_MAX_26579#21174, GIE_PO_22_26586#21091 AS BASE_BOHRINGER_26561_GIE_PO_22_26586#21175, GIE_PV_22_26580#21092 AS BASE_BOHRINGER_26561_GIE_PV_22_26580#21176, GIE_RU_22_26582#21093 AS BASE_BOHRINGER_26561_GIE_RU_22_26582#21177, ID_VETFAMILY_26578#21094 AS BASE_BOHRINGER_26561_ID_VETFAMILY_26578#21178, MAIL_26568#21095 AS BASE_BOHRINGER_26561_MAIL_26568#21179, NEFTYS_26577#21096 AS BASE_BOHRINGER_26561_NEFTYS_26577#21180, SIRET_26572#21097 AS BASE_BOHRINGER_26561_SIRET_26572#21181, STATUT_26570#21098 AS BASE_BOHRINGER_26561_STATUT_26570#21182, ... 4 more fields]
                                                                                                                                                      +- SubqueryAlias BASE_BOHRINGER_26561117
                                                                                                                                                         +- Relation[ADRESSE_26564#21075,ALCYON_26574#21076,CENTRAVET_26575#21077,CF_GLOBAL_AV_26589#21078,CF_GLOBAL_EQ_26585#21079,CF_GLOBAL_PO_26587#21080,CF_GLOBAL_PV_26581#21081,CF_GLOBAL_RU_26583#21082,CLIENT_26563#21083,CODE_26562#21084,CODE_ORDINAL_26573#21085,COVETO_26576#21086,CP_26565#21087,GIE_AV_22_26588#21088,GIE_EQ_22_26584#21089,GIE_MAX_26579#21090,GIE_PO_22_26586#21091,GIE_PV_22_26580#21092,GIE_RU_22_26582#21093,ID_VETFAMILY_26578#21094,MAIL_26568#21095,NEFTYS_26577#21096,SIRET_26572#21097,STATUT_26570#21098,... 4 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Aggregate [COL_FD05C767_4723_493B_BD22_13134A191D26#22342], [COL_FD05C767_4723_493B_BD22_13134A191D26#22342 AS COL_9BC25268_349F_4392_9581_3228F517B390#22456, count(1) AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22457L]
      +- Project [str_extract_by_str(COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, :, LEFT) AS COL_FD05C767_4723_493B_BD22_13134A191D26#22342]
         +- Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L > 1)
            +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, CONST#21914 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859], [CONST#21914 DESC NULLS LAST]
               +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, 1 AS CONST#21914]
                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557),  : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762]
                     +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21530), [3], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557]
                        +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21233 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21234 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, col0#21303 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, str_split(col1#21304, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21530]
                           +- Filter NOT (str_remove_accent(upper(col1#21304)) <=> )
                              +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21235, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21236, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21237, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21238), [2, 3, 4, 5], false, [col0#21303, col1#21304]
                                 +- Project [CODE_26562#21084 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21233, CLIENT_26563#21083 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21234, ALCYON_26574#21076 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21235, CENTRAVET_26575#21077 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21236, COVETO_26576#21086 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21237, NEFTYS_26577#21096 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21238]
                                    +- Relation[ADRESSE_26564#21075,ALCYON_26574#21076,CENTRAVET_26575#21077,CF_GLOBAL_AV_26589#21078,CF_GLOBAL_EQ_26585#21079,CF_GLOBAL_PO_26587#21080,CF_GLOBAL_PV_26581#21081,CF_GLOBAL_RU_26583#21082,CLIENT_26563#21083,CODE_26562#21084,CODE_ORDINAL_26573#21085,COVETO_26576#21086,CP_26565#21087,GIE_AV_22_26588#21088,GIE_EQ_22_26584#21089,GIE_MAX_26579#21090,GIE_PO_22_26586#21091,GIE_PV_22_26580#21092,GIE_RU_22_26582#21093,ID_VETFAMILY_26578#21094,MAIL_26568#21095,NEFTYS_26577#21096,SIRET_26572#21097,STATUT_26570#21098,... 4 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(7) HashAggregate(keys=[COL_FD05C767_4723_493B_BD22_13134A191D26#22342], functions=[count(1)], output=[COL_9BC25268_349F_4392_9581_3228F517B390#22456, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#22457L])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 2
            +- Exchange hashpartitioning(COL_FD05C767_4723_493B_BD22_13134A191D26#22342, 200), true, [id=#3175]
               +- *(6) HashAggregate(keys=[COL_FD05C767_4723_493B_BD22_13134A191D26#22342], functions=[partial_count(1)], output=[COL_FD05C767_4723_493B_BD22_13134A191D26#22342, count#22565L])
                  +- *(6) Project [str_extract_by_str(COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, :, LEFT) AS COL_FD05C767_4723_493B_BD22_13134A191D26#22342]
                     +- *(6) Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L > 1)
                        +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, CONST#21914 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#21954L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859], [CONST#21914 DESC NULLS LAST]
                           +- *(5) Sort [COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859 ASC NULLS FIRST, CONST#21914 DESC NULLS LAST], false, 0
                              +- CustomShuffleReader coalesced
                                 +- ShuffleQueryStage 1
                                    +- Exchange hashpartitioning(COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, 200), true, [id=#2861]
                                       +- *(4) HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762], functions=[], output=[COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#21855, COL_163AF726_C329_42A2_AFC0_E42939FD4852#21859, CONST#21914])
                                          +- CustomShuffleReader coalesced
                                             +- ShuffleQueryStage 0
                                                +- Exchange hashpartitioning(COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762, 200), true, [id=#2494]
                                                   +- *(3) HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762], functions=[], output=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762])
                                                      +- *(3) Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557),  : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#21762]
                                                         +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21530), [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#21557]
                                                            +- *(2) Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21233 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#21526, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21234 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#21527, col0#21303 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#21528, str_split(col1#21304, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#21530]
                                                               +- *(2) Filter NOT (str_remove_accent(upper(col1#21304)) <=> )
                                                                  +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21235, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21236, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#21237, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#21238), [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21233, COL_A7246A72_2676_467D_80BD_2A058C09CA95#21234], false, [col0#21303, col1#21304]
                                                                     +- *(1) Project [CODE_26562#21084 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#21233, CLIENT_26563#21083 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#21234, ALCYON_26574#21076 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#21235, CENTRAVET_26575#21077 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#21236, COVETO_26576#21086 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#21237, NEFTYS_26577#21096 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#21238]
                                                                        +- *(1) ColumnarToRow
                                                                           +- FileScan parquet [ALCYON_26574#21076,CENTRAVET_26575#21077,CLIENT_26563#21083,CODE_26562#21084,COVETO_26576#21086,NEFTYS_26577#21096] 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...