SP1 - Details for Query 975

Submitted Time: 2026/02/24 09:58:31
Duration: 14 s
Succeeded Jobs: 1328 1329 1330 1331 1332 1334 1336 1337 1338 1340 1341 1342 1343

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time: 1 ms number of written files: 1 job commit time: 9 ms number of output rows: 22 number of dynamic part: 0 written output: 3.2 KiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (20)\n \nduration: 98 ms"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 6 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1722.0 B number of coalesced partitions: 1"]; 7 [labelType="html" label="Exchange shuffle records written: 22 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: 22 local bytes read: 1630.0 B 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: 1760.0 B 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: 1630.0 B"]; 8 [labelType="html" label="Window spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 2055.0: task 2478))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (19)\n \nduration: total (min, med, max (stageId: taskId))\n37 ms (6 ms, 31 ms, 31 ms (stage 2055.0: task 2478))"; 10 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2055.0: task 2478)) peak memory total (min, med, max (stageId: taskId)) 32.1 MiB (16.1 MiB, 16.1 MiB, 16.1 MiB (stage 2055.0: task 2478)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 2055.0: task 2478))"]; } 11 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 717.0 B number of coalesced partitions: 1"]; 12 [labelType="html" label="Exchange shuffle records written: 22 local merged chunks fetched: 0 shuffle write time: 0 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: 44 local bytes read total (min, med, max (stageId: taskId)) 1402.0 B (701.0 B, 701.0 B, 701.0 B (stage 2055.0: task 2478)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2055.0: task 2478)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size: 1408.0 B 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: 701.0 B"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (18)\n \nduration: 3 ms"; 14 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 16.3 MiB number of output rows: 22 number of sort fallback tasks: 0 avg hash probes per key: 1"]; } 15 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1358.0 B number of coalesced partitions: 1"]; 16 [labelType="html" label="Exchange shuffle records written: 22 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: 22 local bytes read: 1291.0 B 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: 1408.0 B 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: 1291.0 B"]; subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (17)\n \nduration: 49 ms"; 18 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 9 ms peak memory: 256.0 KiB number of output rows: 22 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 21 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 89.4 KiB number of coalesced partitions: 1"]; 22 [labelType="html" label="Exchange shuffle records written: 1,790 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 9 ms (1 ms, 1 ms, 1 ms (stage 2021.0: task 2469)) 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: 1,790 local bytes read: 85.5 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 5 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 391.6 KiB (65.0 KiB, 81.8 KiB, 84.2 KiB (stage 2021.0: task 2466)) 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)) 85.5 KiB (15.1 KiB, 17.5 KiB, 18.0 KiB (stage 2021.0: task 2467))"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: total (min, med, max (stageId: taskId))\n1.7 s (75 ms, 261 ms, 270 ms (stage 2014.0: task 2461))"; 24 [labelType="html" label=" Project "]; 25 [labelType="html" label=" Project "]; 26 [labelType="html" label="Filter number of output rows: 3,580"]; } 27 [labelType="html" label="Window spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 2014.0: task 2463))"]; subgraph cluster28 { isCluster="true"; label="WholeStageCodegen (15)\n \nduration: total (min, med, max (stageId: taskId))\n2.5 s (115 ms, 381 ms, 394 ms (stage 2014.0: task 2461))"; 29 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 100 ms (8 ms, 10 ms, 12 ms (stage 2014.0: task 2464)) peak memory total (min, med, max (stageId: taskId)) 165.0 MiB (16.5 MiB, 16.5 MiB, 16.5 MiB (stage 2014.0: task 2463)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 2014.0: task 2463))"]; } 30 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 7.7 MiB (1509.1 KiB, 1572.5 KiB, 1660.0 KiB (driver)) number of coalesced partitions: 5"]; 31 [labelType="html" label="Exchange shuffle records written: 102,689 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 30 ms (5 ms, 8 ms, 15 ms (stage 2000.0: task 2453)) 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: 205,378 local bytes read total (min, med, max (stageId: taskId)) 14.9 MiB (1471.8 KiB, 1495.4 KiB, 1591.1 KiB (stage 2014.0: task 2465)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2014.0: task 2463)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 30 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 54.0 MiB (8.7 MiB, 12.7 MiB, 32.6 MiB (stage 2000.0: task 2453)) 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)) 7.4 MiB (1202.3 KiB, 1813.9 KiB, 4.5 MiB (stage 2000.0: task 2453))"]; subgraph cluster32 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: total (min, med, max (stageId: taskId))\n5.2 s (1.1 s, 1.4 s, 2.7 s (stage 2000.0: task 2453))"; 33 [labelType="html" label=" Project "]; 34 [labelType="html" label=" Project "]; 35 [labelType="html" label=" Project "]; 36 [labelType="html" label=" Project "]; 37 [labelType="html" label=" Project "]; 38 [labelType="html" label="SortMergeJoin number of output rows: 102,689 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 2000.0: task 2454))"]; } subgraph cluster39 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: total (min, med, max (stageId: taskId))\n5.5 s (1.2 s, 1.5 s, 2.8 s (stage 2000.0: task 2453))"; 40 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 30 ms (5 ms, 10 ms, 15 ms (stage 2000.0: task 2453)) peak memory total (min, med, max (stageId: taskId)) 67.5 MiB (16.5 MiB, 17.0 MiB, 34.0 MiB (stage 2000.0: task 2453)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 2000.0: task 2454))"]; } 41 [labelType="html" label="AQEShuffleRead number of partitions: 3 partition data size total (min, med, max (stageId: taskId)) 7.0 MiB (1265.1 KiB, 1831.5 KiB, 4.0 MiB (driver)) number of coalesced partitions: 3"]; 42 [labelType="html" label="Exchange shuffle records written: 102,485 local merged chunks fetched: 0 shuffle write time: 28 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: 102,485 local bytes read total (min, med, max (stageId: taskId)) 6.8 MiB (1172.3 KiB, 1758.1 KiB, 3.9 MiB (stage 2000.0: task 2453)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2000.0: task 2454)) 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: 34.6 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: 6.8 MiB"]; subgraph cluster43 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 9.1 s"; 44 [labelType="html" label=" Project "]; 45 [labelType="html" label=" Project "]; 46 [labelType="html" label=" Project "]; 47 [labelType="html" label=" Project "]; 48 [labelType="html" label=" Project "]; } 49 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster50 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 456 ms"; 51 [labelType="html" label=" Project "]; 52 [labelType="html" label="Filter number of output rows: 102,485"]; } 53 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster54 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 112 ms"; 55 [labelType="html" label="Sort sort time: 11 ms peak memory: 36.0 MiB spill size: 0.0 B"]; } 56 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 4.8 MiB number of coalesced partitions: 1"]; 57 [labelType="html" label="Exchange shuffle records written: 102,485 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 22 ms (3 ms, 4 ms, 5 ms (stage 1981.0: task 2443)) 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: 102,485 local bytes read: 4.4 MiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 5 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 21.6 MiB (2.5 MiB, 4.8 MiB, 4.8 MiB (stage 1981.0: task 2439)) 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)) 4.4 MiB (522.3 KiB, 1001.5 KiB, 1007.5 KiB (stage 1981.0: task 2440))"]; subgraph cluster58 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n890 ms (117 ms, 192 ms, 209 ms (stage 1981.0: task 2440))"; 59 [labelType="html" label=" Project "]; } 60 [labelType="html" label="Scan csv number of output rows: 102,485 number of files read: 1 metadata time: 0 ms size of files read: 18.1 MiB"]; subgraph cluster61 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: total (min, med, max (stageId: taskId))\n1.3 m (2.7 s, 16.8 s, 56.6 s (stage 2000.0: task 2454))"; 62 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2000.0: task 2454)) peak memory total (min, med, max (stageId: taskId)) 48.2 MiB (16.1 MiB, 16.1 MiB, 16.1 MiB (stage 2000.0: task 2454)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 2000.0: task 2454))"]; } 63 [labelType="html" label="AQEShuffleRead number of partitions: 3 partition data size total (min, med, max (stageId: taskId)) 3.7 KiB (739.0 B, 1340.0 B, 1680.0 B (driver)) number of coalesced partitions: 3"]; 64 [labelType="html" label="Exchange shuffle records written: 177 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: 177 local bytes read total (min, med, max (stageId: taskId)) 3.5 KiB (693.0 B, 1279.0 B, 1627.0 B (stage 2000.0: task 2455)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2000.0: task 2454)) 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: 8.3 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: 3.5 KiB"]; subgraph cluster65 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 10 ms"; 66 [labelType="html" label=" Project "]; 67 [labelType="html" label="SortMergeJoin number of output rows: 177 spill size: 0.0 B"]; } subgraph cluster68 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 39 ms"; 69 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 70 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 8.1 KiB number of coalesced partitions: 1"]; 71 [labelType="html" label="Exchange shuffle records written: 499 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 2 ms (0 ms, 0 ms, 0 ms (stage 1982.0: task 2445)) 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: 499 local bytes read: 7.7 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)) 51.9 KiB (16.9 KiB, 17.0 KiB, 18.1 KiB (stage 1982.0: task 2444)) 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)) 7.7 KiB (2.5 KiB, 2.6 KiB, 2.6 KiB (stage 1982.0: task 2444))"]; 72 [labelType="html" label=" Union "]; subgraph cluster73 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 13 ms"; 74 [labelType="html" label=" Project "]; 75 [labelType="html" label="Filter number of output rows: 166"]; 76 [labelType="html" label="ColumnarToRow number of output rows: 166 number of input batches: 1"]; } 77 [labelType="html" label="Scan parquet number of files read: 1 scan time: 3 ms metadata time: 0 ms size of files read: 4.3 KiB number of output rows: 166"]; subgraph cluster78 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 14 ms"; 79 [labelType="html" label=" Project "]; 80 [labelType="html" label="Filter number of output rows: 166"]; 81 [labelType="html" label="ColumnarToRow number of output rows: 166 number of input batches: 1"]; } 82 [labelType="html" label="Scan parquet number of files read: 1 scan time: 4 ms metadata time: 0 ms size of files read: 4.3 KiB number of output rows: 166"]; subgraph cluster83 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 22 ms"; 84 [labelType="html" label=" Project "]; 85 [labelType="html" label="Filter number of output rows: 167"]; 86 [labelType="html" label="ColumnarToRow number of output rows: 167 number of input batches: 1"]; } 87 [labelType="html" label="Scan parquet number of files read: 1 scan time: 8 ms metadata time: 0 ms size of files read: 4.2 KiB number of output rows: 167"]; subgraph cluster88 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 4 ms"; 89 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 90 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 72.0 B number of coalesced partitions: 1"]; 91 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 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: 1 local bytes read: 68.0 B 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: 24.0 B 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: 68.0 B"]; subgraph cluster92 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 5 ms"; 93 [labelType="html" label=" Project "]; } 94 [labelType="html" label="Scan csv number of output rows: 1 number of files read: 1 metadata time: 0 ms size of files read: 62.0 B"]; 1->0; 2->1; 4->2; 5->4; 6->5; 7->6; 8->7; 10->8; 11->10; 12->11; 14->12; 15->14; 16->15; 18->16; 19->18; 20->19; 21->20; 22->21; 24->22; 25->24; 26->25; 27->26; 29->27; 30->29; 31->30; 33->31; 34->33; 35->34; 36->35; 37->36; 38->37; 40->38; 41->40; 42->41; 44->42; 45->44; 46->45; 47->46; 48->47; 49->48; 51->49; 52->51; 53->52; 55->53; 56->55; 57->56; 59->57; 60->59; 62->38; 63->62; 64->63; 66->64; 67->66; 69->67; 70->69; 71->70; 72->71; 74->72; 75->74; 76->75; 77->76; 79->72; 80->79; 81->80; 82->81; 84->72; 85->84; 86->85; 87->86; 89->67; 90->89; 91->90; 93->91; 94->93; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/2815e2ed_15be_476b_9991_43f228019b59, false, Parquet, [path=file:///data/output/cache/parquet/datablock/2815e2ed_15be_476b_9991_43f228019b59], Overwrite, [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0, COL_8246091B_F617_46DA_B417_C911085B619C, COL_BABB3A33_596C_4623_AA68_D934A17418FB, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F]

WriteFiles

Project [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, round(COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, 2) AS COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311428, round(COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, 2) AS COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311429, COL_8246091B_F617_46DA_B417_C911085B619C#311373L, round(COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, 2) AS COL_BABB3A33_596C_4623_AA68_D934A17418FB#311431, round(COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410, 2) AS COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311432]

Sort [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS FIRST, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369 ASC NULLS FIRST], true, 0

WholeStageCodegen (20)

AQEShuffleRead coalesced

Exchange rangepartitioning(COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS FIRST, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=37879]

Window [sum(COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372) windowspecdefinition(1, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, sum(COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371) windowspecdefinition(1, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410], [1], [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS LAST]

Sort [1 ASC NULLS FIRST, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS LAST], false, 0

WholeStageCodegen (19)

AQEShuffleRead coalesced

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

HashAggregate(keys=[COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246], functions=[sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249), sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248), count(1)])

WholeStageCodegen (18)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246, 10), ENSURE_REQUIREMENTS, [plan_id=37764]

HashAggregate(keys=[COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246], functions=[partial_sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249), partial_sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248), partial_count(1)])

Project [COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727 AS COL_A67131E4_E549_4206_9029_E6591A70C578#311246, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079 AS COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231 AS COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026, C)) THEN false ELSE StartsWith(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026, C) END, str_concat(array(str_extract_middle(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026, 74, 4), -, str_extract_middle(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026, 72, 2))), ) AS COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313]

Sort [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364 ASC NULLS FIRST], true, 0

WholeStageCodegen (17)

AQEShuffleRead coalesced

Exchange rangepartitioning(COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=37666]

Project [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, str_if_with_rule(((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A) AND (COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340 <=> 1.0)), str_concat(array(str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, LEFT, 105), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_954A8446_59EE_42A6_874E_5D947C05002E#309087), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_954A8446_59EE_42A6_874E_5D947C05002E#309087), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_B8447468_D81F_445D_91DE_8654426D3D23#309088), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_B8447468_D81F_445D_91DE_8654426D3D23#309088), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#309085), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#309085), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#309086), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#309086), ., RIGHT), 0, 2, RIGHT))), str_extract_middle(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, 138, 1000))), COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941) AS COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026]

Project [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A), dec_operator(SOMME, array(COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, CASE WHEN isnull(COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487) THEN 0.0 ELSE CASE WHEN isnan(COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487) THEN 0.0 ELSE COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487 END END)), null), 2) AS COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#309085, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A), dec_operator(SOMME, array(COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, CASE WHEN isnull(COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762) THEN 0.0 ELSE CASE WHEN isnan(COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762) THEN 0.0 ELSE COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762 END END)), null), 2) AS COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#309086, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A), dec_operator(SOMME, array(COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, CASE WHEN isnull(COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398) THEN 0.0 ELSE CASE WHEN isnan(COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398) THEN 0.0 ELSE COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398 END END)), null), 2) AS COL_954A8446_59EE_42A6_874E_5D947C05002E#309087, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A), dec_operator(SOMME, array(COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, CASE WHEN isnull(COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834) THEN 0.0 ELSE CASE WHEN isnan(COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834) THEN 0.0 ELSE COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834 END END)), null), 2) AS COL_B8447468_D81F_445D_91DE_8654426D3D23#309088, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340]

Filter (COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0)

WholeStageCodegen (16)

Window [sum(COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487, sum(COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762, sum(COL_1E060572_AE15_4178_913A_C47144F27CFB#305267) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398, sum(COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834, max(COL_4B158112_2BA5_45AF_B876_25385319D312#301140) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340], [COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369], [1 DESC NULLS LAST]

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

WholeStageCodegen (15)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 10), ENSURE_REQUIREMENTS, [plan_id=37414]

Project [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, str_if_with_rule(((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> C) AND (COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0)), str_concat(array(str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, LEFT, 93), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079), ., RIGHT), 0, 2, RIGHT))), COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#302087, str_complete(int_to_str(COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378), 0, 3, LEFT), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#301955), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#301955), ., RIGHT), 0, 2, RIGHT))), str_extract_by_index(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, 127, 1000))), str_if_with_rule(((COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0) AND (COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> B)), , COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363)) AS COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> C), dec_operator(DIFFERENCE, array(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382)), null) AS COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> C), dec_operator(DIFFERENCE, array(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383)), null) AS COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> B), dec_operator(DIFFERENCE, array(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382)), null) AS COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> B), dec_operator(DIFFERENCE, array(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383)), null) AS COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]

SortMergeJoin [COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727], [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905], LeftOuter, ((COL_2145E350_E453_4696_8BD8_11A2154405D8#299373 >= TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907) AND (COL_2145E350_E453_4696_8BD8_11A2154405D8#299373 <= TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908))

WholeStageCodegen (14)

Sort [COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727 ASC NULLS FIRST], false, 0

WholeStageCodegen (12)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, 10), ENSURE_REQUIREMENTS, [plan_id=36953]

Project [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916 AS COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930 AS COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 AS COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044 AS COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220 AS COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#299372, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236 AS COL_2145E350_E453_4696_8BD8_11A2154405D8#299373, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253 AS COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#294290 AS COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#294331 AS COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_E29ED133_4552_4D50_8A38_D30257A626BD#294400 AS COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#294425 AS COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, str_remove_space(str_remove_space(COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, LEFT), RIGHT) AS COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, str_to_dec(str_join(array(str_extract(COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#294478, LEFT, 6), str_extract(COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#294478, RIGHT, 2)), .), ##.##) AS COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, str_to_dec(str_join(array(str_extract(COL_9339888E_B0C5_4327_8233_5581882E58E1#294506, LEFT, 6), str_extract(COL_9339888E_B0C5_4327_8233_5581882E58E1#294506, RIGHT, 2)), .), ##.##) AS COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, str_to_dec(str_join(array(str_extract(COL_B244443E_C845_4CB1_B850_D141FCA24A95#294565, LEFT, 6), str_extract(COL_B244443E_C845_4CB1_B850_D141FCA24A95#294565, RIGHT, 2)), .), ##.##) AS COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, str_to_dec(str_join(array(str_extract(COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#294535, LEFT, 6), str_extract(COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#294535, RIGHT, 2)), .), ##.##) AS COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]

Project [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#294290, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#294331, str_to_dec(str_join(array(str_extract(COL_E5077910_2063_4267_B69B_497F468B05F5#294310, LEFT, 6), str_extract(COL_E5077910_2063_4267_B69B_497F468B05F5#294310, RIGHT, 2)), .), ##.##) AS COL_E29ED133_4552_4D50_8A38_D30257A626BD#294400, str_to_dec(str_join(array(str_extract(COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#294353, LEFT, 6), str_extract(COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#294353, RIGHT, 2)), .), ##.##) AS COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#294425, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 106, 8), ) AS COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#294478, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 114, 8), ) AS COL_9339888E_B0C5_4327_8233_5581882E58E1#294506, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 130, 8), ) AS COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#294535, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 122, 8), ) AS COL_B244443E_C845_4CB1_B850_D141FCA24A95#294565]

Project [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, str_to_dec(str_join(array(str_extract(COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#294271, LEFT, 4), str_extract(COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#294271, RIGHT, 2)), .), ##.##) AS COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#294290, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 107, 8), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 101, 8), )) AS COL_E5077910_2063_4267_B69B_497F468B05F5#294310, str_to_integer(str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 115, 3), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 109, 3), ))) AS COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#294331, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 118, 8), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 112, 8), )) AS COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#294353]

Project [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, str_to_dec(str_join(array(str_extract(COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#294191, LEFT, 5), str_extract(COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#294191, RIGHT, 2)), .), ##.##) AS COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, str_to_datez(str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B)), str_join(array(str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 70, 2), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 72, 2), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 74, 4)), /), ), dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, str_to_integer(str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 83, 3), )) AS COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 86, 6), ) AS COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#294271]

Project [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 100, 7), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 94, 7), )) AS COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#294191, str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 78, 5), ) AS COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205]

WholeStageCodegen (11)

Window [last(COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#294019, true) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044], [1], [1 DESC NULLS LAST]

Project [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_join(array(str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_complete(bigint_to_str(COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930), 0, 5, LEFT), ), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 40, 9), )), -), null) AS COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#294019]

Filter (((COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930 <=> 1) AND (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A)) OR (COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930 > 1))

WholeStageCodegen (10)

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

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

WholeStageCodegen (9)

AQEShuffleRead coalesced

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

Project [_c0#293889 AS COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, str_extract(_c0#293889, LEFT, 1) AS COL_D510A167_ACB1_4527_BFB8_45608936317D#293920]

WholeStageCodegen (1)

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

Sort [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905 ASC NULLS FIRST], false, 0

WholeStageCodegen (13)

AQEShuffleRead coalesced

Exchange hashpartitioning(TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, 10), ENSURE_REQUIREMENTS, [plan_id=36677]

Project [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810 AS TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, str_to_dec(str_replace(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, ., ,), ##,##) AS TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906, str_to_datez(COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, dd/MM/yyyy, Europe/Paris, fr_FR) AS TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907, str_to_datez(COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, dd/MM/yyyy, Europe/Paris, fr_FR) AS TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908]

SortMergeJoin [coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815, ), isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815)], [coalesce(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937, ), isnull(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937)], Cross

WholeStageCodegen (8)

Sort [coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815, ) ASC NULLS FIRST, isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815) ASC NULLS FIRST], false, 0

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815, ), isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815), 10), ENSURE_REQUIREMENTS, [plan_id=36138]

Union

Project [Code+Acte#297960 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, Montant#297961 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, Date_effet#297963 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, Date_r%C3%A9vocation#297964 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, Trigramme#297965 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815]

Filter ((isnotnull(Code+Acte#297960) AND isnotnull(str_to_datez(Date_effet#297963, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#297964, dd/MM/yyyy, Europe/Paris, fr_FR)))

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [Code+Acte#297960,Montant#297961,Date_effet#297963,Date_r%C3%A9vocation#297964,Trigramme#297965] Batched: true, DataFilters: [isnotnull(Code+Acte#297960), isnotnull(str_to_datez(Date_effet#297963, dd/MM/yyyy, Europe/Paris,..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/TARIF_FORFAIT_S_345912_c83de576dabb..., PartitionFilters: [], PushedFilters: [IsNotNull(`Code+Acte`)], ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:st...

Project [Code+Acte#298085 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#311667, Montant#298086 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#311668, Date_effet#298088 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#311669, Date_r%C3%A9vocation#298089 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#311670, Trigramme#298090 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#311671]

Filter ((isnotnull(Code+Acte#298085) AND isnotnull(str_to_datez(Date_effet#298088, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#298089, dd/MM/yyyy, Europe/Paris, fr_FR)))

ColumnarToRow

WholeStageCodegen (3)

FileScan parquet [Code+Acte#298085,Montant#298086,Date_effet#298088,Date_r%C3%A9vocation#298089,Trigramme#298090] Batched: true, DataFilters: [isnotnull(Code+Acte#298085), isnotnull(str_to_datez(Date_effet#298088, dd/MM/yyyy, Europe/Paris,..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/TARIF_FORFAIT_S_345912_c7850cbb93f1..., PartitionFilters: [], PushedFilters: [IsNotNull(`Code+Acte`)], ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:st...

Project [Code+Acte#298274 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#311672, Montant#298275 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#311673, Date_effet#298277 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#311674, Date_r%C3%A9vocation#298278 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#311675, Trigramme#298279 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#311676]

Filter ((isnotnull(Code+Acte#298274) AND isnotnull(str_to_datez(Date_effet#298277, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#298278, dd/MM/yyyy, Europe/Paris, fr_FR)))

ColumnarToRow

WholeStageCodegen (4)

FileScan parquet [Code+Acte#298274,Montant#298275,Date_effet#298277,Date_r%C3%A9vocation#298278,Trigramme#298279] Batched: true, DataFilters: [isnotnull(Code+Acte#298274), isnotnull(str_to_datez(Date_effet#298277, dd/MM/yyyy, Europe/Paris,..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/TARIF_FORFAIT_S_345912_752dbd862f97..., PartitionFilters: [], PushedFilters: [IsNotNull(`Code+Acte`)], ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:st...

Sort [coalesce(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937, ) ASC NULLS FIRST, isnull(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937) ASC NULLS FIRST], false, 0

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(coalesce(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937, ), isnull(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937), 10), ENSURE_REQUIREMENTS, [plan_id=36168]

Project [region-tarif#298745 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#298937]

WholeStageCodegen (5)

FileScan csv [region-tarif#298745] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/INFOETAB_DATAAP_345911/current/in..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<region-tarif:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (141)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (84)
   +- WriteFiles (83)
      +- * Project (82)
         +- * Sort (81)
            +- AQEShuffleRead (80)
               +- ShuffleQueryStage (79), Statistics(sizeInBytes=1760.0 B, rowCount=22)
                  +- Exchange (78)
                     +- Window (77)
                        +- * Sort (76)
                           +- AQEShuffleRead (75)
                              +- ShuffleQueryStage (74), Statistics(sizeInBytes=1408.0 B, rowCount=22)
                                 +- Exchange (73)
                                    +- * HashAggregate (72)
                                       +- AQEShuffleRead (71)
                                          +- ShuffleQueryStage (70), Statistics(sizeInBytes=1408.0 B, rowCount=22)
                                             +- Exchange (69)
                                                +- * HashAggregate (68)
                                                   +- * Project (67)
                                                      +- * Sort (66)
                                                         +- AQEShuffleRead (65)
                                                            +- ShuffleQueryStage (64), Statistics(sizeInBytes=391.6 KiB, rowCount=1.79E+3)
                                                               +- Exchange (63)
                                                                  +- * Project (62)
                                                                     +- * Project (61)
                                                                        +- * Filter (60)
                                                                           +- Window (59)
                                                                              +- * Sort (58)
                                                                                 +- AQEShuffleRead (57)
                                                                                    +- ShuffleQueryStage (56), Statistics(sizeInBytes=54.0 MiB, rowCount=1.03E+5)
                                                                                       +- Exchange (55)
                                                                                          +- * Project (54)
                                                                                             +- * Project (53)
                                                                                                +- * Project (52)
                                                                                                   +- * Project (51)
                                                                                                      +- * Project (50)
                                                                                                         +- * SortMergeJoin LeftOuter (49)
                                                                                                            :- * Sort (19)
                                                                                                            :  +- AQEShuffleRead (18)
                                                                                                            :     +- ShuffleQueryStage (17), Statistics(sizeInBytes=34.6 MiB, rowCount=1.02E+5)
                                                                                                            :        +- Exchange (16)
                                                                                                            :           +- * Project (15)
                                                                                                            :              +- * Project (14)
                                                                                                            :                 +- * Project (13)
                                                                                                            :                    +- * Project (12)
                                                                                                            :                       +- * Project (11)
                                                                                                            :                          +- Window (10)
                                                                                                            :                             +- * Project (9)
                                                                                                            :                                +- * Filter (8)
                                                                                                            :                                   +- Window (7)
                                                                                                            :                                      +- * Sort (6)
                                                                                                            :                                         +- AQEShuffleRead (5)
                                                                                                            :                                            +- ShuffleQueryStage (4), Statistics(sizeInBytes=21.6 MiB, rowCount=1.02E+5)
                                                                                                            :                                               +- Exchange (3)
                                                                                                            :                                                  +- * Project (2)
                                                                                                            :                                                     +- Scan csv  (1)
                                                                                                            +- * Sort (48)
                                                                                                               +- AQEShuffleRead (47)
                                                                                                                  +- ShuffleQueryStage (46), Statistics(sizeInBytes=8.3 KiB, rowCount=177)
                                                                                                                     +- Exchange (45)
                                                                                                                        +- * Project (44)
                                                                                                                           +- * SortMergeJoin Cross (43)
                                                                                                                              :- * Sort (36)
                                                                                                                              :  +- AQEShuffleRead (35)
                                                                                                                              :     +- ShuffleQueryStage (34), Statistics(sizeInBytes=51.9 KiB, rowCount=499)
                                                                                                                              :        +- Exchange (33)
                                                                                                                              :           +- Union (32)
                                                                                                                              :              :- * Project (23)
                                                                                                                              :              :  +- * Filter (22)
                                                                                                                              :              :     +- * ColumnarToRow (21)
                                                                                                                              :              :        +- Scan parquet  (20)
                                                                                                                              :              :- * Project (27)
                                                                                                                              :              :  +- * Filter (26)
                                                                                                                              :              :     +- * ColumnarToRow (25)
                                                                                                                              :              :        +- Scan parquet  (24)
                                                                                                                              :              +- * Project (31)
                                                                                                                              :                 +- * Filter (30)
                                                                                                                              :                    +- * ColumnarToRow (29)
                                                                                                                              :                       +- Scan parquet  (28)
                                                                                                                              +- * Sort (42)
                                                                                                                                 +- AQEShuffleRead (41)
                                                                                                                                    +- ShuffleQueryStage (40), Statistics(sizeInBytes=24.0 B, rowCount=1)
                                                                                                                                       +- Exchange (39)
                                                                                                                                          +- * Project (38)
                                                                                                                                             +- Scan csv  (37)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (140)
   +- WriteFiles (139)
      +- Project (138)
         +- Sort (137)
            +- Exchange (136)
               +- Window (135)
                  +- Sort (134)
                     +- Exchange (133)
                        +- HashAggregate (132)
                           +- Exchange (131)
                              +- HashAggregate (130)
                                 +- Project (129)
                                    +- Sort (128)
                                       +- Exchange (127)
                                          +- Project (126)
                                             +- Project (125)
                                                +- Filter (124)
                                                   +- Window (123)
                                                      +- Sort (122)
                                                         +- Exchange (121)
                                                            +- Project (120)
                                                               +- Project (119)
                                                                  +- Project (118)
                                                                     +- Project (117)
                                                                        +- Project (116)
                                                                           +- SortMergeJoin LeftOuter (115)
                                                                              :- Sort (98)
                                                                              :  +- Exchange (97)
                                                                              :     +- Project (96)
                                                                              :        +- Project (95)
                                                                              :           +- Project (94)
                                                                              :              +- Project (93)
                                                                              :                 +- Project (92)
                                                                              :                    +- Window (91)
                                                                              :                       +- Project (90)
                                                                              :                          +- Filter (89)
                                                                              :                             +- Window (88)
                                                                              :                                +- Sort (87)
                                                                              :                                   +- Exchange (86)
                                                                              :                                      +- Project (85)
                                                                              :                                         +- Scan csv  (1)
                                                                              +- Sort (114)
                                                                                 +- Exchange (113)
                                                                                    +- Project (112)
                                                                                       +- SortMergeJoin Cross (111)
                                                                                          :- Sort (107)
                                                                                          :  +- Exchange (106)
                                                                                          :     +- Union (105)
                                                                                          :        :- Project (100)
                                                                                          :        :  +- Filter (99)
                                                                                          :        :     +- Scan parquet  (20)
                                                                                          :        :- Project (102)
                                                                                          :        :  +- Filter (101)
                                                                                          :        :     +- Scan parquet  (24)
                                                                                          :        +- Project (104)
                                                                                          :           +- Filter (103)
                                                                                          :              +- Scan parquet  (28)
                                                                                          +- Sort (110)
                                                                                             +- Exchange (109)
                                                                                                +- Project (108)
                                                                                                   +- Scan csv  (37)


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

(2) Project [codegen id : 1]
Output [2]: [_c0#293889 AS COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, str_extract(_c0#293889, LEFT, 1) AS COL_D510A167_ACB1_4527_BFB8_45608936317D#293920]
Input [1]: [_c0#293889]

(3) Exchange
Input [2]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=36092]

(4) ShuffleQueryStage
Output [2]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920]
Arguments: 0

(5) AQEShuffleRead
Input [2]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920]
Arguments: coalesced

(6) Sort [codegen id : 9]
Input [2]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(7) Window
Input [2]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930], [1], [1 DESC NULLS LAST]

(8) Filter [codegen id : 10]
Input [3]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930]
Condition : (((COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930 <=> 1) AND (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A)) OR (COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930 > 1))

(9) Project [codegen id : 10]
Output [4]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_join(array(str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_complete(bigint_to_str(COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930), 0, 5, LEFT), ), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 40, 9), )), -), null) AS COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#294019]
Input [3]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930]

(10) Window
Input [4]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#294019]
Arguments: [last(COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#294019, true) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044], [1], [1 DESC NULLS LAST]

(11) Project [codegen id : 11]
Output [6]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 100, 7), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 94, 7), )) AS COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#294191, str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 78, 5), ) AS COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205]
Input [5]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#294019, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044]

(12) Project [codegen id : 11]
Output [9]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, str_to_dec(str_join(array(str_extract(COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#294191, LEFT, 5), str_extract(COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#294191, RIGHT, 2)), .), ##.##) AS COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, str_to_datez(str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B)), str_join(array(str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 70, 2), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 72, 2), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 74, 4)), /), ), dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, str_to_integer(str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 83, 3), )) AS COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 86, 6), ) AS COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#294271]
Input [6]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#294191, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205]

(13) Project [codegen id : 11]
Output [12]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, str_to_dec(str_join(array(str_extract(COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#294271, LEFT, 4), str_extract(COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#294271, RIGHT, 2)), .), ##.##) AS COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#294290, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 107, 8), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 101, 8), )) AS COL_E5077910_2063_4267_B69B_497F468B05F5#294310, str_to_integer(str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 115, 3), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 109, 3), ))) AS COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#294331, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 118, 8), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 112, 8), )) AS COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#294353]
Input [9]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#294271]

(14) Project [codegen id : 11]
Output [16]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#294290, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#294331, str_to_dec(str_join(array(str_extract(COL_E5077910_2063_4267_B69B_497F468B05F5#294310, LEFT, 6), str_extract(COL_E5077910_2063_4267_B69B_497F468B05F5#294310, RIGHT, 2)), .), ##.##) AS COL_E29ED133_4552_4D50_8A38_D30257A626BD#294400, str_to_dec(str_join(array(str_extract(COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#294353, LEFT, 6), str_extract(COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#294353, RIGHT, 2)), .), ##.##) AS COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#294425, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 106, 8), ) AS COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#294478, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 114, 8), ) AS COL_9339888E_B0C5_4327_8233_5581882E58E1#294506, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 130, 8), ) AS COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#294535, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 122, 8), ) AS COL_B244443E_C845_4CB1_B850_D141FCA24A95#294565]
Input [12]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#294290, COL_E5077910_2063_4267_B69B_497F468B05F5#294310, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#294331, COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#294353]

(15) Project [codegen id : 11]
Output [16]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916 AS COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930 AS COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 AS COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044 AS COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220 AS COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#299372, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236 AS COL_2145E350_E453_4696_8BD8_11A2154405D8#299373, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253 AS COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#294290 AS COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#294331 AS COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_E29ED133_4552_4D50_8A38_D30257A626BD#294400 AS COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#294425 AS COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, str_remove_space(str_remove_space(COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, LEFT), RIGHT) AS COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, str_to_dec(str_join(array(str_extract(COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#294478, LEFT, 6), str_extract(COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#294478, RIGHT, 2)), .), ##.##) AS COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, str_to_dec(str_join(array(str_extract(COL_9339888E_B0C5_4327_8233_5581882E58E1#294506, LEFT, 6), str_extract(COL_9339888E_B0C5_4327_8233_5581882E58E1#294506, RIGHT, 2)), .), ##.##) AS COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, str_to_dec(str_join(array(str_extract(COL_B244443E_C845_4CB1_B850_D141FCA24A95#294565, LEFT, 6), str_extract(COL_B244443E_C845_4CB1_B850_D141FCA24A95#294565, RIGHT, 2)), .), ##.##) AS COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, str_to_dec(str_join(array(str_extract(COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#294535, LEFT, 6), str_extract(COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#294535, RIGHT, 2)), .), ##.##) AS COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Input [16]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#294290, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#294331, COL_E29ED133_4552_4D50_8A38_D30257A626BD#294400, COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#294425, COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#294478, COL_9339888E_B0C5_4327_8233_5581882E58E1#294506, COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#294535, COL_B244443E_C845_4CB1_B850_D141FCA24A95#294565]

(16) Exchange
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#299372, COL_2145E350_E453_4696_8BD8_11A2154405D8#299373, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: hashpartitioning(COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, 10), ENSURE_REQUIREMENTS, [plan_id=36953]

(17) ShuffleQueryStage
Output [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#299372, COL_2145E350_E453_4696_8BD8_11A2154405D8#299373, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: 4

(18) AQEShuffleRead
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#299372, COL_2145E350_E453_4696_8BD8_11A2154405D8#299373, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: coalesced

(19) Sort [codegen id : 12]
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#299372, COL_2145E350_E453_4696_8BD8_11A2154405D8#299373, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: [COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727 ASC NULLS FIRST], false, 0

(20) Scan parquet 
Output [5]: [Code+Acte#297960, Montant#297961, Date_effet#297963, Date_r%C3%A9vocation#297964, Trigramme#297965]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/TARIF_FORFAIT_S_345912_c83de576dabb2053677f6f2d3b02af00/Region-PUBGUAMAR_tarifs_forfait_urgences.xlsx_85f22dff319ee322430e45d310a9df93]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>

(21) ColumnarToRow [codegen id : 2]
Input [5]: [Code+Acte#297960, Montant#297961, Date_effet#297963, Date_r%C3%A9vocation#297964, Trigramme#297965]

(22) Filter [codegen id : 2]
Input [5]: [Code+Acte#297960, Montant#297961, Date_effet#297963, Date_r%C3%A9vocation#297964, Trigramme#297965]
Condition : ((isnotnull(Code+Acte#297960) AND isnotnull(str_to_datez(Date_effet#297963, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#297964, dd/MM/yyyy, Europe/Paris, fr_FR)))

(23) Project [codegen id : 2]
Output [5]: [Code+Acte#297960 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, Montant#297961 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, Date_effet#297963 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, Date_r%C3%A9vocation#297964 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, Trigramme#297965 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815]
Input [5]: [Code+Acte#297960, Montant#297961, Date_effet#297963, Date_r%C3%A9vocation#297964, Trigramme#297965]

(24) Scan parquet 
Output [5]: [Code+Acte#298085, Montant#298086, Date_effet#298088, Date_r%C3%A9vocation#298089, Trigramme#298090]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/TARIF_FORFAIT_S_345912_c7850cbb93f1df57b61dff47a33ec038/Region-PUBGUYRE_tarifs_forfait_urgences.xlsx_f96df517dfde9c276767d274aaba55da]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>

(25) ColumnarToRow [codegen id : 3]
Input [5]: [Code+Acte#298085, Montant#298086, Date_effet#298088, Date_r%C3%A9vocation#298089, Trigramme#298090]

(26) Filter [codegen id : 3]
Input [5]: [Code+Acte#298085, Montant#298086, Date_effet#298088, Date_r%C3%A9vocation#298089, Trigramme#298090]
Condition : ((isnotnull(Code+Acte#298085) AND isnotnull(str_to_datez(Date_effet#298088, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#298089, dd/MM/yyyy, Europe/Paris, fr_FR)))

(27) Project [codegen id : 3]
Output [5]: [Code+Acte#298085 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#311667, Montant#298086 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#311668, Date_effet#298088 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#311669, Date_r%C3%A9vocation#298089 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#311670, Trigramme#298090 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#311671]
Input [5]: [Code+Acte#298085, Montant#298086, Date_effet#298088, Date_r%C3%A9vocation#298089, Trigramme#298090]

(28) Scan parquet 
Output [5]: [Code+Acte#298274, Montant#298275, Date_effet#298277, Date_r%C3%A9vocation#298278, Trigramme#298279]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/TARIF_FORFAIT_S_345912_752dbd862f975945a413933c1d0bdf6f/Region-PUBMET_tarifs_forfait_urgences.xlsx_7777e9de5fd4557c3d159f9ded396b77]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>

(29) ColumnarToRow [codegen id : 4]
Input [5]: [Code+Acte#298274, Montant#298275, Date_effet#298277, Date_r%C3%A9vocation#298278, Trigramme#298279]

(30) Filter [codegen id : 4]
Input [5]: [Code+Acte#298274, Montant#298275, Date_effet#298277, Date_r%C3%A9vocation#298278, Trigramme#298279]
Condition : ((isnotnull(Code+Acte#298274) AND isnotnull(str_to_datez(Date_effet#298277, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#298278, dd/MM/yyyy, Europe/Paris, fr_FR)))

(31) Project [codegen id : 4]
Output [5]: [Code+Acte#298274 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#311672, Montant#298275 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#311673, Date_effet#298277 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#311674, Date_r%C3%A9vocation#298278 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#311675, Trigramme#298279 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#311676]
Input [5]: [Code+Acte#298274, Montant#298275, Date_effet#298277, Date_r%C3%A9vocation#298278, Trigramme#298279]

(32) Union

(33) Exchange
Input [5]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815]
Arguments: hashpartitioning(coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815, ), isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815), 10), ENSURE_REQUIREMENTS, [plan_id=36138]

(34) ShuffleQueryStage
Output [5]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815]
Arguments: 1

(35) AQEShuffleRead
Input [5]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815]
Arguments: coalesced

(36) Sort [codegen id : 6]
Input [5]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815]
Arguments: [coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815, ) ASC NULLS FIRST, isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815) ASC NULLS FIRST], false, 0

(37) Scan csv 
Output [1]: [region-tarif#298745]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/INFOETAB_DATAAP_345911/current/info_dataapps.csv]
ReadSchema: struct<region-tarif:string>

(38) Project [codegen id : 5]
Output [1]: [region-tarif#298745 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#298937]
Input [1]: [region-tarif#298745]

(39) Exchange
Input [1]: [INFO_DATAAPPS_345943_REGION_TARIF_345945#298937]
Arguments: hashpartitioning(coalesce(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937, ), isnull(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937), 10), ENSURE_REQUIREMENTS, [plan_id=36168]

(40) ShuffleQueryStage
Output [1]: [INFO_DATAAPPS_345943_REGION_TARIF_345945#298937]
Arguments: 2

(41) AQEShuffleRead
Input [1]: [INFO_DATAAPPS_345943_REGION_TARIF_345945#298937]
Arguments: coalesced

(42) Sort [codegen id : 7]
Input [1]: [INFO_DATAAPPS_345943_REGION_TARIF_345945#298937]
Arguments: [coalesce(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937, ) ASC NULLS FIRST, isnull(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937) ASC NULLS FIRST], false, 0

(43) SortMergeJoin [codegen id : 8]
Left keys [2]: [coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815, ), isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815)]
Right keys [2]: [coalesce(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937, ), isnull(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937)]
Join type: Cross
Join condition: None

(44) Project [codegen id : 8]
Output [4]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810 AS TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, str_to_dec(str_replace(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, ., ,), ##,##) AS TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906, str_to_datez(COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, dd/MM/yyyy, Europe/Paris, fr_FR) AS TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907, str_to_datez(COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, dd/MM/yyyy, Europe/Paris, fr_FR) AS TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908]
Input [6]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815, INFO_DATAAPPS_345943_REGION_TARIF_345945#298937]

(45) Exchange
Input [4]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908]
Arguments: hashpartitioning(TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, 10), ENSURE_REQUIREMENTS, [plan_id=36677]

(46) ShuffleQueryStage
Output [4]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908]
Arguments: 3

(47) AQEShuffleRead
Input [4]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908]
Arguments: coalesced

(48) Sort [codegen id : 13]
Input [4]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908]
Arguments: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905 ASC NULLS FIRST], false, 0

(49) SortMergeJoin [codegen id : 14]
Left keys [1]: [COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727]
Right keys [1]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905]
Join type: LeftOuter
Join condition: ((COL_2145E350_E453_4696_8BD8_11A2154405D8#299373 >= TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907) AND (COL_2145E350_E453_4696_8BD8_11A2154405D8#299373 <= TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908))

(50) Project [codegen id : 14]
Output [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906 AS COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, dec_if_with_rule((str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, LEFT, 1) <=> C), dec_operator(DIFFERENCE, array(TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#299372)), 0.0) AS COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231]
Input [20]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#299372, COL_2145E350_E453_4696_8BD8_11A2154405D8#299373, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908]

(51) Project [codegen id : 14]
Output [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, dec_if_with_rule((NOT (COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231 <=> 0.0) AND isnotnull(COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231)), 1.0, 0.0) AS COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231]

(52) Project [codegen id : 14]
Output [18]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, dec_if_with_rule((COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0), dec_operator(PRODUIT, array(COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079)), null) AS COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204]
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]

(53) Project [codegen id : 14]
Output [19]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204, dec_if_with_rule((COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0), dec_operator(PRODUIT, array(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(cast(COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378 as double), 100.0)), COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204)), cast(COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374 as double))), null) AS COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954, dec_if_with_rule((COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0), dec_operator(PRODUIT, array(dec_operator(PRODUIT, array(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376)), cast(COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374 as double))), null) AS COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#301955, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204), ., RIGHT), 0, 2, RIGHT))) AS COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#302087]
Input [18]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204]

(54) Project [codegen id : 14]
Output [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, str_if_with_rule(((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> C) AND (COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0)), str_concat(array(str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, LEFT, 93), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079), ., RIGHT), 0, 2, RIGHT))), COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#302087, str_complete(int_to_str(COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378), 0, 3, LEFT), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#301955), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#301955), ., RIGHT), 0, 2, RIGHT))), str_extract_by_index(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, 127, 1000))), str_if_with_rule(((COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0) AND (COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> B)), , COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363)) AS COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> C), dec_operator(DIFFERENCE, array(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382)), null) AS COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> C), dec_operator(DIFFERENCE, array(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383)), null) AS COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> B), dec_operator(DIFFERENCE, array(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382)), null) AS COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> B), dec_operator(DIFFERENCE, array(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383)), null) AS COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Input [19]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204, COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954, COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#301955, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#302087]

(55) Exchange
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: hashpartitioning(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 10), ENSURE_REQUIREMENTS, [plan_id=37414]

(56) ShuffleQueryStage
Output [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: 5

(57) AQEShuffleRead
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: coalesced

(58) Sort [codegen id : 15]
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: [COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(59) Window
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: [sum(COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487, sum(COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762, sum(COL_1E060572_AE15_4178_913A_C47144F27CFB#305267) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398, sum(COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834, max(COL_4B158112_2BA5_45AF_B876_25385319D312#301140) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340], [COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369], [1 DESC NULLS LAST]

(60) Filter [codegen id : 16]
Input [22]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487, COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762, COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398, COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340]
Condition : (COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0)

(61) Project [codegen id : 16]
Output [12]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A), dec_operator(SOMME, array(COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, CASE WHEN isnull(COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487) THEN 0.0 ELSE CASE WHEN isnan(COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487) THEN 0.0 ELSE COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487 END END)), null), 2) AS COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#309085, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A), dec_operator(SOMME, array(COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, CASE WHEN isnull(COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762) THEN 0.0 ELSE CASE WHEN isnan(COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762) THEN 0.0 ELSE COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762 END END)), null), 2) AS COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#309086, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A), dec_operator(SOMME, array(COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, CASE WHEN isnull(COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398) THEN 0.0 ELSE CASE WHEN isnan(COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398) THEN 0.0 ELSE COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398 END END)), null), 2) AS COL_954A8446_59EE_42A6_874E_5D947C05002E#309087, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A), dec_operator(SOMME, array(COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, CASE WHEN isnull(COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834) THEN 0.0 ELSE CASE WHEN isnan(COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834) THEN 0.0 ELSE COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834 END END)), null), 2) AS COL_B8447468_D81F_445D_91DE_8654426D3D23#309088, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340]
Input [22]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487, COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762, COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398, COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340]

(62) Project [codegen id : 16]
Output [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, str_if_with_rule(((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A) AND (COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340 <=> 1.0)), str_concat(array(str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, LEFT, 105), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_954A8446_59EE_42A6_874E_5D947C05002E#309087), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_954A8446_59EE_42A6_874E_5D947C05002E#309087), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_B8447468_D81F_445D_91DE_8654426D3D23#309088), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_B8447468_D81F_445D_91DE_8654426D3D23#309088), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#309085), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#309085), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#309086), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#309086), ., RIGHT), 0, 2, RIGHT))), str_extract_middle(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, 138, 1000))), COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941) AS COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026]
Input [12]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#309085, COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#309086, COL_954A8446_59EE_42A6_874E_5D947C05002E#309087, COL_B8447468_D81F_445D_91DE_8654426D3D23#309088, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340]

(63) Exchange
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026]
Arguments: rangepartitioning(COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=37666]

(64) ShuffleQueryStage
Output [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026]
Arguments: 6

(65) AQEShuffleRead
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026]
Arguments: coalesced

(66) Sort [codegen id : 17]
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026]
Arguments: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364 ASC NULLS FIRST], true, 0

(67) Project [codegen id : 17]
Output [4]: [COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727 AS COL_A67131E4_E549_4206_9029_E6591A70C578#311246, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079 AS COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231 AS COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026, C)) THEN false ELSE StartsWith(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026, C) END, str_concat(array(str_extract_middle(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026, 74, 4), -, str_extract_middle(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026, 72, 2))), ) AS COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313]
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026]

(68) HashAggregate [codegen id : 17]
Input [4]: [COL_A67131E4_E549_4206_9029_E6591A70C578#311246, COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248, COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249, COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313]
Keys [2]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246]
Functions [3]: [partial_sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249), partial_sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248), partial_count(1)]
Aggregate Attributes [3]: [sum#311677, sum#311678, count#311467L]
Results [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246, sum#311679, sum#311680, count#311470L]

(69) Exchange
Input [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246, sum#311679, sum#311680, count#311470L]
Arguments: hashpartitioning(COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246, 10), ENSURE_REQUIREMENTS, [plan_id=37764]

(70) ShuffleQueryStage
Output [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246, sum#311679, sum#311680, count#311470L]
Arguments: 7

(71) AQEShuffleRead
Input [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246, sum#311679, sum#311680, count#311470L]
Arguments: coalesced

(72) HashAggregate [codegen id : 18]
Input [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246, sum#311679, sum#311680, count#311470L]
Keys [2]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246]
Functions [3]: [sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249), sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248), count(1)]
Aggregate Attributes [3]: [sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249)#311340, sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248)#311342, count(1)#311344L]
Results [5]: [COL_A67131E4_E549_4206_9029_E6591A70C578#311246 AS COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313 AS COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249)#311340 AS COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248)#311342 AS COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, count(1)#311344L AS COL_8246091B_F617_46DA_B417_C911085B619C#311373L]

(73) Exchange
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=37826]

(74) ShuffleQueryStage
Output [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L]
Arguments: 8

(75) AQEShuffleRead
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L]
Arguments: coalesced

(76) Sort [codegen id : 19]
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L]
Arguments: [1 ASC NULLS FIRST, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS LAST], false, 0

(77) Window
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L]
Arguments: [sum(COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372) windowspecdefinition(1, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, sum(COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371) windowspecdefinition(1, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410], [1], [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS LAST]

(78) Exchange
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410]
Arguments: rangepartitioning(COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS FIRST, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=37879]

(79) ShuffleQueryStage
Output [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410]
Arguments: 9

(80) AQEShuffleRead
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410]
Arguments: coalesced

(81) Sort [codegen id : 20]
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410]
Arguments: [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS FIRST, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369 ASC NULLS FIRST], true, 0

(82) Project [codegen id : 20]
Output [7]: [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, round(COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, 2) AS COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311428, round(COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, 2) AS COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311429, COL_8246091B_F617_46DA_B417_C911085B619C#311373L, round(COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, 2) AS COL_BABB3A33_596C_4623_AA68_D934A17418FB#311431, round(COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410, 2) AS COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311432]
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410]

(83) WriteFiles
Input [7]: [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311428, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311429, COL_8246091B_F617_46DA_B417_C911085B619C#311373L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#311431, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311432]

(84) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/2815e2ed_15be_476b_9991_43f228019b59, false, Parquet, [path=file:///data/output/cache/parquet/datablock/2815e2ed_15be_476b_9991_43f228019b59], Overwrite, [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0, COL_8246091B_F617_46DA_B417_C911085B619C, COL_BABB3A33_596C_4623_AA68_D934A17418FB, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F]

(85) Project
Output [2]: [_c0#293889 AS COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, str_extract(_c0#293889, LEFT, 1) AS COL_D510A167_ACB1_4527_BFB8_45608936317D#293920]
Input [1]: [_c0#293889]

(86) Exchange
Input [2]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=35925]

(87) Sort
Input [2]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(88) Window
Input [2]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930], [1], [1 DESC NULLS LAST]

(89) Filter
Input [3]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930]
Condition : (((COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930 <=> 1) AND (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A)) OR (COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930 > 1))

(90) Project
Output [4]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_join(array(str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_complete(bigint_to_str(COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930), 0, 5, LEFT), ), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 40, 9), )), -), null) AS COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#294019]
Input [3]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930]

(91) Window
Input [4]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#294019]
Arguments: [last(COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#294019, true) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044], [1], [1 DESC NULLS LAST]

(92) Project
Output [6]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 100, 7), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 94, 7), )) AS COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#294191, str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 78, 5), ) AS COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205]
Input [5]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#294019, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044]

(93) Project
Output [9]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, str_to_dec(str_join(array(str_extract(COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#294191, LEFT, 5), str_extract(COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#294191, RIGHT, 2)), .), ##.##) AS COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, str_to_datez(str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B)), str_join(array(str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 70, 2), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 72, 2), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 74, 4)), /), ), dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, str_to_integer(str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 83, 3), )) AS COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 86, 6), ) AS COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#294271]
Input [6]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#294191, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205]

(94) Project
Output [12]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, str_to_dec(str_join(array(str_extract(COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#294271, LEFT, 4), str_extract(COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#294271, RIGHT, 2)), .), ##.##) AS COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#294290, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 107, 8), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 101, 8), )) AS COL_E5077910_2063_4267_B69B_497F468B05F5#294310, str_to_integer(str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 115, 3), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 109, 3), ))) AS COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#294331, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 118, 8), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 112, 8), )) AS COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#294353]
Input [9]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#294271]

(95) Project
Output [16]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#294290, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#294331, str_to_dec(str_join(array(str_extract(COL_E5077910_2063_4267_B69B_497F468B05F5#294310, LEFT, 6), str_extract(COL_E5077910_2063_4267_B69B_497F468B05F5#294310, RIGHT, 2)), .), ##.##) AS COL_E29ED133_4552_4D50_8A38_D30257A626BD#294400, str_to_dec(str_join(array(str_extract(COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#294353, LEFT, 6), str_extract(COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#294353, RIGHT, 2)), .), ##.##) AS COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#294425, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 106, 8), ) AS COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#294478, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 114, 8), ) AS COL_9339888E_B0C5_4327_8233_5581882E58E1#294506, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 130, 8), ) AS COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#294535, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, 122, 8), ) AS COL_B244443E_C845_4CB1_B850_D141FCA24A95#294565]
Input [12]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#294290, COL_E5077910_2063_4267_B69B_497F468B05F5#294310, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#294331, COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#294353]

(96) Project
Output [16]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916 AS COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930 AS COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920 AS COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044 AS COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220 AS COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#299372, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236 AS COL_2145E350_E453_4696_8BD8_11A2154405D8#299373, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253 AS COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#294290 AS COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#294331 AS COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_E29ED133_4552_4D50_8A38_D30257A626BD#294400 AS COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#294425 AS COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, str_remove_space(str_remove_space(COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, LEFT), RIGHT) AS COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, str_to_dec(str_join(array(str_extract(COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#294478, LEFT, 6), str_extract(COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#294478, RIGHT, 2)), .), ##.##) AS COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, str_to_dec(str_join(array(str_extract(COL_9339888E_B0C5_4327_8233_5581882E58E1#294506, LEFT, 6), str_extract(COL_9339888E_B0C5_4327_8233_5581882E58E1#294506, RIGHT, 2)), .), ##.##) AS COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, str_to_dec(str_join(array(str_extract(COL_B244443E_C845_4CB1_B850_D141FCA24A95#294565, LEFT, 6), str_extract(COL_B244443E_C845_4CB1_B850_D141FCA24A95#294565, RIGHT, 2)), .), ##.##) AS COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, str_to_dec(str_join(array(str_extract(COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#294535, LEFT, 6), str_extract(COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#294535, RIGHT, 2)), .), ##.##) AS COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Input [16]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#293916, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#293930, COL_D510A167_ACB1_4527_BFB8_45608936317D#293920, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#294044, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#294205, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#294220, COL_E310E7E8_72D1_427D_893E_9CB96908C503#294236, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#294253, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#294290, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#294331, COL_E29ED133_4552_4D50_8A38_D30257A626BD#294400, COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#294425, COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#294478, COL_9339888E_B0C5_4327_8233_5581882E58E1#294506, COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#294535, COL_B244443E_C845_4CB1_B850_D141FCA24A95#294565]

(97) Exchange
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#299372, COL_2145E350_E453_4696_8BD8_11A2154405D8#299373, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: hashpartitioning(COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, 10), ENSURE_REQUIREMENTS, [plan_id=35949]

(98) Sort
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#299372, COL_2145E350_E453_4696_8BD8_11A2154405D8#299373, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: [COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727 ASC NULLS FIRST], false, 0

(99) Filter
Input [5]: [Code+Acte#297960, Montant#297961, Date_effet#297963, Date_r%C3%A9vocation#297964, Trigramme#297965]
Condition : ((isnotnull(Code+Acte#297960) AND isnotnull(str_to_datez(Date_effet#297963, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#297964, dd/MM/yyyy, Europe/Paris, fr_FR)))

(100) Project
Output [5]: [Code+Acte#297960 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, Montant#297961 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, Date_effet#297963 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, Date_r%C3%A9vocation#297964 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, Trigramme#297965 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815]
Input [5]: [Code+Acte#297960, Montant#297961, Date_effet#297963, Date_r%C3%A9vocation#297964, Trigramme#297965]

(101) Filter
Input [5]: [Code+Acte#298085, Montant#298086, Date_effet#298088, Date_r%C3%A9vocation#298089, Trigramme#298090]
Condition : ((isnotnull(Code+Acte#298085) AND isnotnull(str_to_datez(Date_effet#298088, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#298089, dd/MM/yyyy, Europe/Paris, fr_FR)))

(102) Project
Output [5]: [Code+Acte#298085 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#311667, Montant#298086 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#311668, Date_effet#298088 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#311669, Date_r%C3%A9vocation#298089 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#311670, Trigramme#298090 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#311671]
Input [5]: [Code+Acte#298085, Montant#298086, Date_effet#298088, Date_r%C3%A9vocation#298089, Trigramme#298090]

(103) Filter
Input [5]: [Code+Acte#298274, Montant#298275, Date_effet#298277, Date_r%C3%A9vocation#298278, Trigramme#298279]
Condition : ((isnotnull(Code+Acte#298274) AND isnotnull(str_to_datez(Date_effet#298277, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#298278, dd/MM/yyyy, Europe/Paris, fr_FR)))

(104) Project
Output [5]: [Code+Acte#298274 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#311672, Montant#298275 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#311673, Date_effet#298277 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#311674, Date_r%C3%A9vocation#298278 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#311675, Trigramme#298279 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#311676]
Input [5]: [Code+Acte#298274, Montant#298275, Date_effet#298277, Date_r%C3%A9vocation#298278, Trigramme#298279]

(105) Union

(106) Exchange
Input [5]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815]
Arguments: hashpartitioning(coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815, ), isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815), 10), ENSURE_REQUIREMENTS, [plan_id=35939]

(107) Sort
Input [5]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815]
Arguments: [coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815, ) ASC NULLS FIRST, isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815) ASC NULLS FIRST], false, 0

(108) Project
Output [1]: [region-tarif#298745 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#298937]
Input [1]: [region-tarif#298745]

(109) Exchange
Input [1]: [INFO_DATAAPPS_345943_REGION_TARIF_345945#298937]
Arguments: hashpartitioning(coalesce(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937, ), isnull(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937), 10), ENSURE_REQUIREMENTS, [plan_id=35940]

(110) Sort
Input [1]: [INFO_DATAAPPS_345943_REGION_TARIF_345945#298937]
Arguments: [coalesce(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937, ) ASC NULLS FIRST, isnull(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937) ASC NULLS FIRST], false, 0

(111) SortMergeJoin
Left keys [2]: [coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815, ), isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815)]
Right keys [2]: [coalesce(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937, ), isnull(INFO_DATAAPPS_345943_REGION_TARIF_345945#298937)]
Join type: Cross
Join condition: None

(112) Project
Output [4]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810 AS TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, str_to_dec(str_replace(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, ., ,), ##,##) AS TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906, str_to_datez(COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, dd/MM/yyyy, Europe/Paris, fr_FR) AS TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907, str_to_datez(COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, dd/MM/yyyy, Europe/Paris, fr_FR) AS TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908]
Input [6]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815, INFO_DATAAPPS_345943_REGION_TARIF_345945#298937]

(113) Exchange
Input [4]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908]
Arguments: hashpartitioning(TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, 10), ENSURE_REQUIREMENTS, [plan_id=35950]

(114) Sort
Input [4]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908]
Arguments: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905 ASC NULLS FIRST], false, 0

(115) SortMergeJoin
Left keys [1]: [COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727]
Right keys [1]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905]
Join type: LeftOuter
Join condition: ((COL_2145E350_E453_4696_8BD8_11A2154405D8#299373 >= TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907) AND (COL_2145E350_E453_4696_8BD8_11A2154405D8#299373 <= TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908))

(116) Project
Output [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906 AS COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, dec_if_with_rule((str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, LEFT, 1) <=> C), dec_operator(DIFFERENCE, array(TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#299372)), 0.0) AS COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231]
Input [20]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#299372, COL_2145E350_E453_4696_8BD8_11A2154405D8#299373, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299905, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299906, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299907, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299908]

(117) Project
Output [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, dec_if_with_rule((NOT (COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231 <=> 0.0) AND isnotnull(COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231)), 1.0, 0.0) AS COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231]

(118) Project
Output [18]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, dec_if_with_rule((COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0), dec_operator(PRODUIT, array(COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079)), null) AS COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204]
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]

(119) Project
Output [19]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204, dec_if_with_rule((COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0), dec_operator(PRODUIT, array(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(cast(COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378 as double), 100.0)), COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204)), cast(COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374 as double))), null) AS COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954, dec_if_with_rule((COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0), dec_operator(PRODUIT, array(dec_operator(PRODUIT, array(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376)), cast(COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374 as double))), null) AS COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#301955, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204), ., RIGHT), 0, 2, RIGHT))) AS COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#302087]
Input [18]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#299374, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#299376, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204]

(120) Project
Output [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, str_if_with_rule(((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> C) AND (COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0)), str_concat(array(str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, LEFT, 93), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079), ., RIGHT), 0, 2, RIGHT))), COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#302087, str_complete(int_to_str(COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378), 0, 3, LEFT), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#301955), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#301955), ., RIGHT), 0, 2, RIGHT))), str_extract_by_index(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, 127, 1000))), str_if_with_rule(((COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0) AND (COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> B)), , COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363)) AS COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> C), dec_operator(DIFFERENCE, array(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382)), null) AS COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> C), dec_operator(DIFFERENCE, array(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383)), null) AS COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> B), dec_operator(DIFFERENCE, array(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382)), null) AS COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> B), dec_operator(DIFFERENCE, array(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383)), null) AS COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Input [19]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#299378, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#299382, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#299383, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_8E8952B0_AECB_44EF_8977_36AD703337F9#301204, COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#301954, COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#301955, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#302087]

(121) Exchange
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: hashpartitioning(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 10), ENSURE_REQUIREMENTS, [plan_id=35960]

(122) Sort
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: [COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(123) Window
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398]
Arguments: [sum(COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487, sum(COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762, sum(COL_1E060572_AE15_4178_913A_C47144F27CFB#305267) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398, sum(COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834, max(COL_4B158112_2BA5_45AF_B876_25385319D312#301140) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340], [COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369], [1 DESC NULLS LAST]

(124) Filter
Input [22]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487, COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762, COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398, COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340]
Condition : (COL_4B158112_2BA5_45AF_B876_25385319D312#301140 <=> 1.0)

(125) Project
Output [12]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A), dec_operator(SOMME, array(COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, CASE WHEN isnull(COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487) THEN 0.0 ELSE CASE WHEN isnan(COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487) THEN 0.0 ELSE COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487 END END)), null), 2) AS COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#309085, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A), dec_operator(SOMME, array(COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, CASE WHEN isnull(COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762) THEN 0.0 ELSE CASE WHEN isnan(COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762) THEN 0.0 ELSE COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762 END END)), null), 2) AS COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#309086, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A), dec_operator(SOMME, array(COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, CASE WHEN isnull(COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398) THEN 0.0 ELSE CASE WHEN isnan(COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398) THEN 0.0 ELSE COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398 END END)), null), 2) AS COL_954A8446_59EE_42A6_874E_5D947C05002E#309087, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A), dec_operator(SOMME, array(COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, CASE WHEN isnull(COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834) THEN 0.0 ELSE CASE WHEN isnan(COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834) THEN 0.0 ELSE COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834 END END)), null), 2) AS COL_B8447468_D81F_445D_91DE_8654426D3D23#309088, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340]
Input [22]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_C8938273_938E_4A53_B14D_894C621AAAC0#299369, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_4B158112_2BA5_45AF_B876_25385319D312#301140, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#305264, COL_592CA39A_83B9_4E3C_832D_EF1248106693#305265, COL_1E060572_AE15_4178_913A_C47144F27CFB#305267, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#305268, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#299395, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#299396, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#299397, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#299398, COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#305487, COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#305762, COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#306398, COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#306834, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340]

(126) Project
Output [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, str_if_with_rule(((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365 <=> A) AND (COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340 <=> 1.0)), str_concat(array(str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, LEFT, 105), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_954A8446_59EE_42A6_874E_5D947C05002E#309087), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_954A8446_59EE_42A6_874E_5D947C05002E#309087), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_B8447468_D81F_445D_91DE_8654426D3D23#309088), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_B8447468_D81F_445D_91DE_8654426D3D23#309088), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#309085), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#309085), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#309086), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#309086), ., RIGHT), 0, 2, RIGHT))), str_extract_middle(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, 138, 1000))), COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941) AS COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026]
Input [12]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#299363, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#299365, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#303941, COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#309085, COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#309086, COL_954A8446_59EE_42A6_874E_5D947C05002E#309087, COL_B8447468_D81F_445D_91DE_8654426D3D23#309088, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#307340]

(127) Exchange
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026]
Arguments: rangepartitioning(COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=35967]

(128) Sort
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026]
Arguments: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364 ASC NULLS FIRST], true, 0

(129) Project
Output [4]: [COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727 AS COL_A67131E4_E549_4206_9029_E6591A70C578#311246, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079 AS COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231 AS COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026, C)) THEN false ELSE StartsWith(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026, C) END, str_concat(array(str_extract_middle(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026, 74, 4), -, str_extract_middle(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026, 72, 2))), ) AS COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313]
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#299364, COL_FC392F17_9FE4_451F_B853_E9993888E87A#299727, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#300079, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#300231, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#311026]

(130) HashAggregate
Input [4]: [COL_A67131E4_E549_4206_9029_E6591A70C578#311246, COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248, COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249, COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313]
Keys [2]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246]
Functions [3]: [partial_sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249), partial_sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248), partial_count(1)]
Aggregate Attributes [3]: [sum#311677, sum#311678, count#311467L]
Results [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246, sum#311679, sum#311680, count#311470L]

(131) Exchange
Input [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246, sum#311679, sum#311680, count#311470L]
Arguments: hashpartitioning(COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246, 10), ENSURE_REQUIREMENTS, [plan_id=35972]

(132) HashAggregate
Input [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246, sum#311679, sum#311680, count#311470L]
Keys [2]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313, COL_A67131E4_E549_4206_9029_E6591A70C578#311246]
Functions [3]: [sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249), sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248), count(1)]
Aggregate Attributes [3]: [sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249)#311340, sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248)#311342, count(1)#311344L]
Results [5]: [COL_A67131E4_E549_4206_9029_E6591A70C578#311246 AS COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#311313 AS COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#311249)#311340 AS COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#311248)#311342 AS COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, count(1)#311344L AS COL_8246091B_F617_46DA_B417_C911085B619C#311373L]

(133) Exchange
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=35975]

(134) Sort
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L]
Arguments: [1 ASC NULLS FIRST, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS LAST], false, 0

(135) Window
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L]
Arguments: [sum(COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372) windowspecdefinition(1, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, sum(COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371) windowspecdefinition(1, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410], [1], [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS LAST]

(136) Exchange
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410]
Arguments: rangepartitioning(COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS FIRST, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=35979]

(137) Sort
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410]
Arguments: [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370 ASC NULLS FIRST, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369 ASC NULLS FIRST], true, 0

(138) Project
Output [7]: [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, round(COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, 2) AS COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311428, round(COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, 2) AS COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311429, COL_8246091B_F617_46DA_B417_C911085B619C#311373L, round(COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, 2) AS COL_BABB3A33_596C_4623_AA68_D934A17418FB#311431, round(COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410, 2) AS COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311432]
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311371, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311372, COL_8246091B_F617_46DA_B417_C911085B619C#311373L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#311387, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311410]

(139) WriteFiles
Input [7]: [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#311370, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#311369, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#311428, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#311429, COL_8246091B_F617_46DA_B417_C911085B619C#311373L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#311431, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#311432]

(140) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/2815e2ed_15be_476b_9991_43f228019b59, false, Parquet, [path=file:///data/output/cache/parquet/datablock/2815e2ed_15be_476b_9991_43f228019b59], Overwrite, [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0, COL_8246091B_F617_46DA_B417_C911085B619C, COL_BABB3A33_596C_4623_AA68_D934A17418FB, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F]

(141) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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