DC2 - Details for Query 6

Details for Query 6

Submitted Time: 2026/03/05 07:13:15
Duration: 3 s
Succeeded Jobs: 4 6 8

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: 18 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: 70 ms"; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 1 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)) 8 ms (0 ms, 0 ms, 1 ms (stage 7.0: task 33)) 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 7.0: task 32)) 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 7.0: task 32))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n1.0 s (6 ms, 83 ms, 96 ms (stage 7.0: task 29))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 1.0 s (6 ms, 82 ms, 96 ms (stage 7.0: task 29)) 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)) 631 ms (0 ms, 70 ms, 75 ms (stage 7.0: task 34)) peak memory total (min, med, max (stageId: taskId)) 3.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 7.0: task 32)) 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)) 337 ms (21 ms, 45 ms, 110 ms (stage 4.0: task 11)) 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 7.0: task 32)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 7.0: task 32)) 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 4.0: task 11)) 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 4.0: task 11))"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n4.8 s (63 ms, 925 ms, 961 ms (stage 4.0: task 11))"; 15 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 3.4 s (32 ms, 640 ms, 701 ms (stage 4.0: task 13)) peak memory total (min, med, max (stageId: taskId)) 1792.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 4.0: task 12)) 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)) 3.2 s (10 ms, 609 ms, 643 ms (stage 4.0: task 13)) metadata time: 3 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#1206 ASC NULLS FIRST], output=[COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1206,COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1207])

Project [col0#1145 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1206, col1#1146 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1207]

WholeStageCodegen (4)

Generate stack(2, Sans rappro. séma., COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#996, Au moins 1 rappro. séma., COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#997), false, [col0#1145, col1#1146]

Project [bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L)))) AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#996, bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, 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#849, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L)))))))) AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#997]

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

WholeStageCodegen (3)

Exchange SinglePartition, true, [id=#197]

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

HashAggregate(keys=[COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767], functions=[merge_first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769, true)])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767, 200), true, [id=#150]

HashAggregate(keys=[COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767], functions=[partial_first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769, true)])

Project [COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#89 AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767, COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#87 AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#87,COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#89] 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#1206 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1210, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1207 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1211]
      +- Sort [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1206 ASC NULLS FIRST], true
         +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1202 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1206, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1203 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1207]
            +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1198 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1202, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1199 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1203]
               +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1194 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1198, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1195 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1199]
                  +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1190 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1194, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1191 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1195]
                     +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1186 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1190, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1187 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1191]
                        +- Project [cast(ANALYSE_LIEN_GI_39003_COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#1160 as string) AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1186, cast(ANALYSE_LIEN_GI_39003_COL_222208BC_CE88_4728_B52A_83AAAD5F6176#1161 as int) AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1187]
                           +- Project [COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#1149 AS ANALYSE_LIEN_GI_39003_COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#1160, COL_222208BC_CE88_4728_B52A_83AAAD5F6176#1152 AS ANALYSE_LIEN_GI_39003_COL_222208BC_CE88_4728_B52A_83AAAD5F6176#1161]
                              +- SubqueryAlias ANALYSE_LIEN_GI_39003118
                                 +- Project [COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#1149, COL_222208BC_CE88_4728_B52A_83AAAD5F6176#1152]
                                    +- Project [COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#1149, col1#1146 AS COL_222208BC_CE88_4728_B52A_83AAAD5F6176#1152]
                                       +- Project [col0#1145 AS COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#1149, col1#1146]
                                          +- Project [col0#1145, col1#1146]
                                             +- Generate stack(2, Sans rappro. séma., COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#996, Au moins 1 rappro. séma., COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#997), false, [col0#1145, col1#1146]
                                                +- Project [COL_6EB71029_0D30_454E_B7F3_80AB503419F7#986L AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#994L, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#985 AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#995, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#987 AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#996, COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#988 AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#997]
                                                   +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#873 AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#985, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#874L AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#986L, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#896 AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#987, COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#940 AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#988]
                                                      +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#873, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#874L, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#896, 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#873, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#896)))) AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#940]
                                                         +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#873, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#874L, 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#873, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#874L)))) AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#896]
                                                            +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849 AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#873, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#874L]
                                                               +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L]
                                                                  +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L]
                                                                     +- Aggregate [1 AS NULL_1#852, first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769, true) AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, count(distinct COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767) AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L]
                                                                        +- Project [COL_7655E225_968A_4BA2_AE4B_46DF93236F8F#676 AS COL_7655E225_968A_4BA2_AE4B_46DF93236F8F#754, COL_0FCCA874_3F46_417C_BF9C_67A376A4E47B#678 AS COL_0FCCA874_3F46_417C_BF9C_67A376A4E47B#755, COL_2E420555_F6E2_49CC_8BC1_F163AFCD71D1#681 AS COL_2E420555_F6E2_49CC_8BC1_F163AFCD71D1#756, COL_D08B2B58_592D_4A09_A81E_4A4F95EF9E46#684 AS COL_D08B2B58_592D_4A09_A81E_4A4F95EF9E46#757, COL_B7682B50_082C_4AF2_AFA4_25C011882D62#686 AS COL_B7682B50_082C_4AF2_AFA4_25C011882D62#758, COL_C0B76942_B4E4_4299_86B8_50A58AE36ED2#688 AS COL_C0B76942_B4E4_4299_86B8_50A58AE36ED2#759, COL_0F97308E_6030_4FEE_AC22_070DA25D6845#690 AS COL_0F97308E_6030_4FEE_AC22_070DA25D6845#760, COL_1F290799_14D9_4BEB_914C_CDECCBBFE676#692 AS COL_1F290799_14D9_4BEB_914C_CDECCBBFE676#761, COL_293E8352_D31A_4543_A829_35FF86C94519#694 AS COL_293E8352_D31A_4543_A829_35FF86C94519#762, COL_1ED54653_6A64_4D32_9562_B5546C607088#696 AS COL_1ED54653_6A64_4D32_9562_B5546C607088#763, COL_FB0BFD58_16BF_482D_8ABD_37662F428297#698 AS COL_FB0BFD58_16BF_482D_8ABD_37662F428297#764, COL_26BA3866_BE5E_4863_B74E_42249B7A92EC#700 AS COL_26BA3866_BE5E_4863_B74E_42249B7A92EC#765, COL_D9D28B59_BFF9_4941_B82F_DFE5584EE1B0#702 AS COL_D9D28B59_BFF9_4941_B82F_DFE5584EE1B0#766, COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#704 AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767, COL_77AFEAB1_F72A_4A6C_808F_72D3BB30EDEC#706L AS COL_77AFEAB1_F72A_4A6C_808F_72D3BB30EDEC#768L, COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#708 AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769]
                                                                           +- Project [cast(LIEN_GIE_ERP_MA_38630_COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#472 as string) AS COL_7655E225_968A_4BA2_AE4B_46DF93236F8F#676, cast(LIEN_GIE_ERP_MA_38630_COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#470 as string) AS COL_0FCCA874_3F46_417C_BF9C_67A376A4E47B#678, cast(LIEN_GIE_ERP_MA_38630_COL_898D5D22_9D01_4318_B8E7_221E83C51A88#471 as string) AS COL_2E420555_F6E2_49CC_8BC1_F163AFCD71D1#681, cast(LIEN_GIE_ERP_MA_38630_COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#469 as string) AS COL_D08B2B58_592D_4A09_A81E_4A4F95EF9E46#684, cast(LIEN_GIE_ERP_MA_38630_COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#474 as string) AS COL_B7682B50_082C_4AF2_AFA4_25C011882D62#686, cast(LIEN_GIE_ERP_MA_38630_COL_605386DE_CCAB_46E4_A684_F9449D050D33#473 as string) AS COL_C0B76942_B4E4_4299_86B8_50A58AE36ED2#688, cast(LIEN_GIE_ERP_MA_38630_COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#479 as string) AS COL_0F97308E_6030_4FEE_AC22_070DA25D6845#690, cast(LIEN_GIE_ERP_MA_38630_COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#482 as string) AS COL_1F290799_14D9_4BEB_914C_CDECCBBFE676#692, cast(LIEN_GIE_ERP_MA_38630_COL_FE618529_0873_4690_B1DA_084DC1715835#480 as string) AS COL_293E8352_D31A_4543_A829_35FF86C94519#694, cast(LIEN_GIE_ERP_MA_38630_COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#483 as string) AS COL_1ED54653_6A64_4D32_9562_B5546C607088#696, cast(LIEN_GIE_ERP_MA_38630_COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#481 as string) AS COL_FB0BFD58_16BF_482D_8ABD_37662F428297#698, cast(LIEN_GIE_ERP_MA_38630_COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#484 as string) AS COL_26BA3866_BE5E_4863_B74E_42249B7A92EC#700, cast(LIEN_GIE_ERP_MA_38630_COL_6BC44D5F_C691_4AC6_BB8C_87BCFD8D9D01#499 as int) AS COL_D9D28B59_BFF9_4941_B82F_DFE5584EE1B0#702, cast(LIEN_GIE_ERP_MA_38630_COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#504 as string) AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#704, cast(LIEN_GIE_ERP_MA_38630_COL_1DD34323_CDA4_40CB_B7A1_0ABF22E67755#505L as bigint) AS COL_77AFEAB1_F72A_4A6C_808F_72D3BB30EDEC#706L, cast(LIEN_GIE_ERP_MA_38630_COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#503 as int) AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#708]
                                                                              +- Project [COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#7 AS LIEN_GIE_ERP_MA_38630_COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#469, COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#10 AS LIEN_GIE_ERP_MA_38630_COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#470, COL_898D5D22_9D01_4318_B8E7_221E83C51A88#12 AS LIEN_GIE_ERP_MA_38630_COL_898D5D22_9D01_4318_B8E7_221E83C51A88#471, COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#14 AS LIEN_GIE_ERP_MA_38630_COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#472, COL_605386DE_CCAB_46E4_A684_F9449D050D33#16 AS LIEN_GIE_ERP_MA_38630_COL_605386DE_CCAB_46E4_A684_F9449D050D33#473, COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#18 AS LIEN_GIE_ERP_MA_38630_COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#474, COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#20 AS LIEN_GIE_ERP_MA_38630_COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#475, COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#23 AS LIEN_GIE_ERP_MA_38630_COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#476, COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#25 AS LIEN_GIE_ERP_MA_38630_COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#477, COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#28 AS LIEN_GIE_ERP_MA_38630_COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#478, COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#31 AS LIEN_GIE_ERP_MA_38630_COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#479, COL_FE618529_0873_4690_B1DA_084DC1715835#34 AS LIEN_GIE_ERP_MA_38630_COL_FE618529_0873_4690_B1DA_084DC1715835#480, COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#36 AS LIEN_GIE_ERP_MA_38630_COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#481, COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#39 AS LIEN_GIE_ERP_MA_38630_COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#482, COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#41 AS LIEN_GIE_ERP_MA_38630_COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#483, COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#45 AS LIEN_GIE_ERP_MA_38630_COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#484, COL_D9C0D816_857E_43AB_BB97_231118B63DB4#48 AS LIEN_GIE_ERP_MA_38630_COL_D9C0D816_857E_43AB_BB97_231118B63DB4#485, COL_7DB28DE9_8E36_465B_B40B_286835BE909D#50 AS LIEN_GIE_ERP_MA_38630_COL_7DB28DE9_8E36_465B_B40B_286835BE909D#486, COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#52 AS LIEN_GIE_ERP_MA_38630_COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#487, COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#54 AS LIEN_GIE_ERP_MA_38630_COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#488, COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#56 AS LIEN_GIE_ERP_MA_38630_COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#489, COL_0105775B_EA44_44B2_8C95_E36C29A4D241#58 AS LIEN_GIE_ERP_MA_38630_COL_0105775B_EA44_44B2_8C95_E36C29A4D241#490, COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#61 AS LIEN_GIE_ERP_MA_38630_COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#491, COL_3872240D_C102_43BD_AC54_87416C97E6C5#62 AS LIEN_GIE_ERP_MA_38630_COL_3872240D_C102_43BD_AC54_87416C97E6C5#492, ... 18 more fields]
                                                                                 +- SubqueryAlias LIEN_GIE_ERP_MA_38630118
                                                                                    +- Relation[COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#7,COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#10,COL_898D5D22_9D01_4318_B8E7_221E83C51A88#12,COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#14,COL_605386DE_CCAB_46E4_A684_F9449D050D33#16,COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#18,COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#20,COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#23,COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#25,COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#28,COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#31,COL_FE618529_0873_4690_B1DA_084DC1715835#34,COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#36,COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#39,COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#41,COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#45,COL_D9C0D816_857E_43AB_BB97_231118B63DB4#48,COL_7DB28DE9_8E36_465B_B40B_286835BE909D#50,COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#52,COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#54,COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#56,COL_0105775B_EA44_44B2_8C95_E36C29A4D241#58,COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#61,COL_3872240D_C102_43BD_AC54_87416C97E6C5#62,... 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#1206 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1210, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1207 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1211]
      +- Sort [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1206 ASC NULLS FIRST], true
         +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1202 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1206, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1203 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1207]
            +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1198 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1202, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1199 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1203]
               +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1194 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1198, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1195 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1199]
                  +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1190 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1194, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1191 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1195]
                     +- Project [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1186 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1190, COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1187 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1191]
                        +- Project [cast(ANALYSE_LIEN_GI_39003_COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#1160 as string) AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1186, cast(ANALYSE_LIEN_GI_39003_COL_222208BC_CE88_4728_B52A_83AAAD5F6176#1161 as int) AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1187]
                           +- Project [COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#1149 AS ANALYSE_LIEN_GI_39003_COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#1160, COL_222208BC_CE88_4728_B52A_83AAAD5F6176#1152 AS ANALYSE_LIEN_GI_39003_COL_222208BC_CE88_4728_B52A_83AAAD5F6176#1161]
                              +- SubqueryAlias ANALYSE_LIEN_GI_39003118
                                 +- Project [COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#1149, COL_222208BC_CE88_4728_B52A_83AAAD5F6176#1152]
                                    +- Project [COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#1149, col1#1146 AS COL_222208BC_CE88_4728_B52A_83AAAD5F6176#1152]
                                       +- Project [col0#1145 AS COL_89B42E6A_9349_4AB7_A7DD_9BA6B6268D9A#1149, col1#1146]
                                          +- Project [col0#1145, col1#1146]
                                             +- Generate stack(2, Sans rappro. séma., COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#996, Au moins 1 rappro. séma., COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#997), false, [col0#1145, col1#1146]
                                                +- Project [COL_6EB71029_0D30_454E_B7F3_80AB503419F7#986L AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#994L, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#985 AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#995, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#987 AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#996, COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#988 AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#997]
                                                   +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#873 AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#985, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#874L AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#986L, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#896 AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#987, COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#940 AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#988]
                                                      +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#873, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#874L, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#896, 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#873, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D, COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#896)))) AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#940]
                                                         +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#873, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#874L, 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#873, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#874L)))) AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#896]
                                                            +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849 AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#873, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#874L]
                                                               +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L]
                                                                  +- Project [COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L]
                                                                     +- Aggregate [1 AS NULL_1#852, first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769, true) AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, count(distinct COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767) AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L]
                                                                        +- Project [COL_7655E225_968A_4BA2_AE4B_46DF93236F8F#676 AS COL_7655E225_968A_4BA2_AE4B_46DF93236F8F#754, COL_0FCCA874_3F46_417C_BF9C_67A376A4E47B#678 AS COL_0FCCA874_3F46_417C_BF9C_67A376A4E47B#755, COL_2E420555_F6E2_49CC_8BC1_F163AFCD71D1#681 AS COL_2E420555_F6E2_49CC_8BC1_F163AFCD71D1#756, COL_D08B2B58_592D_4A09_A81E_4A4F95EF9E46#684 AS COL_D08B2B58_592D_4A09_A81E_4A4F95EF9E46#757, COL_B7682B50_082C_4AF2_AFA4_25C011882D62#686 AS COL_B7682B50_082C_4AF2_AFA4_25C011882D62#758, COL_C0B76942_B4E4_4299_86B8_50A58AE36ED2#688 AS COL_C0B76942_B4E4_4299_86B8_50A58AE36ED2#759, COL_0F97308E_6030_4FEE_AC22_070DA25D6845#690 AS COL_0F97308E_6030_4FEE_AC22_070DA25D6845#760, COL_1F290799_14D9_4BEB_914C_CDECCBBFE676#692 AS COL_1F290799_14D9_4BEB_914C_CDECCBBFE676#761, COL_293E8352_D31A_4543_A829_35FF86C94519#694 AS COL_293E8352_D31A_4543_A829_35FF86C94519#762, COL_1ED54653_6A64_4D32_9562_B5546C607088#696 AS COL_1ED54653_6A64_4D32_9562_B5546C607088#763, COL_FB0BFD58_16BF_482D_8ABD_37662F428297#698 AS COL_FB0BFD58_16BF_482D_8ABD_37662F428297#764, COL_26BA3866_BE5E_4863_B74E_42249B7A92EC#700 AS COL_26BA3866_BE5E_4863_B74E_42249B7A92EC#765, COL_D9D28B59_BFF9_4941_B82F_DFE5584EE1B0#702 AS COL_D9D28B59_BFF9_4941_B82F_DFE5584EE1B0#766, COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#704 AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767, COL_77AFEAB1_F72A_4A6C_808F_72D3BB30EDEC#706L AS COL_77AFEAB1_F72A_4A6C_808F_72D3BB30EDEC#768L, COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#708 AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769]
                                                                           +- Project [cast(LIEN_GIE_ERP_MA_38630_COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#472 as string) AS COL_7655E225_968A_4BA2_AE4B_46DF93236F8F#676, cast(LIEN_GIE_ERP_MA_38630_COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#470 as string) AS COL_0FCCA874_3F46_417C_BF9C_67A376A4E47B#678, cast(LIEN_GIE_ERP_MA_38630_COL_898D5D22_9D01_4318_B8E7_221E83C51A88#471 as string) AS COL_2E420555_F6E2_49CC_8BC1_F163AFCD71D1#681, cast(LIEN_GIE_ERP_MA_38630_COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#469 as string) AS COL_D08B2B58_592D_4A09_A81E_4A4F95EF9E46#684, cast(LIEN_GIE_ERP_MA_38630_COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#474 as string) AS COL_B7682B50_082C_4AF2_AFA4_25C011882D62#686, cast(LIEN_GIE_ERP_MA_38630_COL_605386DE_CCAB_46E4_A684_F9449D050D33#473 as string) AS COL_C0B76942_B4E4_4299_86B8_50A58AE36ED2#688, cast(LIEN_GIE_ERP_MA_38630_COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#479 as string) AS COL_0F97308E_6030_4FEE_AC22_070DA25D6845#690, cast(LIEN_GIE_ERP_MA_38630_COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#482 as string) AS COL_1F290799_14D9_4BEB_914C_CDECCBBFE676#692, cast(LIEN_GIE_ERP_MA_38630_COL_FE618529_0873_4690_B1DA_084DC1715835#480 as string) AS COL_293E8352_D31A_4543_A829_35FF86C94519#694, cast(LIEN_GIE_ERP_MA_38630_COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#483 as string) AS COL_1ED54653_6A64_4D32_9562_B5546C607088#696, cast(LIEN_GIE_ERP_MA_38630_COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#481 as string) AS COL_FB0BFD58_16BF_482D_8ABD_37662F428297#698, cast(LIEN_GIE_ERP_MA_38630_COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#484 as string) AS COL_26BA3866_BE5E_4863_B74E_42249B7A92EC#700, cast(LIEN_GIE_ERP_MA_38630_COL_6BC44D5F_C691_4AC6_BB8C_87BCFD8D9D01#499 as int) AS COL_D9D28B59_BFF9_4941_B82F_DFE5584EE1B0#702, cast(LIEN_GIE_ERP_MA_38630_COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#504 as string) AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#704, cast(LIEN_GIE_ERP_MA_38630_COL_1DD34323_CDA4_40CB_B7A1_0ABF22E67755#505L as bigint) AS COL_77AFEAB1_F72A_4A6C_808F_72D3BB30EDEC#706L, cast(LIEN_GIE_ERP_MA_38630_COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#503 as int) AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#708]
                                                                              +- Project [COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#7 AS LIEN_GIE_ERP_MA_38630_COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#469, COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#10 AS LIEN_GIE_ERP_MA_38630_COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#470, COL_898D5D22_9D01_4318_B8E7_221E83C51A88#12 AS LIEN_GIE_ERP_MA_38630_COL_898D5D22_9D01_4318_B8E7_221E83C51A88#471, COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#14 AS LIEN_GIE_ERP_MA_38630_COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#472, COL_605386DE_CCAB_46E4_A684_F9449D050D33#16 AS LIEN_GIE_ERP_MA_38630_COL_605386DE_CCAB_46E4_A684_F9449D050D33#473, COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#18 AS LIEN_GIE_ERP_MA_38630_COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#474, COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#20 AS LIEN_GIE_ERP_MA_38630_COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#475, COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#23 AS LIEN_GIE_ERP_MA_38630_COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#476, COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#25 AS LIEN_GIE_ERP_MA_38630_COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#477, COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#28 AS LIEN_GIE_ERP_MA_38630_COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#478, COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#31 AS LIEN_GIE_ERP_MA_38630_COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#479, COL_FE618529_0873_4690_B1DA_084DC1715835#34 AS LIEN_GIE_ERP_MA_38630_COL_FE618529_0873_4690_B1DA_084DC1715835#480, COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#36 AS LIEN_GIE_ERP_MA_38630_COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#481, COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#39 AS LIEN_GIE_ERP_MA_38630_COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#482, COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#41 AS LIEN_GIE_ERP_MA_38630_COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#483, COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#45 AS LIEN_GIE_ERP_MA_38630_COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#484, COL_D9C0D816_857E_43AB_BB97_231118B63DB4#48 AS LIEN_GIE_ERP_MA_38630_COL_D9C0D816_857E_43AB_BB97_231118B63DB4#485, COL_7DB28DE9_8E36_465B_B40B_286835BE909D#50 AS LIEN_GIE_ERP_MA_38630_COL_7DB28DE9_8E36_465B_B40B_286835BE909D#486, COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#52 AS LIEN_GIE_ERP_MA_38630_COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#487, COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#54 AS LIEN_GIE_ERP_MA_38630_COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#488, COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#56 AS LIEN_GIE_ERP_MA_38630_COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#489, COL_0105775B_EA44_44B2_8C95_E36C29A4D241#58 AS LIEN_GIE_ERP_MA_38630_COL_0105775B_EA44_44B2_8C95_E36C29A4D241#490, COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#61 AS LIEN_GIE_ERP_MA_38630_COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#491, COL_3872240D_C102_43BD_AC54_87416C97E6C5#62 AS LIEN_GIE_ERP_MA_38630_COL_3872240D_C102_43BD_AC54_87416C97E6C5#492, ... 18 more fields]
                                                                                 +- SubqueryAlias LIEN_GIE_ERP_MA_38630118
                                                                                    +- Relation[COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#7,COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#10,COL_898D5D22_9D01_4318_B8E7_221E83C51A88#12,COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#14,COL_605386DE_CCAB_46E4_A684_F9449D050D33#16,COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#18,COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#20,COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#23,COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#25,COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#28,COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#31,COL_FE618529_0873_4690_B1DA_084DC1715835#34,COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#36,COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#39,COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#41,COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#45,COL_D9C0D816_857E_43AB_BB97_231118B63DB4#48,COL_7DB28DE9_8E36_465B_B40B_286835BE909D#50,COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#52,COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#54,COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#56,COL_0105775B_EA44_44B2_8C95_E36C29A4D241#58,COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#61,COL_3872240D_C102_43BD_AC54_87416C97E6C5#62,... 18 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Sort [COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1206 ASC NULLS FIRST], true
      +- Project [col0#1145 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1206, col1#1146 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1207]
         +- Generate stack(2, Sans rappro. séma., COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#996, Au moins 1 rappro. séma., COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#997), [0, 1], false, [col0#1145, col1#1146]
            +- Project [bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L)))) AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#996, bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, 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#849, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L)))))))) AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#997]
               +- Aggregate [first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769, true) AS COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, count(distinct COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767) AS COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L]
                  +- Project [COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#89 AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767, COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#87 AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769]
                     +- Relation[COL_A18B45E4_AA24_49E7_A6C7_365C9D4229BA#7,COL_EEB3D23B_7A4A_440B_85CC_8188D5E6ACA7#10,COL_898D5D22_9D01_4318_B8E7_221E83C51A88#12,COL_2A6FCCE6_0345_4192_9394_A23C03FB6D0D#14,COL_605386DE_CCAB_46E4_A684_F9449D050D33#16,COL_BFF446D1_3656_4E98_A584_A4FF0EEF5F0B#18,COL_5562CDE3_FA82_49BA_BEEB_D58AD0003D71#20,COL_46BEF3AB_5856_47E6_BEAE_D1758AE921E3#23,COL_348DA9DF_E9B2_4819_A759_D4670DEA4B2B#25,COL_DC698BF1_F10A_4916_997D_0B0E6E11BCE0#28,COL_C93ABE87_DAEC_4081_B4F2_CF10C270DE0F#31,COL_FE618529_0873_4690_B1DA_084DC1715835#34,COL_9EE26593_AB10_44AE_B4D4_77ADE3848E84#36,COL_C5085C46_AFC4_4EFC_97A6_8055D2ACAAE2#39,COL_685CD7F8_2A79_4385_A4FB_C38D0A22D806#41,COL_363AB8BD_76FF_4D8F_AAAA_8E7F82F1D668#45,COL_D9C0D816_857E_43AB_BB97_231118B63DB4#48,COL_7DB28DE9_8E36_465B_B40B_286835BE909D#50,COL_CDECBB87_8A81_45E9_9C6E_37D3D148C9EA#52,COL_AEBB05CA_8E5D_49D4_AD99_59ED8BC134CB#54,COL_3953CBF7_AFEB_4F7E_8C82_E651C786A2AB#56,COL_0105775B_EA44_44B2_8C95_E36C29A4D241#58,COL_9C08FC8D_53CA_4E76_A653_4197B76A069F#61,COL_3872240D_C102_43BD_AC54_87416C97E6C5#62,... 18 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1206 ASC NULLS FIRST], output=[COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1206,COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1207])
   +- *(4) Project [col0#1145 AS COL_D4D4CEAC_A0B0_4D15_9EF2_C738663C2D09#1206, col1#1146 AS COL_BFF5A23B_FD22_447D_BD2B_2EECB355C142#1207]
      +- Generate stack(2, Sans rappro. séma., COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#996, Au moins 1 rappro. séma., COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#997), false, [col0#1145, col1#1146]
         +- *(3) Project [bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L)))) AS COL_019D1F5D_AD48_4CC9_98DA_77FA3EB9D02D#996, bigint_to_int(dec_to_int(dec_operator(DIFFERENCE, struct(COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2, COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, 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#849, COL_6EB71029_0D30_454E_B7F3_80AB503419F7, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L)))))))) AS COL_1F326A50_0CC6_49C5_9CE7_66B6B16C7FB9#997]
            +- *(3) HashAggregate(keys=[], functions=[first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769, true), count(distinct COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767)], output=[COL_21FD49A5_4A6C_4D10_A13E_7DB877E7E9E2#849, COL_6EB71029_0D30_454E_B7F3_80AB503419F7#850L])
               +- ShuffleQueryStage 1
                  +- Exchange SinglePartition, true, [id=#197]
                     +- *(2) HashAggregate(keys=[], functions=[merge_first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769, true), partial_count(distinct COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767)], output=[first#1216, valueSet#1217, count#1220L])
                        +- *(2) HashAggregate(keys=[COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767], functions=[merge_first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769, true)], output=[COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767, first#1216, valueSet#1217])
                           +- CustomShuffleReader coalesced
                              +- ShuffleQueryStage 0
                                 +- Exchange hashpartitioning(COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767, 200), true, [id=#150]
                                    +- *(1) HashAggregate(keys=[COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767], functions=[partial_first(COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769, true)], output=[COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767, first#1216, valueSet#1217])
                                       +- *(1) Project [COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#89 AS COL_9766C476_B8B0_44E9_BEAC_CC333EA65639#767, COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#87 AS COL_A4AF65C7_5ECC_48F7_A760_B15FFD6AF6F6#769]
                                          +- *(1) ColumnarToRow
                                             +- FileScan parquet [COL_AA7AF1DB_17C6_4FFF_BEA7_86DECA9BF035#87,COL_0BFFB8BB_D083_4847_976A_207D4A1BD197#89] 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>