DC2 - Details for Query 30

Details for Query 30

Submitted Time: 2026/03/05 07:13:37
Duration: 3 s
Succeeded Jobs: 47 50 53 56 57

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 92.0: task 238))"; 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 92.0: task 238)) peak memory total (min, med, max (stageId: taskId)) 257.3 MiB (256.0 KiB, 64.3 MiB, 64.3 MiB (stage 92.0: task 238)) number of output rows: 4 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 92.0: task 238))"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 23 shuffle write time total (min, med, max (stageId: taskId)) 125 ms (3 ms, 10 ms, 19 ms (stage 80.0: task 228)) 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 96.0: task 240)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 92.0: task 238)) 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 80.0: task 232)) 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 80.0: task 232))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n368 ms (5 ms, 35 ms, 46 ms (stage 80.0: task 228))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 117 ms (0 ms, 10 ms, 15 ms (stage 80.0: task 229)) peak memory total (min, med, max (stageId: taskId)) 3.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 80.0: task 232)) 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))\n635 ms (17 ms, 57 ms, 70 ms (stage 80.0: task 221))"; 12 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 62 ms (0 ms, 4 ms, 20 ms (stage 80.0: task 234)) peak memory total (min, med, max (stageId: taskId)) 832.8 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 80.0: task 232)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 80.0: task 232))"]; } 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 (27 ms, 163 ms, 224 ms (stage 71.0: task 186)) 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 80.0: task 222)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 80.0: task 232)) 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 71.0: task 202)) 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 71.0: task 202))"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n488 ms (23 ms, 28 ms, 76 ms (stage 71.0: task 203))"; 16 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 46 ms (1 ms, 3 ms, 8 ms (stage 71.0: task 197)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 71.0: task 186)) number of output rows: 14,814 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 71.0: task 186))"]; } 17 [labelType="html" label=" CustomShuffleReader "]; 18 [labelType="html" label="Exchange shuffle records written: 14,814 shuffle write time total (min, med, max (stageId: taskId)) 2.7 s (93 ms, 212 ms, 378 ms (stage 65.0: task 148)) 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 71.0: task 202)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 71.0: task 186)) 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 65.0: task 146)) 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 65.0: task 146))"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.0 s (22 ms, 88 ms, 182 ms (stage 65.0: task 146))"; 20 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 581 ms (13 ms, 51 ms, 110 ms (stage 65.0: task 146)) peak memory total (min, med, max (stageId: taskId)) 771.0 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 65.0: task 146)) number of output rows: 14,814 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 65.0: task 146))"]; 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))\n628 ms (16 ms, 55 ms, 115 ms (stage 65.0: task 150))"; 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))\n645 ms (17 ms, 55 ms, 116 ms (stage 65.0: task 150))"; 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)) 110 ms (3 ms, 6 ms, 31 ms (stage 65.0: task 150)) 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#5473], functions=[count(1)])

WholeStageCodegen (7)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_FD05C767_4723_493B_BD22_13134A191D26#5473, 200), true, [id=#1658]

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

Project [str_extract_by_str(COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, :, LEFT) AS COL_FD05C767_4723_493B_BD22_13134A191D26#5473]

Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L > 1)

WholeStageCodegen (6)

Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, CONST#4890 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821], [CONST#4890 DESC NULLS LAST]

Sort [COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821 ASC NULLS FIRST, CONST#4890 DESC NULLS LAST], false, 0

WholeStageCodegen (5)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, 200), true, [id=#1412]

HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672], functions=[])

WholeStageCodegen (4)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672, 200), true, [id=#974]

Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597), : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672]

WholeStageCodegen (3)

Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4562), [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597]

Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4429 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4430 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, col0#4443 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, str_split(col1#4444, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4562]

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

WholeStageCodegen (2)

Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4431, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4432, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4433, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#4434), [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4429, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4430], false, [col0#4443, col1#4444]

Project [CODE_26562#4258 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4429, CLIENT_26563#4257 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4430, ALCYON_26574#4250 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4431, CENTRAVET_26575#4251 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4432, COVETO_26576#4260 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4433, NEFTYS_26577#4270 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4434]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ALCYON_26574#4250,CENTRAVET_26575#4251,CLIENT_26563#4257,CODE_26562#4258,COVETO_26576#4260,NEFTYS_26577#4270] 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#5569 AS COL_9BC25268_349F_4392_9581_3228F517B390#5585, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5570L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5586L]
      +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#5554 AS COL_9BC25268_349F_4392_9581_3228F517B390#5569, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5555L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5570L]
         +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#5543 AS COL_9BC25268_349F_4392_9581_3228F517B390#5554, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5544L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5555L]
            +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#5539 AS COL_9BC25268_349F_4392_9581_3228F517B390#5543, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5540L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5544L]
               +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#5500 AS COL_9BC25268_349F_4392_9581_3228F517B390#5539, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5514L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5540L]
                  +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#5500, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5514L]
                     +- Aggregate [COL_FD05C767_4723_493B_BD22_13134A191D26#5473], [COL_FD05C767_4723_493B_BD22_13134A191D26#5473 AS COL_9BC25268_349F_4392_9581_3228F517B390#5500, 1 AS NULL_1#5516, count(1) AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5514L]
                        +- Project [COL_8343D674_F7B4_49D3_9485_902B2BAAF953#5399, COL_2276CD98_E802_486D_8515_19B39DABC591#5400, COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#5401, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5402L, str_extract_by_str(COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#5401, cast(: as string), cast(LEFT as string)) AS COL_FD05C767_4723_493B_BD22_13134A191D26#5473]
                           +- Project [COL_8343D674_F7B4_49D3_9485_902B2BAAF953#5399, COL_2276CD98_E802_486D_8515_19B39DABC591#5400, COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#5401, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5402L]
                              +- Project [cast(UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5376 as string) AS COL_8343D674_F7B4_49D3_9485_902B2BAAF953#5399, cast(UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5377 as string) AS COL_2276CD98_E802_486D_8515_19B39DABC591#5400, cast(UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#5378 as string) AS COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#5401, cast(UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5379L as bigint) AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5402L]
                                 +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5248 AS UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5376, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5249 AS UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5377, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5250 AS UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#5378, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5251L AS UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5379L]
                                    +- SubqueryAlias UNITE_CODE_CENT_36755115
                                       +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5138 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5248, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5139 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5249, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5142 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5250, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5143L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5251L]
                                          +- Filter CASE WHEN isnull((COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5143L > cast(1 as bigint))) THEN false ELSE (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5143L > cast(1 as bigint)) END
                                             +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5107 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5138, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5108 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5139, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5109 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5140, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5110 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5141, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5111 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5142, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5143L]
                                                +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5107, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5108, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5109, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5110, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5111, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L]
                                                   +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L]
                                                      +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, CONST#4890, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L]
                                                         +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, CONST#4890, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L]
                                                            +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, CONST#4890 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821], [CONST#4890 DESC NULLS LAST]
                                                               +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, CONST#4890]
                                                                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, 1 AS CONST#4890]
                                                                     +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4678 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4679 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4680 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4681 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4682 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821]
                                                                        +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4678, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4679, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4680, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4681, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4682]
                                                                           +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4678, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4679, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4680, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4681, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4682]
                                                                              +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4668, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4669, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4670, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4671, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4668 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4678, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4669 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4679, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4670 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4680, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4671 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4681, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#4682, 1 AS NULL_1#4688]
                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4659 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4668, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4660 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4669, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4661 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4670, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4662 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4671, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4653 AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672]
                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4645 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4659, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4646 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4660, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4647 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4661, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4648 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4662, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4653]
                                                                                       +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4645, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4646, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4647, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4648, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4647, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4648), cast( :  as string)) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4653]
                                                                                          +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4637 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4645, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4638 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4646, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4639 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4647, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4640 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4648]
                                                                                             +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4637, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4638, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4639, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4640]
                                                                                                +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4561, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597]
                                                                                                   +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4561, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4562, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597]
                                                                                                      +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4562), false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597]
                                                                                                         +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4549 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4550 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4551 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4552 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4561, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4543 AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4562]
                                                                                                            +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4535 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4549, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4536 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4550, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4537 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4551, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4538 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4552, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4543]
                                                                                                               +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4535, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4536, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4537, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4538, str_split(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4538, cast(- as string)) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4543]
                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4527 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4535, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4528 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4536, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4529 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4537, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4530 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4538]
                                                                                                                     +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4497 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4527, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4498 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4528, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4499 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4529, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4500 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4530]
                                                                                                                        +- Filter NOT (str_remove_accent(upper(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4500)) <=> )
                                                                                                                           +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4467 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4497, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4468 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4498, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4469 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4499, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4470 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4500]
                                                                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4441 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4467, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4442 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4468, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4449 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4469, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4454 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4470]
                                                                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4441, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4442, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4449, col1#4444 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4454]
                                                                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4441, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4442, col0#4443 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4449, col1#4444]
                                                                                                                                       +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4429 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4441, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4430 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4442, col0#4443, col1#4444]
                                                                                                                                          +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4431, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4432, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4433, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#4434), false, [col0#4443, col1#4444]
                                                                                                                                             +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4417 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4429, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4418 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4430, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4419 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4431, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4420 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4432, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4421 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4433, COL_254FB614_FB51_4228_B230_A642F782E3FD#4422 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4434]
                                                                                                                                                +- Project [cast(BASE_BOHRINGER_26561_CODE_26562#4364 as string) AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4417, cast(BASE_BOHRINGER_26561_CLIENT_26563#4363 as string) AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4418, cast(BASE_BOHRINGER_26561_ALCYON_26574#4356 as string) AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4419, cast(BASE_BOHRINGER_26561_CENTRAVET_26575#4357 as string) AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4420, cast(BASE_BOHRINGER_26561_COVETO_26576#4366 as string) AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4421, cast(BASE_BOHRINGER_26561_NEFTYS_26577#4376 as string) AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4422]
                                                                                                                                                   +- Project [ADRESSE_26564#4249 AS BASE_BOHRINGER_26561_ADRESSE_26564#4355, ALCYON_26574#4250 AS BASE_BOHRINGER_26561_ALCYON_26574#4356, CENTRAVET_26575#4251 AS BASE_BOHRINGER_26561_CENTRAVET_26575#4357, CF_GLOBAL_AV_26589#4252 AS BASE_BOHRINGER_26561_CF_GLOBAL_AV_26589#4358, CF_GLOBAL_EQ_26585#4253 AS BASE_BOHRINGER_26561_CF_GLOBAL_EQ_26585#4359, CF_GLOBAL_PO_26587#4254 AS BASE_BOHRINGER_26561_CF_GLOBAL_PO_26587#4360, CF_GLOBAL_PV_26581#4255 AS BASE_BOHRINGER_26561_CF_GLOBAL_PV_26581#4361, CF_GLOBAL_RU_26583#4256 AS BASE_BOHRINGER_26561_CF_GLOBAL_RU_26583#4362, CLIENT_26563#4257 AS BASE_BOHRINGER_26561_CLIENT_26563#4363, CODE_26562#4258 AS BASE_BOHRINGER_26561_CODE_26562#4364, CODE_ORDINAL_26573#4259 AS BASE_BOHRINGER_26561_CODE_ORDINAL_26573#4365, COVETO_26576#4260 AS BASE_BOHRINGER_26561_COVETO_26576#4366, CP_26565#4261 AS BASE_BOHRINGER_26561_CP_26565#4367, GIE_AV_22_26588#4262 AS BASE_BOHRINGER_26561_GIE_AV_22_26588#4368, GIE_EQ_22_26584#4263 AS BASE_BOHRINGER_26561_GIE_EQ_22_26584#4369, GIE_MAX_26579#4264 AS BASE_BOHRINGER_26561_GIE_MAX_26579#4370, GIE_PO_22_26586#4265 AS BASE_BOHRINGER_26561_GIE_PO_22_26586#4371, GIE_PV_22_26580#4266 AS BASE_BOHRINGER_26561_GIE_PV_22_26580#4372, GIE_RU_22_26582#4267 AS BASE_BOHRINGER_26561_GIE_RU_22_26582#4373, ID_VETFAMILY_26578#4268 AS BASE_BOHRINGER_26561_ID_VETFAMILY_26578#4374, MAIL_26568#4269 AS BASE_BOHRINGER_26561_MAIL_26568#4375, NEFTYS_26577#4270 AS BASE_BOHRINGER_26561_NEFTYS_26577#4376, SIRET_26572#4271 AS BASE_BOHRINGER_26561_SIRET_26572#4377, STATUT_26570#4272 AS BASE_BOHRINGER_26561_STATUT_26570#4378, ... 4 more fields]
                                                                                                                                                      +- SubqueryAlias BASE_BOHRINGER_26561115
                                                                                                                                                         +- Relation[ADRESSE_26564#4249,ALCYON_26574#4250,CENTRAVET_26575#4251,CF_GLOBAL_AV_26589#4252,CF_GLOBAL_EQ_26585#4253,CF_GLOBAL_PO_26587#4254,CF_GLOBAL_PV_26581#4255,CF_GLOBAL_RU_26583#4256,CLIENT_26563#4257,CODE_26562#4258,CODE_ORDINAL_26573#4259,COVETO_26576#4260,CP_26565#4261,GIE_AV_22_26588#4262,GIE_EQ_22_26584#4263,GIE_MAX_26579#4264,GIE_PO_22_26586#4265,GIE_PV_22_26580#4266,GIE_RU_22_26582#4267,ID_VETFAMILY_26578#4268,MAIL_26568#4269,NEFTYS_26577#4270,SIRET_26572#4271,STATUT_26570#4272,... 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#5569 AS COL_9BC25268_349F_4392_9581_3228F517B390#5585, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5570L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5586L]
      +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#5554 AS COL_9BC25268_349F_4392_9581_3228F517B390#5569, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5555L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5570L]
         +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#5543 AS COL_9BC25268_349F_4392_9581_3228F517B390#5554, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5544L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5555L]
            +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#5539 AS COL_9BC25268_349F_4392_9581_3228F517B390#5543, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5540L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5544L]
               +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#5500 AS COL_9BC25268_349F_4392_9581_3228F517B390#5539, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5514L AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5540L]
                  +- Project [COL_9BC25268_349F_4392_9581_3228F517B390#5500, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5514L]
                     +- Aggregate [COL_FD05C767_4723_493B_BD22_13134A191D26#5473], [COL_FD05C767_4723_493B_BD22_13134A191D26#5473 AS COL_9BC25268_349F_4392_9581_3228F517B390#5500, 1 AS NULL_1#5516, count(1) AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5514L]
                        +- Project [COL_8343D674_F7B4_49D3_9485_902B2BAAF953#5399, COL_2276CD98_E802_486D_8515_19B39DABC591#5400, COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#5401, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5402L, str_extract_by_str(COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#5401, cast(: as string), cast(LEFT as string)) AS COL_FD05C767_4723_493B_BD22_13134A191D26#5473]
                           +- Project [COL_8343D674_F7B4_49D3_9485_902B2BAAF953#5399, COL_2276CD98_E802_486D_8515_19B39DABC591#5400, COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#5401, COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5402L]
                              +- Project [cast(UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5376 as string) AS COL_8343D674_F7B4_49D3_9485_902B2BAAF953#5399, cast(UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5377 as string) AS COL_2276CD98_E802_486D_8515_19B39DABC591#5400, cast(UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#5378 as string) AS COL_D95A7A24_4A8A_4A05_8631_9574786FF3A4#5401, cast(UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5379L as bigint) AS COL_6D8312C3_0520_414A_BE81_92EF9F766AF6#5402L]
                                 +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5248 AS UNITE_CODE_CENT_36755_COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5376, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5249 AS UNITE_CODE_CENT_36755_COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5377, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5250 AS UNITE_CODE_CENT_36755_COL_163AF726_C329_42A2_AFC0_E42939FD4852#5378, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5251L AS UNITE_CODE_CENT_36755_COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5379L]
                                    +- SubqueryAlias UNITE_CODE_CENT_36755115
                                       +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5138 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5248, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5139 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5249, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5142 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5250, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5143L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5251L]
                                          +- Filter CASE WHEN isnull((COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5143L > cast(1 as bigint))) THEN false ELSE (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5143L > cast(1 as bigint)) END
                                             +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5107 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5138, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5108 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5139, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5109 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5140, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5110 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5141, COL_163AF726_C329_42A2_AFC0_E42939FD4852#5111 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5142, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#5143L]
                                                +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#5107, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#5108, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#5109, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#5110, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#5111, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L]
                                                   +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L]
                                                      +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, CONST#4890, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L]
                                                         +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, CONST#4890, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L, COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L]
                                                            +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, CONST#4890 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821], [CONST#4890 DESC NULLS LAST]
                                                               +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, CONST#4890]
                                                                  +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, 1 AS CONST#4890]
                                                                     +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4678 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4679 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4818, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4680 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4819, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4681 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4820, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4682 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821]
                                                                        +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4678, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4679, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4680, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4681, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4682]
                                                                           +- Project [COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4678, COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4679, COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4680, COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4681, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4682]
                                                                              +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4668, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4669, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4670, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4671, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4668 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4678, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4669 AS COL_0FBA7345_04EE_4090_B1EE_57E9F1EDE208#4679, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4670 AS COL_C33F71D0_D6FB_427E_AB2B_A4BCAA812581#4680, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4671 AS COL_3522DD81_E2EA_49CF_B5B4_A7F6490AD2F9#4681, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#4682, 1 AS NULL_1#4688]
                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4659 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4668, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4660 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4669, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4661 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4670, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4662 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4671, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4653 AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672]
                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4645 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4659, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4646 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4660, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4647 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4661, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4648 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4662, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4653]
                                                                                       +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4645, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4646, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4647, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4648, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4647, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4648), cast( :  as string)) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4653]
                                                                                          +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4637 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4645, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4638 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4646, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4639 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4647, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4640 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4648]
                                                                                             +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4637, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4638, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4639, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597 AS COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4640]
                                                                                                +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4561, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597]
                                                                                                   +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4561, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4562, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597]
                                                                                                      +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4562), false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597]
                                                                                                         +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4549 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4550 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4551 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4552 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4561, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4543 AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4562]
                                                                                                            +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4535 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4549, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4536 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4550, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4537 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4551, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4538 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4552, COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4543]
                                                                                                               +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4535, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4536, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4537, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4538, str_split(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4538, cast(- as string)) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4543]
                                                                                                                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4527 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4535, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4528 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4536, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4529 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4537, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4530 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4538]
                                                                                                                     +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4497 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4527, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4498 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4528, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4499 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4529, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4500 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4530]
                                                                                                                        +- Filter NOT (str_remove_accent(upper(COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4500)) <=> )
                                                                                                                           +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4467 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4497, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4468 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4498, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4469 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4499, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4470 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4500]
                                                                                                                              +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4441 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4467, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4442 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4468, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4449 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4469, COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4454 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4470]
                                                                                                                                 +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4441, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4442, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4449, col1#4444 AS COL_664630A1_4CE8_43DA_A982_A21F2333D22D#4454]
                                                                                                                                    +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4441, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4442, col0#4443 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4449, col1#4444]
                                                                                                                                       +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4429 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4441, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4430 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4442, col0#4443, col1#4444]
                                                                                                                                          +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4431, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4432, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4433, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#4434), false, [col0#4443, col1#4444]
                                                                                                                                             +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4417 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4429, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4418 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4430, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4419 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4431, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4420 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4432, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4421 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4433, COL_254FB614_FB51_4228_B230_A642F782E3FD#4422 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4434]
                                                                                                                                                +- Project [cast(BASE_BOHRINGER_26561_CODE_26562#4364 as string) AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4417, cast(BASE_BOHRINGER_26561_CLIENT_26563#4363 as string) AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4418, cast(BASE_BOHRINGER_26561_ALCYON_26574#4356 as string) AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4419, cast(BASE_BOHRINGER_26561_CENTRAVET_26575#4357 as string) AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4420, cast(BASE_BOHRINGER_26561_COVETO_26576#4366 as string) AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4421, cast(BASE_BOHRINGER_26561_NEFTYS_26577#4376 as string) AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4422]
                                                                                                                                                   +- Project [ADRESSE_26564#4249 AS BASE_BOHRINGER_26561_ADRESSE_26564#4355, ALCYON_26574#4250 AS BASE_BOHRINGER_26561_ALCYON_26574#4356, CENTRAVET_26575#4251 AS BASE_BOHRINGER_26561_CENTRAVET_26575#4357, CF_GLOBAL_AV_26589#4252 AS BASE_BOHRINGER_26561_CF_GLOBAL_AV_26589#4358, CF_GLOBAL_EQ_26585#4253 AS BASE_BOHRINGER_26561_CF_GLOBAL_EQ_26585#4359, CF_GLOBAL_PO_26587#4254 AS BASE_BOHRINGER_26561_CF_GLOBAL_PO_26587#4360, CF_GLOBAL_PV_26581#4255 AS BASE_BOHRINGER_26561_CF_GLOBAL_PV_26581#4361, CF_GLOBAL_RU_26583#4256 AS BASE_BOHRINGER_26561_CF_GLOBAL_RU_26583#4362, CLIENT_26563#4257 AS BASE_BOHRINGER_26561_CLIENT_26563#4363, CODE_26562#4258 AS BASE_BOHRINGER_26561_CODE_26562#4364, CODE_ORDINAL_26573#4259 AS BASE_BOHRINGER_26561_CODE_ORDINAL_26573#4365, COVETO_26576#4260 AS BASE_BOHRINGER_26561_COVETO_26576#4366, CP_26565#4261 AS BASE_BOHRINGER_26561_CP_26565#4367, GIE_AV_22_26588#4262 AS BASE_BOHRINGER_26561_GIE_AV_22_26588#4368, GIE_EQ_22_26584#4263 AS BASE_BOHRINGER_26561_GIE_EQ_22_26584#4369, GIE_MAX_26579#4264 AS BASE_BOHRINGER_26561_GIE_MAX_26579#4370, GIE_PO_22_26586#4265 AS BASE_BOHRINGER_26561_GIE_PO_22_26586#4371, GIE_PV_22_26580#4266 AS BASE_BOHRINGER_26561_GIE_PV_22_26580#4372, GIE_RU_22_26582#4267 AS BASE_BOHRINGER_26561_GIE_RU_22_26582#4373, ID_VETFAMILY_26578#4268 AS BASE_BOHRINGER_26561_ID_VETFAMILY_26578#4374, MAIL_26568#4269 AS BASE_BOHRINGER_26561_MAIL_26568#4375, NEFTYS_26577#4270 AS BASE_BOHRINGER_26561_NEFTYS_26577#4376, SIRET_26572#4271 AS BASE_BOHRINGER_26561_SIRET_26572#4377, STATUT_26570#4272 AS BASE_BOHRINGER_26561_STATUT_26570#4378, ... 4 more fields]
                                                                                                                                                      +- SubqueryAlias BASE_BOHRINGER_26561115
                                                                                                                                                         +- Relation[ADRESSE_26564#4249,ALCYON_26574#4250,CENTRAVET_26575#4251,CF_GLOBAL_AV_26589#4252,CF_GLOBAL_EQ_26585#4253,CF_GLOBAL_PO_26587#4254,CF_GLOBAL_PV_26581#4255,CF_GLOBAL_RU_26583#4256,CLIENT_26563#4257,CODE_26562#4258,CODE_ORDINAL_26573#4259,COVETO_26576#4260,CP_26565#4261,GIE_AV_22_26588#4262,GIE_EQ_22_26584#4263,GIE_MAX_26579#4264,GIE_PO_22_26586#4265,GIE_PV_22_26580#4266,GIE_RU_22_26582#4267,ID_VETFAMILY_26578#4268,MAIL_26568#4269,NEFTYS_26577#4270,SIRET_26572#4271,STATUT_26570#4272,... 4 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Aggregate [COL_FD05C767_4723_493B_BD22_13134A191D26#5473], [COL_FD05C767_4723_493B_BD22_13134A191D26#5473 AS COL_9BC25268_349F_4392_9581_3228F517B390#5585, count(1) AS COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5586L]
      +- Project [str_extract_by_str(COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, :, LEFT) AS COL_FD05C767_4723_493B_BD22_13134A191D26#5473]
         +- Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L > 1)
            +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, CONST#4890 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821], [CONST#4890 DESC NULLS LAST]
               +- Aggregate [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672], [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558 AS COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672 AS COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, 1 AS CONST#4890]
                  +- Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597),  : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672]
                     +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4562), [3], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597]
                        +- Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4429 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4430 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, col0#4443 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, str_split(col1#4444, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4562]
                           +- Filter NOT (str_remove_accent(upper(col1#4444)) <=> )
                              +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4431, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4432, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4433, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#4434), [2, 3, 4, 5], false, [col0#4443, col1#4444]
                                 +- Project [CODE_26562#4258 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4429, CLIENT_26563#4257 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4430, ALCYON_26574#4250 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4431, CENTRAVET_26575#4251 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4432, COVETO_26576#4260 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4433, NEFTYS_26577#4270 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4434]
                                    +- Relation[ADRESSE_26564#4249,ALCYON_26574#4250,CENTRAVET_26575#4251,CF_GLOBAL_AV_26589#4252,CF_GLOBAL_EQ_26585#4253,CF_GLOBAL_PO_26587#4254,CF_GLOBAL_PV_26581#4255,CF_GLOBAL_RU_26583#4256,CLIENT_26563#4257,CODE_26562#4258,CODE_ORDINAL_26573#4259,COVETO_26576#4260,CP_26565#4261,GIE_AV_22_26588#4262,GIE_EQ_22_26584#4263,GIE_MAX_26579#4264,GIE_PO_22_26586#4265,GIE_PV_22_26580#4266,GIE_RU_22_26582#4267,ID_VETFAMILY_26578#4268,MAIL_26568#4269,NEFTYS_26577#4270,SIRET_26572#4271,STATUT_26570#4272,... 4 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(7) HashAggregate(keys=[COL_FD05C767_4723_493B_BD22_13134A191D26#5473], functions=[count(1)], output=[COL_9BC25268_349F_4392_9581_3228F517B390#5585, COL_56C6B496_B95B_4192_9CA3_E29527B922BA#5586L])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 2
            +- Exchange hashpartitioning(COL_FD05C767_4723_493B_BD22_13134A191D26#5473, 200), true, [id=#1658]
               +- *(6) HashAggregate(keys=[COL_FD05C767_4723_493B_BD22_13134A191D26#5473], functions=[partial_count(1)], output=[COL_FD05C767_4723_493B_BD22_13134A191D26#5473, count#5801L])
                  +- *(6) Project [str_extract_by_str(COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, :, LEFT) AS COL_FD05C767_4723_493B_BD22_13134A191D26#5473]
                     +- *(6) Filter (COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L > 1)
                        +- Window [count(COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817) windowspecdefinition(COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, CONST#4890 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_75E367AD_E31F_4D77_BB7D_646877CF0FC7#4909L], [COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821], [CONST#4890 DESC NULLS LAST]
                           +- *(5) Sort [COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821 ASC NULLS FIRST, CONST#4890 DESC NULLS LAST], false, 0
                              +- CustomShuffleReader coalesced
                                 +- ShuffleQueryStage 1
                                    +- Exchange hashpartitioning(COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, 200), true, [id=#1412]
                                       +- *(4) HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672], functions=[], output=[COL_6C47DCD1_F1EB_47CA_9E70_190EE20BE7BA#4817, COL_163AF726_C329_42A2_AFC0_E42939FD4852#4821, CONST#4890])
                                          +- CustomShuffleReader coalesced
                                             +- ShuffleQueryStage 0
                                                +- Exchange hashpartitioning(COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672, 200), true, [id=#974]
                                                   +- *(3) HashAggregate(keys=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672], functions=[], output=[COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597, COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672])
                                                      +- *(3) Project [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597, str_join(struct(COL_CFC5448E_9363_4429_B721_3D7210A1D9C1, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8, COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597),  : ) AS COL_C9C7C9A6_06CE_4F7C_9073_6AD821862758#4672]
                                                         +- Generate explode(COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4562), [COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560], false, [COL_9565D746_B435_4DDB_B988_0F0798DD1DD8#4597]
                                                            +- *(2) Project [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4429 AS COL_49E8FE33_0002_41C7_BA6D_9DECE809A2EC#4558, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4430 AS COL_467879CC_AD65_41ED_B10C_7830173EB2CD#4559, col0#4443 AS COL_CFC5448E_9363_4429_B721_3D7210A1D9C1#4560, str_split(col1#4444, -) AS COL_FC1005F0_8B2A_470B_969B_2F695DEC0615#4562]
                                                               +- *(2) Filter NOT (str_remove_accent(upper(col1#4444)) <=> )
                                                                  +- Generate stack(4, ALCYON, COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4431, CENTRAVET, COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4432, COVETO, COL_849E3089_5C66_4628_8089_C7A14A3915D9#4433, NEFTYS, COL_254FB614_FB51_4228_B230_A642F782E3FD#4434), [COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4429, COL_A7246A72_2676_467D_80BD_2A058C09CA95#4430], false, [col0#4443, col1#4444]
                                                                     +- *(1) Project [CODE_26562#4258 AS COL_4336771F_0F65_4B5C_B5EA_8E8BDD96D725#4429, CLIENT_26563#4257 AS COL_A7246A72_2676_467D_80BD_2A058C09CA95#4430, ALCYON_26574#4250 AS COL_B1D08602_1B29_490B_B8FA_8FE4C4CACEB3#4431, CENTRAVET_26575#4251 AS COL_BD47C491_EA60_4864_9BEB_4C1EBDF53FA6#4432, COVETO_26576#4260 AS COL_849E3089_5C66_4628_8089_C7A14A3915D9#4433, NEFTYS_26577#4270 AS COL_254FB614_FB51_4228_B230_A642F782E3FD#4434]
                                                                        +- *(1) ColumnarToRow
                                                                           +- FileScan parquet [ALCYON_26574#4250,CENTRAVET_26575#4251,CLIENT_26563#4257,CODE_26562#4258,COVETO_26576#4260,NEFTYS_26577#4270] 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...