SP1 - Details for Query 1051

Submitted Time: 2026/02/24 11:05:18
Duration: 14 s
Succeeded Jobs: 1444 1445 1446 1447 1448 1449 1451 1453 1454 1455 1456 1457 1458

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: 11 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: 52 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: 2 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 2456.0: task 2718))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (19)\n \nduration: total (min, med, max (stageId: taskId))\n34 ms (8 ms, 26 ms, 26 ms (stage 2446.0: task 2717))"; 10 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2456.0: task 2718)) peak memory total (min, med, max (stageId: taskId)) 32.1 MiB (16.1 MiB, 16.1 MiB, 16.1 MiB (stage 2456.0: task 2718)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 2456.0: task 2718))"]; } 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 2456.0: task 2718)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2456.0: task 2718)) 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: 69 ms"; 18 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 11 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, 2 ms (stage 2419.0: task 2712)) 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 2419.0: task 2710)) 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 2419.0: task 2711))"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: total (min, med, max (stageId: taskId))\n616 ms (50 ms, 62 ms, 83 ms (stage 2405.0: task 2700))"; 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 2405.0: task 2702))"]; subgraph cluster28 { isCluster="true"; label="WholeStageCodegen (15)\n \nduration: total (min, med, max (stageId: taskId))\n1.3 s (95 ms, 135 ms, 157 ms (stage 2405.0: task 2700))"; 29 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 98 ms (8 ms, 9 ms, 13 ms (stage 2419.0: task 2714)) peak memory total (min, med, max (stageId: taskId)) 165.0 MiB (16.5 MiB, 16.5 MiB, 16.5 MiB (stage 2405.0: task 2702)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 2405.0: task 2702))"]; } 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)) 31 ms (6 ms, 7 ms, 17 ms (stage 2392.0: task 2694)) 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 2405.0: task 2704)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2405.0: task 2702)) 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 2392.0: task 2694)) 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 2392.0: task 2694))"]; 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.8 s (stage 2392.0: task 2694))"; 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 2392.0: task 2695))"]; } subgraph cluster39 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: total (min, med, max (stageId: taskId))\n5.5 s (1.1 s, 1.5 s, 2.9 s (stage 2392.0: task 2694))"; 40 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 31 ms (6 ms, 9 ms, 16 ms (stage 2392.0: task 2694)) peak memory total (min, med, max (stageId: taskId)) 67.5 MiB (16.5 MiB, 17.0 MiB, 34.0 MiB (stage 2392.0: task 2694)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 2392.0: task 2695))"]; } 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: 35 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 2392.0: task 2694)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2392.0: task 2695)) 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.4 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: 433 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: 122 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)) 18 ms (3 ms, 3 ms, 4 ms (stage 2379.0: task 2683)) 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 2379.0: task 2683)) 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 2379.0: task 2684))"]; subgraph cluster58 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n669 ms (70 ms, 150 ms, 152 ms (stage 2379.0: task 2685))"; 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.2 m (2.8 s, 16.1 s, 55.6 s (stage 2392.0: task 2695))"; 62 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2392.0: task 2695)) peak memory total (min, med, max (stageId: taskId)) 48.2 MiB (16.1 MiB, 16.1 MiB, 16.1 MiB (stage 2392.0: task 2695)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 2392.0: task 2695))"]; } 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 2392.0: task 2696)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2392.0: task 2695)) 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: 8 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: 12 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 2380.0: task 2689)) 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 2380.0: task 2688)) 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 2380.0: task 2688))"]; 72 [labelType="html" label=" Union "]; subgraph cluster73 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 16 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: 15 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: 10 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: 3 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: 3 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: 6 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/79cf5ab7_f28c_4ae0_990e_c998ee669496, false, Parquet, [path=file:///data/output/cache/parquet/datablock/79cf5ab7_f28c_4ae0_990e_c998ee669496], 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#355861, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, round(COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, 2) AS COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355919, round(COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, 2) AS COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355920, COL_8246091B_F617_46DA_B417_C911085B619C#355864L, round(COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, 2) AS COL_BABB3A33_596C_4623_AA68_D934A17418FB#355922, round(COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901, 2) AS COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355923]

Sort [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS FIRST, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860 ASC NULLS FIRST], true, 0

WholeStageCodegen (20)

AQEShuffleRead coalesced

Exchange rangepartitioning(COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS FIRST, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=48899]

Window [sum(COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863) windowspecdefinition(1, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, sum(COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862) windowspecdefinition(1, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901], [1], [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS LAST]

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

WholeStageCodegen (19)

AQEShuffleRead coalesced

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

HashAggregate(keys=[COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737], functions=[sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740), sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739), count(1)])

WholeStageCodegen (18)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737, 10), ENSURE_REQUIREMENTS, [plan_id=48784]

HashAggregate(keys=[COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737], functions=[partial_sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740), partial_sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739), partial_count(1)])

Project [COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047 AS COL_A67131E4_E549_4206_9029_E6591A70C578#355737, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284 AS COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377 AS COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517, C)) THEN false ELSE StartsWith(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517, C) END, str_concat(array(str_extract_middle(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517, 74, 4), -, str_extract_middle(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517, 72, 2))), ) AS COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804]

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

WholeStageCodegen (17)

AQEShuffleRead coalesced

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

Project [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, str_if_with_rule(((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A) AND (COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754 <=> 1.0)), str_concat(array(str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, LEFT, 105), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_954A8446_59EE_42A6_874E_5D947C05002E#353332), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_954A8446_59EE_42A6_874E_5D947C05002E#353332), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_B8447468_D81F_445D_91DE_8654426D3D23#353333), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_B8447468_D81F_445D_91DE_8654426D3D23#353333), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#353330), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#353330), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#353331), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#353331), ., RIGHT), 0, 2, RIGHT))), str_extract_middle(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, 138, 1000))), COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078) AS COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517]

Project [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A), dec_operator(SOMME, array(COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, CASE WHEN isnull(COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833) THEN 0.0 ELSE CASE WHEN isnan(COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833) THEN 0.0 ELSE COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833 END END)), null), 2) AS COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#353330, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A), dec_operator(SOMME, array(COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, CASE WHEN isnull(COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106) THEN 0.0 ELSE CASE WHEN isnan(COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106) THEN 0.0 ELSE COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106 END END)), null), 2) AS COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#353331, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A), dec_operator(SOMME, array(COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, CASE WHEN isnull(COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664) THEN 0.0 ELSE CASE WHEN isnan(COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664) THEN 0.0 ELSE COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664 END END)), null), 2) AS COL_954A8446_59EE_42A6_874E_5D947C05002E#353332, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A), dec_operator(SOMME, array(COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, CASE WHEN isnull(COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949) THEN 0.0 ELSE CASE WHEN isnan(COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949) THEN 0.0 ELSE COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949 END END)), null), 2) AS COL_B8447468_D81F_445D_91DE_8654426D3D23#353333, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754]

Filter (COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0)

WholeStageCodegen (16)

Window [sum(COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833, sum(COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106, sum(COL_1E060572_AE15_4178_913A_C47144F27CFB#349544) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664, sum(COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949, max(COL_4B158112_2BA5_45AF_B876_25385319D312#345445) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754], [COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579], [1 DESC NULLS LAST]

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

WholeStageCodegen (15)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 10), ENSURE_REQUIREMENTS, [plan_id=48289]

Project [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, str_if_with_rule(((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> C) AND (COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0)), str_concat(array(str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, LEFT, 93), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284), ., RIGHT), 0, 2, RIGHT))), COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#346251, str_complete(int_to_str(COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588), 0, 3, LEFT), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#346057), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#346057), ., RIGHT), 0, 2, RIGHT))), str_extract_by_index(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, 127, 1000))), str_if_with_rule(((COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0) AND (COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> B)), , COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573)) AS COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> C), dec_operator(DIFFERENCE, array(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592)), null) AS COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> C), dec_operator(DIFFERENCE, array(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593)), null) AS COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> B), dec_operator(DIFFERENCE, array(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592)), null) AS COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> B), dec_operator(DIFFERENCE, array(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593)), null) AS COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]

SortMergeJoin [COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047], [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111], LeftOuter, ((COL_2145E350_E453_4696_8BD8_11A2154405D8#343583 >= TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113) AND (COL_2145E350_E453_4696_8BD8_11A2154405D8#343583 <= TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114))

WholeStageCodegen (14)

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

WholeStageCodegen (12)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, 10), ENSURE_REQUIREMENTS, [plan_id=47973]

Project [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407 AS COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421 AS COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 AS COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535 AS COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711 AS COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#343582, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727 AS COL_2145E350_E453_4696_8BD8_11A2154405D8#343583, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744 AS COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#338781 AS COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#338822 AS COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_E29ED133_4552_4D50_8A38_D30257A626BD#338891 AS COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#338916 AS COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, str_remove_space(str_remove_space(COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, LEFT), RIGHT) AS COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, str_to_dec(str_join(array(str_extract(COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#338969, LEFT, 6), str_extract(COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#338969, RIGHT, 2)), .), ##.##) AS COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, str_to_dec(str_join(array(str_extract(COL_9339888E_B0C5_4327_8233_5581882E58E1#338997, LEFT, 6), str_extract(COL_9339888E_B0C5_4327_8233_5581882E58E1#338997, RIGHT, 2)), .), ##.##) AS COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, str_to_dec(str_join(array(str_extract(COL_B244443E_C845_4CB1_B850_D141FCA24A95#339056, LEFT, 6), str_extract(COL_B244443E_C845_4CB1_B850_D141FCA24A95#339056, RIGHT, 2)), .), ##.##) AS COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, str_to_dec(str_join(array(str_extract(COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#339026, LEFT, 6), str_extract(COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#339026, RIGHT, 2)), .), ##.##) AS COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]

Project [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#338781, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#338822, str_to_dec(str_join(array(str_extract(COL_E5077910_2063_4267_B69B_497F468B05F5#338801, LEFT, 6), str_extract(COL_E5077910_2063_4267_B69B_497F468B05F5#338801, RIGHT, 2)), .), ##.##) AS COL_E29ED133_4552_4D50_8A38_D30257A626BD#338891, str_to_dec(str_join(array(str_extract(COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#338844, LEFT, 6), str_extract(COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#338844, RIGHT, 2)), .), ##.##) AS COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#338916, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 106, 8), ) AS COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#338969, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 114, 8), ) AS COL_9339888E_B0C5_4327_8233_5581882E58E1#338997, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 130, 8), ) AS COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#339026, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 122, 8), ) AS COL_B244443E_C845_4CB1_B850_D141FCA24A95#339056]

Project [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, str_to_dec(str_join(array(str_extract(COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#338762, LEFT, 4), str_extract(COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#338762, RIGHT, 2)), .), ##.##) AS COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#338781, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 107, 8), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 101, 8), )) AS COL_E5077910_2063_4267_B69B_497F468B05F5#338801, str_to_integer(str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 115, 3), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 109, 3), ))) AS COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#338822, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 118, 8), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 112, 8), )) AS COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#338844]

Project [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, str_to_dec(str_join(array(str_extract(COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#338682, LEFT, 5), str_extract(COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#338682, RIGHT, 2)), .), ##.##) AS COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, str_to_datez(str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B)), str_join(array(str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 70, 2), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 72, 2), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 74, 4)), /), ), dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, str_to_integer(str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 83, 3), )) AS COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 86, 6), ) AS COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#338762]

Project [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 100, 7), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 94, 7), )) AS COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#338682, str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 78, 5), ) AS COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696]

WholeStageCodegen (11)

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

Project [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_join(array(str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_complete(bigint_to_str(COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421), 0, 5, LEFT), ), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 40, 9), )), -), null) AS COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#338510]

Filter (((COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421 <=> 1) AND (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A)) OR (COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421 > 1))

WholeStageCodegen (10)

Window [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421], [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=47112]

Project [_c0#338380 AS COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, str_extract(_c0#338380, LEFT, 1) AS COL_D510A167_ACB1_4527_BFB8_45608936317D#338411]

WholeStageCodegen (1)

FileScan csv [_c0#338380] 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#344111 ASC NULLS FIRST], false, 0

WholeStageCodegen (13)

AQEShuffleRead coalesced

Exchange hashpartitioning(TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, 10), ENSURE_REQUIREMENTS, [plan_id=47697]

Project [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965 AS TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, str_to_dec(str_replace(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, ., ,), ##,##) AS TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112, str_to_datez(COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, dd/MM/yyyy, Europe/Paris, fr_FR) AS TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113, str_to_datez(COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, dd/MM/yyyy, Europe/Paris, fr_FR) AS TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114]

SortMergeJoin [coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970, ), isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970)], [coalesce(INFO_DATAAPPS_345943_REGION_TARIF_345945#342980, ), isnull(INFO_DATAAPPS_345943_REGION_TARIF_345945#342980)], Cross

WholeStageCodegen (8)

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

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970, ), isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970), 10), ENSURE_REQUIREMENTS, [plan_id=47158]

Union

Project [Code+Acte#342190 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, Montant#342191 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, Date_effet#342193 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, Date_r%C3%A9vocation#342194 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, Trigramme#342195 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970]

Filter ((isnotnull(Code+Acte#342190) AND isnotnull(str_to_datez(Date_effet#342193, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#342194, dd/MM/yyyy, Europe/Paris, fr_FR)))

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [Code+Acte#342190,Montant#342191,Date_effet#342193,Date_r%C3%A9vocation#342194,Trigramme#342195] Batched: true, DataFilters: [isnotnull(Code+Acte#342190), isnotnull(str_to_datez(Date_effet#342193, 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#342469 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#356152, Montant#342470 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#356153, Date_effet#342472 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#356154, Date_r%C3%A9vocation#342473 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#356155, Trigramme#342474 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#356156]

Filter ((isnotnull(Code+Acte#342469) AND isnotnull(str_to_datez(Date_effet#342472, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#342473, dd/MM/yyyy, Europe/Paris, fr_FR)))

ColumnarToRow

WholeStageCodegen (3)

FileScan parquet [Code+Acte#342469,Montant#342470,Date_effet#342472,Date_r%C3%A9vocation#342473,Trigramme#342474] Batched: true, DataFilters: [isnotnull(Code+Acte#342469), isnotnull(str_to_datez(Date_effet#342472, 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#342654 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#356157, Montant#342655 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#356158, Date_effet#342657 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#356159, Date_r%C3%A9vocation#342658 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#356160, Trigramme#342659 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#356161]

Filter ((isnotnull(Code+Acte#342654) AND isnotnull(str_to_datez(Date_effet#342657, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#342658, dd/MM/yyyy, Europe/Paris, fr_FR)))

ColumnarToRow

WholeStageCodegen (4)

FileScan parquet [Code+Acte#342654,Montant#342655,Date_effet#342657,Date_r%C3%A9vocation#342658,Trigramme#342659] Batched: true, DataFilters: [isnotnull(Code+Acte#342654), isnotnull(str_to_datez(Date_effet#342657, 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#342980, ) ASC NULLS FIRST, isnull(INFO_DATAAPPS_345943_REGION_TARIF_345945#342980) ASC NULLS FIRST], false, 0

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(coalesce(INFO_DATAAPPS_345943_REGION_TARIF_345945#342980, ), isnull(INFO_DATAAPPS_345943_REGION_TARIF_345945#342980), 10), ENSURE_REQUIREMENTS, [plan_id=47188]

Project [region-tarif#342844 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#342980]

WholeStageCodegen (5)

FileScan csv [region-tarif#342844] 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#338380]
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#338380 AS COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, str_extract(_c0#338380, LEFT, 1) AS COL_D510A167_ACB1_4527_BFB8_45608936317D#338411]
Input [1]: [_c0#338380]

(3) Exchange
Input [2]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=47112]

(4) ShuffleQueryStage
Output [2]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411]
Arguments: 0

(5) AQEShuffleRead
Input [2]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411]
Arguments: coalesced

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

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

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

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

(10) Window
Input [4]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#338510]
Arguments: [last(COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#338510, true) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535], [1], [1 DESC NULLS LAST]

(11) Project [codegen id : 11]
Output [6]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 100, 7), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 94, 7), )) AS COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#338682, str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 78, 5), ) AS COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696]
Input [5]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#338510, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535]

(12) Project [codegen id : 11]
Output [9]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, str_to_dec(str_join(array(str_extract(COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#338682, LEFT, 5), str_extract(COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#338682, RIGHT, 2)), .), ##.##) AS COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, str_to_datez(str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B)), str_join(array(str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 70, 2), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 72, 2), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 74, 4)), /), ), dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, str_to_integer(str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 83, 3), )) AS COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 86, 6), ) AS COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#338762]
Input [6]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#338682, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696]

(13) Project [codegen id : 11]
Output [12]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, str_to_dec(str_join(array(str_extract(COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#338762, LEFT, 4), str_extract(COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#338762, RIGHT, 2)), .), ##.##) AS COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#338781, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 107, 8), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 101, 8), )) AS COL_E5077910_2063_4267_B69B_497F468B05F5#338801, str_to_integer(str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 115, 3), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 109, 3), ))) AS COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#338822, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 118, 8), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 112, 8), )) AS COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#338844]
Input [9]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#338762]

(14) Project [codegen id : 11]
Output [16]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#338781, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#338822, str_to_dec(str_join(array(str_extract(COL_E5077910_2063_4267_B69B_497F468B05F5#338801, LEFT, 6), str_extract(COL_E5077910_2063_4267_B69B_497F468B05F5#338801, RIGHT, 2)), .), ##.##) AS COL_E29ED133_4552_4D50_8A38_D30257A626BD#338891, str_to_dec(str_join(array(str_extract(COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#338844, LEFT, 6), str_extract(COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#338844, RIGHT, 2)), .), ##.##) AS COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#338916, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 106, 8), ) AS COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#338969, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 114, 8), ) AS COL_9339888E_B0C5_4327_8233_5581882E58E1#338997, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 130, 8), ) AS COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#339026, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 122, 8), ) AS COL_B244443E_C845_4CB1_B850_D141FCA24A95#339056]
Input [12]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#338781, COL_E5077910_2063_4267_B69B_497F468B05F5#338801, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#338822, COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#338844]

(15) Project [codegen id : 11]
Output [16]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407 AS COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421 AS COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 AS COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535 AS COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711 AS COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#343582, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727 AS COL_2145E350_E453_4696_8BD8_11A2154405D8#343583, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744 AS COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#338781 AS COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#338822 AS COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_E29ED133_4552_4D50_8A38_D30257A626BD#338891 AS COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#338916 AS COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, str_remove_space(str_remove_space(COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, LEFT), RIGHT) AS COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, str_to_dec(str_join(array(str_extract(COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#338969, LEFT, 6), str_extract(COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#338969, RIGHT, 2)), .), ##.##) AS COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, str_to_dec(str_join(array(str_extract(COL_9339888E_B0C5_4327_8233_5581882E58E1#338997, LEFT, 6), str_extract(COL_9339888E_B0C5_4327_8233_5581882E58E1#338997, RIGHT, 2)), .), ##.##) AS COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, str_to_dec(str_join(array(str_extract(COL_B244443E_C845_4CB1_B850_D141FCA24A95#339056, LEFT, 6), str_extract(COL_B244443E_C845_4CB1_B850_D141FCA24A95#339056, RIGHT, 2)), .), ##.##) AS COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, str_to_dec(str_join(array(str_extract(COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#339026, LEFT, 6), str_extract(COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#339026, RIGHT, 2)), .), ##.##) AS COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Input [16]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#338781, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#338822, COL_E29ED133_4552_4D50_8A38_D30257A626BD#338891, COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#338916, COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#338969, COL_9339888E_B0C5_4327_8233_5581882E58E1#338997, COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#339026, COL_B244443E_C845_4CB1_B850_D141FCA24A95#339056]

(16) Exchange
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#343582, COL_2145E350_E453_4696_8BD8_11A2154405D8#343583, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: hashpartitioning(COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, 10), ENSURE_REQUIREMENTS, [plan_id=47973]

(17) ShuffleQueryStage
Output [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#343582, COL_2145E350_E453_4696_8BD8_11A2154405D8#343583, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: 4

(18) AQEShuffleRead
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#343582, COL_2145E350_E453_4696_8BD8_11A2154405D8#343583, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: coalesced

(19) Sort [codegen id : 12]
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#343582, COL_2145E350_E453_4696_8BD8_11A2154405D8#343583, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: [COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047 ASC NULLS FIRST], false, 0

(20) Scan parquet 
Output [5]: [Code+Acte#342190, Montant#342191, Date_effet#342193, Date_r%C3%A9vocation#342194, Trigramme#342195]
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#342190, Montant#342191, Date_effet#342193, Date_r%C3%A9vocation#342194, Trigramme#342195]

(22) Filter [codegen id : 2]
Input [5]: [Code+Acte#342190, Montant#342191, Date_effet#342193, Date_r%C3%A9vocation#342194, Trigramme#342195]
Condition : ((isnotnull(Code+Acte#342190) AND isnotnull(str_to_datez(Date_effet#342193, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#342194, dd/MM/yyyy, Europe/Paris, fr_FR)))

(23) Project [codegen id : 2]
Output [5]: [Code+Acte#342190 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, Montant#342191 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, Date_effet#342193 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, Date_r%C3%A9vocation#342194 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, Trigramme#342195 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970]
Input [5]: [Code+Acte#342190, Montant#342191, Date_effet#342193, Date_r%C3%A9vocation#342194, Trigramme#342195]

(24) Scan parquet 
Output [5]: [Code+Acte#342469, Montant#342470, Date_effet#342472, Date_r%C3%A9vocation#342473, Trigramme#342474]
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#342469, Montant#342470, Date_effet#342472, Date_r%C3%A9vocation#342473, Trigramme#342474]

(26) Filter [codegen id : 3]
Input [5]: [Code+Acte#342469, Montant#342470, Date_effet#342472, Date_r%C3%A9vocation#342473, Trigramme#342474]
Condition : ((isnotnull(Code+Acte#342469) AND isnotnull(str_to_datez(Date_effet#342472, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#342473, dd/MM/yyyy, Europe/Paris, fr_FR)))

(27) Project [codegen id : 3]
Output [5]: [Code+Acte#342469 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#356152, Montant#342470 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#356153, Date_effet#342472 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#356154, Date_r%C3%A9vocation#342473 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#356155, Trigramme#342474 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#356156]
Input [5]: [Code+Acte#342469, Montant#342470, Date_effet#342472, Date_r%C3%A9vocation#342473, Trigramme#342474]

(28) Scan parquet 
Output [5]: [Code+Acte#342654, Montant#342655, Date_effet#342657, Date_r%C3%A9vocation#342658, Trigramme#342659]
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#342654, Montant#342655, Date_effet#342657, Date_r%C3%A9vocation#342658, Trigramme#342659]

(30) Filter [codegen id : 4]
Input [5]: [Code+Acte#342654, Montant#342655, Date_effet#342657, Date_r%C3%A9vocation#342658, Trigramme#342659]
Condition : ((isnotnull(Code+Acte#342654) AND isnotnull(str_to_datez(Date_effet#342657, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#342658, dd/MM/yyyy, Europe/Paris, fr_FR)))

(31) Project [codegen id : 4]
Output [5]: [Code+Acte#342654 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#356157, Montant#342655 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#356158, Date_effet#342657 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#356159, Date_r%C3%A9vocation#342658 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#356160, Trigramme#342659 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#356161]
Input [5]: [Code+Acte#342654, Montant#342655, Date_effet#342657, Date_r%C3%A9vocation#342658, Trigramme#342659]

(32) Union

(33) Exchange
Input [5]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970]
Arguments: hashpartitioning(coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970, ), isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970), 10), ENSURE_REQUIREMENTS, [plan_id=47158]

(34) ShuffleQueryStage
Output [5]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970]
Arguments: 1

(35) AQEShuffleRead
Input [5]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970]
Arguments: coalesced

(36) Sort [codegen id : 6]
Input [5]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970]
Arguments: [coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970, ) ASC NULLS FIRST, isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970) ASC NULLS FIRST], false, 0

(37) Scan csv 
Output [1]: [region-tarif#342844]
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#342844 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#342980]
Input [1]: [region-tarif#342844]

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

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

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

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

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

(44) Project [codegen id : 8]
Output [4]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965 AS TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, str_to_dec(str_replace(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, ., ,), ##,##) AS TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112, str_to_datez(COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, dd/MM/yyyy, Europe/Paris, fr_FR) AS TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113, str_to_datez(COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, dd/MM/yyyy, Europe/Paris, fr_FR) AS TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114]
Input [6]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970, INFO_DATAAPPS_345943_REGION_TARIF_345945#342980]

(45) Exchange
Input [4]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114]
Arguments: hashpartitioning(TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, 10), ENSURE_REQUIREMENTS, [plan_id=47697]

(46) ShuffleQueryStage
Output [4]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114]
Arguments: 3

(47) AQEShuffleRead
Input [4]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114]
Arguments: coalesced

(48) Sort [codegen id : 13]
Input [4]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114]
Arguments: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111 ASC NULLS FIRST], false, 0

(49) SortMergeJoin [codegen id : 14]
Left keys [1]: [COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047]
Right keys [1]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111]
Join type: LeftOuter
Join condition: ((COL_2145E350_E453_4696_8BD8_11A2154405D8#343583 >= TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113) AND (COL_2145E350_E453_4696_8BD8_11A2154405D8#343583 <= TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114))

(50) Project [codegen id : 14]
Output [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112 AS COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, dec_if_with_rule((str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, LEFT, 1) <=> C), dec_operator(DIFFERENCE, array(TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#343582)), 0.0) AS COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377]
Input [20]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#343582, COL_2145E350_E453_4696_8BD8_11A2154405D8#343583, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114]

(51) Project [codegen id : 14]
Output [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, dec_if_with_rule((NOT (COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377 <=> 0.0) AND isnotnull(COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377)), 1.0, 0.0) AS COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377]

(52) Project [codegen id : 14]
Output [18]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, dec_if_with_rule((COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0), dec_operator(PRODUIT, array(COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284)), null) AS COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570]
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]

(53) Project [codegen id : 14]
Output [19]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570, dec_if_with_rule((COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0), dec_operator(PRODUIT, array(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(cast(COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588 as double), 100.0)), COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570)), cast(COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584 as double))), null) AS COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056, dec_if_with_rule((COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0), dec_operator(PRODUIT, array(dec_operator(PRODUIT, array(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586)), cast(COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584 as double))), null) AS COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#346057, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570), ., RIGHT), 0, 2, RIGHT))) AS COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#346251]
Input [18]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570]

(54) Project [codegen id : 14]
Output [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, str_if_with_rule(((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> C) AND (COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0)), str_concat(array(str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, LEFT, 93), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284), ., RIGHT), 0, 2, RIGHT))), COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#346251, str_complete(int_to_str(COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588), 0, 3, LEFT), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#346057), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#346057), ., RIGHT), 0, 2, RIGHT))), str_extract_by_index(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, 127, 1000))), str_if_with_rule(((COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0) AND (COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> B)), , COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573)) AS COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> C), dec_operator(DIFFERENCE, array(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592)), null) AS COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> C), dec_operator(DIFFERENCE, array(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593)), null) AS COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> B), dec_operator(DIFFERENCE, array(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592)), null) AS COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> B), dec_operator(DIFFERENCE, array(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593)), null) AS COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Input [19]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570, COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056, COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#346057, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#346251]

(55) Exchange
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: hashpartitioning(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 10), ENSURE_REQUIREMENTS, [plan_id=48289]

(56) ShuffleQueryStage
Output [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: 5

(57) AQEShuffleRead
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: coalesced

(58) Sort [codegen id : 15]
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: [COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(59) Window
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: [sum(COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833, sum(COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106, sum(COL_1E060572_AE15_4178_913A_C47144F27CFB#349544) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664, sum(COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949, max(COL_4B158112_2BA5_45AF_B876_25385319D312#345445) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754], [COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579], [1 DESC NULLS LAST]

(60) Filter [codegen id : 16]
Input [22]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833, COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106, COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664, COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754]
Condition : (COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0)

(61) Project [codegen id : 16]
Output [12]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A), dec_operator(SOMME, array(COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, CASE WHEN isnull(COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833) THEN 0.0 ELSE CASE WHEN isnan(COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833) THEN 0.0 ELSE COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833 END END)), null), 2) AS COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#353330, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A), dec_operator(SOMME, array(COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, CASE WHEN isnull(COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106) THEN 0.0 ELSE CASE WHEN isnan(COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106) THEN 0.0 ELSE COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106 END END)), null), 2) AS COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#353331, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A), dec_operator(SOMME, array(COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, CASE WHEN isnull(COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664) THEN 0.0 ELSE CASE WHEN isnan(COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664) THEN 0.0 ELSE COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664 END END)), null), 2) AS COL_954A8446_59EE_42A6_874E_5D947C05002E#353332, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A), dec_operator(SOMME, array(COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, CASE WHEN isnull(COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949) THEN 0.0 ELSE CASE WHEN isnan(COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949) THEN 0.0 ELSE COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949 END END)), null), 2) AS COL_B8447468_D81F_445D_91DE_8654426D3D23#353333, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754]
Input [22]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833, COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106, COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664, COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754]

(62) Project [codegen id : 16]
Output [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, str_if_with_rule(((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A) AND (COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754 <=> 1.0)), str_concat(array(str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, LEFT, 105), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_954A8446_59EE_42A6_874E_5D947C05002E#353332), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_954A8446_59EE_42A6_874E_5D947C05002E#353332), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_B8447468_D81F_445D_91DE_8654426D3D23#353333), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_B8447468_D81F_445D_91DE_8654426D3D23#353333), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#353330), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#353330), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#353331), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#353331), ., RIGHT), 0, 2, RIGHT))), str_extract_middle(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, 138, 1000))), COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078) AS COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517]
Input [12]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#353330, COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#353331, COL_954A8446_59EE_42A6_874E_5D947C05002E#353332, COL_B8447468_D81F_445D_91DE_8654426D3D23#353333, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754]

(63) Exchange
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517]
Arguments: rangepartitioning(COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=48589]

(64) ShuffleQueryStage
Output [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517]
Arguments: 6

(65) AQEShuffleRead
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517]
Arguments: coalesced

(66) Sort [codegen id : 17]
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517]
Arguments: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574 ASC NULLS FIRST], true, 0

(67) Project [codegen id : 17]
Output [4]: [COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047 AS COL_A67131E4_E549_4206_9029_E6591A70C578#355737, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284 AS COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377 AS COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517, C)) THEN false ELSE StartsWith(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517, C) END, str_concat(array(str_extract_middle(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517, 74, 4), -, str_extract_middle(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517, 72, 2))), ) AS COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804]
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517]

(68) HashAggregate [codegen id : 17]
Input [4]: [COL_A67131E4_E549_4206_9029_E6591A70C578#355737, COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739, COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740, COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804]
Keys [2]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737]
Functions [3]: [partial_sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740), partial_sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739), partial_count(1)]
Aggregate Attributes [3]: [sum#356168, sum#356169, count#355958L]
Results [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737, sum#356170, sum#356171, count#355961L]

(69) Exchange
Input [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737, sum#356170, sum#356171, count#355961L]
Arguments: hashpartitioning(COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737, 10), ENSURE_REQUIREMENTS, [plan_id=48784]

(70) ShuffleQueryStage
Output [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737, sum#356170, sum#356171, count#355961L]
Arguments: 7

(71) AQEShuffleRead
Input [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737, sum#356170, sum#356171, count#355961L]
Arguments: coalesced

(72) HashAggregate [codegen id : 18]
Input [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737, sum#356170, sum#356171, count#355961L]
Keys [2]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737]
Functions [3]: [sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740), sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739), count(1)]
Aggregate Attributes [3]: [sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740)#355831, sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739)#355833, count(1)#355835L]
Results [5]: [COL_A67131E4_E549_4206_9029_E6591A70C578#355737 AS COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804 AS COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740)#355831 AS COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739)#355833 AS COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, count(1)#355835L AS COL_8246091B_F617_46DA_B417_C911085B619C#355864L]

(73) Exchange
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=48846]

(74) ShuffleQueryStage
Output [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L]
Arguments: 8

(75) AQEShuffleRead
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L]
Arguments: coalesced

(76) Sort [codegen id : 19]
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L]
Arguments: [1 ASC NULLS FIRST, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS LAST], false, 0

(77) Window
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L]
Arguments: [sum(COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863) windowspecdefinition(1, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, sum(COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862) windowspecdefinition(1, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901], [1], [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS LAST]

(78) Exchange
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901]
Arguments: rangepartitioning(COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS FIRST, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=48899]

(79) ShuffleQueryStage
Output [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901]
Arguments: 9

(80) AQEShuffleRead
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901]
Arguments: coalesced

(81) Sort [codegen id : 20]
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901]
Arguments: [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS FIRST, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860 ASC NULLS FIRST], true, 0

(82) Project [codegen id : 20]
Output [7]: [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, round(COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, 2) AS COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355919, round(COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, 2) AS COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355920, COL_8246091B_F617_46DA_B417_C911085B619C#355864L, round(COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, 2) AS COL_BABB3A33_596C_4623_AA68_D934A17418FB#355922, round(COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901, 2) AS COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355923]
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901]

(83) WriteFiles
Input [7]: [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355919, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355920, COL_8246091B_F617_46DA_B417_C911085B619C#355864L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#355922, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355923]

(84) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/79cf5ab7_f28c_4ae0_990e_c998ee669496, false, Parquet, [path=file:///data/output/cache/parquet/datablock/79cf5ab7_f28c_4ae0_990e_c998ee669496], 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#338380 AS COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, str_extract(_c0#338380, LEFT, 1) AS COL_D510A167_ACB1_4527_BFB8_45608936317D#338411]
Input [1]: [_c0#338380]

(86) Exchange
Input [2]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=46945]

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

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

(89) Filter
Input [3]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421]
Condition : (((COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421 <=> 1) AND (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A)) OR (COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421 > 1))

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

(91) Window
Input [4]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#338510]
Arguments: [last(COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#338510, true) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535], [1], [1 DESC NULLS LAST]

(92) Project
Output [6]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 100, 7), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 94, 7), )) AS COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#338682, str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 78, 5), ) AS COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696]
Input [5]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_4CA6ACE3_B62F_470F_A827_AEF975E104E7#338510, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535]

(93) Project
Output [9]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, str_to_dec(str_join(array(str_extract(COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#338682, LEFT, 5), str_extract(COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#338682, RIGHT, 2)), .), ##.##) AS COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, str_to_datez(str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B)), str_join(array(str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 70, 2), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 72, 2), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 74, 4)), /), ), dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, str_to_integer(str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 83, 3), )) AS COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, str_if_with_rule(((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C) OR (COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B)), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 86, 6), ) AS COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#338762]
Input [6]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_B1193DFE_9198_415B_BBF1_7ACB56DC7AA2#338682, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696]

(94) Project
Output [12]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, str_to_dec(str_join(array(str_extract(COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#338762, LEFT, 4), str_extract(COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#338762, RIGHT, 2)), .), ##.##) AS COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#338781, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 107, 8), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 101, 8), )) AS COL_E5077910_2063_4267_B69B_497F468B05F5#338801, str_to_integer(str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 115, 3), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 109, 3), ))) AS COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#338822, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> B), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 118, 8), str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> C), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 112, 8), )) AS COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#338844]
Input [9]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, COL_C91FDE99_2699_4F25_9BC5_668DF5D76F66#338762]

(95) Project
Output [16]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#338781, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#338822, str_to_dec(str_join(array(str_extract(COL_E5077910_2063_4267_B69B_497F468B05F5#338801, LEFT, 6), str_extract(COL_E5077910_2063_4267_B69B_497F468B05F5#338801, RIGHT, 2)), .), ##.##) AS COL_E29ED133_4552_4D50_8A38_D30257A626BD#338891, str_to_dec(str_join(array(str_extract(COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#338844, LEFT, 6), str_extract(COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#338844, RIGHT, 2)), .), ##.##) AS COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#338916, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 106, 8), ) AS COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#338969, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 114, 8), ) AS COL_9339888E_B0C5_4327_8233_5581882E58E1#338997, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 130, 8), ) AS COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#339026, str_if_with_rule((COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 <=> A), str_extract_middle(COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, 122, 8), ) AS COL_B244443E_C845_4CB1_B850_D141FCA24A95#339056]
Input [12]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#338781, COL_E5077910_2063_4267_B69B_497F468B05F5#338801, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#338822, COL_EBACECE4_C8E8_45E9_A30E_B77C434D786C#338844]

(96) Project
Output [16]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407 AS COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421 AS COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411 AS COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535 AS COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711 AS COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#343582, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727 AS COL_2145E350_E453_4696_8BD8_11A2154405D8#343583, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744 AS COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#338781 AS COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#338822 AS COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_E29ED133_4552_4D50_8A38_D30257A626BD#338891 AS COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#338916 AS COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, str_remove_space(str_remove_space(COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, LEFT), RIGHT) AS COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, str_to_dec(str_join(array(str_extract(COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#338969, LEFT, 6), str_extract(COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#338969, RIGHT, 2)), .), ##.##) AS COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, str_to_dec(str_join(array(str_extract(COL_9339888E_B0C5_4327_8233_5581882E58E1#338997, LEFT, 6), str_extract(COL_9339888E_B0C5_4327_8233_5581882E58E1#338997, RIGHT, 2)), .), ##.##) AS COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, str_to_dec(str_join(array(str_extract(COL_B244443E_C845_4CB1_B850_D141FCA24A95#339056, LEFT, 6), str_extract(COL_B244443E_C845_4CB1_B850_D141FCA24A95#339056, RIGHT, 2)), .), ##.##) AS COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, str_to_dec(str_join(array(str_extract(COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#339026, LEFT, 6), str_extract(COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#339026, RIGHT, 2)), .), ##.##) AS COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Input [16]: [COL_E511E580_90D5_46FF_98FE_1080DF5E69F9#338407, COL_4FC79CD7_7315_4757_93CF_0A9F4884476A#338421, COL_D510A167_ACB1_4527_BFB8_45608936317D#338411, COL_309F8E2E_B6D4_43B6_BAD4_9EF99EFF9693#338535, COL_720C7642_39AD_40D8_A8A4_8F7E91C6EE12#338696, COL_9B8261ED_48CB_4CAB_9342_9BE61D48C8CF#338711, COL_E310E7E8_72D1_427D_893E_9CB96908C503#338727, COL_03B7D945_6563_4C53_9BB0_307952AA92FF#338744, COL_747C87DC_D4C5_4C85_9D88_F4F0F08CBEDE#338781, COL_20FCC7C6_1B2F_454D_A1E1_090A75706717#338822, COL_E29ED133_4552_4D50_8A38_D30257A626BD#338891, COL_19C5C361_0F61_42AB_8EBA_F6D0C5C107BE#338916, COL_FE52DA9F_6F43_4E85_9CAF_982289A8D579#338969, COL_9339888E_B0C5_4327_8233_5581882E58E1#338997, COL_4E0063FB_8019_4C97_B116_0FDB78A2D337#339026, COL_B244443E_C845_4CB1_B850_D141FCA24A95#339056]

(97) Exchange
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#343582, COL_2145E350_E453_4696_8BD8_11A2154405D8#343583, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: hashpartitioning(COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, 10), ENSURE_REQUIREMENTS, [plan_id=46969]

(98) Sort
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#343582, COL_2145E350_E453_4696_8BD8_11A2154405D8#343583, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: [COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047 ASC NULLS FIRST], false, 0

(99) Filter
Input [5]: [Code+Acte#342190, Montant#342191, Date_effet#342193, Date_r%C3%A9vocation#342194, Trigramme#342195]
Condition : ((isnotnull(Code+Acte#342190) AND isnotnull(str_to_datez(Date_effet#342193, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#342194, dd/MM/yyyy, Europe/Paris, fr_FR)))

(100) Project
Output [5]: [Code+Acte#342190 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, Montant#342191 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, Date_effet#342193 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, Date_r%C3%A9vocation#342194 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, Trigramme#342195 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970]
Input [5]: [Code+Acte#342190, Montant#342191, Date_effet#342193, Date_r%C3%A9vocation#342194, Trigramme#342195]

(101) Filter
Input [5]: [Code+Acte#342469, Montant#342470, Date_effet#342472, Date_r%C3%A9vocation#342473, Trigramme#342474]
Condition : ((isnotnull(Code+Acte#342469) AND isnotnull(str_to_datez(Date_effet#342472, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#342473, dd/MM/yyyy, Europe/Paris, fr_FR)))

(102) Project
Output [5]: [Code+Acte#342469 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#356152, Montant#342470 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#356153, Date_effet#342472 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#356154, Date_r%C3%A9vocation#342473 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#356155, Trigramme#342474 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#356156]
Input [5]: [Code+Acte#342469, Montant#342470, Date_effet#342472, Date_r%C3%A9vocation#342473, Trigramme#342474]

(103) Filter
Input [5]: [Code+Acte#342654, Montant#342655, Date_effet#342657, Date_r%C3%A9vocation#342658, Trigramme#342659]
Condition : ((isnotnull(Code+Acte#342654) AND isnotnull(str_to_datez(Date_effet#342657, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#342658, dd/MM/yyyy, Europe/Paris, fr_FR)))

(104) Project
Output [5]: [Code+Acte#342654 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#356157, Montant#342655 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#356158, Date_effet#342657 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#356159, Date_r%C3%A9vocation#342658 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#356160, Trigramme#342659 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#356161]
Input [5]: [Code+Acte#342654, Montant#342655, Date_effet#342657, Date_r%C3%A9vocation#342658, Trigramme#342659]

(105) Union

(106) Exchange
Input [5]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970]
Arguments: hashpartitioning(coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970, ), isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970), 10), ENSURE_REQUIREMENTS, [plan_id=46959]

(107) Sort
Input [5]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970]
Arguments: [coalesce(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970, ) ASC NULLS FIRST, isnull(COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970) ASC NULLS FIRST], false, 0

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

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

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

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

(112) Project
Output [4]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965 AS TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, str_to_dec(str_replace(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, ., ,), ##,##) AS TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112, str_to_datez(COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, dd/MM/yyyy, Europe/Paris, fr_FR) AS TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113, str_to_datez(COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, dd/MM/yyyy, Europe/Paris, fr_FR) AS TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114]
Input [6]: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970, INFO_DATAAPPS_345943_REGION_TARIF_345945#342980]

(113) Exchange
Input [4]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114]
Arguments: hashpartitioning(TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, 10), ENSURE_REQUIREMENTS, [plan_id=46970]

(114) Sort
Input [4]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114]
Arguments: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111 ASC NULLS FIRST], false, 0

(115) SortMergeJoin
Left keys [1]: [COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047]
Right keys [1]: [TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111]
Join type: LeftOuter
Join condition: ((COL_2145E350_E453_4696_8BD8_11A2154405D8#343583 >= TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113) AND (COL_2145E350_E453_4696_8BD8_11A2154405D8#343583 <= TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114))

(116) Project
Output [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112 AS COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, dec_if_with_rule((str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, LEFT, 1) <=> C), dec_operator(DIFFERENCE, array(TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#343582)), 0.0) AS COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377]
Input [20]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_BBF1EEA5_8E7A_46C1_B4A1_067E1B011C57#343582, COL_2145E350_E453_4696_8BD8_11A2154405D8#343583, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, TARIF_HISTORIQU_345998_COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#344111, TARIF_HISTORIQU_345998_COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#344112, TARIF_HISTORIQU_345998_COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#344113, TARIF_HISTORIQU_345998_COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#344114]

(117) Project
Output [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, dec_if_with_rule((NOT (COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377 <=> 0.0) AND isnotnull(COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377)), 1.0, 0.0) AS COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Input [16]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377]

(118) Project
Output [18]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, dec_if_with_rule((COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0), dec_operator(PRODUIT, array(COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284)), null) AS COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570]
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]

(119) Project
Output [19]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570, dec_if_with_rule((COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0), dec_operator(PRODUIT, array(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(cast(COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588 as double), 100.0)), COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570)), cast(COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584 as double))), null) AS COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056, dec_if_with_rule((COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0), dec_operator(PRODUIT, array(dec_operator(PRODUIT, array(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586)), cast(COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584 as double))), null) AS COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#346057, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570), ., RIGHT), 0, 2, RIGHT))) AS COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#346251]
Input [18]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_D42259CA_CBC7_4CF5_AAE2_47FABDA04E4D#343584, COL_512BD1E9_F37F_4626_B67A_8DCFD23B8145#343586, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570]

(120) Project
Output [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, str_if_with_rule(((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> C) AND (COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0)), str_concat(array(str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, LEFT, 93), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284), ., RIGHT), 0, 2, RIGHT))), COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#346251, str_complete(int_to_str(COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588), 0, 3, LEFT), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#346057), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#346057), ., RIGHT), 0, 2, RIGHT))), str_extract_by_index(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, 127, 1000))), str_if_with_rule(((COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0) AND (COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> B)), , COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573)) AS COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> C), dec_operator(DIFFERENCE, array(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592)), null) AS COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> C), dec_operator(DIFFERENCE, array(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593)), null) AS COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> B), dec_operator(DIFFERENCE, array(COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592)), null) AS COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> B), dec_operator(DIFFERENCE, array(COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593)), null) AS COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Input [19]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_E82C07E4_ACF6_4E26_8E8B_21E1BE59AC42#343588, COL_1C803C3B_5841_4B5C_AAC6_3053A0EE7BB1#343592, COL_3B860329_B7B4_4692_A5D1_8D41429951B5#343593, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_8E8952B0_AECB_44EF_8977_36AD703337F9#345570, COL_0B1C5490_AA5F_4ED0_B2E9_D1D6E5097CD1#346056, COL_4C74029D_5E87_4A09_86B4_4DE0A80740EC#346057, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, COL_C7BC2890_084E_4FDF_B549_C5C94B88E15C#346251]

(121) Exchange
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: hashpartitioning(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 10), ENSURE_REQUIREMENTS, [plan_id=46980]

(122) Sort
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: [COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(123) Window
Input [17]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608]
Arguments: [sum(COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833, sum(COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106, sum(COL_1E060572_AE15_4178_913A_C47144F27CFB#349544) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664, sum(COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949, max(COL_4B158112_2BA5_45AF_B876_25385319D312#345445) windowspecdefinition(COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754], [COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579], [1 DESC NULLS LAST]

(124) Filter
Input [22]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833, COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106, COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664, COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754]
Condition : (COL_4B158112_2BA5_45AF_B876_25385319D312#345445 <=> 1.0)

(125) Project
Output [12]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A), dec_operator(SOMME, array(COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, CASE WHEN isnull(COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833) THEN 0.0 ELSE CASE WHEN isnan(COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833) THEN 0.0 ELSE COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833 END END)), null), 2) AS COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#353330, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A), dec_operator(SOMME, array(COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, CASE WHEN isnull(COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106) THEN 0.0 ELSE CASE WHEN isnan(COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106) THEN 0.0 ELSE COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106 END END)), null), 2) AS COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#353331, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A), dec_operator(SOMME, array(COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, CASE WHEN isnull(COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664) THEN 0.0 ELSE CASE WHEN isnan(COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664) THEN 0.0 ELSE COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664 END END)), null), 2) AS COL_954A8446_59EE_42A6_874E_5D947C05002E#353332, dec_round(dec_if_with_rule((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A), dec_operator(SOMME, array(COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, CASE WHEN isnull(COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949) THEN 0.0 ELSE CASE WHEN isnan(COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949) THEN 0.0 ELSE COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949 END END)), null), 2) AS COL_B8447468_D81F_445D_91DE_8654426D3D23#353333, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754]
Input [22]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_C8938273_938E_4A53_B14D_894C621AAAC0#343579, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_4B158112_2BA5_45AF_B876_25385319D312#345445, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_A0129035_9ADA_4551_B5BB_ADE2ECC65045#349541, COL_592CA39A_83B9_4E3C_832D_EF1248106693#349542, COL_1E060572_AE15_4178_913A_C47144F27CFB#349544, COL_7D82CF4B_D087_4EF8_A412_C2BB136AB26F#349545, COL_334593A3_9AFB_4A2E_9797_CF0B9AA1B223#343605, COL_129B775F_F0BF_448C_99E0_84F6E70D03D9#343606, COL_379A79F3_244E_4506_A5A4_DFA4C6E940AA#343607, COL_C533691A_BA7E_42FC_9EEA_9935FB288FD3#343608, COL_88BB29DC_9F4A_4309_B8AE_B89FAB921F94#349833, COL_6B9C02A4_A27C_4D8E_B2A8_E5099F1C4FA5#350106, COL_4EC2397F_054D_483C_93CD_30CB38CD51AD#350664, COL_B75A297A_2155_451B_B5AD_F05E76ACFB16#350949, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754]

(126) Project
Output [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, str_if_with_rule(((COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575 <=> A) AND (COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754 <=> 1.0)), str_concat(array(str_extract(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, LEFT, 105), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_954A8446_59EE_42A6_874E_5D947C05002E#353332), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_954A8446_59EE_42A6_874E_5D947C05002E#353332), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_B8447468_D81F_445D_91DE_8654426D3D23#353333), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_B8447468_D81F_445D_91DE_8654426D3D23#353333), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#353330), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#353330), ., RIGHT), 0, 2, RIGHT))), str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#353331), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#353331), ., RIGHT), 0, 2, RIGHT))), str_extract_middle(COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, 138, 1000))), COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078) AS COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517]
Input [12]: [COL_A6053708_A703_4A95_B2F5_66BB5073E2EB#343573, COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_996D87B6_DF42_4F44_96E3_B44D5DA778C7#343575, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_B622F73C_11B4_4465_B86C_A00D47754DAB#348078, COL_9DC85821_B5F7_44D1_A958_9CF2724D1939#353330, COL_F7E62A02_F7C2_4067_9181_5CCE95ADC71A#353331, COL_954A8446_59EE_42A6_874E_5D947C05002E#353332, COL_B8447468_D81F_445D_91DE_8654426D3D23#353333, COL_A0F94A2F_1BC1_44DB_ADFB_0D9D81883C37#351754]

(127) Exchange
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517]
Arguments: rangepartitioning(COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=46987]

(128) Sort
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517]
Arguments: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574 ASC NULLS FIRST], true, 0

(129) Project
Output [4]: [COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047 AS COL_A67131E4_E549_4206_9029_E6591A70C578#355737, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284 AS COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377 AS COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517, C)) THEN false ELSE StartsWith(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517, C) END, str_concat(array(str_extract_middle(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517, 74, 4), -, str_extract_middle(COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517, 72, 2))), ) AS COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804]
Input [5]: [COL_59F6A737_2D9A_4D44_80EB_23F8F4B48180#343574, COL_FC392F17_9FE4_451F_B853_E9993888E87A#344047, COL_B516B6D6_AB3D_4D9C_9C12_7F437D937CAE#344284, COL_CAAA53AE_5E8E_40CC_82DF_F37638AB5F76#344377, COL_80DAF8F3_34AA_48D8_BB3E_A6B0C8C71896#355517]

(130) HashAggregate
Input [4]: [COL_A67131E4_E549_4206_9029_E6591A70C578#355737, COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739, COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740, COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804]
Keys [2]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737]
Functions [3]: [partial_sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740), partial_sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739), partial_count(1)]
Aggregate Attributes [3]: [sum#356168, sum#356169, count#355958L]
Results [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737, sum#356170, sum#356171, count#355961L]

(131) Exchange
Input [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737, sum#356170, sum#356171, count#355961L]
Arguments: hashpartitioning(COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737, 10), ENSURE_REQUIREMENTS, [plan_id=46992]

(132) HashAggregate
Input [5]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737, sum#356170, sum#356171, count#355961L]
Keys [2]: [COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804, COL_A67131E4_E549_4206_9029_E6591A70C578#355737]
Functions [3]: [sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740), sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739), count(1)]
Aggregate Attributes [3]: [sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740)#355831, sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739)#355833, count(1)#355835L]
Results [5]: [COL_A67131E4_E549_4206_9029_E6591A70C578#355737 AS COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_B36E87C1_2C8E_4F7D_BFE8_09504031F246#355804 AS COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, sum(COL_E381FEB3_4A41_4429_9D72_3B4E07C64D2E#355740)#355831 AS COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, sum(COL_5BCBE5C9_F92C_4BB1_B3A0_ECC077CB649D#355739)#355833 AS COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, count(1)#355835L AS COL_8246091B_F617_46DA_B417_C911085B619C#355864L]

(133) Exchange
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=46995]

(134) Sort
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L]
Arguments: [1 ASC NULLS FIRST, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS LAST], false, 0

(135) Window
Input [5]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L]
Arguments: [sum(COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863) windowspecdefinition(1, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, sum(COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862) windowspecdefinition(1, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901], [1], [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS LAST]

(136) Exchange
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901]
Arguments: rangepartitioning(COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS FIRST, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=46999]

(137) Sort
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901]
Arguments: [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861 ASC NULLS FIRST, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860 ASC NULLS FIRST], true, 0

(138) Project
Output [7]: [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, round(COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, 2) AS COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355919, round(COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, 2) AS COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355920, COL_8246091B_F617_46DA_B417_C911085B619C#355864L, round(COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, 2) AS COL_BABB3A33_596C_4623_AA68_D934A17418FB#355922, round(COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901, 2) AS COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355923]
Input [7]: [COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355862, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355863, COL_8246091B_F617_46DA_B417_C911085B619C#355864L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#355878, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355901]

(139) WriteFiles
Input [7]: [COL_631E5908_AE2B_4F95_B6A1_D0D5E181EBBD#355861, COL_26078F6F_FB72_4DED_824E_A44E0A0F90E4#355860, COL_55E0614A_3A58_4EC8_BEF5_74E892471F37#355919, COL_ABB610E3_3404_45F9_A951_5D8E525D57C0#355920, COL_8246091B_F617_46DA_B417_C911085B619C#355864L, COL_BABB3A33_596C_4623_AA68_D934A17418FB#355922, COL_D6C8DDB8_93B2_4E07_B593_1AA52533799F#355923]

(140) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/79cf5ab7_f28c_4ae0_990e_c998ee669496, false, Parquet, [path=file:///data/output/cache/parquet/datablock/79cf5ab7_f28c_4ae0_990e_c998ee669496], 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