DC2 - Details for Query 51

Details for Query 51

Submitted Time: 2025/11/07 08:58:23
Duration: 1 s
Succeeded Jobs: 69 71 72

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" TakeOrderedAndProject "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 10 ms"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label="Generate number of output rows: 2"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 15 ms"; 6 [labelType="html" label=" Project "]; 7 [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"]; } 8 [labelType="html" label="Exchange shuffle records written: 13 shuffle write time total (min, med, max (stageId: taskId)) 9 ms (0 ms, 0 ms, 4 ms (stage 80.0: task 188)) records read: 13 local bytes read: 884.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)) 416.0 B (32.0 B, 32.0 B, 32.0 B (stage 80.0: task 187)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 884.0 B (68.0 B, 68.0 B, 68.0 B (stage 80.0: task 187))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n100 ms (2 ms, 6 ms, 17 ms (stage 80.0: task 183))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 88 ms (2 ms, 5 ms, 17 ms (stage 80.0: task 185)) peak memory: 0.0 B number of output rows: 13 avg hash probe bucket list iters: 0"]; 11 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 2 ms (0 ms, 0 ms, 1 ms (stage 80.0: task 192)) peak memory total (min, med, max (stageId: taskId)) 3.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 80.0: task 187)) number of output rows: 355 avg hash probe bucket list iters: 0"]; } 12 [labelType="html" label=" CustomShuffleReader "]; 13 [labelType="html" label="Exchange shuffle records written: 355 shuffle write time total (min, med, max (stageId: taskId)) 321 ms (8 ms, 51 ms, 73 ms (stage 75.0: task 164)) records read: 355 local bytes read total (min, med, max (stageId: taskId)) 35.2 KiB (1827.0 B, 2.8 KiB, 2.9 KiB (stage 80.0: task 189)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 80.0: task 187)) remote bytes read: 0.0 B local blocks read: 88 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 25.0 KiB (2.5 KiB, 3.4 KiB, 5.0 KiB (stage 75.0: task 165)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 35.2 KiB (3.6 KiB, 4.9 KiB, 6.9 KiB (stage 75.0: task 165))"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n800 ms (52 ms, 134 ms, 147 ms (stage 75.0: task 167))"; 15 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 126 ms (5 ms, 17 ms, 24 ms (stage 75.0: task 166)) peak memory total (min, med, max (stageId: taskId)) 1792.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 75.0: task 171)) number of output rows: 355 avg hash probe bucket list iters: 0"]; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label="ColumnarToRow number of output rows: 9,034 number of input batches: 13"]; } 18 [labelType="html" label="Scan parquet number of files read: 13 scan time total (min, med, max (stageId: taskId)) 57 ms (4 ms, 9 ms, 13 ms (stage 75.0: task 166)) metadata time: 0 ms size of files read: 1019.8 KiB number of output rows: 9,034"]; 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 10->8; 11->10; 12->11; 13->12; 15->13; 16->15; 17->16; 18->17; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=500000, orderBy=[COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125 ASC NULLS FIRST], output=[COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125,COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18126])

Project [col0#17940 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125, col1#17941 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18126]

WholeStageCodegen (4)

Generate stack(2, Sans rappro. séma., COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17920, Au moins 1 rappro. séma., COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17921), false, [col0#17940, col1#17941]

Project [bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L)))) AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17920, bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D, bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L)))))))) AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17921]

HashAggregate(keys=[], functions=[first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852, true), count(distinct COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850)])

WholeStageCodegen (3)

Exchange SinglePartition, true, [id=#1760]

HashAggregate(keys=[], functions=[merge_first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852, true), partial_count(distinct COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850)])

HashAggregate(keys=[COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850], functions=[merge_first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852, true)])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850, 200), true, [id=#1700]

HashAggregate(keys=[COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850], functions=[partial_first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852, true)])

Project [COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#17614 AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850, COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#17613 AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#17613,COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#17614] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/LIEN_GIE_ERP_MA_38630], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035:int,COL_0BFFB8BB_D083_4847_976A_207D4A1BD197:string>

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18148, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18126 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18149]
      +- Sort [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125 ASC NULLS FIRST], true
         +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18121 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18122 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18126]
            +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18117 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18121, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18118 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18122]
               +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18094 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18117, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18095 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18118]
                  +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18090 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18094, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18091 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18095]
                     +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18067 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18090, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18068 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18091]
                        +- Project [cast(ANALYSE_LIEN_GI_39003_COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#18061 as string) AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18067, cast(ANALYSE_LIEN_GI_39003_COL_222208BC_CE88_4728_B52A_83AAAD5F6176#18062 as int) AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18068]
                           +- Project [COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#18047 AS ANALYSE_LIEN_GI_39003_COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#18061, COL_222208BC_CE88_4728_B52A_83AAAD5F6176#18050 AS ANALYSE_LIEN_GI_39003_COL_222208BC_CE88_4728_B52A_83AAAD5F6176#18062]
                              +- SubqueryAlias ANALYSE_LIEN_GI_39003116
                                 +- Project [COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#18047, COL_222208BC_CE88_4728_B52A_83AAAD5F6176#18050]
                                    +- Project [COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#18047, col1#17941 AS COL_222208BC_CE88_4728_B52A_83AAAD5F6176#18050]
                                       +- Project [col0#17940 AS COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#18047, col1#17941]
                                          +- Project [col0#17940, col1#17941]
                                             +- Generate stack(2, Sans rappro. séma., COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17920, Au moins 1 rappro. séma., COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17921), false, [col0#17940, col1#17941]
                                                +- Project [COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17911L AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17918L, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17910 AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17919, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17912 AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17920, COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17913 AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17921]
                                                   +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17897 AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17910, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17898L AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17911L, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17901 AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17912, COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17905 AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17913]
                                                      +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17897, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17898L, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17901, bigint_to_int(dec_to_int(dec_operator(cast(DIFFERENCE as string), struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17897, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17901)))) AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17905]
                                                         +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17897, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17898L, bigint_to_int(dec_to_int(dec_operator(cast(DIFFERENCE as string), struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17897, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17898L)))) AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17901]
                                                            +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886 AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17897, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17898L]
                                                               +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L]
                                                                  +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L]
                                                                     +- Aggregate [1 AS NULL_1#17888, first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852, true) AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, count(distinct COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850) AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L]
                                                                        +- Project [COL_7655E225_968A_4BA2_AE4B_46DF93236F8F#17805 AS COL_7655E225_968A_4BA2_AE4B_46DF93236F8F#17837, COL_0FCCA874_3F46_417C_BF9C_67A376A4E47B#17806 AS COL_0FCCA874_3F46_417C_BF9C_67A376A4E47B#17838, COL_2E420555_F6E2_49CC_8BC1_F163AFCD71D1#17807 AS COL_2E420555_F6E2_49CC_8BC1_F163AFCD71D1#17839, COL_D08B2B58_592D_4A09_A81E_4A4F95EF9E46#17808 AS COL_D08B2B58_592D_4A09_A81E_4A4F95EF9E46#17840, COL_B7682B50_082C_4AF2_AFA4_25C011882D62#17809 AS COL_B7682B50_082C_4AF2_AFA4_25C011882D62#17841, COL_C0B76942_B4E4_4299_86B8_50A58AE36ED2#17810 AS COL_C0B76942_B4E4_4299_86B8_50A58AE36ED2#17842, COL_0F97308E_6030_4FEE_AC22_070DA25D6845#17811 AS COL_0F97308E_6030_4FEE_AC22_070DA25D6845#17843, COL_1F290799_14D9_4BEB_914C_CDECCBBFE676#17812 AS COL_1F290799_14D9_4BEB_914C_CDECCBBFE676#17844, COL_293E8352_D31A_4543_A829_35FF86C94519#17813 AS COL_293E8352_D31A_4543_A829_35FF86C94519#17845, COL_1ED54653_6A64_4D32_9562_B5546C607088#17814 AS COL_1ED54653_6A64_4D32_9562_B5546C607088#17846, COL_FB0BFD58_16BF_482D_8ABD_37662F428297#17815 AS COL_FB0BFD58_16BF_482D_8ABD_37662F428297#17847, COL_26BA3866_BE5E_4863_B74E_42249B7A92EC#17816 AS COL_26BA3866_BE5E_4863_B74E_42249B7A92EC#17848, COL_D9D28B59_BFF9_4941_B82F_DFE5584EE1B0#17817 AS COL_D9D28B59_BFF9_4941_B82F_DFE5584EE1B0#17849, COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17818 AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850, COL_77AFEAB1_F72A_4A6C_808F_72D3BB30EDEC#17819L AS COL_77AFEAB1_F72A_4A6C_808F_72D3BB30EDEC#17851L, COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17820 AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852]
                                                                           +- Project [cast(LIEN_GIE_ERP_MA_38630_COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#17708 as string) AS COL_7655E225_968A_4BA2_AE4B_46DF93236F8F#17805, cast(LIEN_GIE_ERP_MA_38630_COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#17706 as string) AS COL_0FCCA874_3F46_417C_BF9C_67A376A4E47B#17806, cast(LIEN_GIE_ERP_MA_38630_COL_898D5D22_9D01_4318_B8E7_221E83C51A88#17707 as string) AS COL_2E420555_F6E2_49CC_8BC1_F163AFCD71D1#17807, cast(LIEN_GIE_ERP_MA_38630_COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#17705 as string) AS COL_D08B2B58_592D_4A09_A81E_4A4F95EF9E46#17808, cast(LIEN_GIE_ERP_MA_38630_COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#17710 as string) AS COL_B7682B50_082C_4AF2_AFA4_25C011882D62#17809, cast(LIEN_GIE_ERP_MA_38630_COL_605386DE_CCAB_46E4_A684_F9449D050D33#17709 as string) AS COL_C0B76942_B4E4_4299_86B8_50A58AE36ED2#17810, cast(LIEN_GIE_ERP_MA_38630_COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#17715 as string) AS COL_0F97308E_6030_4FEE_AC22_070DA25D6845#17811, cast(LIEN_GIE_ERP_MA_38630_COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#17718 as string) AS COL_1F290799_14D9_4BEB_914C_CDECCBBFE676#17812, cast(LIEN_GIE_ERP_MA_38630_COL_FE618529_0873_4690_B1DA_084DC1715835#17716 as string) AS COL_293E8352_D31A_4543_A829_35FF86C94519#17813, cast(LIEN_GIE_ERP_MA_38630_COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#17719 as string) AS COL_1ED54653_6A64_4D32_9562_B5546C607088#17814, cast(LIEN_GIE_ERP_MA_38630_COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#17717 as string) AS COL_FB0BFD58_16BF_482D_8ABD_37662F428297#17815, cast(LIEN_GIE_ERP_MA_38630_COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#17720 as string) AS COL_26BA3866_BE5E_4863_B74E_42249B7A92EC#17816, cast(LIEN_GIE_ERP_MA_38630_COL_6BC44D5F_C691_4AC6_BB8C_87BCFD8D9D01#17735 as int) AS COL_D9D28B59_BFF9_4941_B82F_DFE5584EE1B0#17817, cast(LIEN_GIE_ERP_MA_38630_COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#17740 as string) AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17818, cast(LIEN_GIE_ERP_MA_38630_COL_1DD34323_CDA4_40CB_B7A1_0ABF22E67755#17741L as bigint) AS COL_77AFEAB1_F72A_4A6C_808F_72D3BB30EDEC#17819L, cast(LIEN_GIE_ERP_MA_38630_COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#17739 as int) AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17820]
                                                                              +- Project [COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#17579 AS LIEN_GIE_ERP_MA_38630_COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#17705, COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#17580 AS LIEN_GIE_ERP_MA_38630_COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#17706, COL_898D5D22_9D01_4318_B8E7_221E83C51A88#17581 AS LIEN_GIE_ERP_MA_38630_COL_898D5D22_9D01_4318_B8E7_221E83C51A88#17707, COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#17582 AS LIEN_GIE_ERP_MA_38630_COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#17708, COL_605386DE_CCAB_46E4_A684_F9449D050D33#17583 AS LIEN_GIE_ERP_MA_38630_COL_605386DE_CCAB_46E4_A684_F9449D050D33#17709, COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#17584 AS LIEN_GIE_ERP_MA_38630_COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#17710, COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#17585 AS LIEN_GIE_ERP_MA_38630_COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#17711, COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#17586 AS LIEN_GIE_ERP_MA_38630_COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#17712, COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#17587 AS LIEN_GIE_ERP_MA_38630_COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#17713, COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#17588 AS LIEN_GIE_ERP_MA_38630_COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#17714, COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#17589 AS LIEN_GIE_ERP_MA_38630_COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#17715, COL_FE618529_0873_4690_B1DA_084DC1715835#17590 AS LIEN_GIE_ERP_MA_38630_COL_FE618529_0873_4690_B1DA_084DC1715835#17716, COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#17591 AS LIEN_GIE_ERP_MA_38630_COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#17717, COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#17592 AS LIEN_GIE_ERP_MA_38630_COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#17718, COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#17593 AS LIEN_GIE_ERP_MA_38630_COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#17719, COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#17594 AS LIEN_GIE_ERP_MA_38630_COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#17720, COL_D9C0D816_857E_43AB_BB97_231118B63DB4#17595 AS LIEN_GIE_ERP_MA_38630_COL_D9C0D816_857E_43AB_BB97_231118B63DB4#17721, COL_7DB28DE9_8E36_465B_B40B_286835BE909D#17596 AS LIEN_GIE_ERP_MA_38630_COL_7DB28DE9_8E36_465B_B40B_286835BE909D#17722, COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#17597 AS LIEN_GIE_ERP_MA_38630_COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#17723, COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#17598 AS LIEN_GIE_ERP_MA_38630_COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#17724, COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#17599 AS LIEN_GIE_ERP_MA_38630_COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#17725, COL_0105775B_EA44_44B2_8C95_E36C29A4D241#17600 AS LIEN_GIE_ERP_MA_38630_COL_0105775B_EA44_44B2_8C95_E36C29A4D241#17726, COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#17601 AS LIEN_GIE_ERP_MA_38630_COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#17727, COL_3872240D_C102_43BD_AC54_87416C97E6C5#17602 AS LIEN_GIE_ERP_MA_38630_COL_3872240D_C102_43BD_AC54_87416C97E6C5#17728, ... 18 more fields]
                                                                                 +- SubqueryAlias LIEN_GIE_ERP_MA_38630116
                                                                                    +- Relation[COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#17579,COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#17580,COL_898D5D22_9D01_4318_B8E7_221E83C51A88#17581,COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#17582,COL_605386DE_CCAB_46E4_A684_F9449D050D33#17583,COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#17584,COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#17585,COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#17586,COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#17587,COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#17588,COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#17589,COL_FE618529_0873_4690_B1DA_084DC1715835#17590,COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#17591,COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#17592,COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#17593,COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#17594,COL_D9C0D816_857E_43AB_BB97_231118B63DB4#17595,COL_7DB28DE9_8E36_465B_B40B_286835BE909D#17596,COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#17597,COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#17598,COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#17599,COL_0105775B_EA44_44B2_8C95_E36C29A4D241#17600,COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#17601,COL_3872240D_C102_43BD_AC54_87416C97E6C5#17602,... 18 more fields] parquet

== Analyzed Logical Plan ==
COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09: string, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142: int
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18148, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18126 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18149]
      +- Sort [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125 ASC NULLS FIRST], true
         +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18121 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18122 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18126]
            +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18117 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18121, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18118 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18122]
               +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18094 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18117, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18095 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18118]
                  +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18090 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18094, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18091 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18095]
                     +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18067 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18090, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18068 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18091]
                        +- Project [cast(ANALYSE_LIEN_GI_39003_COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#18061 as string) AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18067, cast(ANALYSE_LIEN_GI_39003_COL_222208BC_CE88_4728_B52A_83AAAD5F6176#18062 as int) AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18068]
                           +- Project [COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#18047 AS ANALYSE_LIEN_GI_39003_COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#18061, COL_222208BC_CE88_4728_B52A_83AAAD5F6176#18050 AS ANALYSE_LIEN_GI_39003_COL_222208BC_CE88_4728_B52A_83AAAD5F6176#18062]
                              +- SubqueryAlias ANALYSE_LIEN_GI_39003116
                                 +- Project [COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#18047, COL_222208BC_CE88_4728_B52A_83AAAD5F6176#18050]
                                    +- Project [COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#18047, col1#17941 AS COL_222208BC_CE88_4728_B52A_83AAAD5F6176#18050]
                                       +- Project [col0#17940 AS COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#18047, col1#17941]
                                          +- Project [col0#17940, col1#17941]
                                             +- Generate stack(2, Sans rappro. séma., COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17920, Au moins 1 rappro. séma., COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17921), false, [col0#17940, col1#17941]
                                                +- Project [COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17911L AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17918L, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17910 AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17919, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17912 AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17920, COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17913 AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17921]
                                                   +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17897 AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17910, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17898L AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17911L, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17901 AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17912, COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17905 AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17913]
                                                      +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17897, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17898L, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17901, bigint_to_int(dec_to_int(dec_operator(cast(DIFFERENCE as string), struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17897, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17901)))) AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17905]
                                                         +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17897, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17898L, bigint_to_int(dec_to_int(dec_operator(cast(DIFFERENCE as string), struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17897, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17898L)))) AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17901]
                                                            +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886 AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17897, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17898L]
                                                               +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L]
                                                                  +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L]
                                                                     +- Aggregate [1 AS NULL_1#17888, first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852, true) AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, count(distinct COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850) AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L]
                                                                        +- Project [COL_7655E225_968A_4BA2_AE4B_46DF93236F8F#17805 AS COL_7655E225_968A_4BA2_AE4B_46DF93236F8F#17837, COL_0FCCA874_3F46_417C_BF9C_67A376A4E47B#17806 AS COL_0FCCA874_3F46_417C_BF9C_67A376A4E47B#17838, COL_2E420555_F6E2_49CC_8BC1_F163AFCD71D1#17807 AS COL_2E420555_F6E2_49CC_8BC1_F163AFCD71D1#17839, COL_D08B2B58_592D_4A09_A81E_4A4F95EF9E46#17808 AS COL_D08B2B58_592D_4A09_A81E_4A4F95EF9E46#17840, COL_B7682B50_082C_4AF2_AFA4_25C011882D62#17809 AS COL_B7682B50_082C_4AF2_AFA4_25C011882D62#17841, COL_C0B76942_B4E4_4299_86B8_50A58AE36ED2#17810 AS COL_C0B76942_B4E4_4299_86B8_50A58AE36ED2#17842, COL_0F97308E_6030_4FEE_AC22_070DA25D6845#17811 AS COL_0F97308E_6030_4FEE_AC22_070DA25D6845#17843, COL_1F290799_14D9_4BEB_914C_CDECCBBFE676#17812 AS COL_1F290799_14D9_4BEB_914C_CDECCBBFE676#17844, COL_293E8352_D31A_4543_A829_35FF86C94519#17813 AS COL_293E8352_D31A_4543_A829_35FF86C94519#17845, COL_1ED54653_6A64_4D32_9562_B5546C607088#17814 AS COL_1ED54653_6A64_4D32_9562_B5546C607088#17846, COL_FB0BFD58_16BF_482D_8ABD_37662F428297#17815 AS COL_FB0BFD58_16BF_482D_8ABD_37662F428297#17847, COL_26BA3866_BE5E_4863_B74E_42249B7A92EC#17816 AS COL_26BA3866_BE5E_4863_B74E_42249B7A92EC#17848, COL_D9D28B59_BFF9_4941_B82F_DFE5584EE1B0#17817 AS COL_D9D28B59_BFF9_4941_B82F_DFE5584EE1B0#17849, COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17818 AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850, COL_77AFEAB1_F72A_4A6C_808F_72D3BB30EDEC#17819L AS COL_77AFEAB1_F72A_4A6C_808F_72D3BB30EDEC#17851L, COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17820 AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852]
                                                                           +- Project [cast(LIEN_GIE_ERP_MA_38630_COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#17708 as string) AS COL_7655E225_968A_4BA2_AE4B_46DF93236F8F#17805, cast(LIEN_GIE_ERP_MA_38630_COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#17706 as string) AS COL_0FCCA874_3F46_417C_BF9C_67A376A4E47B#17806, cast(LIEN_GIE_ERP_MA_38630_COL_898D5D22_9D01_4318_B8E7_221E83C51A88#17707 as string) AS COL_2E420555_F6E2_49CC_8BC1_F163AFCD71D1#17807, cast(LIEN_GIE_ERP_MA_38630_COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#17705 as string) AS COL_D08B2B58_592D_4A09_A81E_4A4F95EF9E46#17808, cast(LIEN_GIE_ERP_MA_38630_COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#17710 as string) AS COL_B7682B50_082C_4AF2_AFA4_25C011882D62#17809, cast(LIEN_GIE_ERP_MA_38630_COL_605386DE_CCAB_46E4_A684_F9449D050D33#17709 as string) AS COL_C0B76942_B4E4_4299_86B8_50A58AE36ED2#17810, cast(LIEN_GIE_ERP_MA_38630_COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#17715 as string) AS COL_0F97308E_6030_4FEE_AC22_070DA25D6845#17811, cast(LIEN_GIE_ERP_MA_38630_COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#17718 as string) AS COL_1F290799_14D9_4BEB_914C_CDECCBBFE676#17812, cast(LIEN_GIE_ERP_MA_38630_COL_FE618529_0873_4690_B1DA_084DC1715835#17716 as string) AS COL_293E8352_D31A_4543_A829_35FF86C94519#17813, cast(LIEN_GIE_ERP_MA_38630_COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#17719 as string) AS COL_1ED54653_6A64_4D32_9562_B5546C607088#17814, cast(LIEN_GIE_ERP_MA_38630_COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#17717 as string) AS COL_FB0BFD58_16BF_482D_8ABD_37662F428297#17815, cast(LIEN_GIE_ERP_MA_38630_COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#17720 as string) AS COL_26BA3866_BE5E_4863_B74E_42249B7A92EC#17816, cast(LIEN_GIE_ERP_MA_38630_COL_6BC44D5F_C691_4AC6_BB8C_87BCFD8D9D01#17735 as int) AS COL_D9D28B59_BFF9_4941_B82F_DFE5584EE1B0#17817, cast(LIEN_GIE_ERP_MA_38630_COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#17740 as string) AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17818, cast(LIEN_GIE_ERP_MA_38630_COL_1DD34323_CDA4_40CB_B7A1_0ABF22E67755#17741L as bigint) AS COL_77AFEAB1_F72A_4A6C_808F_72D3BB30EDEC#17819L, cast(LIEN_GIE_ERP_MA_38630_COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#17739 as int) AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17820]
                                                                              +- Project [COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#17579 AS LIEN_GIE_ERP_MA_38630_COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#17705, COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#17580 AS LIEN_GIE_ERP_MA_38630_COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#17706, COL_898D5D22_9D01_4318_B8E7_221E83C51A88#17581 AS LIEN_GIE_ERP_MA_38630_COL_898D5D22_9D01_4318_B8E7_221E83C51A88#17707, COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#17582 AS LIEN_GIE_ERP_MA_38630_COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#17708, COL_605386DE_CCAB_46E4_A684_F9449D050D33#17583 AS LIEN_GIE_ERP_MA_38630_COL_605386DE_CCAB_46E4_A684_F9449D050D33#17709, COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#17584 AS LIEN_GIE_ERP_MA_38630_COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#17710, COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#17585 AS LIEN_GIE_ERP_MA_38630_COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#17711, COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#17586 AS LIEN_GIE_ERP_MA_38630_COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#17712, COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#17587 AS LIEN_GIE_ERP_MA_38630_COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#17713, COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#17588 AS LIEN_GIE_ERP_MA_38630_COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#17714, COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#17589 AS LIEN_GIE_ERP_MA_38630_COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#17715, COL_FE618529_0873_4690_B1DA_084DC1715835#17590 AS LIEN_GIE_ERP_MA_38630_COL_FE618529_0873_4690_B1DA_084DC1715835#17716, COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#17591 AS LIEN_GIE_ERP_MA_38630_COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#17717, COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#17592 AS LIEN_GIE_ERP_MA_38630_COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#17718, COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#17593 AS LIEN_GIE_ERP_MA_38630_COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#17719, COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#17594 AS LIEN_GIE_ERP_MA_38630_COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#17720, COL_D9C0D816_857E_43AB_BB97_231118B63DB4#17595 AS LIEN_GIE_ERP_MA_38630_COL_D9C0D816_857E_43AB_BB97_231118B63DB4#17721, COL_7DB28DE9_8E36_465B_B40B_286835BE909D#17596 AS LIEN_GIE_ERP_MA_38630_COL_7DB28DE9_8E36_465B_B40B_286835BE909D#17722, COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#17597 AS LIEN_GIE_ERP_MA_38630_COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#17723, COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#17598 AS LIEN_GIE_ERP_MA_38630_COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#17724, COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#17599 AS LIEN_GIE_ERP_MA_38630_COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#17725, COL_0105775B_EA44_44B2_8C95_E36C29A4D241#17600 AS LIEN_GIE_ERP_MA_38630_COL_0105775B_EA44_44B2_8C95_E36C29A4D241#17726, COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#17601 AS LIEN_GIE_ERP_MA_38630_COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#17727, COL_3872240D_C102_43BD_AC54_87416C97E6C5#17602 AS LIEN_GIE_ERP_MA_38630_COL_3872240D_C102_43BD_AC54_87416C97E6C5#17728, ... 18 more fields]
                                                                                 +- SubqueryAlias LIEN_GIE_ERP_MA_38630116
                                                                                    +- Relation[COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#17579,COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#17580,COL_898D5D22_9D01_4318_B8E7_221E83C51A88#17581,COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#17582,COL_605386DE_CCAB_46E4_A684_F9449D050D33#17583,COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#17584,COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#17585,COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#17586,COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#17587,COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#17588,COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#17589,COL_FE618529_0873_4690_B1DA_084DC1715835#17590,COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#17591,COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#17592,COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#17593,COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#17594,COL_D9C0D816_857E_43AB_BB97_231118B63DB4#17595,COL_7DB28DE9_8E36_465B_B40B_286835BE909D#17596,COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#17597,COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#17598,COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#17599,COL_0105775B_EA44_44B2_8C95_E36C29A4D241#17600,COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#17601,COL_3872240D_C102_43BD_AC54_87416C97E6C5#17602,... 18 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Sort [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125 ASC NULLS FIRST], true
      +- Project [col0#17940 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125, col1#17941 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18126]
         +- Generate stack(2, Sans rappro. séma., COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17920, Au moins 1 rappro. séma., COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17921), [0, 1], false, [col0#17940, col1#17941]
            +- Project [bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L)))) AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17920, bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D, bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L)))))))) AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17921]
               +- Aggregate [first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852, true) AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, count(distinct COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850) AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L]
                  +- Project [COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#17614 AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850, COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#17613 AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852]
                     +- Relation[COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#17579,COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#17580,COL_898D5D22_9D01_4318_B8E7_221E83C51A88#17581,COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#17582,COL_605386DE_CCAB_46E4_A684_F9449D050D33#17583,COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#17584,COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#17585,COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#17586,COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#17587,COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#17588,COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#17589,COL_FE618529_0873_4690_B1DA_084DC1715835#17590,COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#17591,COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#17592,COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#17593,COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#17594,COL_D9C0D816_857E_43AB_BB97_231118B63DB4#17595,COL_7DB28DE9_8E36_465B_B40B_286835BE909D#17596,COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#17597,COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#17598,COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#17599,COL_0105775B_EA44_44B2_8C95_E36C29A4D241#17600,COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#17601,COL_3872240D_C102_43BD_AC54_87416C97E6C5#17602,... 18 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125 ASC NULLS FIRST], output=[COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125,COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18126])
   +- *(4) Project [col0#17940 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#18125, col1#17941 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#18126]
      +- Generate stack(2, Sans rappro. séma., COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17920, Au moins 1 rappro. séma., COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17921), false, [col0#17940, col1#17941]
         +- *(3) Project [bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L)))) AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#17920, bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D, bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L)))))))) AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#17921]
            +- *(3) HashAggregate(keys=[], functions=[first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852, true), count(distinct COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850)], output=[COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#17886, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#17887L])
               +- ShuffleQueryStage 1
                  +- Exchange SinglePartition, true, [id=#1760]
                     +- *(2) HashAggregate(keys=[], functions=[merge_first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852, true), partial_count(distinct COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850)], output=[first#18251, valueSet#18252, count#18255L])
                        +- *(2) HashAggregate(keys=[COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850], functions=[merge_first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852, true)], output=[COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850, first#18251, valueSet#18252])
                           +- CustomShuffleReader coalesced
                              +- ShuffleQueryStage 0
                                 +- Exchange hashpartitioning(COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850, 200), true, [id=#1700]
                                    +- *(1) HashAggregate(keys=[COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850], functions=[partial_first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852, true)], output=[COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850, first#18251, valueSet#18252])
                                       +- *(1) Project [COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#17614 AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#17850, COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#17613 AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#17852]
                                          +- *(1) ColumnarToRow
                                             +- FileScan parquet [COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#17613,COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#17614] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/LIEN_GIE_ERP_MA_38630], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035:int,COL_0BFFB8BB_D083_4847_976A_207D4A1BD197:string>