DC2 - Details for Query 70

Details for Query 70

Submitted Time: 2026/03/05 07:13:50
Duration: 0.7 s
Succeeded Jobs: 115 116 117 118 119

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: 1 ms"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label="Generate number of output rows: 4"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 3 ms"; 6 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 1 avg hash probe bucket list iters: 0"]; } 7 [labelType="html" label="Exchange shuffle records written: 13 shuffle write time total (min, med, max (stageId: taskId)) 3 ms (0 ms, 0 ms, 0 ms (stage 193.0: task 565)) records read: 13 local bytes read: 854.0 B fetch wait time: 0 ms remote bytes read: 0.0 B local blocks read: 13 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 728.0 B (56.0 B, 56.0 B, 56.0 B (stage 193.0: task 564)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 854.0 B (64.0 B, 65.0 B, 73.0 B (stage 193.0: task 571))"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n61 ms (2 ms, 3 ms, 11 ms (stage 193.0: task 570))"; 9 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 58 ms (2 ms, 3 ms, 11 ms (stage 193.0: task 570)) peak memory: 0.0 B number of output rows: 13 avg hash probe bucket list iters: 0"]; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 13 ms (0 ms, 1 ms, 2 ms (stage 193.0: task 568)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 193.0: task 564)) number of output rows: 3,806 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 193.0: task 564))"]; } 11 [labelType="html" label=" CustomShuffleReader "]; 12 [labelType="html" label="Exchange shuffle records written: 3,826 shuffle write time total (min, med, max (stageId: taskId)) 192 ms (14 ms, 34 ms, 39 ms (stage 191.0: task 554)) records read: 3,826 local bytes read total (min, med, max (stageId: taskId)) 195.7 KiB (7.4 KiB, 15.7 KiB, 16.2 KiB (stage 193.0: task 562)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 193.0: task 564)) remote bytes read: 0.0 B local blocks read: 76 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 357.9 KiB (2.4 KiB, 35.2 KiB, 177.4 KiB (stage 191.0: task 553)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 195.7 KiB (2.5 KiB, 24.0 KiB, 80.5 KiB (stage 191.0: task 553))"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n468 ms (43 ms, 72 ms, 86 ms (stage 191.0: task 553))"; 14 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 83 ms (2 ms, 13 ms, 21 ms (stage 191.0: task 553)) peak memory total (min, med, max (stageId: taskId)) 385.8 MiB (256.0 KiB, 64.3 MiB, 64.3 MiB (stage 191.0: task 558)) number of output rows: 3,826 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 191.0: task 558))"]; 15 [labelType="html" label="Expand number of output rows: 19,010"]; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label="BroadcastHashJoin number of output rows: 3,802"]; 18 [labelType="html" label=" Project "]; 19 [labelType="html" label="BroadcastHashJoin number of output rows: 3,802"]; 20 [labelType="html" label=" Project "]; 21 [labelType="html" label="BroadcastHashJoin number of output rows: 3,802"]; 22 [labelType="html" label=" Project "]; 23 [labelType="html" label="ColumnarToRow number of output rows: 3,802 number of input batches: 6"]; } 24 [labelType="html" label="Scan parquet number of files read: 7 scan time total (min, med, max (stageId: taskId)) 47 ms (2 ms, 6 ms, 13 ms (stage 191.0: task 557)) metadata time: 0 ms size of files read: 351.5 KiB number of output rows: 3,802"]; 25 [labelType="html" label="BroadcastExchange data size: 64.3 MiB time to collect: 187 ms time to build: 16 ms time to broadcast: 12 ms"]; subgraph cluster26 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n453 ms (4 ms, 72 ms, 83 ms (stage 189.0: task 537))"; 27 [labelType="html" label=" Project "]; 28 [labelType="html" label="Filter number of output rows: 5,424"]; 29 [labelType="html" label="ColumnarToRow number of output rows: 5,424 number of input batches: 9"]; } 30 [labelType="html" label="Scan parquet number of files read: 9 scan time total (min, med, max (stageId: taskId)) 442 ms (4 ms, 68 ms, 81 ms (stage 189.0: task 537)) metadata time: 0 ms size of files read: 839.4 KiB number of output rows: 5,424"]; 31 [labelType="html" label="BroadcastExchange data size: 64.3 MiB time to collect: 170 ms time to build: 12 ms time to broadcast: 13 ms"]; subgraph cluster32 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n160 ms (4 ms, 9 ms, 45 ms (stage 190.0: task 540))"; 33 [labelType="html" label=" Project "]; 34 [labelType="html" label="Filter number of output rows: 9,747"]; 35 [labelType="html" label="ColumnarToRow number of output rows: 9,747 number of input batches: 13"]; } 36 [labelType="html" label="Scan parquet number of files read: 13 scan time total (min, med, max (stageId: taskId)) 153 ms (4 ms, 8 ms, 44 ms (stage 190.0: task 540)) metadata time: 0 ms size of files read: 1661.7 KiB number of output rows: 9,747"]; 1->0; 3->1; 4->3; 6->4; 7->6; 9->7; 10->9; 11->10; 12->11; 14->12; 15->14; 16->15; 17->16; 18->17; 19->18; 20->19; 21->20; 22->21; 23->22; 24->23; 25->21; 27->25; 28->27; 29->28; 30->29; 31->19; 33->31; 34->33; 35->34; 36->35; 31->17; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

Project [str_extract(col0#14085, LEFT, 1) AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14208, str_extract_by_str(col0#14085, _, RIGHT) AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14209, col1#14086L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14210L, COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14043L AS COL_71232578_F97E_49C3_853C_8855059795AE#14211L]

WholeStageCodegen (7)

Generate stack(4, 1_Creconciliation, COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14044L, 2_CMise en qualité, COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14045L, 3_CLiens ERP, COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14046L, 4_CTemplate intermédiaire, COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14047L), [COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14043L], false, [col0#14085, col1#14086L]

HashAggregate(keys=[], functions=[first(if ((gid#14216 = 0)) first(`COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`)#14222L else null, true), count(if ((gid#14216 = 2)) `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218 else null), count(if ((gid#14216 = 3)) `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219 else null), count(if ((gid#14216 = 1)) `COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217 else null), count(if ((gid#14216 = 4)) `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220 else null)])

WholeStageCodegen (6)

Exchange SinglePartition, true, [id=#3535]

HashAggregate(keys=[], functions=[partial_first(if ((gid#14216 = 0)) first(`COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`)#14222L else null, true), partial_count(if ((gid#14216 = 2)) `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218 else null), partial_count(if ((gid#14216 = 3)) `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219 else null), partial_count(if ((gid#14216 = 1)) `COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217 else null), partial_count(if ((gid#14216 = 4)) `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220 else null)])

HashAggregate(keys=[`COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217, `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218, `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219, `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220, gid#14216], functions=[first(`COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`#14221L, true)])

WholeStageCodegen (5)

CustomShuffleReader coalesced

Exchange hashpartitioning(`COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217, `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218, `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219, `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220, gid#14216, 200), true, [id=#3465]

HashAggregate(keys=[`COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217, `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218, `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219, `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220, gid#14216], functions=[partial_first(`COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`#14221L, true)])

Expand [ArrayBuffer(null, null, null, null, 0, COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L), ArrayBuffer(COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754, null, null, null, 1, null), ArrayBuffer(null, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, null, null, 2, null), ArrayBuffer(null, null, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507, null, 3, null), ArrayBuffer(null, null, null, COL_7D036902_86FC_458E_9191_C7366A25077D#14026, 4, null)], [`COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217, `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218, `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219, `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220, gid#14216, `COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`#14221L]

Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507, COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754, UNION_CONSOLIDA_35706_COL_15D6002F_01DC_4CD1_B54A_C61057C00E79#13818 AS COL_7D036902_86FC_458E_9191_C7366A25077D#14026]

BroadcastHashJoin [COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298], [UNION_CONSOLIDA_35706_COL_15D6002F_01DC_4CD1_B54A_C61057C00E79#13818], LeftOuter, BuildRight

Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507, UNION_CONSOLIDA_32798_COL_43086D10_3F11_4F63_A391_E0C83BB48357#13586 AS COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754]

BroadcastHashJoin [COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298], [UNION_CONSOLIDA_32798_COL_43086D10_3F11_4F63_A391_E0C83BB48357#13586], LeftOuter, BuildRight

Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, MISE_EN_QUALITE_32533_COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#13365 AS COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507]

BroadcastHashJoin [COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298], [MISE_EN_QUALITE_32533_COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#13365], LeftOuter, BuildRight

Project [COL_3AA9677C_9524_43B7_9984_7C0506F35631#12790L AS COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#12793 AS COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298]

ColumnarToRow

WholeStageCodegen (4)

FileScan parquet [COL_3AA9677C_9524_43B7_9984_7C0506F35631#12790L,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#12793] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/BASE_RECONCILIA_32037], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_3AA9677C_9524_43B7_9984_7C0506F35631:bigint,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595:s...

BroadcastExchange HashedRelationBroadcastMode(List(input[0, string, true])), [id=#3236]

Project [COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#12410 AS MISE_EN_QUALITE_32533_COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#13365]

Filter isnotnull(COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#12410)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#12410] Batched: true, DataFilters: [isnotnull(COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#12410)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/MISE_EN_QUALITE_32533], PartitionFilters: [], PushedFilters: [IsNotNull(COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C)], ReadSchema: struct<COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C:string>

BroadcastExchange HashedRelationBroadcastMode(List(input[0, string, true])), [id=#3257]

Project [COL_43086D10_3F11_4F63_A391_E0C83BB48357#12968 AS UNION_CONSOLIDA_32798_COL_43086D10_3F11_4F63_A391_E0C83BB48357#13586]

Filter isnotnull(COL_43086D10_3F11_4F63_A391_E0C83BB48357#12968)

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [COL_43086D10_3F11_4F63_A391_E0C83BB48357#12968] Batched: true, DataFilters: [isnotnull(COL_43086D10_3F11_4F63_A391_E0C83BB48357#12968)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/UNION_CONSOLIDA_32798], PartitionFilters: [], PushedFilters: [IsNotNull(COL_43086D10_3F11_4F63_A391_E0C83BB48357)], ReadSchema: struct<COL_43086D10_3F11_4F63_A391_E0C83BB48357:string>

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14200 AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14208, COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14201 AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14209, COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14202L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14210L, COL_71232578_F97E_49C3_853C_8855059795AE#14203L AS COL_71232578_F97E_49C3_853C_8855059795AE#14211L]
      +- Project [COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14184 AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14200, COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14185 AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14201, COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14186L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14202L, COL_71232578_F97E_49C3_853C_8855059795AE#14187L AS COL_71232578_F97E_49C3_853C_8855059795AE#14203L]
         +- Project [COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14176 AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14184, COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14177 AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14185, COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14178L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14186L, COL_71232578_F97E_49C3_853C_8855059795AE#14179L AS COL_71232578_F97E_49C3_853C_8855059795AE#14187L]
            +- Project [COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14168 AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14176, COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14169 AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14177, COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14170L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14178L, COL_71232578_F97E_49C3_853C_8855059795AE#14171L AS COL_71232578_F97E_49C3_853C_8855059795AE#14179L]
               +- Project [COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14160 AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14168, COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14161 AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14169, COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14162L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14170L, COL_71232578_F97E_49C3_853C_8855059795AE#14163L AS COL_71232578_F97E_49C3_853C_8855059795AE#14171L]
                  +- Project [COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14152 AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14160, COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14153 AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14161, COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14154L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14162L, COL_71232578_F97E_49C3_853C_8855059795AE#14155L AS COL_71232578_F97E_49C3_853C_8855059795AE#14163L]
                     +- Project [cast(DATA_INTEGRITE__38236_COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14140 as string) AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14152, cast(DATA_INTEGRITE__38236_COL_5CC15D06_EC66_4F21_9F5F_7985C4F1CBD9#14141 as string) AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14153, cast(DATA_INTEGRITE__38236_COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14142L as bigint) AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14154L, cast(DATA_INTEGRITE__38236_COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14143L as bigint) AS COL_71232578_F97E_49C3_853C_8855059795AE#14155L]
                        +- Project [COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14128 AS DATA_INTEGRITE__38236_COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14140, COL_5CC15D06_EC66_4F21_9F5F_7985C4F1CBD9#14129 AS DATA_INTEGRITE__38236_COL_5CC15D06_EC66_4F21_9F5F_7985C4F1CBD9#14141, COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14130L AS DATA_INTEGRITE__38236_COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14142L, COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14131L AS DATA_INTEGRITE__38236_COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14143L]
                           +- SubqueryAlias DATA_INTEGRITE__38236117
                              +- Project [COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14109 AS COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14128, COL_5CC15D06_EC66_4F21_9F5F_7985C4F1CBD9#14114 AS COL_5CC15D06_EC66_4F21_9F5F_7985C4F1CBD9#14129, COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14105L AS COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14130L, COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L AS COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14131L]
                                 +- Project [COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14104, COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14105L, COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L, COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14109, str_extract_by_str(COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14104, cast(_ as string), cast(RIGHT as string)) AS COL_5CC15D06_EC66_4F21_9F5F_7985C4F1CBD9#14114]
                                    +- Project [COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14104, COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14105L, COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L, str_extract(COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14104, cast(LEFT as string), cast(1 as bigint)) AS COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14109]
                                       +- Project [COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14090 AS COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14104, COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14094L AS COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14105L, COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L]
                                          +- Project [COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L, COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14090, COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14094L]
                                             +- Project [COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L, COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14090, col1#14086L AS COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14094L]
                                                +- Project [COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L, col0#14085 AS COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14090, col1#14086L]
                                                   +- Project [COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14074L AS COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L, col0#14085, col1#14086L]
                                                      +- Generate stack(4, 1_Creconciliation, COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14075L, 2_CMise en qualité, COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14076L, 3_CLiens ERP, COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14077L, 4_CTemplate intermédiaire, COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14078L), false, [col0#14085, col1#14086L]
                                                         +- Project [COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14064L AS COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14074L, COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14065L AS COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14075L, COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14066L AS COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14076L, COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14067L AS COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14077L, COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14068L AS COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14078L]
                                                            +- Project [COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14043L AS COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14064L, COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14044L AS COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14065L, COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14045L AS COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14066L, COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14046L AS COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14067L, COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14047L AS COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14068L]
                                                               +- Project [COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14043L, COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14044L, COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14045L, COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14046L, COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14047L]
                                                                  +- Aggregate [1 AS NULL_1#14048, first(COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#14022L, true) AS COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14043L, count(distinct COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#14023) AS COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14044L, count(distinct COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#14024) AS COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14045L, count(distinct COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#14025) AS COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14046L, count(distinct COL_7D036902_86FC_458E_9191_C7366A25077D#14026) AS COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14047L]
                                                                     +- Filter true
                                                                        +- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#14022L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#14023, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#14024, COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#14025, COL_7D036902_86FC_458E_9191_C7366A25077D#14026]
                                                                           +- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L AS COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#14022L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298 AS COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#14023, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507 AS COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#14024, COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754 AS COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#14025, COL_7D036902_86FC_458E_9191_C7366A25077D#14016 AS COL_7D036902_86FC_458E_9191_C7366A25077D#14026]
                                                                              +- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507, COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754, UNION_CONSOLIDA_35706_COL_15D6002F_01DC_4CD1_B54A_C61057C00E79#13818 AS COL_7D036902_86FC_458E_9191_C7366A25077D#14016]
                                                                                 +- Join LeftOuter, (COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298 = UNION_CONSOLIDA_35706_COL_15D6002F_01DC_4CD1_B54A_C61057C00E79#13818)
                                                                                    :- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507, UNION_CONSOLIDA_32798_COL_43086D10_3F11_4F63_A391_E0C83BB48357#13586 AS COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754]
                                                                                    :  +- Join LeftOuter, (COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298 = UNION_CONSOLIDA_32798_COL_43086D10_3F11_4F63_A391_E0C83BB48357#13586)
                                                                                    :     :- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, MISE_EN_QUALITE_32533_COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#13365 AS COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507]
                                                                                    :     :  +- Join LeftOuter, (COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298 = MISE_EN_QUALITE_32533_COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#13365)
                                                                                    :     :     :- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298]
                                                                                    :     :     :  +- Project [cast(BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#13262L as bigint) AS COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, cast(BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#13265 as string) AS COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298]
                                                                                    :     :     :     +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#12771 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#13243, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#12772 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#13244, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#12773 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#13245, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#12774 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#13246, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#12775 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#13247, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#12776 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#13248, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#12777 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#13249, COL_D67142F7_A207_4870_8963_E237B841636A#12778 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#13250, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#12779 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#13251, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#12780 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#13252, COL_1C35A227_836A_4477_8139_CAB7258B4395#12781 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#13253, COL_D171F390_EECB_4924_B2C2_095D45EAE768#12782 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#13254, COL_15505186_7875_4C25_9AEA_F3510A184E50#12783 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#13255, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#12784 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#13256, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#12785 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#13257, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#12786 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#13258, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#12787 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#13259, COL_7097258E_E88A_49F2_831E_C3EE780B3488#12788 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#13260, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#12789 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#13261, COL_3AA9677C_9524_43B7_9984_7C0506F35631#12790L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#13262L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#12791L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#13263L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#12792 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#13264, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#12793 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#13265, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#12794L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#13266L, ... 2 more fields]
                                                                                    :     :     :        +- SubqueryAlias BASE_RECONCILIA_32037117
                                                                                    :     :     :           +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#12771,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#12772,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#12773,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#12774,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#12775,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#12776,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#12777,COL_D67142F7_A207_4870_8963_E237B841636A#12778,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#12779,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#12780,COL_1C35A227_836A_4477_8139_CAB7258B4395#12781,COL_D171F390_EECB_4924_B2C2_095D45EAE768#12782,COL_15505186_7875_4C25_9AEA_F3510A184E50#12783,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#12784,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#12785,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#12786,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#12787,COL_7097258E_E88A_49F2_831E_C3EE780B3488#12788,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#12789,COL_3AA9677C_9524_43B7_9984_7C0506F35631#12790L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#12791L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#12792,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#12793,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#12794L,... 2 more fields] parquet
                                                                                    :     :     +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#12381 AS MISE_EN_QUALITE_32533_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#13336, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#12382 AS MISE_EN_QUALITE_32533_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#13337, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#12383 AS MISE_EN_QUALITE_32533_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#13338, COL_CB2E17FC_221C_4C38_A806_E9E33FB8E13F#12384 AS MISE_EN_QUALITE_32533_COL_CB2E17FC_221C_4C38_A806_E9E33FB8E13F#13339, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#12385 AS MISE_EN_QUALITE_32533_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#13340, COL_E081A41A_87E9_4DC8_AC27_5C5C87155BB3#12386 AS MISE_EN_QUALITE_32533_COL_E081A41A_87E9_4DC8_AC27_5C5C87155BB3#13341, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#12387 AS MISE_EN_QUALITE_32533_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#13342, COL_529FE1B7_3F7A_404A_A9DB_662BC865EDF0#12388 AS MISE_EN_QUALITE_32533_COL_529FE1B7_3F7A_404A_A9DB_662BC865EDF0#13343, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#12389 AS MISE_EN_QUALITE_32533_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#13344, COL_E9A52100_C307_4AF4_814C_D9AADF72F033#12390 AS MISE_EN_QUALITE_32533_COL_E9A52100_C307_4AF4_814C_D9AADF72F033#13345, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#12391 AS MISE_EN_QUALITE_32533_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#13346, COL_94E54ED5_3042_45FF_80D0_0CAC840EB097#12392 AS MISE_EN_QUALITE_32533_COL_94E54ED5_3042_45FF_80D0_0CAC840EB097#13347, COL_D67142F7_A207_4870_8963_E237B841636A#12393 AS MISE_EN_QUALITE_32533_COL_D67142F7_A207_4870_8963_E237B841636A#13348, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#12394 AS MISE_EN_QUALITE_32533_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#13349, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#12395 AS MISE_EN_QUALITE_32533_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#13350, COL_250EFFA3_F3D1_4D95_9062_004B0C5E91B7#12396 AS MISE_EN_QUALITE_32533_COL_250EFFA3_F3D1_4D95_9062_004B0C5E91B7#13351, COL_D171F390_EECB_4924_B2C2_095D45EAE768#12397 AS MISE_EN_QUALITE_32533_COL_D171F390_EECB_4924_B2C2_095D45EAE768#13352, COL_15505186_7875_4C25_9AEA_F3510A184E50#12398 AS MISE_EN_QUALITE_32533_COL_15505186_7875_4C25_9AEA_F3510A184E50#13353, COL_B5F1716C_B5E3_470C_86DB_85BBE52E1E63#12399 AS MISE_EN_QUALITE_32533_COL_B5F1716C_B5E3_470C_86DB_85BBE52E1E63#13354, COL_1C35A227_836A_4477_8139_CAB7258B4395#12400 AS MISE_EN_QUALITE_32533_COL_1C35A227_836A_4477_8139_CAB7258B4395#13355, COL_B1E40BB3_6570_4A14_9E67_BB0574B6130D#12401 AS MISE_EN_QUALITE_32533_COL_B1E40BB3_6570_4A14_9E67_BB0574B6130D#13356, COL_26B6B621_1F72_4B3A_92EE_F4C1423FE922#12402 AS MISE_EN_QUALITE_32533_COL_26B6B621_1F72_4B3A_92EE_F4C1423FE922#13357, COL_A5D0563B_E31F_4108_91C1_A7D995E0288F#12403 AS MISE_EN_QUALITE_32533_COL_A5D0563B_E31F_4108_91C1_A7D995E0288F#13358, COL_687B345E_3370_42F7_AB82_B53990B19AFE#12404 AS MISE_EN_QUALITE_32533_COL_687B345E_3370_42F7_AB82_B53990B19AFE#13359, ... 9 more fields]
                                                                                    :     :        +- SubqueryAlias MISE_EN_QUALITE_32533117
                                                                                    :     :           +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#12381,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#12382,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#12383,COL_CB2E17FC_221C_4C38_A806_E9E33FB8E13F#12384,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#12385,COL_E081A41A_87E9_4DC8_AC27_5C5C87155BB3#12386,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#12387,COL_529FE1B7_3F7A_404A_A9DB_662BC865EDF0#12388,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#12389,COL_E9A52100_C307_4AF4_814C_D9AADF72F033#12390,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#12391,COL_94E54ED5_3042_45FF_80D0_0CAC840EB097#12392,COL_D67142F7_A207_4870_8963_E237B841636A#12393,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#12394,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#12395,COL_250EFFA3_F3D1_4D95_9062_004B0C5E91B7#12396,COL_D171F390_EECB_4924_B2C2_095D45EAE768#12397,COL_15505186_7875_4C25_9AEA_F3510A184E50#12398,COL_B5F1716C_B5E3_470C_86DB_85BBE52E1E63#12399,COL_1C35A227_836A_4477_8139_CAB7258B4395#12400,COL_B1E40BB3_6570_4A14_9E67_BB0574B6130D#12401,COL_26B6B621_1F72_4B3A_92EE_F4C1423FE922#12402,COL_A5D0563B_E31F_4108_91C1_A7D995E0288F#12403,COL_687B345E_3370_42F7_AB82_B53990B19AFE#12404,... 9 more fields] parquet
                                                                                    :     +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#12932 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#13550, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#12933 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#13551, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#12934 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#13552, COL_413BE7B8_1BFE_4393_A802_209E3937124C#12935 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#13553, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#12936 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#13554, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#12937 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#13555, COL_F472560C_DB99_41F2_9279_7069140A9D65#12938 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#13556, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#12939 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#13557, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#12940 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#13558, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#12941 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#13559, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#12942 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#13560, COL_135AAA37_5078_4633_9560_24643D2CFC87#12943 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#13561, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#12944 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#13562, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#12945 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#13563, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#12946 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#13564, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#12947 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#13565, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#12948 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#13566, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#12949 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#13567, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#12950 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#13568, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#12951 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#13569, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#12952 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#13570, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#12953 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#13571, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#12954 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#13572, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#12955 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#13573, ... 15 more fields]
                                                                                    :        +- SubqueryAlias UNION_CONSOLIDA_32798117
                                                                                    :           +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#12932,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#12933,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#12934,COL_413BE7B8_1BFE_4393_A802_209E3937124C#12935,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#12936,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#12937,COL_F472560C_DB99_41F2_9279_7069140A9D65#12938,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#12939,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#12940,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#12941,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#12942,COL_135AAA37_5078_4633_9560_24643D2CFC87#12943,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#12944,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#12945,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#12946,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#12947,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#12948,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#12949,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#12950,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#12951,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#12952,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#12953,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#12954,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#12955,... 15 more fields] parquet
                                                                                    +- Project [COL_03FA2FE8_57E6_4BA4_BC1C_FB81A09DC35B#13157 AS UNION_CONSOLIDA_35706_COL_03FA2FE8_57E6_4BA4_BC1C_FB81A09DC35B#13789, COL_B4B39710_A1AA_4F99_955F_A79B0A749692#13158 AS UNION_CONSOLIDA_35706_COL_B4B39710_A1AA_4F99_955F_A79B0A749692#13790, COL_F96D2D63_4A68_4C49_B6BC_BCEEDB231D6C#13159 AS UNION_CONSOLIDA_35706_COL_F96D2D63_4A68_4C49_B6BC_BCEEDB231D6C#13791, COL_AC91CA45_F531_455F_99EA_4453452756C1#13160 AS UNION_CONSOLIDA_35706_COL_AC91CA45_F531_455F_99EA_4453452756C1#13792, COL_AB6A6557_8CBB_4CE2_A4D1_026314A487B4#13161 AS UNION_CONSOLIDA_35706_COL_AB6A6557_8CBB_4CE2_A4D1_026314A487B4#13793, COL_17EB52F1_5CF0_47EB_9FF5_B955A17853BE#13162 AS UNION_CONSOLIDA_35706_COL_17EB52F1_5CF0_47EB_9FF5_B955A17853BE#13794, COL_A7D1531F_308A_45DA_A12B_AB82BABE3F20#13163 AS UNION_CONSOLIDA_35706_COL_A7D1531F_308A_45DA_A12B_AB82BABE3F20#13795, COL_9E08B51E_A147_470F_8848_D4146F5BCEED#13164 AS UNION_CONSOLIDA_35706_COL_9E08B51E_A147_470F_8848_D4146F5BCEED#13796, COL_CAB88597_47F3_4C68_8F0C_4225C4CD9A8D#13165 AS UNION_CONSOLIDA_35706_COL_CAB88597_47F3_4C68_8F0C_4225C4CD9A8D#13797, COL_CCFFB59C_09FC_42B9_8A6E_990BE798A17C#13166 AS UNION_CONSOLIDA_35706_COL_CCFFB59C_09FC_42B9_8A6E_990BE798A17C#13798, COL_CC2A67E4_5191_40DC_A445_0618845F0226#13167 AS UNION_CONSOLIDA_35706_COL_CC2A67E4_5191_40DC_A445_0618845F0226#13799, COL_F2785A1D_51FF_442C_8DE3_FB23ACFF9FA7#13168 AS UNION_CONSOLIDA_35706_COL_F2785A1D_51FF_442C_8DE3_FB23ACFF9FA7#13800, COL_E66EEC2D_4399_4485_AF89_26F8259A852B#13169 AS UNION_CONSOLIDA_35706_COL_E66EEC2D_4399_4485_AF89_26F8259A852B#13801, COL_044DF798_9678_45F4_84D5_870F3084A58A#13170 AS UNION_CONSOLIDA_35706_COL_044DF798_9678_45F4_84D5_870F3084A58A#13802, COL_9D63F002_6A77_46D8_8756_334017AC4798#13171 AS UNION_CONSOLIDA_35706_COL_9D63F002_6A77_46D8_8756_334017AC4798#13803, COL_EA15D99C_060D_495A_ABBD_3F19F29DA6C0#13172 AS UNION_CONSOLIDA_35706_COL_EA15D99C_060D_495A_ABBD_3F19F29DA6C0#13804, COL_E8618990_8A19_4FB9_82A7_14EC1BCB4EC5#13173 AS UNION_CONSOLIDA_35706_COL_E8618990_8A19_4FB9_82A7_14EC1BCB4EC5#13805, COL_BD1BF8C3_4EA7_4473_BEA7_D59EA61F6883#13174 AS UNION_CONSOLIDA_35706_COL_BD1BF8C3_4EA7_4473_BEA7_D59EA61F6883#13806, COL_B957617E_8860_4DF9_A716_7A2FA0A993C1#13175 AS UNION_CONSOLIDA_35706_COL_B957617E_8860_4DF9_A716_7A2FA0A993C1#13807, COL_ECD3CDA2_A160_4E4D_9080_D70CDFBA4C7D#13176 AS UNION_CONSOLIDA_35706_COL_ECD3CDA2_A160_4E4D_9080_D70CDFBA4C7D#13808, COL_79E1EA6C_E644_40AF_BC11_6FEAF7DF79BB#13177 AS UNION_CONSOLIDA_35706_COL_79E1EA6C_E644_40AF_BC11_6FEAF7DF79BB#13809, COL_D2E32321_D502_4601_852A_0484DE59E4B4#13178 AS UNION_CONSOLIDA_35706_COL_D2E32321_D502_4601_852A_0484DE59E4B4#13810, COL_5170A57B_4F46_4902_A468_6E66AC125B3F#13179 AS UNION_CONSOLIDA_35706_COL_5170A57B_4F46_4902_A468_6E66AC125B3F#13811, COL_52E363B6_0838_43F6_936B_6B0C510B4F8F#13180 AS UNION_CONSOLIDA_35706_COL_52E363B6_0838_43F6_936B_6B0C510B4F8F#13812, ... 6 more fields]
                                                                                       +- SubqueryAlias UNION_CONSOLIDA_35706117
                                                                                          +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#13049 as string) AS COL_03FA2FE8_57E6_4BA4_BC1C_FB81A09DC35B#13157, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#13050 as string) AS COL_B4B39710_A1AA_4F99_955F_A79B0A749692#13158, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#13051 as string) AS COL_F96D2D63_4A68_4C49_B6BC_BCEEDB231D6C#13159, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#13052 as string) AS COL_AC91CA45_F531_455F_99EA_4453452756C1#13160, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#13053 as string) AS COL_AB6A6557_8CBB_4CE2_A4D1_026314A487B4#13161, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#13054 as string) AS COL_17EB52F1_5CF0_47EB_9FF5_B955A17853BE#13162, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#13055 as string) AS COL_A7D1531F_308A_45DA_A12B_AB82BABE3F20#13163, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#13056 as string) AS COL_9E08B51E_A147_470F_8848_D4146F5BCEED#13164, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#13057 as string) AS COL_CAB88597_47F3_4C68_8F0C_4225C4CD9A8D#13165, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#13058 as string) AS COL_CCFFB59C_09FC_42B9_8A6E_990BE798A17C#13166, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#13059 as string) AS COL_CC2A67E4_5191_40DC_A445_0618845F0226#13167, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#13060 as string) AS COL_F2785A1D_51FF_442C_8DE3_FB23ACFF9FA7#13168, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#13061 as int) AS COL_E66EEC2D_4399_4485_AF89_26F8259A852B#13169, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#13062 as string) AS COL_044DF798_9678_45F4_84D5_870F3084A58A#13170, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#13063 as string) AS COL_9D63F002_6A77_46D8_8756_334017AC4798#13171, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#13064 as string) AS COL_EA15D99C_060D_495A_ABBD_3F19F29DA6C0#13172, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#13065 as string) AS COL_E8618990_8A19_4FB9_82A7_14EC1BCB4EC5#13173, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#13066 as string) AS COL_BD1BF8C3_4EA7_4473_BEA7_D59EA61F6883#13174, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#13067 as string) AS COL_B957617E_8860_4DF9_A716_7A2FA0A993C1#13175, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#13068 as string) AS COL_ECD3CDA2_A160_4E4D_9080_D70CDFBA4C7D#13176, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#13069 as string) AS COL_79E1EA6C_E644_40AF_BC11_6FEAF7DF79BB#13177, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#13070 as string) AS COL_D2E32321_D502_4601_852A_0484DE59E4B4#13178, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#13071 as string) AS COL_5170A57B_4F46_4902_A468_6E66AC125B3F#13179, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#13072 as string) AS COL_52E363B6_0838_43F6_936B_6B0C510B4F8F#13180, ... 6 more fields]
                                                                                             +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#12932 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#13049, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#12933 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#13050, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#12934 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#13051, COL_413BE7B8_1BFE_4393_A802_209E3937124C#12935 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#13052, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#12936 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#13053, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#12937 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#13054, COL_F472560C_DB99_41F2_9279_7069140A9D65#12938 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#13055, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#12939 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#13056, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#12940 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#13057, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#12941 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#13058, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#12942 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#13059, COL_135AAA37_5078_4633_9560_24643D2CFC87#12943 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#13060, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#12944 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#13061, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#12945 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#13062, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#12946 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#13063, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#12947 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#13064, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#12948 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#13065, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#12949 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#13066, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#12950 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#13067, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#12951 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#13068, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#12952 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#13069, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#12953 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#13070, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#12954 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#13071, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#12955 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#13072, ... 15 more fields]
                                                                                                +- SubqueryAlias UNION_CONSOLIDA_32798117
                                                                                                   +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#12932,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#12933,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#12934,COL_413BE7B8_1BFE_4393_A802_209E3937124C#12935,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#12936,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#12937,COL_F472560C_DB99_41F2_9279_7069140A9D65#12938,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#12939,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#12940,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#12941,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#12942,COL_135AAA37_5078_4633_9560_24643D2CFC87#12943,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#12944,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#12945,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#12946,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#12947,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#12948,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#12949,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#12950,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#12951,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#12952,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#12953,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#12954,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#12955,... 15 more fields] parquet

== Analyzed Logical Plan ==
COL_DD76590D_237D_4F60_AD1B_9EE19E82973B: string, COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF: string, COL_7BE840B2_31C5_4134_B22E_733DCE5B8181: bigint, COL_71232578_F97E_49C3_853C_8855059795AE: bigint
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14200 AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14208, COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14201 AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14209, COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14202L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14210L, COL_71232578_F97E_49C3_853C_8855059795AE#14203L AS COL_71232578_F97E_49C3_853C_8855059795AE#14211L]
      +- Project [COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14184 AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14200, COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14185 AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14201, COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14186L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14202L, COL_71232578_F97E_49C3_853C_8855059795AE#14187L AS COL_71232578_F97E_49C3_853C_8855059795AE#14203L]
         +- Project [COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14176 AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14184, COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14177 AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14185, COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14178L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14186L, COL_71232578_F97E_49C3_853C_8855059795AE#14179L AS COL_71232578_F97E_49C3_853C_8855059795AE#14187L]
            +- Project [COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14168 AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14176, COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14169 AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14177, COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14170L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14178L, COL_71232578_F97E_49C3_853C_8855059795AE#14171L AS COL_71232578_F97E_49C3_853C_8855059795AE#14179L]
               +- Project [COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14160 AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14168, COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14161 AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14169, COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14162L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14170L, COL_71232578_F97E_49C3_853C_8855059795AE#14163L AS COL_71232578_F97E_49C3_853C_8855059795AE#14171L]
                  +- Project [COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14152 AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14160, COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14153 AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14161, COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14154L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14162L, COL_71232578_F97E_49C3_853C_8855059795AE#14155L AS COL_71232578_F97E_49C3_853C_8855059795AE#14163L]
                     +- Project [cast(DATA_INTEGRITE__38236_COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14140 as string) AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14152, cast(DATA_INTEGRITE__38236_COL_5CC15D06_EC66_4F21_9F5F_7985C4F1CBD9#14141 as string) AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14153, cast(DATA_INTEGRITE__38236_COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14142L as bigint) AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14154L, cast(DATA_INTEGRITE__38236_COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14143L as bigint) AS COL_71232578_F97E_49C3_853C_8855059795AE#14155L]
                        +- Project [COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14128 AS DATA_INTEGRITE__38236_COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14140, COL_5CC15D06_EC66_4F21_9F5F_7985C4F1CBD9#14129 AS DATA_INTEGRITE__38236_COL_5CC15D06_EC66_4F21_9F5F_7985C4F1CBD9#14141, COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14130L AS DATA_INTEGRITE__38236_COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14142L, COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14131L AS DATA_INTEGRITE__38236_COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14143L]
                           +- SubqueryAlias DATA_INTEGRITE__38236117
                              +- Project [COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14109 AS COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14128, COL_5CC15D06_EC66_4F21_9F5F_7985C4F1CBD9#14114 AS COL_5CC15D06_EC66_4F21_9F5F_7985C4F1CBD9#14129, COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14105L AS COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14130L, COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L AS COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14131L]
                                 +- Project [COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14104, COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14105L, COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L, COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14109, str_extract_by_str(COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14104, cast(_ as string), cast(RIGHT as string)) AS COL_5CC15D06_EC66_4F21_9F5F_7985C4F1CBD9#14114]
                                    +- Project [COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14104, COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14105L, COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L, str_extract(COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14104, cast(LEFT as string), cast(1 as bigint)) AS COL_6A1A4B32_6530_4993_BB9B_58FBDEB96F61#14109]
                                       +- Project [COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14090 AS COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14104, COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14094L AS COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14105L, COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L]
                                          +- Project [COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L, COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14090, COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14094L]
                                             +- Project [COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L, COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14090, col1#14086L AS COL_22D827C8_F62A_4D2E_B2DF_D479AC0D82D9#14094L]
                                                +- Project [COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L, col0#14085 AS COL_E4F388DC_B563_40F9_AF03_B454B7993B2F#14090, col1#14086L]
                                                   +- Project [COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14074L AS COL_3AD06DDF_8776_4258_9EBB_4D583690C3F1#14084L, col0#14085, col1#14086L]
                                                      +- Generate stack(4, 1_Creconciliation, COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14075L, 2_CMise en qualité, COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14076L, 3_CLiens ERP, COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14077L, 4_CTemplate intermédiaire, COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14078L), false, [col0#14085, col1#14086L]
                                                         +- Project [COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14064L AS COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14074L, COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14065L AS COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14075L, COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14066L AS COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14076L, COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14067L AS COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14077L, COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14068L AS COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14078L]
                                                            +- Project [COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14043L AS COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14064L, COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14044L AS COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14065L, COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14045L AS COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14066L, COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14046L AS COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14067L, COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14047L AS COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14068L]
                                                               +- Project [COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14043L, COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14044L, COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14045L, COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14046L, COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14047L]
                                                                  +- Aggregate [1 AS NULL_1#14048, first(COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#14022L, true) AS COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14043L, count(distinct COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#14023) AS COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14044L, count(distinct COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#14024) AS COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14045L, count(distinct COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#14025) AS COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14046L, count(distinct COL_7D036902_86FC_458E_9191_C7366A25077D#14026) AS COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14047L]
                                                                     +- Filter true
                                                                        +- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#14022L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#14023, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#14024, COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#14025, COL_7D036902_86FC_458E_9191_C7366A25077D#14026]
                                                                           +- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L AS COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#14022L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298 AS COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#14023, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507 AS COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#14024, COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754 AS COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#14025, COL_7D036902_86FC_458E_9191_C7366A25077D#14016 AS COL_7D036902_86FC_458E_9191_C7366A25077D#14026]
                                                                              +- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507, COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754, UNION_CONSOLIDA_35706_COL_15D6002F_01DC_4CD1_B54A_C61057C00E79#13818 AS COL_7D036902_86FC_458E_9191_C7366A25077D#14016]
                                                                                 +- Join LeftOuter, (COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298 = UNION_CONSOLIDA_35706_COL_15D6002F_01DC_4CD1_B54A_C61057C00E79#13818)
                                                                                    :- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507, UNION_CONSOLIDA_32798_COL_43086D10_3F11_4F63_A391_E0C83BB48357#13586 AS COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754]
                                                                                    :  +- Join LeftOuter, (COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298 = UNION_CONSOLIDA_32798_COL_43086D10_3F11_4F63_A391_E0C83BB48357#13586)
                                                                                    :     :- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, MISE_EN_QUALITE_32533_COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#13365 AS COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507]
                                                                                    :     :  +- Join LeftOuter, (COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298 = MISE_EN_QUALITE_32533_COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#13365)
                                                                                    :     :     :- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298]
                                                                                    :     :     :  +- Project [cast(BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#13262L as bigint) AS COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, cast(BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#13265 as string) AS COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298]
                                                                                    :     :     :     +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#12771 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#13243, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#12772 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#13244, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#12773 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#13245, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#12774 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#13246, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#12775 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#13247, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#12776 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#13248, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#12777 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#13249, COL_D67142F7_A207_4870_8963_E237B841636A#12778 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#13250, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#12779 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#13251, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#12780 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#13252, COL_1C35A227_836A_4477_8139_CAB7258B4395#12781 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#13253, COL_D171F390_EECB_4924_B2C2_095D45EAE768#12782 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#13254, COL_15505186_7875_4C25_9AEA_F3510A184E50#12783 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#13255, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#12784 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#13256, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#12785 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#13257, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#12786 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#13258, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#12787 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#13259, COL_7097258E_E88A_49F2_831E_C3EE780B3488#12788 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#13260, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#12789 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#13261, COL_3AA9677C_9524_43B7_9984_7C0506F35631#12790L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#13262L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#12791L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#13263L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#12792 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#13264, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#12793 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#13265, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#12794L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#13266L, ... 2 more fields]
                                                                                    :     :     :        +- SubqueryAlias BASE_RECONCILIA_32037117
                                                                                    :     :     :           +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#12771,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#12772,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#12773,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#12774,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#12775,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#12776,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#12777,COL_D67142F7_A207_4870_8963_E237B841636A#12778,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#12779,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#12780,COL_1C35A227_836A_4477_8139_CAB7258B4395#12781,COL_D171F390_EECB_4924_B2C2_095D45EAE768#12782,COL_15505186_7875_4C25_9AEA_F3510A184E50#12783,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#12784,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#12785,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#12786,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#12787,COL_7097258E_E88A_49F2_831E_C3EE780B3488#12788,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#12789,COL_3AA9677C_9524_43B7_9984_7C0506F35631#12790L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#12791L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#12792,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#12793,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#12794L,... 2 more fields] parquet
                                                                                    :     :     +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#12381 AS MISE_EN_QUALITE_32533_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#13336, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#12382 AS MISE_EN_QUALITE_32533_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#13337, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#12383 AS MISE_EN_QUALITE_32533_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#13338, COL_CB2E17FC_221C_4C38_A806_E9E33FB8E13F#12384 AS MISE_EN_QUALITE_32533_COL_CB2E17FC_221C_4C38_A806_E9E33FB8E13F#13339, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#12385 AS MISE_EN_QUALITE_32533_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#13340, COL_E081A41A_87E9_4DC8_AC27_5C5C87155BB3#12386 AS MISE_EN_QUALITE_32533_COL_E081A41A_87E9_4DC8_AC27_5C5C87155BB3#13341, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#12387 AS MISE_EN_QUALITE_32533_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#13342, COL_529FE1B7_3F7A_404A_A9DB_662BC865EDF0#12388 AS MISE_EN_QUALITE_32533_COL_529FE1B7_3F7A_404A_A9DB_662BC865EDF0#13343, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#12389 AS MISE_EN_QUALITE_32533_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#13344, COL_E9A52100_C307_4AF4_814C_D9AADF72F033#12390 AS MISE_EN_QUALITE_32533_COL_E9A52100_C307_4AF4_814C_D9AADF72F033#13345, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#12391 AS MISE_EN_QUALITE_32533_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#13346, COL_94E54ED5_3042_45FF_80D0_0CAC840EB097#12392 AS MISE_EN_QUALITE_32533_COL_94E54ED5_3042_45FF_80D0_0CAC840EB097#13347, COL_D67142F7_A207_4870_8963_E237B841636A#12393 AS MISE_EN_QUALITE_32533_COL_D67142F7_A207_4870_8963_E237B841636A#13348, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#12394 AS MISE_EN_QUALITE_32533_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#13349, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#12395 AS MISE_EN_QUALITE_32533_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#13350, COL_250EFFA3_F3D1_4D95_9062_004B0C5E91B7#12396 AS MISE_EN_QUALITE_32533_COL_250EFFA3_F3D1_4D95_9062_004B0C5E91B7#13351, COL_D171F390_EECB_4924_B2C2_095D45EAE768#12397 AS MISE_EN_QUALITE_32533_COL_D171F390_EECB_4924_B2C2_095D45EAE768#13352, COL_15505186_7875_4C25_9AEA_F3510A184E50#12398 AS MISE_EN_QUALITE_32533_COL_15505186_7875_4C25_9AEA_F3510A184E50#13353, COL_B5F1716C_B5E3_470C_86DB_85BBE52E1E63#12399 AS MISE_EN_QUALITE_32533_COL_B5F1716C_B5E3_470C_86DB_85BBE52E1E63#13354, COL_1C35A227_836A_4477_8139_CAB7258B4395#12400 AS MISE_EN_QUALITE_32533_COL_1C35A227_836A_4477_8139_CAB7258B4395#13355, COL_B1E40BB3_6570_4A14_9E67_BB0574B6130D#12401 AS MISE_EN_QUALITE_32533_COL_B1E40BB3_6570_4A14_9E67_BB0574B6130D#13356, COL_26B6B621_1F72_4B3A_92EE_F4C1423FE922#12402 AS MISE_EN_QUALITE_32533_COL_26B6B621_1F72_4B3A_92EE_F4C1423FE922#13357, COL_A5D0563B_E31F_4108_91C1_A7D995E0288F#12403 AS MISE_EN_QUALITE_32533_COL_A5D0563B_E31F_4108_91C1_A7D995E0288F#13358, COL_687B345E_3370_42F7_AB82_B53990B19AFE#12404 AS MISE_EN_QUALITE_32533_COL_687B345E_3370_42F7_AB82_B53990B19AFE#13359, ... 9 more fields]
                                                                                    :     :        +- SubqueryAlias MISE_EN_QUALITE_32533117
                                                                                    :     :           +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#12381,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#12382,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#12383,COL_CB2E17FC_221C_4C38_A806_E9E33FB8E13F#12384,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#12385,COL_E081A41A_87E9_4DC8_AC27_5C5C87155BB3#12386,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#12387,COL_529FE1B7_3F7A_404A_A9DB_662BC865EDF0#12388,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#12389,COL_E9A52100_C307_4AF4_814C_D9AADF72F033#12390,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#12391,COL_94E54ED5_3042_45FF_80D0_0CAC840EB097#12392,COL_D67142F7_A207_4870_8963_E237B841636A#12393,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#12394,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#12395,COL_250EFFA3_F3D1_4D95_9062_004B0C5E91B7#12396,COL_D171F390_EECB_4924_B2C2_095D45EAE768#12397,COL_15505186_7875_4C25_9AEA_F3510A184E50#12398,COL_B5F1716C_B5E3_470C_86DB_85BBE52E1E63#12399,COL_1C35A227_836A_4477_8139_CAB7258B4395#12400,COL_B1E40BB3_6570_4A14_9E67_BB0574B6130D#12401,COL_26B6B621_1F72_4B3A_92EE_F4C1423FE922#12402,COL_A5D0563B_E31F_4108_91C1_A7D995E0288F#12403,COL_687B345E_3370_42F7_AB82_B53990B19AFE#12404,... 9 more fields] parquet
                                                                                    :     +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#12932 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#13550, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#12933 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#13551, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#12934 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#13552, COL_413BE7B8_1BFE_4393_A802_209E3937124C#12935 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#13553, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#12936 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#13554, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#12937 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#13555, COL_F472560C_DB99_41F2_9279_7069140A9D65#12938 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#13556, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#12939 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#13557, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#12940 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#13558, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#12941 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#13559, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#12942 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#13560, COL_135AAA37_5078_4633_9560_24643D2CFC87#12943 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#13561, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#12944 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#13562, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#12945 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#13563, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#12946 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#13564, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#12947 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#13565, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#12948 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#13566, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#12949 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#13567, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#12950 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#13568, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#12951 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#13569, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#12952 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#13570, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#12953 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#13571, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#12954 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#13572, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#12955 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#13573, ... 15 more fields]
                                                                                    :        +- SubqueryAlias UNION_CONSOLIDA_32798117
                                                                                    :           +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#12932,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#12933,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#12934,COL_413BE7B8_1BFE_4393_A802_209E3937124C#12935,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#12936,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#12937,COL_F472560C_DB99_41F2_9279_7069140A9D65#12938,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#12939,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#12940,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#12941,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#12942,COL_135AAA37_5078_4633_9560_24643D2CFC87#12943,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#12944,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#12945,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#12946,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#12947,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#12948,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#12949,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#12950,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#12951,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#12952,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#12953,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#12954,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#12955,... 15 more fields] parquet
                                                                                    +- Project [COL_03FA2FE8_57E6_4BA4_BC1C_FB81A09DC35B#13157 AS UNION_CONSOLIDA_35706_COL_03FA2FE8_57E6_4BA4_BC1C_FB81A09DC35B#13789, COL_B4B39710_A1AA_4F99_955F_A79B0A749692#13158 AS UNION_CONSOLIDA_35706_COL_B4B39710_A1AA_4F99_955F_A79B0A749692#13790, COL_F96D2D63_4A68_4C49_B6BC_BCEEDB231D6C#13159 AS UNION_CONSOLIDA_35706_COL_F96D2D63_4A68_4C49_B6BC_BCEEDB231D6C#13791, COL_AC91CA45_F531_455F_99EA_4453452756C1#13160 AS UNION_CONSOLIDA_35706_COL_AC91CA45_F531_455F_99EA_4453452756C1#13792, COL_AB6A6557_8CBB_4CE2_A4D1_026314A487B4#13161 AS UNION_CONSOLIDA_35706_COL_AB6A6557_8CBB_4CE2_A4D1_026314A487B4#13793, COL_17EB52F1_5CF0_47EB_9FF5_B955A17853BE#13162 AS UNION_CONSOLIDA_35706_COL_17EB52F1_5CF0_47EB_9FF5_B955A17853BE#13794, COL_A7D1531F_308A_45DA_A12B_AB82BABE3F20#13163 AS UNION_CONSOLIDA_35706_COL_A7D1531F_308A_45DA_A12B_AB82BABE3F20#13795, COL_9E08B51E_A147_470F_8848_D4146F5BCEED#13164 AS UNION_CONSOLIDA_35706_COL_9E08B51E_A147_470F_8848_D4146F5BCEED#13796, COL_CAB88597_47F3_4C68_8F0C_4225C4CD9A8D#13165 AS UNION_CONSOLIDA_35706_COL_CAB88597_47F3_4C68_8F0C_4225C4CD9A8D#13797, COL_CCFFB59C_09FC_42B9_8A6E_990BE798A17C#13166 AS UNION_CONSOLIDA_35706_COL_CCFFB59C_09FC_42B9_8A6E_990BE798A17C#13798, COL_CC2A67E4_5191_40DC_A445_0618845F0226#13167 AS UNION_CONSOLIDA_35706_COL_CC2A67E4_5191_40DC_A445_0618845F0226#13799, COL_F2785A1D_51FF_442C_8DE3_FB23ACFF9FA7#13168 AS UNION_CONSOLIDA_35706_COL_F2785A1D_51FF_442C_8DE3_FB23ACFF9FA7#13800, COL_E66EEC2D_4399_4485_AF89_26F8259A852B#13169 AS UNION_CONSOLIDA_35706_COL_E66EEC2D_4399_4485_AF89_26F8259A852B#13801, COL_044DF798_9678_45F4_84D5_870F3084A58A#13170 AS UNION_CONSOLIDA_35706_COL_044DF798_9678_45F4_84D5_870F3084A58A#13802, COL_9D63F002_6A77_46D8_8756_334017AC4798#13171 AS UNION_CONSOLIDA_35706_COL_9D63F002_6A77_46D8_8756_334017AC4798#13803, COL_EA15D99C_060D_495A_ABBD_3F19F29DA6C0#13172 AS UNION_CONSOLIDA_35706_COL_EA15D99C_060D_495A_ABBD_3F19F29DA6C0#13804, COL_E8618990_8A19_4FB9_82A7_14EC1BCB4EC5#13173 AS UNION_CONSOLIDA_35706_COL_E8618990_8A19_4FB9_82A7_14EC1BCB4EC5#13805, COL_BD1BF8C3_4EA7_4473_BEA7_D59EA61F6883#13174 AS UNION_CONSOLIDA_35706_COL_BD1BF8C3_4EA7_4473_BEA7_D59EA61F6883#13806, COL_B957617E_8860_4DF9_A716_7A2FA0A993C1#13175 AS UNION_CONSOLIDA_35706_COL_B957617E_8860_4DF9_A716_7A2FA0A993C1#13807, COL_ECD3CDA2_A160_4E4D_9080_D70CDFBA4C7D#13176 AS UNION_CONSOLIDA_35706_COL_ECD3CDA2_A160_4E4D_9080_D70CDFBA4C7D#13808, COL_79E1EA6C_E644_40AF_BC11_6FEAF7DF79BB#13177 AS UNION_CONSOLIDA_35706_COL_79E1EA6C_E644_40AF_BC11_6FEAF7DF79BB#13809, COL_D2E32321_D502_4601_852A_0484DE59E4B4#13178 AS UNION_CONSOLIDA_35706_COL_D2E32321_D502_4601_852A_0484DE59E4B4#13810, COL_5170A57B_4F46_4902_A468_6E66AC125B3F#13179 AS UNION_CONSOLIDA_35706_COL_5170A57B_4F46_4902_A468_6E66AC125B3F#13811, COL_52E363B6_0838_43F6_936B_6B0C510B4F8F#13180 AS UNION_CONSOLIDA_35706_COL_52E363B6_0838_43F6_936B_6B0C510B4F8F#13812, ... 6 more fields]
                                                                                       +- SubqueryAlias UNION_CONSOLIDA_35706117
                                                                                          +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#13049 as string) AS COL_03FA2FE8_57E6_4BA4_BC1C_FB81A09DC35B#13157, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#13050 as string) AS COL_B4B39710_A1AA_4F99_955F_A79B0A749692#13158, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#13051 as string) AS COL_F96D2D63_4A68_4C49_B6BC_BCEEDB231D6C#13159, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#13052 as string) AS COL_AC91CA45_F531_455F_99EA_4453452756C1#13160, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#13053 as string) AS COL_AB6A6557_8CBB_4CE2_A4D1_026314A487B4#13161, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#13054 as string) AS COL_17EB52F1_5CF0_47EB_9FF5_B955A17853BE#13162, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#13055 as string) AS COL_A7D1531F_308A_45DA_A12B_AB82BABE3F20#13163, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#13056 as string) AS COL_9E08B51E_A147_470F_8848_D4146F5BCEED#13164, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#13057 as string) AS COL_CAB88597_47F3_4C68_8F0C_4225C4CD9A8D#13165, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#13058 as string) AS COL_CCFFB59C_09FC_42B9_8A6E_990BE798A17C#13166, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#13059 as string) AS COL_CC2A67E4_5191_40DC_A445_0618845F0226#13167, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#13060 as string) AS COL_F2785A1D_51FF_442C_8DE3_FB23ACFF9FA7#13168, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#13061 as int) AS COL_E66EEC2D_4399_4485_AF89_26F8259A852B#13169, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#13062 as string) AS COL_044DF798_9678_45F4_84D5_870F3084A58A#13170, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#13063 as string) AS COL_9D63F002_6A77_46D8_8756_334017AC4798#13171, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#13064 as string) AS COL_EA15D99C_060D_495A_ABBD_3F19F29DA6C0#13172, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#13065 as string) AS COL_E8618990_8A19_4FB9_82A7_14EC1BCB4EC5#13173, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#13066 as string) AS COL_BD1BF8C3_4EA7_4473_BEA7_D59EA61F6883#13174, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#13067 as string) AS COL_B957617E_8860_4DF9_A716_7A2FA0A993C1#13175, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#13068 as string) AS COL_ECD3CDA2_A160_4E4D_9080_D70CDFBA4C7D#13176, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#13069 as string) AS COL_79E1EA6C_E644_40AF_BC11_6FEAF7DF79BB#13177, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#13070 as string) AS COL_D2E32321_D502_4601_852A_0484DE59E4B4#13178, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#13071 as string) AS COL_5170A57B_4F46_4902_A468_6E66AC125B3F#13179, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#13072 as string) AS COL_52E363B6_0838_43F6_936B_6B0C510B4F8F#13180, ... 6 more fields]
                                                                                             +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#12932 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#13049, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#12933 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#13050, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#12934 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#13051, COL_413BE7B8_1BFE_4393_A802_209E3937124C#12935 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#13052, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#12936 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#13053, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#12937 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#13054, COL_F472560C_DB99_41F2_9279_7069140A9D65#12938 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#13055, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#12939 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#13056, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#12940 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#13057, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#12941 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#13058, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#12942 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#13059, COL_135AAA37_5078_4633_9560_24643D2CFC87#12943 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#13060, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#12944 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#13061, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#12945 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#13062, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#12946 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#13063, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#12947 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#13064, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#12948 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#13065, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#12949 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#13066, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#12950 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#13067, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#12951 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#13068, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#12952 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#13069, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#12953 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#13070, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#12954 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#13071, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#12955 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#13072, ... 15 more fields]
                                                                                                +- SubqueryAlias UNION_CONSOLIDA_32798117
                                                                                                   +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#12932,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#12933,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#12934,COL_413BE7B8_1BFE_4393_A802_209E3937124C#12935,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#12936,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#12937,COL_F472560C_DB99_41F2_9279_7069140A9D65#12938,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#12939,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#12940,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#12941,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#12942,COL_135AAA37_5078_4633_9560_24643D2CFC87#12943,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#12944,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#12945,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#12946,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#12947,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#12948,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#12949,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#12950,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#12951,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#12952,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#12953,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#12954,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#12955,... 15 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [str_extract(col0#14085, LEFT, 1) AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14208, str_extract_by_str(col0#14085, _, RIGHT) AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14209, col1#14086L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14210L, COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14043L AS COL_71232578_F97E_49C3_853C_8855059795AE#14211L]
      +- Generate stack(4, 1_Creconciliation, COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14044L, 2_CMise en qualité, COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14045L, 3_CLiens ERP, COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14046L, 4_CTemplate intermédiaire, COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14047L), [1, 2, 3, 4], false, [col0#14085, col1#14086L]
         +- Aggregate [first(if ((gid#14216 = 0)) first(`COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`)#14222L else null, true) AS COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14043L, count(if ((gid#14216 = 2)) `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218 else null) AS COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14044L, count(if ((gid#14216 = 3)) `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219 else null) AS COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14045L, count(if ((gid#14216 = 1)) `COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217 else null) AS COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14046L, count(if ((gid#14216 = 4)) `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220 else null) AS COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14047L]
            +- Aggregate [`COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217, `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218, `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219, `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220, gid#14216], [`COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217, `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218, `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219, `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220, gid#14216, first(`COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`#14221L, true) AS first(`COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`)#14222L]
               +- Expand [ArrayBuffer(null, null, null, null, 0, COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L), ArrayBuffer(COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754, null, null, null, 1, null), ArrayBuffer(null, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, null, null, 2, null), ArrayBuffer(null, null, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507, null, 3, null), ArrayBuffer(null, null, null, COL_7D036902_86FC_458E_9191_C7366A25077D#14026, 4, null)], [`COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217, `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218, `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219, `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220, gid#14216, `COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`#14221L]
                  +- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507, COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754, UNION_CONSOLIDA_35706_COL_15D6002F_01DC_4CD1_B54A_C61057C00E79#13818 AS COL_7D036902_86FC_458E_9191_C7366A25077D#14026]
                     +- Join LeftOuter, (COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298 = UNION_CONSOLIDA_35706_COL_15D6002F_01DC_4CD1_B54A_C61057C00E79#13818)
                        :- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507, UNION_CONSOLIDA_32798_COL_43086D10_3F11_4F63_A391_E0C83BB48357#13586 AS COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754]
                        :  +- Join LeftOuter, (COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298 = UNION_CONSOLIDA_32798_COL_43086D10_3F11_4F63_A391_E0C83BB48357#13586)
                        :     :- Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, MISE_EN_QUALITE_32533_COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#13365 AS COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507]
                        :     :  +- Join LeftOuter, (COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298 = MISE_EN_QUALITE_32533_COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#13365)
                        :     :     :- Project [COL_3AA9677C_9524_43B7_9984_7C0506F35631#12790L AS COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#12793 AS COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298]
                        :     :     :  +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#12771,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#12772,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#12773,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#12774,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#12775,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#12776,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#12777,COL_D67142F7_A207_4870_8963_E237B841636A#12778,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#12779,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#12780,COL_1C35A227_836A_4477_8139_CAB7258B4395#12781,COL_D171F390_EECB_4924_B2C2_095D45EAE768#12782,COL_15505186_7875_4C25_9AEA_F3510A184E50#12783,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#12784,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#12785,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#12786,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#12787,COL_7097258E_E88A_49F2_831E_C3EE780B3488#12788,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#12789,COL_3AA9677C_9524_43B7_9984_7C0506F35631#12790L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#12791L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#12792,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#12793,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#12794L,... 2 more fields] parquet
                        :     :     +- Project [COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#12410 AS MISE_EN_QUALITE_32533_COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#13365]
                        :     :        +- Filter isnotnull(COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#12410)
                        :     :           +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#12381,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#12382,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#12383,COL_CB2E17FC_221C_4C38_A806_E9E33FB8E13F#12384,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#12385,COL_E081A41A_87E9_4DC8_AC27_5C5C87155BB3#12386,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#12387,COL_529FE1B7_3F7A_404A_A9DB_662BC865EDF0#12388,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#12389,COL_E9A52100_C307_4AF4_814C_D9AADF72F033#12390,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#12391,COL_94E54ED5_3042_45FF_80D0_0CAC840EB097#12392,COL_D67142F7_A207_4870_8963_E237B841636A#12393,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#12394,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#12395,COL_250EFFA3_F3D1_4D95_9062_004B0C5E91B7#12396,COL_D171F390_EECB_4924_B2C2_095D45EAE768#12397,COL_15505186_7875_4C25_9AEA_F3510A184E50#12398,COL_B5F1716C_B5E3_470C_86DB_85BBE52E1E63#12399,COL_1C35A227_836A_4477_8139_CAB7258B4395#12400,COL_B1E40BB3_6570_4A14_9E67_BB0574B6130D#12401,COL_26B6B621_1F72_4B3A_92EE_F4C1423FE922#12402,COL_A5D0563B_E31F_4108_91C1_A7D995E0288F#12403,COL_687B345E_3370_42F7_AB82_B53990B19AFE#12404,... 9 more fields] parquet
                        :     +- Project [COL_43086D10_3F11_4F63_A391_E0C83BB48357#12968 AS UNION_CONSOLIDA_32798_COL_43086D10_3F11_4F63_A391_E0C83BB48357#13586]
                        :        +- Filter isnotnull(COL_43086D10_3F11_4F63_A391_E0C83BB48357#12968)
                        :           +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#12932,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#12933,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#12934,COL_413BE7B8_1BFE_4393_A802_209E3937124C#12935,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#12936,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#12937,COL_F472560C_DB99_41F2_9279_7069140A9D65#12938,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#12939,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#12940,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#12941,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#12942,COL_135AAA37_5078_4633_9560_24643D2CFC87#12943,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#12944,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#12945,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#12946,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#12947,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#12948,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#12949,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#12950,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#12951,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#12952,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#12953,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#12954,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#12955,... 15 more fields] parquet
                        +- Project [COL_43086D10_3F11_4F63_A391_E0C83BB48357#12968 AS UNION_CONSOLIDA_35706_COL_15D6002F_01DC_4CD1_B54A_C61057C00E79#13818]
                           +- Filter isnotnull(COL_43086D10_3F11_4F63_A391_E0C83BB48357#12968)
                              +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#12932,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#12933,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#12934,COL_413BE7B8_1BFE_4393_A802_209E3937124C#12935,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#12936,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#12937,COL_F472560C_DB99_41F2_9279_7069140A9D65#12938,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#12939,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#12940,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#12941,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#12942,COL_135AAA37_5078_4633_9560_24643D2CFC87#12943,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#12944,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#12945,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#12946,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#12947,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#12948,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#12949,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#12950,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#12951,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#12952,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#12953,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#12954,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#12955,... 15 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(7) Project [str_extract(col0#14085, LEFT, 1) AS COL_DD76590D_237D_4F60_AD1B_9EE19E82973B#14208, str_extract_by_str(col0#14085, _, RIGHT) AS COL_990E0DB6_9EFE_44D8_A7D5_0C4ED47DB4FF#14209, col1#14086L AS COL_7BE840B2_31C5_4134_B22E_733DCE5B8181#14210L, COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14043L AS COL_71232578_F97E_49C3_853C_8855059795AE#14211L]
      +- Generate stack(4, 1_Creconciliation, COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14044L, 2_CMise en qualité, COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14045L, 3_CLiens ERP, COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14046L, 4_CTemplate intermédiaire, COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14047L), [COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14043L], false, [col0#14085, col1#14086L]
         +- *(6) HashAggregate(keys=[], functions=[first(if ((gid#14216 = 0)) first(`COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`)#14222L else null, true), count(if ((gid#14216 = 2)) `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218 else null), count(if ((gid#14216 = 3)) `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219 else null), count(if ((gid#14216 = 1)) `COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217 else null), count(if ((gid#14216 = 4)) `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220 else null)], output=[COL_2975DA6F_5BBF_47D2_9DEB_5D84A5A544A8#14043L, COL_97E7B1D8_F450_4994_9AA5_DED6B0378C35#14044L, COL_FACE53AE_5B96_4B34_89DF_F34821A97C2A#14045L, COL_B36F7843_58E2_45FE_A9C1_53E697B720AC#14046L, COL_05BCC250_C714_4C46_92FC_D7CC44D741B7#14047L])
            +- ShuffleQueryStage 5
               +- Exchange SinglePartition, true, [id=#3535]
                  +- *(5) HashAggregate(keys=[], functions=[partial_first(if ((gid#14216 = 0)) first(`COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`)#14222L else null, true), partial_count(if ((gid#14216 = 2)) `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218 else null), partial_count(if ((gid#14216 = 3)) `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219 else null), partial_count(if ((gid#14216 = 1)) `COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217 else null), partial_count(if ((gid#14216 = 4)) `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220 else null)], output=[first#14306L, valueSet#14307, count#14308L, count#14309L, count#14310L, count#14311L])
                     +- *(5) HashAggregate(keys=[`COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217, `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218, `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219, `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220, gid#14216], functions=[first(`COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`#14221L, true)], output=[`COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217, `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218, `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219, `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220, gid#14216, first(`COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`)#14222L])
                        +- CustomShuffleReader coalesced
                           +- ShuffleQueryStage 4
                              +- Exchange hashpartitioning(`COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217, `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218, `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219, `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220, gid#14216, 200), true, [id=#3465]
                                 +- *(4) HashAggregate(keys=[`COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217, `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218, `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219, `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220, gid#14216], functions=[partial_first(`COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`#14221L, true)], output=[`COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217, `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218, `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219, `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220, gid#14216, first#14314L, valueSet#14315])
                                    +- *(4) Expand [ArrayBuffer(null, null, null, null, 0, COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L), ArrayBuffer(COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754, null, null, null, 1, null), ArrayBuffer(null, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, null, null, 2, null), ArrayBuffer(null, null, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507, null, 3, null), ArrayBuffer(null, null, null, COL_7D036902_86FC_458E_9191_C7366A25077D#14026, 4, null)], [`COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4`#14217, `COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C`#14218, `COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA`#14219, `COL_7D036902_86FC_458E_9191_C7366A25077D`#14220, gid#14216, `COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0`#14221L]
                                       +- *(4) Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507, COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754, UNION_CONSOLIDA_35706_COL_15D6002F_01DC_4CD1_B54A_C61057C00E79#13818 AS COL_7D036902_86FC_458E_9191_C7366A25077D#14026]
                                          +- *(4) BroadcastHashJoin [COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298], [UNION_CONSOLIDA_35706_COL_15D6002F_01DC_4CD1_B54A_C61057C00E79#13818], LeftOuter, BuildRight
                                             :- *(4) Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507, UNION_CONSOLIDA_32798_COL_43086D10_3F11_4F63_A391_E0C83BB48357#13586 AS COL_BD845E06_19C2_4682_8804_E65DA3C3D3C4#13754]
                                             :  +- *(4) BroadcastHashJoin [COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298], [UNION_CONSOLIDA_32798_COL_43086D10_3F11_4F63_A391_E0C83BB48357#13586], LeftOuter, BuildRight
                                             :     :- *(4) Project [COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298, MISE_EN_QUALITE_32533_COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#13365 AS COL_0DE6696C_F70A_4F57_95EB_9D6E8F00DDAA#13507]
                                             :     :  +- *(4) BroadcastHashJoin [COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298], [MISE_EN_QUALITE_32533_COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#13365], LeftOuter, BuildRight
                                             :     :     :- *(4) Project [COL_3AA9677C_9524_43B7_9984_7C0506F35631#12790L AS COL_852330B2_7BEC_44C4_B74B_7BA83D974BE0#13297L, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#12793 AS COL_EA3ACC96_EB0A_461C_B53B_51BC93AA7D3C#13298]
                                             :     :     :  +- *(4) ColumnarToRow
                                             :     :     :     +- FileScan parquet [COL_3AA9677C_9524_43B7_9984_7C0506F35631#12790L,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#12793] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/BASE_RECONCILIA_32037], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_3AA9677C_9524_43B7_9984_7C0506F35631:bigint,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595:s...
                                             :     :     +- BroadcastQueryStage 0
                                             :     :        +- BroadcastExchange HashedRelationBroadcastMode(List(input[0, string, true])), [id=#3236]
                                             :     :           +- *(1) Project [COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#12410 AS MISE_EN_QUALITE_32533_COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#13365]
                                             :     :              +- *(1) Filter isnotnull(COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#12410)
                                             :     :                 +- *(1) ColumnarToRow
                                             :     :                    +- FileScan parquet [COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#12410] Batched: true, DataFilters: [isnotnull(COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C#12410)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/MISE_EN_QUALITE_32533], PartitionFilters: [], PushedFilters: [IsNotNull(COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C)], ReadSchema: struct<COL_23625D52_51A7_4BE8_9ADD_5022CD4F6F5C:string>
                                             :     +- BroadcastQueryStage 1
                                             :        +- BroadcastExchange HashedRelationBroadcastMode(List(input[0, string, true])), [id=#3257]
                                             :           +- *(2) Project [COL_43086D10_3F11_4F63_A391_E0C83BB48357#12968 AS UNION_CONSOLIDA_32798_COL_43086D10_3F11_4F63_A391_E0C83BB48357#13586]
                                             :              +- *(2) Filter isnotnull(COL_43086D10_3F11_4F63_A391_E0C83BB48357#12968)
                                             :                 +- *(2) ColumnarToRow
                                             :                    +- FileScan parquet [COL_43086D10_3F11_4F63_A391_E0C83BB48357#12968] Batched: true, DataFilters: [isnotnull(COL_43086D10_3F11_4F63_A391_E0C83BB48357#12968)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/UNION_CONSOLIDA_32798], PartitionFilters: [], PushedFilters: [IsNotNull(COL_43086D10_3F11_4F63_A391_E0C83BB48357)], ReadSchema: struct<COL_43086D10_3F11_4F63_A391_E0C83BB48357:string>
                                             +- BroadcastQueryStage 3
                                                +- ReusedExchange [UNION_CONSOLIDA_35706_COL_15D6002F_01DC_4CD1_B54A_C61057C00E79#13818], BroadcastExchange HashedRelationBroadcastMode(List(input[0, string, true])), [id=#3257]