hdh-spark-job - Details for Query 1171

Submitted Time: 2026/10/27 14:50:51
Duration: 0.7 s
Succeeded Jobs: 1105 1106 1107 1108 1109 1110 1111

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 (13)\n \nduration: 0 ms"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="SortMergeJoin number of output rows: 1,501"]; } subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 0 ms"; 6 [labelType="html" label="Sort sort time: 23 ms peak memory: 64.5 MiB spill size: 0.0 B"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 905.4 KiB number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 21,131 local merged chunks fetched: 0 shuffle write time: 3 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: 21,131 local bytes read: 860.2 KiB 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: 5.7 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: 860.2 KiB"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 67 ms"; 10 [labelType="html" label=" Project "]; 11 [labelType="html" label="SortMergeJoin number of output rows: 21,131 spill size: 0.0 B"]; } subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 170 ms"; 13 [labelType="html" label="Sort sort time: 4 ms peak memory: 64.5 MiB spill size: 0.0 B"]; } 14 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 880.7 KiB number of coalesced partitions: 1"]; 15 [labelType="html" label="Exchange shuffle records written: 21,127 local merged chunks fetched: 0 shuffle write time: 3 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: 21,127 local bytes read: 833.3 KiB 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: 5.0 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: 833.3 KiB"]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 60 ms"; 17 [labelType="html" label=" Project "]; 18 [labelType="html" label="SortMergeJoin number of output rows: 21,127 spill size: 0.0 B"]; } subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 138 ms"; 20 [labelType="html" label="Sort sort time: 12 ms peak memory: 64.5 MiB spill size: 0.0 B"]; } 21 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1014.5 KiB number of coalesced partitions: 1"]; 22 [labelType="html" label="Exchange shuffle records written: 21,121 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 6 ms (1 ms, 2 ms, 2 ms (stage 1689.0: task 1441)) 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: 21,121 local bytes read: 972.1 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 3 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 4.4 MiB (139.9 KiB, 2.1 MiB, 2.1 MiB (stage 1689.0: task 1440)) 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)) 972.1 KiB (32.6 KiB, 469.5 KiB, 469.9 KiB (stage 1689.0: task 1440))"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n211 ms (10 ms, 98 ms, 103 ms (stage 1689.0: task 1441))"; 24 [labelType="html" label=" Project "]; } 25 [labelType="html" label="Scan csv number of output rows: 21,121 number of files read: 1 metadata time: 0 ms size of files read: 8.3 MiB"]; subgraph cluster26 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 1.4 m"; 27 [labelType="html" label="Sort sort time: 0 ms peak memory: 64.1 MiB spill size: 0.0 B"]; 28 [labelType="html" label=" Project "]; } 29 [labelType="html" label="ObjectHashAggregate number of output rows: 445 time in aggregation build: 6 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 30 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 18.6 KiB number of coalesced partitions: 1"]; 31 [labelType="html" label="Exchange shuffle records written: 445 local merged chunks fetched: 0 shuffle write time: 1 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: 445 local bytes read: 17.7 KiB 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: 53.8 KiB 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: 17.7 KiB"]; 32 [labelType="html" label="ObjectHashAggregate number of output rows: 445 time in aggregation build: 16 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster33 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 16 ms"; 34 [labelType="html" label=" Project "]; } 35 [labelType="html" label="Scan csv number of output rows: 1,216 number of files read: 1 metadata time: 0 ms size of files read: 111.6 KiB"]; subgraph cluster36 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 156 ms"; 37 [labelType="html" label="Sort sort time: 0 ms peak memory: 64.1 MiB spill size: 0.0 B"]; 38 [labelType="html" label=" Project "]; } 39 [labelType="html" label="ObjectHashAggregate number of output rows: 464 time in aggregation build: 6 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 40 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 9.6 KiB number of coalesced partitions: 1"]; 41 [labelType="html" label="Exchange shuffle records written: 464 local merged chunks fetched: 0 shuffle write time: 1 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: 464 local bytes read: 9.1 KiB 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: 43.8 KiB 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: 9.1 KiB"]; 42 [labelType="html" label="ObjectHashAggregate number of output rows: 464 time in aggregation build: 11 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster43 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 10 ms"; 44 [labelType="html" label=" Project "]; } 45 [labelType="html" label="Scan csv number of output rows: 486 number of files read: 1 metadata time: 0 ms size of files read: 50.8 KiB"]; subgraph cluster46 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: 0 ms"; 47 [labelType="html" label="Sort sort time: 9 ms peak memory: 65.0 MiB spill size: 0.0 B"]; } 48 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 513.6 KiB number of coalesced partitions: 1"]; 49 [labelType="html" label="Exchange shuffle records written: 26,044 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 6 ms (1 ms, 1 ms, 2 ms (stage 1692.0: task 1445)) 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: 26,044 local bytes read: 495.5 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 3 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 2.6 MiB (18.3 KiB, 1279.3 KiB, 1347.5 KiB (stage 1692.0: task 1446)) 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)) 495.5 KiB (5.3 KiB, 237.0 KiB, 253.2 KiB (stage 1692.0: task 1446))"]; subgraph cluster50 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n230 ms (4 ms, 109 ms, 117 ms (stage 1692.0: task 1445))"; 51 [labelType="html" label=" Project "]; } 52 [labelType="html" label="Scan csv number of output rows: 26,044 number of files read: 1 metadata time: 0 ms size of files read: 8.0 MiB"]; 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 10->8; 11->10; 13->11; 14->13; 15->14; 17->15; 18->17; 20->18; 21->20; 22->21; 24->22; 25->24; 27->18; 28->27; 29->28; 30->29; 31->30; 32->31; 34->32; 35->34; 37->11; 38->37; 39->38; 40->39; 41->40; 42->41; 44->42; 45->44; 47->4; 48->47; 49->48; 51->49; 52->51; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139, RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192 AS COL_73D74EBE_833B_4E31_9DF5_A246CF60FFA0#424396, RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193 AS COL_E53BE285_65B5_4C30_A5A1_834C97529087#424397, RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196 AS COL_90A4E254_6A13_422C_90D0_6E90879B9F1A#424398]

SortMergeJoin [COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335], [RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195], FullOuter

WholeStageCodegen (13)

Sort [COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335 ASC NULLS FIRST], false, 0

WholeStageCodegen (11)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, 10), ENSURE_REQUIREMENTS, [plan_id=41120]

Project [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, MOLECULES_ONERE_440476_COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#424015 AS COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, MOLECULES_ONERE_440476_COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#424016 AS COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014 AS COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, MOLECULES_ONERE_440476_COL_0E667C51_6C84_403A_9D26_666830EFDC70#424017 AS COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139]

SortMergeJoin [COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877], [MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014], FullOuter

WholeStageCodegen (10)

Sort [COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877 ASC NULLS FIRST], false, 0

WholeStageCodegen (8)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, 10), ENSURE_REQUIREMENTS, [plan_id=40953]

Project [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, 01_DMI_DECOUPAG_440467_COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#423894 AS COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, 01_DMI_DECOUPAG_440467_COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#423895 AS COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, 01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893 AS COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, 01_DMI_DECOUPAG_440467_COL_0BE82637_88B2_4D38_AB56_F261497B0D57#423896 AS COL_059961D5_87D2_4745_B270_05C29151B074#423994]

SortMergeJoin [COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877], [01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893], FullOuter

WholeStageCodegen (7)

Sort [COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, 10), ENSURE_REQUIREMENTS, [plan_id=40727]

Project [FINESS#419976 AS COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, NO_RSS#419977 AS COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, NO_ADMIN#419978 AS COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, DATE_ENT#419979 AS COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, DATE_SOR#419980 AS COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, VALO#419981 AS COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, GHS#419982 AS COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, str_to_dec(MNT_MON#420118, ##.##) AS COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, str_to_dec(MNT_DMI#420119, ##.##) AS COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, MNT_MED_APAC#420120 AS COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, str_remove_space(NO_ADMIN#419978, ALL) AS COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877]

WholeStageCodegen (1)

FileScan csv [FINESS#419976,NO_RSS#419977,NO_ADMIN#419978,DATE_ENT#419979,DATE_SOR#419980,VALO#419981,GHS#419982,MNT_MON#420118,MNT_DMI#420119,MNT_MED_APAC#420120] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/VISUALVALOSEJOU_440300/420780652.2025.1..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<FINESS:string,NO_RSS:string,NO_ADMIN:string,DATE_ENT:string,DATE_SOR:string,VALO:string,GH...

Sort [01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893 ASC NULLS FIRST], false, 0

Project [COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#421540 AS 01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893, COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#421541 AS 01_DMI_DECOUPAG_440467_COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#423894, COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#421542 AS 01_DMI_DECOUPAG_440467_COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#423895, size(COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#421542, true) AS 01_DMI_DECOUPAG_440467_COL_0BE82637_88B2_4D38_AB56_F261497B0D57#423896]

WholeStageCodegen (6)

ObjectHashAggregate(keys=[COL_C898C1FE_14C4_493A_878B_315EB757695B#421494], functions=[sum(COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500), collect_list(COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, 10), ENSURE_REQUIREMENTS, [plan_id=40740]

ObjectHashAggregate(keys=[COL_C898C1FE_14C4_493A_878B_315EB757695B#421494], functions=[partial_sum(COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500), partial_collect_list(COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, 0, 0)])

Project [str_remove_space(str_extract_middle(_c0#421389, 12, 20), ALL) AS COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, str_remove_space(str_extract_middle(_c0#421389, 58, 15), ALL) AS COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, round(str_to_dec(str_join(array(str_extract_middle(_c0#421389, 83, 7), str_extract_middle(_c0#421389, 90, 3)), .), ##.##), 2) AS COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500]

WholeStageCodegen (2)

FileScan csv [_c0#421389] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/DMI_M12_2025_440461/DMI-M12-2025 - BIS...., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<_c0:string>

Sort [MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014 ASC NULLS FIRST], false, 0

Project [COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#421762 AS MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014, COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#421763 AS MOLECULES_ONERE_440476_COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#424015, COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#421764 AS MOLECULES_ONERE_440476_COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#424016, size(COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#421764, true) AS MOLECULES_ONERE_440476_COL_0E667C51_6C84_403A_9D26_666830EFDC70#424017]

WholeStageCodegen (9)

ObjectHashAggregate(keys=[COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710], functions=[sum(COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717), collect_list(COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, 10), ENSURE_REQUIREMENTS, [plan_id=40761]

ObjectHashAggregate(keys=[COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710], functions=[partial_sum(COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717), partial_collect_list(COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, 0, 0)])

Project [str_remove_space(str_extract_middle(_c0#421576, 12, 20), ALL) AS COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, str_remove_space(str_extract_middle(_c0#421576, 40, 15), ALL) AS COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, str_to_dec(str_join(array(str_extract_middle(_c0#421576, 65, 7), str_extract_middle(_c0#421576, 72, 3)), .), ##.##) AS COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717]

WholeStageCodegen (3)

FileScan csv [_c0#421576] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/MOLECULES_ONERE_440457/MO-M12-2025.txt], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<_c0:string>

Sort [RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195 ASC NULLS FIRST], false, 0

WholeStageCodegen (12)

AQEShuffleRead coalesced

Exchange hashpartitioning(RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, 10), ENSURE_REQUIREMENTS, [plan_id=40786]

Project [str_extract_middle(_c0#421798, 3, 2) AS RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192, str_extract_middle(_c0#421798, 5, 4) AS RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193, str_extract_middle(_c0#421798, 28, 20) AS RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, str_extract_middle(_c0#421798, 48, 20) AS RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196]

WholeStageCodegen (4)

FileScan csv [_c0#421798] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/RSS_M12_2025_440462/RSS- 420780652.txt], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<_c0:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (75)
+- == Final Plan ==
   CollectLimit (45)
   +- * Project (44)
      +- * SortMergeJoin FullOuter (43)
         :- * Sort (36)
         :  +- AQEShuffleRead (35)
         :     +- ShuffleQueryStage (34), Statistics(sizeInBytes=5.7 MiB, rowCount=2.11E+4)
         :        +- Exchange (33)
         :           +- * Project (32)
         :              +- * SortMergeJoin FullOuter (31)
         :                 :- * Sort (21)
         :                 :  +- AQEShuffleRead (20)
         :                 :     +- ShuffleQueryStage (19), Statistics(sizeInBytes=5.0 MiB, rowCount=2.11E+4)
         :                 :        +- Exchange (18)
         :                 :           +- * Project (17)
         :                 :              +- * SortMergeJoin FullOuter (16)
         :                 :                 :- * Sort (6)
         :                 :                 :  +- AQEShuffleRead (5)
         :                 :                 :     +- ShuffleQueryStage (4), Statistics(sizeInBytes=4.4 MiB, rowCount=2.11E+4)
         :                 :                 :        +- Exchange (3)
         :                 :                 :           +- * Project (2)
         :                 :                 :              +- Scan csv  (1)
         :                 :                 +- * Sort (15)
         :                 :                    +- * Project (14)
         :                 :                       +- ObjectHashAggregate (13)
         :                 :                          +- AQEShuffleRead (12)
         :                 :                             +- ShuffleQueryStage (11), Statistics(sizeInBytes=53.8 KiB, rowCount=445)
         :                 :                                +- Exchange (10)
         :                 :                                   +- ObjectHashAggregate (9)
         :                 :                                      +- * Project (8)
         :                 :                                         +- Scan csv  (7)
         :                 +- * Sort (30)
         :                    +- * Project (29)
         :                       +- ObjectHashAggregate (28)
         :                          +- AQEShuffleRead (27)
         :                             +- ShuffleQueryStage (26), Statistics(sizeInBytes=43.8 KiB, rowCount=464)
         :                                +- Exchange (25)
         :                                   +- ObjectHashAggregate (24)
         :                                      +- * Project (23)
         :                                         +- Scan csv  (22)
         +- * Sort (42)
            +- AQEShuffleRead (41)
               +- ShuffleQueryStage (40), Statistics(sizeInBytes=2.6 MiB, rowCount=2.60E+4)
                  +- Exchange (39)
                     +- * Project (38)
                        +- Scan csv  (37)
+- == Initial Plan ==
   CollectLimit (74)
   +- Project (73)
      +- SortMergeJoin FullOuter (72)
         :- Sort (68)
         :  +- Exchange (67)
         :     +- Project (66)
         :        +- SortMergeJoin FullOuter (65)
         :           :- Sort (58)
         :           :  +- Exchange (57)
         :           :     +- Project (56)
         :           :        +- SortMergeJoin FullOuter (55)
         :           :           :- Sort (48)
         :           :           :  +- Exchange (47)
         :           :           :     +- Project (46)
         :           :           :        +- Scan csv  (1)
         :           :           +- Sort (54)
         :           :              +- Project (53)
         :           :                 +- ObjectHashAggregate (52)
         :           :                    +- Exchange (51)
         :           :                       +- ObjectHashAggregate (50)
         :           :                          +- Project (49)
         :           :                             +- Scan csv  (7)
         :           +- Sort (64)
         :              +- Project (63)
         :                 +- ObjectHashAggregate (62)
         :                    +- Exchange (61)
         :                       +- ObjectHashAggregate (60)
         :                          +- Project (59)
         :                             +- Scan csv  (22)
         +- Sort (71)
            +- Exchange (70)
               +- Project (69)
                  +- Scan csv  (37)


(1) Scan csv 
Output [10]: [FINESS#419976, NO_RSS#419977, NO_ADMIN#419978, DATE_ENT#419979, DATE_SOR#419980, VALO#419981, GHS#419982, MNT_MON#420118, MNT_DMI#420119, MNT_MED_APAC#420120]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/VISUALVALOSEJOU_440300/420780652.2025.12.MCO.VisualValoSejours.csv]
ReadSchema: struct<FINESS:string,NO_RSS:string,NO_ADMIN:string,DATE_ENT:string,DATE_SOR:string,VALO:string,GHS:string,MNT_MON:string,MNT_DMI:string,MNT_MED_APAC:string>

(2) Project [codegen id : 1]
Output [11]: [FINESS#419976 AS COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, NO_RSS#419977 AS COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, NO_ADMIN#419978 AS COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, DATE_ENT#419979 AS COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, DATE_SOR#419980 AS COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, VALO#419981 AS COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, GHS#419982 AS COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, str_to_dec(MNT_MON#420118, ##.##) AS COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, str_to_dec(MNT_DMI#420119, ##.##) AS COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, MNT_MED_APAC#420120 AS COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, str_remove_space(NO_ADMIN#419978, ALL) AS COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877]
Input [10]: [FINESS#419976, NO_RSS#419977, NO_ADMIN#419978, DATE_ENT#419979, DATE_SOR#419980, VALO#419981, GHS#419982, MNT_MON#420118, MNT_DMI#420119, MNT_MED_APAC#420120]

(3) Exchange
Input [11]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877]
Arguments: hashpartitioning(COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, 10), ENSURE_REQUIREMENTS, [plan_id=40727]

(4) ShuffleQueryStage
Output [11]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877]
Arguments: 0

(5) AQEShuffleRead
Input [11]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877]
Arguments: coalesced

(6) Sort [codegen id : 5]
Input [11]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877]
Arguments: [COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877 ASC NULLS FIRST], false, 0

(7) Scan csv 
Output [1]: [_c0#421389]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/DMI_M12_2025_440461/DMI-M12-2025 - BIS.txt]
ReadSchema: struct<_c0:string>

(8) Project [codegen id : 2]
Output [3]: [str_remove_space(str_extract_middle(_c0#421389, 12, 20), ALL) AS COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, str_remove_space(str_extract_middle(_c0#421389, 58, 15), ALL) AS COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, round(str_to_dec(str_join(array(str_extract_middle(_c0#421389, 83, 7), str_extract_middle(_c0#421389, 90, 3)), .), ##.##), 2) AS COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500]
Input [1]: [_c0#421389]

(9) ObjectHashAggregate
Input [3]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500]
Keys [1]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494]
Functions [2]: [partial_sum(COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500), partial_collect_list(COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, 0, 0)]
Aggregate Attributes [2]: [sum#424421, buf#424422]
Results [3]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, sum#424423, buf#424424]

(10) Exchange
Input [3]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, sum#424423, buf#424424]
Arguments: hashpartitioning(COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, 10), ENSURE_REQUIREMENTS, [plan_id=40740]

(11) ShuffleQueryStage
Output [3]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, sum#424423, buf#424424]
Arguments: 1

(12) AQEShuffleRead
Input [3]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, sum#424423, buf#424424]
Arguments: coalesced

(13) ObjectHashAggregate
Input [3]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, sum#424423, buf#424424]
Keys [1]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494]
Functions [2]: [sum(COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500), collect_list(COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, 0, 0)]
Aggregate Attributes [2]: [sum(COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500)#421522, collect_list(COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, 0, 0)#421524]
Results [3]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494 AS COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#421540, round(sum(COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500)#421522, 2) AS COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#421541, collect_list(COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, 0, 0)#421524 AS COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#421542]

(14) Project [codegen id : 6]
Output [4]: [COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#421540 AS 01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893, COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#421541 AS 01_DMI_DECOUPAG_440467_COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#423894, COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#421542 AS 01_DMI_DECOUPAG_440467_COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#423895, size(COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#421542, true) AS 01_DMI_DECOUPAG_440467_COL_0BE82637_88B2_4D38_AB56_F261497B0D57#423896]
Input [3]: [COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#421540, COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#421541, COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#421542]

(15) Sort [codegen id : 6]
Input [4]: [01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893, 01_DMI_DECOUPAG_440467_COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#423894, 01_DMI_DECOUPAG_440467_COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#423895, 01_DMI_DECOUPAG_440467_COL_0BE82637_88B2_4D38_AB56_F261497B0D57#423896]
Arguments: [01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893 ASC NULLS FIRST], false, 0

(16) SortMergeJoin [codegen id : 7]
Left keys [1]: [COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877]
Right keys [1]: [01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893]
Join type: FullOuter
Join condition: None

(17) Project [codegen id : 7]
Output [15]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, 01_DMI_DECOUPAG_440467_COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#423894 AS COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, 01_DMI_DECOUPAG_440467_COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#423895 AS COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, 01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893 AS COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, 01_DMI_DECOUPAG_440467_COL_0BE82637_88B2_4D38_AB56_F261497B0D57#423896 AS COL_059961D5_87D2_4745_B270_05C29151B074#423994]
Input [15]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, 01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893, 01_DMI_DECOUPAG_440467_COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#423894, 01_DMI_DECOUPAG_440467_COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#423895, 01_DMI_DECOUPAG_440467_COL_0BE82637_88B2_4D38_AB56_F261497B0D57#423896]

(18) Exchange
Input [15]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_059961D5_87D2_4745_B270_05C29151B074#423994]
Arguments: hashpartitioning(COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, 10), ENSURE_REQUIREMENTS, [plan_id=40953]

(19) ShuffleQueryStage
Output [15]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_059961D5_87D2_4745_B270_05C29151B074#423994]
Arguments: 4

(20) AQEShuffleRead
Input [15]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_059961D5_87D2_4745_B270_05C29151B074#423994]
Arguments: coalesced

(21) Sort [codegen id : 8]
Input [15]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_059961D5_87D2_4745_B270_05C29151B074#423994]
Arguments: [COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877 ASC NULLS FIRST], false, 0

(22) Scan csv 
Output [1]: [_c0#421576]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/MOLECULES_ONERE_440457/MO-M12-2025.txt]
ReadSchema: struct<_c0:string>

(23) Project [codegen id : 3]
Output [3]: [str_remove_space(str_extract_middle(_c0#421576, 12, 20), ALL) AS COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, str_remove_space(str_extract_middle(_c0#421576, 40, 15), ALL) AS COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, str_to_dec(str_join(array(str_extract_middle(_c0#421576, 65, 7), str_extract_middle(_c0#421576, 72, 3)), .), ##.##) AS COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717]
Input [1]: [_c0#421576]

(24) ObjectHashAggregate
Input [3]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717]
Keys [1]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710]
Functions [2]: [partial_sum(COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717), partial_collect_list(COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, 0, 0)]
Aggregate Attributes [2]: [sum#424425, buf#424426]
Results [3]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, sum#424427, buf#424428]

(25) Exchange
Input [3]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, sum#424427, buf#424428]
Arguments: hashpartitioning(COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, 10), ENSURE_REQUIREMENTS, [plan_id=40761]

(26) ShuffleQueryStage
Output [3]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, sum#424427, buf#424428]
Arguments: 2

(27) AQEShuffleRead
Input [3]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, sum#424427, buf#424428]
Arguments: coalesced

(28) ObjectHashAggregate
Input [3]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, sum#424427, buf#424428]
Keys [1]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710]
Functions [2]: [sum(COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717), collect_list(COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, 0, 0)]
Aggregate Attributes [2]: [sum(COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717)#421744, collect_list(COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, 0, 0)#421746]
Results [3]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710 AS COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#421762, round(sum(COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717)#421744, 2) AS COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#421763, collect_list(COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, 0, 0)#421746 AS COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#421764]

(29) Project [codegen id : 9]
Output [4]: [COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#421762 AS MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014, COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#421763 AS MOLECULES_ONERE_440476_COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#424015, COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#421764 AS MOLECULES_ONERE_440476_COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#424016, size(COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#421764, true) AS MOLECULES_ONERE_440476_COL_0E667C51_6C84_403A_9D26_666830EFDC70#424017]
Input [3]: [COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#421762, COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#421763, COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#421764]

(30) Sort [codegen id : 9]
Input [4]: [MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014, MOLECULES_ONERE_440476_COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#424015, MOLECULES_ONERE_440476_COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#424016, MOLECULES_ONERE_440476_COL_0E667C51_6C84_403A_9D26_666830EFDC70#424017]
Arguments: [MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014 ASC NULLS FIRST], false, 0

(31) SortMergeJoin [codegen id : 10]
Left keys [1]: [COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877]
Right keys [1]: [MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014]
Join type: FullOuter
Join condition: None

(32) Project [codegen id : 10]
Output [19]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, MOLECULES_ONERE_440476_COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#424015 AS COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, MOLECULES_ONERE_440476_COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#424016 AS COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014 AS COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, MOLECULES_ONERE_440476_COL_0E667C51_6C84_403A_9D26_666830EFDC70#424017 AS COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139]
Input [19]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_059961D5_87D2_4745_B270_05C29151B074#423994, MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014, MOLECULES_ONERE_440476_COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#424015, MOLECULES_ONERE_440476_COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#424016, MOLECULES_ONERE_440476_COL_0E667C51_6C84_403A_9D26_666830EFDC70#424017]

(33) Exchange
Input [19]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139]
Arguments: hashpartitioning(COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, 10), ENSURE_REQUIREMENTS, [plan_id=41120]

(34) ShuffleQueryStage
Output [19]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139]
Arguments: 5

(35) AQEShuffleRead
Input [19]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139]
Arguments: coalesced

(36) Sort [codegen id : 11]
Input [19]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139]
Arguments: [COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335 ASC NULLS FIRST], false, 0

(37) Scan csv 
Output [1]: [_c0#421798]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/RSS_M12_2025_440462/RSS- 420780652.txt]
ReadSchema: struct<_c0:string>

(38) Project [codegen id : 4]
Output [4]: [str_extract_middle(_c0#421798, 3, 2) AS RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192, str_extract_middle(_c0#421798, 5, 4) AS RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193, str_extract_middle(_c0#421798, 28, 20) AS RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, str_extract_middle(_c0#421798, 48, 20) AS RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196]
Input [1]: [_c0#421798]

(39) Exchange
Input [4]: [RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192, RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193, RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196]
Arguments: hashpartitioning(RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, 10), ENSURE_REQUIREMENTS, [plan_id=40786]

(40) ShuffleQueryStage
Output [4]: [RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192, RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193, RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196]
Arguments: 3

(41) AQEShuffleRead
Input [4]: [RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192, RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193, RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196]
Arguments: coalesced

(42) Sort [codegen id : 12]
Input [4]: [RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192, RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193, RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196]
Arguments: [RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195 ASC NULLS FIRST], false, 0

(43) SortMergeJoin [codegen id : 13]
Left keys [1]: [COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335]
Right keys [1]: [RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195]
Join type: FullOuter
Join condition: None

(44) Project [codegen id : 13]
Output [22]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139, RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192 AS COL_73D74EBE_833B_4E31_9DF5_A246CF60FFA0#424396, RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193 AS COL_E53BE285_65B5_4C30_A5A1_834C97529087#424397, RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196 AS COL_90A4E254_6A13_422C_90D0_6E90879B9F1A#424398]
Input [23]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139, RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192, RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193, RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196]

(45) CollectLimit
Input [22]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139, COL_73D74EBE_833B_4E31_9DF5_A246CF60FFA0#424396, COL_E53BE285_65B5_4C30_A5A1_834C97529087#424397, COL_90A4E254_6A13_422C_90D0_6E90879B9F1A#424398]
Arguments: 1500

(46) Project
Output [11]: [FINESS#419976 AS COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, NO_RSS#419977 AS COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, NO_ADMIN#419978 AS COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, DATE_ENT#419979 AS COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, DATE_SOR#419980 AS COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, VALO#419981 AS COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, GHS#419982 AS COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, str_to_dec(MNT_MON#420118, ##.##) AS COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, str_to_dec(MNT_DMI#420119, ##.##) AS COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, MNT_MED_APAC#420120 AS COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, str_remove_space(NO_ADMIN#419978, ALL) AS COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877]
Input [10]: [FINESS#419976, NO_RSS#419977, NO_ADMIN#419978, DATE_ENT#419979, DATE_SOR#419980, VALO#419981, GHS#419982, MNT_MON#420118, MNT_DMI#420119, MNT_MED_APAC#420120]

(47) Exchange
Input [11]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877]
Arguments: hashpartitioning(COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, 10), ENSURE_REQUIREMENTS, [plan_id=40651]

(48) Sort
Input [11]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877]
Arguments: [COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877 ASC NULLS FIRST], false, 0

(49) Project
Output [3]: [str_remove_space(str_extract_middle(_c0#421389, 12, 20), ALL) AS COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, str_remove_space(str_extract_middle(_c0#421389, 58, 15), ALL) AS COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, round(str_to_dec(str_join(array(str_extract_middle(_c0#421389, 83, 7), str_extract_middle(_c0#421389, 90, 3)), .), ##.##), 2) AS COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500]
Input [1]: [_c0#421389]

(50) ObjectHashAggregate
Input [3]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500]
Keys [1]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494]
Functions [2]: [partial_sum(COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500), partial_collect_list(COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, 0, 0)]
Aggregate Attributes [2]: [sum#424421, buf#424422]
Results [3]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, sum#424423, buf#424424]

(51) Exchange
Input [3]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, sum#424423, buf#424424]
Arguments: hashpartitioning(COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, 10), ENSURE_REQUIREMENTS, [plan_id=40646]

(52) ObjectHashAggregate
Input [3]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494, sum#424423, buf#424424]
Keys [1]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494]
Functions [2]: [sum(COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500), collect_list(COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, 0, 0)]
Aggregate Attributes [2]: [sum(COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500)#421522, collect_list(COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, 0, 0)#421524]
Results [3]: [COL_C898C1FE_14C4_493A_878B_315EB757695B#421494 AS COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#421540, round(sum(COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#421500)#421522, 2) AS COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#421541, collect_list(COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#421496, 0, 0)#421524 AS COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#421542]

(53) Project
Output [4]: [COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#421540 AS 01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893, COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#421541 AS 01_DMI_DECOUPAG_440467_COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#423894, COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#421542 AS 01_DMI_DECOUPAG_440467_COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#423895, size(COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#421542, true) AS 01_DMI_DECOUPAG_440467_COL_0BE82637_88B2_4D38_AB56_F261497B0D57#423896]
Input [3]: [COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#421540, COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#421541, COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#421542]

(54) Sort
Input [4]: [01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893, 01_DMI_DECOUPAG_440467_COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#423894, 01_DMI_DECOUPAG_440467_COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#423895, 01_DMI_DECOUPAG_440467_COL_0BE82637_88B2_4D38_AB56_F261497B0D57#423896]
Arguments: [01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893 ASC NULLS FIRST], false, 0

(55) SortMergeJoin
Left keys [1]: [COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877]
Right keys [1]: [01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893]
Join type: FullOuter
Join condition: None

(56) Project
Output [15]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, 01_DMI_DECOUPAG_440467_COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#423894 AS COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, 01_DMI_DECOUPAG_440467_COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#423895 AS COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, 01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893 AS COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, 01_DMI_DECOUPAG_440467_COL_0BE82637_88B2_4D38_AB56_F261497B0D57#423896 AS COL_059961D5_87D2_4745_B270_05C29151B074#423994]
Input [15]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, 01_DMI_DECOUPAG_440467_COL_7CC70679_D8A9_4AFA_853C_0B83772BB57F#423893, 01_DMI_DECOUPAG_440467_COL_09C9C0C9_12D2_4B88_AA5D_EE56C4B13EED#423894, 01_DMI_DECOUPAG_440467_COL_4592CA9A_29CD_4295_BD86_00D4BBBF99FD#423895, 01_DMI_DECOUPAG_440467_COL_0BE82637_88B2_4D38_AB56_F261497B0D57#423896]

(57) Exchange
Input [15]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_059961D5_87D2_4745_B270_05C29151B074#423994]
Arguments: hashpartitioning(COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, 10), ENSURE_REQUIREMENTS, [plan_id=40661]

(58) Sort
Input [15]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_059961D5_87D2_4745_B270_05C29151B074#423994]
Arguments: [COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877 ASC NULLS FIRST], false, 0

(59) Project
Output [3]: [str_remove_space(str_extract_middle(_c0#421576, 12, 20), ALL) AS COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, str_remove_space(str_extract_middle(_c0#421576, 40, 15), ALL) AS COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, str_to_dec(str_join(array(str_extract_middle(_c0#421576, 65, 7), str_extract_middle(_c0#421576, 72, 3)), .), ##.##) AS COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717]
Input [1]: [_c0#421576]

(60) ObjectHashAggregate
Input [3]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717]
Keys [1]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710]
Functions [2]: [partial_sum(COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717), partial_collect_list(COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, 0, 0)]
Aggregate Attributes [2]: [sum#424425, buf#424426]
Results [3]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, sum#424427, buf#424428]

(61) Exchange
Input [3]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, sum#424427, buf#424428]
Arguments: hashpartitioning(COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, 10), ENSURE_REQUIREMENTS, [plan_id=40656]

(62) ObjectHashAggregate
Input [3]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710, sum#424427, buf#424428]
Keys [1]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710]
Functions [2]: [sum(COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717), collect_list(COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, 0, 0)]
Aggregate Attributes [2]: [sum(COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717)#421744, collect_list(COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, 0, 0)#421746]
Results [3]: [COL_9979D704_E827_4785_AA6A_46B46DBF4847#421710 AS COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#421762, round(sum(COL_83950E9E_E1A2_40D0_8B87_BED2FABAA685#421717)#421744, 2) AS COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#421763, collect_list(COL_88F0CE42_F8A7_4281_8763_D8933C024F46#421712, 0, 0)#421746 AS COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#421764]

(63) Project
Output [4]: [COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#421762 AS MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014, COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#421763 AS MOLECULES_ONERE_440476_COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#424015, COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#421764 AS MOLECULES_ONERE_440476_COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#424016, size(COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#421764, true) AS MOLECULES_ONERE_440476_COL_0E667C51_6C84_403A_9D26_666830EFDC70#424017]
Input [3]: [COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#421762, COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#421763, COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#421764]

(64) Sort
Input [4]: [MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014, MOLECULES_ONERE_440476_COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#424015, MOLECULES_ONERE_440476_COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#424016, MOLECULES_ONERE_440476_COL_0E667C51_6C84_403A_9D26_666830EFDC70#424017]
Arguments: [MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014 ASC NULLS FIRST], false, 0

(65) SortMergeJoin
Left keys [1]: [COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877]
Right keys [1]: [MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014]
Join type: FullOuter
Join condition: None

(66) Project
Output [19]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, MOLECULES_ONERE_440476_COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#424015 AS COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, MOLECULES_ONERE_440476_COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#424016 AS COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014 AS COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, MOLECULES_ONERE_440476_COL_0E667C51_6C84_403A_9D26_666830EFDC70#424017 AS COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139]
Input [19]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_059961D5_87D2_4745_B270_05C29151B074#423994, MOLECULES_ONERE_440476_COL_F1D11223_61B6_416F_B9C1_A2E3B5D0A062#424014, MOLECULES_ONERE_440476_COL_7FE83AB2_FE45_4E07_ABE2_B7A44F323A8F#424015, MOLECULES_ONERE_440476_COL_1C7F4A28_C2C6_47DF_86EF_9C17C4107422#424016, MOLECULES_ONERE_440476_COL_0E667C51_6C84_403A_9D26_666830EFDC70#424017]

(67) Exchange
Input [19]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139]
Arguments: hashpartitioning(COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, 10), ENSURE_REQUIREMENTS, [plan_id=40670]

(68) Sort
Input [19]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139]
Arguments: [COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335 ASC NULLS FIRST], false, 0

(69) Project
Output [4]: [str_extract_middle(_c0#421798, 3, 2) AS RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192, str_extract_middle(_c0#421798, 5, 4) AS RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193, str_extract_middle(_c0#421798, 28, 20) AS RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, str_extract_middle(_c0#421798, 48, 20) AS RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196]
Input [1]: [_c0#421798]

(70) Exchange
Input [4]: [RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192, RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193, RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196]
Arguments: hashpartitioning(RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, 10), ENSURE_REQUIREMENTS, [plan_id=40671]

(71) Sort
Input [4]: [RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192, RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193, RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196]
Arguments: [RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195 ASC NULLS FIRST], false, 0

(72) SortMergeJoin
Left keys [1]: [COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335]
Right keys [1]: [RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195]
Join type: FullOuter
Join condition: None

(73) Project
Output [22]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139, RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192 AS COL_73D74EBE_833B_4E31_9DF5_A246CF60FFA0#424396, RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193 AS COL_E53BE285_65B5_4C30_A5A1_834C97529087#424397, RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196 AS COL_90A4E254_6A13_422C_90D0_6E90879B9F1A#424398]
Input [23]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139, RSS_DECOUPAGE_440487_COL_E09BE310_CFCE_497E_848C_34FBF72DB14C#424192, RSS_DECOUPAGE_440487_COL_F8AD746F_4F7F_4AED_85D7_96E1109D17B8#424193, RSS_DECOUPAGE_440487_COL_4E5BCDED_FFA3_4620_99A4_CB56AB972321#424195, RSS_DECOUPAGE_440487_COL_B42B9C47_0D9D_4A8E_A1F6_F91DB86D5D92#424196]

(74) CollectLimit
Input [22]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139, COL_73D74EBE_833B_4E31_9DF5_A246CF60FFA0#424396, COL_E53BE285_65B5_4C30_A5A1_834C97529087#424397, COL_90A4E254_6A13_422C_90D0_6E90879B9F1A#424398]
Arguments: 1500

(75) AdaptiveSparkPlan
Output [22]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#423334, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#423335, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#423336, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#423337, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#423338, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#423339, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#423340, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#423874, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#423875, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#423478, COL_AA2A4EC8_3B37_49D4_8E9E_4D9406083A09#423877, COL_9AC6AF0B_628B_42CB_AD38_5FA9E8E4EEC4#423991, COL_C41A4DA6_55E8_44C6_8652_24471CDC2940#424133, COL_5513B169_9E79_4981_98E9_9AD91CAD2AAE#423992, COL_28CD0FFE_3726_4A14_92A6_39B976EA09F7#424135, COL_FA768035_91AB_411A_A41F_8AE118FFF1BE#423993, COL_79276767_E311_42C2_815B_DCED4B9FEBC1#424137, COL_059961D5_87D2_4745_B270_05C29151B074#423994, COL_85502B1E_8D0B_42FD_AF14_4EC248FB719F#424139, COL_73D74EBE_833B_4E31_9DF5_A246CF60FFA0#424396, COL_E53BE285_65B5_4C30_A5A1_834C97529087#424397, COL_90A4E254_6A13_422C_90D0_6E90879B9F1A#424398]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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