SP1 - Details for Query 4841

Submitted Time: 2026/05/21 14:22:03
Duration: 11 s
Succeeded Jobs: 7536 7537 7538

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 (6)\n \nduration: 0 ms"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; 6 [labelType="html" label="Sort sort time: 5 ms peak memory: 17.0 MiB spill size: 0.0 B"]; } 7 [labelType="html" label="Exchange shuffle records written: 323,604 local merged chunks fetched: 0 shuffle write time: 76 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 32,751 local bytes read: 2.7 MiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 137.9 MiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 26.3 MiB"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 960 ms"; 9 [labelType="html" label=" Project "]; } 10 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 8.6 s"; 12 [labelType="html" label="Sort sort time: 38 ms peak memory: 152.0 MiB spill size: 0.0 B"]; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label=" Project "]; } 15 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 557 ms"; 17 [labelType="html" label="Sort sort time: 30 ms peak memory: 104.0 MiB spill size: 0.0 B"]; } 18 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 17.5 MiB number of coalesced partitions: 1"]; 19 [labelType="html" label="Exchange shuffle records written: 323,604 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 71 ms (2 ms, 6 ms, 17 ms (stage 15370.0: task 21297)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 323,604 local bytes read: 16.9 MiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 84.5 MiB (3.3 MiB, 9.0 MiB, 9.0 MiB (stage 15370.0: task 21296)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 16.9 MiB (693.9 KiB, 1853.5 KiB, 1878.3 KiB (stage 15370.0: task 21302))"]; subgraph cluster20 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n3.0 s (205 ms, 316 ms, 322 ms (stage 15370.0: task 21298))"; 21 [labelType="html" label=" Project "]; } 22 [labelType="html" label="Scan csv number of output rows: 323,604 number of files read: 1 metadata time: 0 ms size of files read: 58.9 MiB"]; 1->0; 3->1; 4->3; 6->4; 7->6; 9->7; 10->9; 12->10; 13->12; 14->13; 15->14; 17->15; 18->17; 19->18; 21->19; 22->21; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

WholeStageCodegen (6)

Window [last(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1201055, last(COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1201121, last(COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1201190, last(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1201262, last(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1201337, last(COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1201415, last(COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1201496, last(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1201580, last(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1201667, last(COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1201757L, last(COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_119C9448_3C3F_46EA_80E7_062422A2830D#1201850], [COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916], [COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST]

Sort [COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916 ASC NULLS FIRST, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST], false, 0

WholeStageCodegen (5)

Exchange hashpartitioning(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, 10), ENSURE_REQUIREMENTS, [plan_id=674443]

WholeStageCodegen (4)

Window [last(COL_E0F52912_684D_4ECF_BC6F_111DCB66F8D5#1200872, true) windowspecdefinition(1, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916], [1], [COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST]

Sort [1 ASC NULLS FIRST, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST], false, 0

Project [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_join(array(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, str_complete(int_to_str(COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602), 0, 7, LEFT), COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724), -), null) AS COL_E0F52912_684D_4ECF_BC6F_111DCB66F8D5#1200872, str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 70, 8), str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 67, 8), null)) AS COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> C)), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 68, 2), ALL), null) AS COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, date_diff(YEAR, str_to_datez(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, ddMMyyyy, Europe/Paris, fr_FR), str_to_datez(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, ddMMyyyy, Europe/Paris, fr_FR)) AS COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 64, 1), null) AS COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876]

Project [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 172, 1), ALL), null) AS COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 71, 1), ALL), null) AS COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 76, 8), ALL), null) AS COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 85, 8), ALL), null) AS COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 93, 8), ALL), null) AS COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 66, 2), ALL), null) AS COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 70, 2), ALL), null) AS COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, str_complete(str_remove_space(COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, ALL), 0, 9, LEFT) AS COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724]

WholeStageCodegen (3)

Window [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602], [1], [1 DESC NULLS LAST]

Sort [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (2)

AQEShuffleRead coalesced

Exchange hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=674349]

Project [_c0#1200530 AS COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, str_extract_middle(_c0#1200530, 2, 9) AS COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, str_if_with_rule(CASE WHEN isnull(StartsWith(_c0#1200530, A)) THEN false ELSE StartsWith(_c0#1200530, A) END, str_extract_middle(_c0#1200530, 40, 9), str_extract_middle(_c0#1200530, 38, 9)) AS COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, str_extract_middle(_c0#1200530, 1, 1) AS COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590]

WholeStageCodegen (1)

FileScan csv [_c0#1200530] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/RSF_SOURCE_SERV_208434/rsfMCO30012026 L..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<_c0:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (33)
+- == Final Plan ==
   CollectLimit (18)
   +- * Project (17)
      +- Window (16)
         +- * Sort (15)
            +- ShuffleQueryStage (14), Statistics(sizeInBytes=137.9 MiB, rowCount=3.24E+5)
               +- Exchange (13)
                  +- * Project (12)
                     +- Window (11)
                        +- * Sort (10)
                           +- * Project (9)
                              +- * Project (8)
                                 +- Window (7)
                                    +- * Sort (6)
                                       +- AQEShuffleRead (5)
                                          +- ShuffleQueryStage (4), Statistics(sizeInBytes=84.5 MiB, rowCount=3.24E+5)
                                             +- Exchange (3)
                                                +- * Project (2)
                                                   +- Scan csv  (1)
+- == Initial Plan ==
   CollectLimit (32)
   +- Project (31)
      +- Window (30)
         +- Sort (29)
            +- Exchange (28)
               +- Project (27)
                  +- Window (26)
                     +- Sort (25)
                        +- Project (24)
                           +- Project (23)
                              +- Window (22)
                                 +- Sort (21)
                                    +- Exchange (20)
                                       +- Project (19)
                                          +- Scan csv  (1)


(1) Scan csv 
Output [1]: [_c0#1200530]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/RSF_SOURCE_SERV_208434/rsfMCO30012026 Lavaur.txt]
ReadSchema: struct<_c0:string>

(2) Project [codegen id : 1]
Output [4]: [_c0#1200530 AS COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, str_extract_middle(_c0#1200530, 2, 9) AS COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, str_if_with_rule(CASE WHEN isnull(StartsWith(_c0#1200530, A)) THEN false ELSE StartsWith(_c0#1200530, A) END, str_extract_middle(_c0#1200530, 40, 9), str_extract_middle(_c0#1200530, 38, 9)) AS COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, str_extract_middle(_c0#1200530, 1, 1) AS COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590]
Input [1]: [_c0#1200530]

(3) Exchange
Input [4]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=674349]

(4) ShuffleQueryStage
Output [4]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590]
Arguments: 0

(5) AQEShuffleRead
Input [4]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590]
Arguments: coalesced

(6) Sort [codegen id : 2]
Input [4]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(7) Window
Input [4]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602], [1], [1 DESC NULLS LAST]

(8) Project [codegen id : 3]
Output [13]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 172, 1), ALL), null) AS COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 71, 1), ALL), null) AS COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 76, 8), ALL), null) AS COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 85, 8), ALL), null) AS COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 93, 8), ALL), null) AS COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 66, 2), ALL), null) AS COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 70, 2), ALL), null) AS COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, str_complete(str_remove_space(COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, ALL), 0, 9, LEFT) AS COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724]
Input [5]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602]

(9) Project [codegen id : 3]
Output [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_join(array(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, str_complete(int_to_str(COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602), 0, 7, LEFT), COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724), -), null) AS COL_E0F52912_684D_4ECF_BC6F_111DCB66F8D5#1200872, str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 70, 8), str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 67, 8), null)) AS COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> C)), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 68, 2), ALL), null) AS COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, date_diff(YEAR, str_to_datez(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, ddMMyyyy, Europe/Paris, fr_FR), str_to_datez(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, ddMMyyyy, Europe/Paris, fr_FR)) AS COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 64, 1), null) AS COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876]
Input [13]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724]

(10) Sort [codegen id : 3]
Input [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_E0F52912_684D_4ECF_BC6F_111DCB66F8D5#1200872, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876]
Arguments: [1 ASC NULLS FIRST, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST], false, 0

(11) Window
Input [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_E0F52912_684D_4ECF_BC6F_111DCB66F8D5#1200872, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876]
Arguments: [last(COL_E0F52912_684D_4ECF_BC6F_111DCB66F8D5#1200872, true) windowspecdefinition(1, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916], [1], [COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST]

(12) Project [codegen id : 4]
Output [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916]
Input [19]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_E0F52912_684D_4ECF_BC6F_111DCB66F8D5#1200872, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916]

(13) Exchange
Input [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916]
Arguments: hashpartitioning(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, 10), ENSURE_REQUIREMENTS, [plan_id=674443]

(14) ShuffleQueryStage
Output [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916]
Arguments: 1

(15) Sort [codegen id : 5]
Input [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916]
Arguments: [COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916 ASC NULLS FIRST, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST], false, 0

(16) Window
Input [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916]
Arguments: [last(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1201055, last(COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1201121, last(COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1201190, last(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1201262, last(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1201337, last(COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1201415, last(COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1201496, last(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1201580, last(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1201667, last(COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1201757L, last(COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_119C9448_3C3F_46EA_80E7_062422A2830D#1201850], [COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916], [COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST]

(17) Project [codegen id : 6]
Output [29]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1201055, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1201121, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1201190, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1201262, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1201337, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1201415, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1201496, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1201580, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1201667, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1201757L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1201850, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916 AS COL_06CB38F0_2321_426B_AA44_D37094826BC3#1202062]
Input [29]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1201055, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1201121, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1201190, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1201262, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1201337, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1201415, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1201496, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1201580, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1201667, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1201757L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1201850]

(18) CollectLimit
Input [29]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1201055, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1201121, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1201190, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1201262, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1201337, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1201415, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1201496, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1201580, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1201667, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1201757L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1201850, COL_06CB38F0_2321_426B_AA44_D37094826BC3#1202062]
Arguments: 1500

(19) Project
Output [4]: [_c0#1200530 AS COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, str_extract_middle(_c0#1200530, 2, 9) AS COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, str_if_with_rule(CASE WHEN isnull(StartsWith(_c0#1200530, A)) THEN false ELSE StartsWith(_c0#1200530, A) END, str_extract_middle(_c0#1200530, 40, 9), str_extract_middle(_c0#1200530, 38, 9)) AS COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, str_extract_middle(_c0#1200530, 1, 1) AS COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590]
Input [1]: [_c0#1200530]

(20) Exchange
Input [4]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=674312]

(21) Sort
Input [4]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(22) Window
Input [4]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602], [1], [1 DESC NULLS LAST]

(23) Project
Output [13]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 172, 1), ALL), null) AS COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 71, 1), ALL), null) AS COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 76, 8), ALL), null) AS COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 85, 8), ALL), null) AS COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 93, 8), ALL), null) AS COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 66, 2), ALL), null) AS COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 70, 2), ALL), null) AS COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, str_complete(str_remove_space(COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, ALL), 0, 9, LEFT) AS COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724]
Input [5]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602]

(24) Project
Output [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_join(array(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, str_complete(int_to_str(COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602), 0, 7, LEFT), COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724), -), null) AS COL_E0F52912_684D_4ECF_BC6F_111DCB66F8D5#1200872, str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 70, 8), str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 67, 8), null)) AS COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> C)), str_remove_space(str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 68, 2), ALL), null) AS COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, date_diff(YEAR, str_to_datez(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, ddMMyyyy, Europe/Paris, fr_FR), str_to_datez(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, ddMMyyyy, Europe/Paris, fr_FR)) AS COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590 <=> A), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, 64, 1), null) AS COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876]
Input [13]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724]

(25) Sort
Input [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_E0F52912_684D_4ECF_BC6F_111DCB66F8D5#1200872, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876]
Arguments: [1 ASC NULLS FIRST, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST], false, 0

(26) Window
Input [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_E0F52912_684D_4ECF_BC6F_111DCB66F8D5#1200872, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876]
Arguments: [last(COL_E0F52912_684D_4ECF_BC6F_111DCB66F8D5#1200872, true) windowspecdefinition(1, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916], [1], [COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST]

(27) Project
Output [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916]
Input [19]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_E0F52912_684D_4ECF_BC6F_111DCB66F8D5#1200872, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916]

(28) Exchange
Input [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916]
Arguments: hashpartitioning(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, 10), ENSURE_REQUIREMENTS, [plan_id=674322]

(29) Sort
Input [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916]
Arguments: [COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916 ASC NULLS FIRST, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST], false, 0

(30) Window
Input [18]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916]
Arguments: [last(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1201055, last(COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1201121, last(COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1201190, last(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1201262, last(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1201337, last(COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1201415, last(COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1201496, last(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1201580, last(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1201667, last(COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1201757L, last(COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, true) windowspecdefinition(COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_119C9448_3C3F_46EA_80E7_062422A2830D#1201850], [COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916], [COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602 ASC NULLS LAST]

(31) Project
Output [29]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1201055, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1201121, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1201190, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1201262, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1201337, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1201415, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1201496, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1201580, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1201667, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1201757L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1201850, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916 AS COL_06CB38F0_2321_426B_AA44_D37094826BC3#1202062]
Input [29]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_CDD001F2_A695_481B_A50A_634A78AE8379#1200916, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1201055, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1201121, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1201190, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1201262, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1201337, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1201415, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1201496, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1201580, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1201667, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1201757L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1201850]

(32) CollectLimit
Input [29]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1201055, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1201121, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1201190, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1201262, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1201337, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1201415, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1201496, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1201580, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1201667, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1201757L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1201850, COL_06CB38F0_2321_426B_AA44_D37094826BC3#1202062]
Arguments: 1500

(33) AdaptiveSparkPlan
Output [29]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1200587, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1200588, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1200589, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1200590, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1200602, COL_71C73F12_7D79_456A_A833_96D8469F46F2#1200654, COL_E9867A66_711B_4AA1_A283_E4318900C80F#1200661, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#1200669, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#1200678, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#1200688, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#1200699, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#1200711, COL_553A0519_208D_498B_AEFE_829D7F40180B#1200724, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1200873, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1200874, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#1200875L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#1200876, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1201055, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1201121, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1201190, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1201262, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1201337, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1201415, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1201496, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1201580, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1201667, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1201757L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1201850, COL_06CB38F0_2321_426B_AA44_D37094826BC3#1202062]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet