SP1 - Details for Query 4726

Submitted Time: 2026/05/21 07:34:37
Duration: 11 s
Succeeded Jobs: 7379 7380 7381 7382 7383 7384 7385 7393 7395

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (22)\n \nduration: 1 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 12 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 3 ms (0 ms, 0 ms, 0 ms (stage 15157.0: task 21072)) 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: 12 local bytes read: 708.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 12 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 192.0 B (16.0 B, 16.0 B, 16.0 B (stage 15157.0: task 21074)) local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 708.0 B (59.0 B, 59.0 B, 59.0 B (stage 15157.0: task 21074))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (21)\n \nduration: total (min, med, max (stageId: taskId))\n14.2 s (43 ms, 61 ms, 7.0 s (stage 15157.0: task 21078))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 14.2 s (43 ms, 61 ms, 7.0 s (stage 15157.0: task 21078)) number of output rows: 12"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (19)\n \nduration: total (min, med, max (stageId: taskId))\n13.6 s (6.6 s, 7.0 s, 7.0 s (stage 15157.0: task 21078))"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 46,038"]; } 10 [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 15157.0: task 21077))"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (18)\n \nduration: total (min, med, max (stageId: taskId))\n15.4 s (7.5 s, 7.8 s, 7.8 s (stage 15157.0: task 21078))"; 12 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 9 ms (3 ms, 6 ms, 6 ms (stage 15157.0: task 21077)) peak memory total (min, med, max (stageId: taskId)) 34.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 15157.0: task 21077)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15157.0: task 21077))"]; } 13 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 2.2 MiB (1133.7 KiB, 1155.5 KiB, 1155.5 KiB (driver)) number of coalesced partitions: 2"]; 14 [labelType="html" label="Exchange shuffle records written: 46,038 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 10 ms (1 ms, 3 ms, 5 ms (stage 15133.0: task 21035)) 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: 46,038 local bytes read total (min, med, max (stageId: taskId)) 2.1 MiB (1069.7 KiB, 1101.2 KiB, 1101.2 KiB (stage 15157.0: task 21078)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15157.0: task 21077)) 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)) 11.6 MiB (181.9 KiB, 4.6 MiB, 6.9 MiB (stage 15133.0: task 21035)) 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)) 2.1 MiB (46.1 KiB, 849.1 KiB, 1275.6 KiB (stage 15133.0: task 21035))"]; 15 [labelType="html" label="CartesianProduct number of output rows: 46,038"]; 16 [labelType="html" label=" Union "]; subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: total (min, med, max (stageId: taskId))\n282 ms (111 ms, 171 ms, 171 ms (stage 15133.0: task 21035))"; 18 [labelType="html" label=" Project "]; 19 [labelType="html" label="Filter number of output rows: 45,235"]; } 20 [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 15133.0: task 21034))"]; subgraph cluster21 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: total (min, med, max (stageId: taskId))\n449 ms (194 ms, 255 ms, 255 ms (stage 15133.0: task 21035))"; 22 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 27 ms (11 ms, 16 ms, 16 ms (stage 15133.0: task 21035)) peak memory total (min, med, max (stageId: taskId)) 33.5 MiB (16.5 MiB, 17.0 MiB, 17.0 MiB (stage 15133.0: task 21035)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15133.0: task 21034))"]; } 23 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 2.7 MiB (1103.1 KiB, 1671.4 KiB, 1671.4 KiB (driver)) number of coalesced partitions: 2"]; 24 [labelType="html" label="Exchange shuffle records written: 45,283 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 12 ms (3 ms, 4 ms, 4 ms (stage 15126.0: task 21033)) 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: 45,283 local bytes read total (min, med, max (stageId: taskId)) 2.6 MiB (1056.5 KiB, 1593.7 KiB, 1593.7 KiB (stage 15133.0: task 21035)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15133.0: task 21034)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 6 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 13.2 MiB (3.9 MiB, 3.9 MiB, 5.3 MiB (stage 15126.0: task 21033)) 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)) 2.6 MiB (803.2 KiB, 811.9 KiB, 1035.0 KiB (stage 15126.0: task 21033))"]; subgraph cluster25 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: total (min, med, max (stageId: taskId))\n565 ms (176 ms, 184 ms, 205 ms (stage 15126.0: task 21033))"; 26 [labelType="html" label=" Project "]; 27 [labelType="html" label=" Project "]; 28 [labelType="html" label="SortMergeJoin number of output rows: 45,283 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15126.0: task 21032))"]; } subgraph cluster29 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: total (min, med, max (stageId: taskId))\n794 ms (253 ms, 260 ms, 281 ms (stage 15126.0: task 21033))"; 30 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 45 ms (11 ms, 11 ms, 23 ms (stage 15126.0: task 21033)) peak memory total (min, med, max (stageId: taskId)) 49.5 MiB (16.5 MiB, 16.5 MiB, 16.5 MiB (stage 15126.0: task 21032)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15126.0: task 21032))"]; } 31 [labelType="html" label="AQEShuffleRead number of partitions: 3 partition data size total (min, med, max (stageId: taskId)) 3.9 MiB (1187.1 KiB, 1190.6 KiB, 1602.9 KiB (driver)) number of coalesced partitions: 3"]; 32 [labelType="html" label="Exchange shuffle records written: 45,283 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 38 ms (3 ms, 3 ms, 5 ms (stage 15118.0: task 21009)) 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: 45,283 local bytes read total (min, med, max (stageId: taskId)) 3.7 MiB (1127.7 KiB, 1136.8 KiB, 1530.8 KiB (stage 15126.0: task 21033)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15126.0: task 21032)) 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)) 14.2 MiB (1417.6 KiB, 1451.7 KiB, 1498.6 KiB (stage 15118.0: task 21007)) 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)) 3.7 MiB (370.9 KiB, 379.7 KiB, 392.6 KiB (stage 15118.0: task 21007))"]; subgraph cluster33 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.3 s (115 ms, 128 ms, 137 ms (stage 15118.0: task 21011))"; 34 [labelType="html" label=" Project "]; 35 [labelType="html" label=" Project "]; } 36 [labelType="html" label="CartesianProduct number of output rows: 45,283"]; subgraph cluster37 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n1.8 s (168 ms, 180 ms, 190 ms (stage 15118.0: task 21011))"; 38 [labelType="html" label=" Project "]; 39 [labelType="html" label="ColumnarToRow number of output rows: 45,283 number of input batches: 20"]; } 40 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 165 ms (8 ms, 18 ms, 22 ms (stage 15118.0: task 21016)) metadata time: 0 ms size of files read: 6.2 MiB number of output rows: 45,283"]; subgraph cluster41 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n240 ms (19 ms, 25 ms, 28 ms (stage 15118.0: task 21009))"; 42 [labelType="html" label=" Project "]; 43 [labelType="html" label="Filter number of output rows: 10"]; } 44 [labelType="html" label="Scan csv number of output rows: 10 number of files read: 1 metadata time: 0 ms size of files read: 175.0 B"]; subgraph cluster45 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: total (min, med, max (stageId: taskId))\n9.8 m (1.4 m, 2.2 m, 6.2 m (stage 15126.0: task 21032))"; 46 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15126.0: task 21032)) peak memory total (min, med, max (stageId: taskId)) 48.2 MiB (16.1 MiB, 16.1 MiB, 16.1 MiB (stage 15126.0: task 21032)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15126.0: task 21032))"]; } 47 [labelType="html" label="AQEShuffleRead number of partitions: 3 partition data size total (min, med, max (stageId: taskId)) 2.3 KiB (672.0 B, 730.0 B, 997.0 B (driver)) number of coalesced partitions: 3"]; 48 [labelType="html" label="Exchange shuffle records written: 48 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: 48 local bytes read total (min, med, max (stageId: taskId)) 2.2 KiB (646.0 B, 692.0 B, 948.0 B (stage 15126.0: task 21033)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15126.0: task 21032)) 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: 3.7 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: 2.2 KiB"]; subgraph cluster49 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 17 ms"; 50 [labelType="html" label=" Project "]; 51 [labelType="html" label="Filter number of output rows: 48"]; 52 [labelType="html" label="ColumnarToRow number of output rows: 851 number of input batches: 1"]; } 53 [labelType="html" label="Scan parquet number of files read: 1 scan time: 13 ms metadata time: 0 ms size of files read: 48.4 KiB number of output rows: 851"]; subgraph cluster54 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: 432 ms"; 55 [labelType="html" label=" Project "]; 56 [labelType="html" label=" Project "]; 57 [labelType="html" label=" Project "]; 58 [labelType="html" label=" Project "]; 59 [labelType="html" label=" Project "]; 60 [labelType="html" label="SortMergeJoin number of output rows: 803 spill size: 0.0 B"]; } subgraph cluster61 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: 596 ms"; 62 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 63 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 21.8 KiB number of coalesced partitions: 1"]; 64 [labelType="html" label="Exchange shuffle records written: 803 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: 803 local bytes read: 20.9 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 82.7 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: 20.9 KiB"]; subgraph cluster65 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 28 ms"; 66 [labelType="html" label=" Project "]; 67 [labelType="html" label="Filter number of output rows: 803"]; 68 [labelType="html" label="ColumnarToRow number of output rows: 851 number of input batches: 1"]; } 69 [labelType="html" label="Scan parquet number of files read: 1 scan time: 24 ms metadata time: 0 ms size of files read: 48.4 KiB number of output rows: 851"]; subgraph cluster70 { isCluster="true"; label="WholeStageCodegen (15)\n \nduration: 0 ms"; 71 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.3 MiB spill size: 0.0 B"]; 72 [labelType="html" label=" Project "]; } 73 [labelType="html" label="ObjectHashAggregate number of output rows: 10,259 time in aggregation build: 45 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 74 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 2009.9 KiB number of coalesced partitions: 1"]; 75 [labelType="html" label="Exchange shuffle records written: 17,635 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 9 ms (4 ms, 4 ms, 4 ms (stage 15123.0: task 21030)) 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: 17,635 local bytes read: 1915.1 KiB fetch wait time: 0 ms 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 total (min, med, max (stageId: taskId)) 10.1 MiB (4.2 MiB, 5.9 MiB, 5.9 MiB (stage 15123.0: task 21030)) 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)) 1915.1 KiB (813.2 KiB, 1101.9 KiB, 1101.9 KiB (stage 15123.0: task 21030))"]; 76 [labelType="html" label="ObjectHashAggregate number of output rows: 17,635 time in aggregation build total (min, med, max (stageId: taskId)) 529 ms (238 ms, 291 ms, 291 ms (stage 15123.0: task 21030)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15123.0: task 21029)) number of sort fallback tasks: 2"]; subgraph cluster77 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: total (min, med, max (stageId: taskId))\n525 ms (237 ms, 288 ms, 288 ms (stage 15123.0: task 21030))"; 78 [labelType="html" label=" Project "]; 79 [labelType="html" label="Filter number of output rows: 30,777"]; } 80 [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 15123.0: task 21029))"]; subgraph cluster81 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n961 ms (455 ms, 506 ms, 506 ms (stage 15123.0: task 21030))"; 82 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 205 ms (101 ms, 104 ms, 104 ms (stage 15123.0: task 21030)) peak memory total (min, med, max (stageId: taskId)) 33.5 MiB (16.5 MiB, 17.0 MiB, 17.0 MiB (stage 15123.0: task 21030)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15123.0: task 21029))"]; } 83 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 2.8 MiB (1123.4 KiB, 1695.1 KiB, 1695.1 KiB (driver)) number of coalesced partitions: 2"]; 84 [labelType="html" label="Exchange shuffle records written: 45,283 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 28 ms (2 ms, 2 ms, 4 ms (stage 15121.0: task 21026)) 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: 45,283 local bytes read total (min, med, max (stageId: taskId)) 2.6 MiB (1070.6 KiB, 1616.1 KiB, 1616.1 KiB (stage 15123.0: task 21030)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15123.0: task 21029)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 20 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 11.4 MiB (1131.0 KiB, 1173.3 KiB, 1199.5 KiB (stage 15121.0: task 21019)) 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)) 2.6 MiB (260.4 KiB, 268.7 KiB, 274.6 KiB (stage 15121.0: task 21019))"]; subgraph cluster85 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n237 ms (13 ms, 21 ms, 48 ms (stage 15121.0: task 21019))"; 86 [labelType="html" label=" Project "]; 87 [labelType="html" label="Filter number of output rows: 45,283"]; 88 [labelType="html" label="ColumnarToRow number of output rows: 45,283 number of input batches: 20"]; } 89 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 63 ms (5 ms, 7 ms, 8 ms (stage 15121.0: task 21020)) metadata time: 0 ms size of files read: 3.4 MiB number of output rows: 45,283"]; subgraph cluster90 { isCluster="true"; label="WholeStageCodegen (17)\n \nduration: total (min, med, max (stageId: taskId))\n9 ms (2 ms, 3 ms, 4 ms (stage 15133.0: task 21034))"; 91 [labelType="html" label=" Project "]; 92 [labelType="html" label="Filter number of output rows: 3"]; } 93 [labelType="html" label="Scan csv number of output rows: 3 number of files read: 1 metadata time: 0 ms size of files read: 175.0 B"]; subgraph cluster94 { isCluster="true"; label="WholeStageCodegen (20)\n \nduration: total (min, med, max (stageId: taskId))\n634 ms (51 ms, 61 ms, 83 ms (stage 15157.0: task 21069))"; 95 [labelType="html" label=" Project "]; 96 [labelType="html" label="Filter number of output rows: 102,866"]; 97 [labelType="html" label="ColumnarToRow number of output rows: 148,149 number of input batches: 40"]; } 98 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 127 ms (8 ms, 14 ms, 18 ms (stage 15157.0: task 21069)) metadata time: 0 ms size of files read: 8.6 MiB number of output rows: 148,149"]; 2->0; 3->2; 5->3; 6->5; 8->6; 9->8; 10->9; 12->10; 13->12; 14->13; 15->14; 16->15; 18->16; 19->18; 20->19; 22->20; 23->22; 24->23; 26->24; 27->26; 28->27; 30->28; 31->30; 32->31; 34->32; 35->34; 36->35; 38->36; 39->38; 40->39; 42->36; 43->42; 44->43; 46->28; 47->46; 48->47; 50->48; 51->50; 52->51; 53->52; 55->16; 56->55; 57->56; 58->57; 59->58; 60->59; 62->60; 63->62; 64->63; 66->64; 67->66; 68->67; 69->68; 71->60; 72->71; 73->72; 74->73; 75->74; 76->75; 78->76; 79->78; 80->79; 82->80; 83->82; 84->83; 86->84; 87->86; 88->87; 89->88; 91->15; 92->91; 93->92; 95->6; 96->95; 97->96; 98->97; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(1)])

WholeStageCodegen (22)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=669722]

HashAggregate(keys=[], functions=[partial_count(1)])

WholeStageCodegen (21)

Union

Project

Filter (NOT (str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 1, 105), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 138, 173))), COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676) <=> ) AND isnotnull(str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 1, 105), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 138, 173))), COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676)))

WholeStageCodegen (19)

Window [sum(COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, sum(COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350], [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674], [1 DESC NULLS LAST]

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

WholeStageCodegen (18)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, 10), ENSURE_REQUIREMENTS, [plan_id=668551]

CartesianProduct

Union

Project [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752 AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> A), COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1180876, 0.0) AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> A), COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1180957, 0.0) AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678]

Filter (str_if_with_rule(((COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787 <=> 1) OR isnotnull(COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286)), O, N) <=> N)

WholeStageCodegen (13)

Window [sum(COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1180876, sum(COL_484809BD_733B_4872_89AD_F55431EFA656#1180512) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1180957], [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757], [1 DESC NULLS LAST]

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

WholeStageCodegen (12)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, 10), ENSURE_REQUIREMENTS, [plan_id=668249]

Project [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> B) AND (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948 <=> N)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1180313, 0.0) AS COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> C) OR (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948 <=> O)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1180313, 0.0) AS COL_484809BD_733B_4872_89AD_F55431EFA656#1180512]

Project [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, 09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116 AS COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948, dec_if_with_rule(NOT (COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> A), dec_sum(array(CASE WHEN isnull(09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127) THEN 0.0 ELSE CASE WHEN isnan(09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127) THEN 0.0 ELSE 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127 END END, CASE WHEN isnull(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788) THEN 0.0 ELSE CASE WHEN isnan(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788) THEN 0.0 ELSE COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788 END END)), 0.0) AS COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1180313]

SortMergeJoin [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075], [09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123], LeftOuter

WholeStageCodegen (11)

Sort [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757 ASC NULLS FIRST, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 ASC NULLS FIRST, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075 ASC NULLS FIRST], false, 0

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, 10), ENSURE_REQUIREMENTS, [plan_id=667431]

Project [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> B)), str_if_with_rule((((((COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SIC) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SIM)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SAS)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SSN)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SSF)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, 68, 2), RIGHT), ), ) AS COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948]

Project [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, 14_E_REGLES_EFF_172829_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1179863 AS COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> B)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, 78, 5), RIGHT), ) AS COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958]

WholeStageCodegen (3)

CartesianProduct

Project [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1176670 AS COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1176674 AS COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1176675 AS COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1176725 AS COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1176724 AS COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1176670,COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1176674,COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1176675,COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1176724,COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1176725] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_172632], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_497B3BF1_A9CE_4411_8889_2F0461FEE049:string,COL_A213E432_2691_4225_8DF4_C45A67AF4D9C:s...

Project [APPLICABLE#1179437 AS 14_E_REGLES_EFF_172829_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1179863]

Filter (isnotnull(REGLES#1179436) AND (FP-TO-LC = REGLES#1179436))

WholeStageCodegen (2)

FileScan csv [REGLES#1179436,APPLICABLE#1179437] Batched: false, DataFilters: [isnotnull(REGLES#1179436), (FP-TO-LC = REGLES#1179436)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_172102/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,FP-TO-LC)], ReadSchema: struct<REGLES:string,APPLICABLE:string>

Sort [09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116 ASC NULLS FIRST, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121 ASC NULLS FIRST, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123 ASC NULLS FIRST], false, 0

WholeStageCodegen (10)

AQEShuffleRead coalesced

Exchange hashpartitioning(09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, 10), ENSURE_REQUIREMENTS, [plan_id=667463]

Project [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1174391 AS 09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1174396 AS 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1174398 AS 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1174402 AS 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127]

Filter (((((COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1174395 <=> -) AND isnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#1174406)) AND isnotnull(COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1174391)) AND isnotnull(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1174396)) AND isnotnull(COL_06545D41_928E_4A54_93BF_65904FCF81AA#1174398))

ColumnarToRow

WholeStageCodegen (4)

FileScan parquet [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1174391,COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1174395,COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1174396,COL_06545D41_928E_4A54_93BF_65904FCF81AA#1174398,COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1174402,COL_A2516838_D999_49FB_A245_E9F9B72D742A#1174406] Batched: true, DataFilters: [(COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1174395 <=> -), isnull(COL_A2516838_D999_49FB_A245_E9F..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/06_COMPILATION__172800], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7,-), IsNull(COL_A2516838_D999_49FB_A245_E9..., ReadSchema: struct<COL_EB47ADCA_4440_4090_8691_F8499DB4555E:string,COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7:s...

Project [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1185462, str_concat(array(str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPU)), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1175622, @MntRembAMO, 00000000), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1175622, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#1174844), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#1174844), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)), COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1175351)) AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#1185464, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840 AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1185465, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841 AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1185466]

Project [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1175351, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPU)), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1175593, @TauxApp, 000), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1175593, @TauxApp, 100)) AS COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1175622]

Project [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPU)), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1175062, @MntRembAMO, 00000000), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1175062, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)) AS COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1175351, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> B), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522 <=> ), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, @SpeExec, 01), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, , 5, RIGHT)), @Quantité, 001), @Coefficient, 000100), @TypePrest, ), @CoefMCO, 00000), @Denomb, 01), @PrixUnitaire, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., RIGHT), 0, 2, RIGHT)))) AS COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1175593]

Project [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> B), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, 0.0) AS COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> C), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, 0.0) AS COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, 02_F_TRONC_COMM_172701_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1174600 AS COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> B), COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526, 0.0) AS COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> C), COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526, 0.0) AS COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845, str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> C), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522 <=> ), str_replace(02_F_TRONC_COMM_172701_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174599, @SpeExec, 01), str_replace(02_F_TRONC_COMM_172701_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174599, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, , 5, RIGHT)), @Quantité, 001), @Coefficient, 000100), @Denomb, 01), @PrixUnitaire, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., RIGHT), 0, 2, RIGHT)))) AS COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1175034]

SortMergeJoin [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515], [02_F_TRONC_COMM_172701_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174597], LeftOuter

WholeStageCodegen (16)

Sort [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515 ASC NULLS FIRST], false, 0

WholeStageCodegen (14)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, 10), ENSURE_REQUIREMENTS, [plan_id=667492]

Project [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1181649 AS COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1181654 AS COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1181656 AS COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1181657 AS COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1181659 AS COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1181660 AS COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1181665 AS COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526]

Filter (COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1181653 <=> +)

ColumnarToRow

WholeStageCodegen (5)

FileScan parquet [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1181649,COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1181653,COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1181654,COL_06545D41_928E_4A54_93BF_65904FCF81AA#1181656,COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1181657,COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1181659,COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1181660,COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1181665] Batched: true, DataFilters: [(COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1181653 <=> +)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/06_COMPILATION__172800], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7,+)], ReadSchema: struct<COL_EB47ADCA_4440_4090_8691_F8499DB4555E:string,COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7:s...

Sort [02_F_TRONC_COMM_172701_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174597 ASC NULLS FIRST], false, 0

Project [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174345 AS 02_F_TRONC_COMM_172701_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174597, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174366 AS 02_F_TRONC_COMM_172701_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174599, str_if_with_rule(((COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1174359 <=> ) OR isnull(COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1174359)), str_concat(array(B, str_extract_middle(COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174366, 2, 66), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@TypePrest@CoefMCO@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_complete( , , 15, LEFT), str_extract_middle(COL_658F143C_7372_42DE_925A_644EBED14EE5#1174353, 302, 9))), COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1174359) AS 02_F_TRONC_COMM_172701_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1174600]

WholeStageCodegen (15)

ObjectHashAggregate(keys=[COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210], functions=[collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305, 0, 0), collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, 0, 0), collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, 10), ENSURE_REQUIREMENTS, [plan_id=668044]

ObjectHashAggregate(keys=[COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210], functions=[partial_collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305, 0, 0), partial_collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, 0, 0), partial_collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, 0, 0)])

Project [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209 <=> C), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, LEFT, 67), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_extract_middle(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, 135, 27))), null) AS COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209 <=> B), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, LEFT, 67), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@TypePrest@CoefMCO@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_extract_middle(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, 141, 24))), null) AS COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209 <=> A), COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, null) AS COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305]

Filter (COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1174222 <=> 1)

WholeStageCodegen (8)

Window [row_number() windowspecdefinition(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1174222], [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209], [1 DESC NULLS LAST]

Sort [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210 ASC NULLS FIRST, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, 10), ENSURE_REQUIREMENTS, [plan_id=667513]

Project [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1173929 AS COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1173933 AS COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934 AS COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]

Filter isnotnull(COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934)

ColumnarToRow

WholeStageCodegen (6)

FileScan parquet [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1173929,COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1173933,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934] Batched: true, DataFilters: [isnotnull(COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_172496], PartitionFilters: [], PushedFilters: [IsNotNull(COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB)], ReadSchema: struct<COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA:string,COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56:s...

Project

Filter (isnotnull(REGLES#1181712) AND (FP-TO-LC = REGLES#1181712))

WholeStageCodegen (17)

FileScan csv [REGLES#1181712] Batched: false, DataFilters: [isnotnull(REGLES#1181712), (FP-TO-LC = REGLES#1181712)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_172102/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,FP-TO-LC)], ReadSchema: struct<REGLES:string>

Project

Filter (((COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1176314 <=> Non Eligible) AND NOT (COL_016E6242_B446_46F7_97DC_5F775D66196E#1176304 <=> )) AND isnotnull(COL_016E6242_B446_46F7_97DC_5F775D66196E#1176304))

ColumnarToRow

WholeStageCodegen (20)

FileScan parquet [COL_016E6242_B446_46F7_97DC_5F775D66196E#1176304,COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1176314] Batched: true, DataFilters: [(COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1176314 <=> Non Eligible), NOT (COL_016E6242_B446_46F7..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_D_DETERMINAT_172725], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_FC10C112_88B1_45B9_AA4E_B279540F2D09,Non Eligible), Not(EqualNullSafe(COL_016E..., ReadSchema: struct<COL_016E6242_B446_46F7_97DC_5F775D66196E:string,COL_FC10C112_88B1_45B9_AA4E_B279540F2D09:s...

Details

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


(1) Scan parquet 
Output [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1176670, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1176674, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1176675, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1176724, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1176725]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_172632]
ReadSchema: struct<COL_497B3BF1_A9CE_4411_8889_2F0461FEE049:string,COL_A213E432_2691_4225_8DF4_C45A67AF4D9C:string,COL_E3EB948B_0B85_4F37_970A_DD334B343EE2:string,COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E:double,COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC:string>

(2) ColumnarToRow [codegen id : 1]
Input [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1176670, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1176674, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1176675, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1176724, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1176725]

(3) Project [codegen id : 1]
Output [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1176670 AS COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1176674 AS COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1176675 AS COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1176725 AS COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1176724 AS COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788]
Input [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1176670, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1176674, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1176675, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1176724, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1176725]

(4) Scan csv 
Output [2]: [REGLES#1179436, APPLICABLE#1179437]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_172102/REGLES-A-TTT new Aigle.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,FP-TO-LC)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(5) Filter [codegen id : 2]
Input [2]: [REGLES#1179436, APPLICABLE#1179437]
Condition : (isnotnull(REGLES#1179436) AND (FP-TO-LC = REGLES#1179436))

(6) Project [codegen id : 2]
Output [1]: [APPLICABLE#1179437 AS 14_E_REGLES_EFF_172829_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1179863]
Input [2]: [REGLES#1179436, APPLICABLE#1179437]

(7) CartesianProduct
Join type: Inner
Join condition: None

(8) Project [codegen id : 3]
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, 14_E_REGLES_EFF_172829_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1179863 AS COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> B)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, 78, 5), RIGHT), ) AS COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958]
Input [6]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, 14_E_REGLES_EFF_172829_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1179863]

(9) Project [codegen id : 3]
Output [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> B)), str_if_with_rule((((((COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SIC) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SIM)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SAS)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SSN)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SSF)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, 68, 2), RIGHT), ), ) AS COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958]

(10) Exchange
Input [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948]
Arguments: hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, 10), ENSURE_REQUIREMENTS, [plan_id=667431]

(11) ShuffleQueryStage
Output [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948]
Arguments: 0

(12) AQEShuffleRead
Input [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948]
Arguments: coalesced

(13) Sort [codegen id : 9]
Input [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948]
Arguments: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757 ASC NULLS FIRST, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 ASC NULLS FIRST, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075 ASC NULLS FIRST], false, 0

(14) Scan parquet 
Output [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1174391, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1174395, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1174396, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1174398, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1174402, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1174406]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/06_COMPILATION__172800]
PushedFilters: [EqualNullSafe(COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7,-), IsNull(COL_A2516838_D999_49FB_A245_E9F9B72D742A), IsNotNull(COL_EB47ADCA_4440_4090_8691_F8499DB4555E), IsNotNull(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E), IsNotNull(COL_06545D41_928E_4A54_93BF_65904FCF81AA)]
ReadSchema: struct<COL_EB47ADCA_4440_4090_8691_F8499DB4555E:string,COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7:string,COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E:string,COL_06545D41_928E_4A54_93BF_65904FCF81AA:string,COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6:double,COL_A2516838_D999_49FB_A245_E9F9B72D742A:int>

(15) ColumnarToRow [codegen id : 4]
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1174391, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1174395, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1174396, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1174398, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1174402, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1174406]

(16) Filter [codegen id : 4]
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1174391, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1174395, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1174396, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1174398, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1174402, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1174406]
Condition : (((((COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1174395 <=> -) AND isnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#1174406)) AND isnotnull(COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1174391)) AND isnotnull(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1174396)) AND isnotnull(COL_06545D41_928E_4A54_93BF_65904FCF81AA#1174398))

(17) Project [codegen id : 4]
Output [4]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1174391 AS 09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1174396 AS 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1174398 AS 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1174402 AS 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127]
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1174391, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1174395, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1174396, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1174398, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1174402, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1174406]

(18) Exchange
Input [4]: [09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127]
Arguments: hashpartitioning(09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, 10), ENSURE_REQUIREMENTS, [plan_id=667463]

(19) ShuffleQueryStage
Output [4]: [09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127]
Arguments: 1

(20) AQEShuffleRead
Input [4]: [09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127]
Arguments: coalesced

(21) Sort [codegen id : 10]
Input [4]: [09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127]
Arguments: [09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116 ASC NULLS FIRST, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121 ASC NULLS FIRST, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123 ASC NULLS FIRST], false, 0

(22) SortMergeJoin [codegen id : 11]
Left keys [3]: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075]
Right keys [3]: [09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123]
Join type: LeftOuter
Join condition: None

(23) Project [codegen id : 11]
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, 09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116 AS COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948, dec_if_with_rule(NOT (COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> A), dec_sum(array(CASE WHEN isnull(09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127) THEN 0.0 ELSE CASE WHEN isnan(09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127) THEN 0.0 ELSE 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127 END END, CASE WHEN isnull(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788) THEN 0.0 ELSE CASE WHEN isnan(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788) THEN 0.0 ELSE COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788 END END)), 0.0) AS COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1180313]
Input [12]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948, 09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127]

(24) Project [codegen id : 11]
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> B) AND (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948 <=> N)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1180313, 0.0) AS COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> C) OR (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948 <=> O)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1180313, 0.0) AS COL_484809BD_733B_4872_89AD_F55431EFA656#1180512]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948, COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1180313]

(25) Exchange
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, COL_484809BD_733B_4872_89AD_F55431EFA656#1180512]
Arguments: hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, 10), ENSURE_REQUIREMENTS, [plan_id=668249]

(26) ShuffleQueryStage
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, COL_484809BD_733B_4872_89AD_F55431EFA656#1180512]
Arguments: 5

(27) AQEShuffleRead
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, COL_484809BD_733B_4872_89AD_F55431EFA656#1180512]
Arguments: coalesced

(28) Sort [codegen id : 12]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, COL_484809BD_733B_4872_89AD_F55431EFA656#1180512]
Arguments: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(29) Window
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, COL_484809BD_733B_4872_89AD_F55431EFA656#1180512]
Arguments: [sum(COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1180876, sum(COL_484809BD_733B_4872_89AD_F55431EFA656#1180512) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1180957], [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757], [1 DESC NULLS LAST]

(30) Filter [codegen id : 13]
Input [9]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, COL_484809BD_733B_4872_89AD_F55431EFA656#1180512, COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1180876, COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1180957]
Condition : (str_if_with_rule(((COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787 <=> 1) OR isnotnull(COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286)), O, N) <=> N)

(31) Project [codegen id : 13]
Output [4]: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752 AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> A), COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1180876, 0.0) AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> A), COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1180957, 0.0) AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678]
Input [9]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, COL_484809BD_733B_4872_89AD_F55431EFA656#1180512, COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1180876, COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1180957]

(32) Scan parquet 
Output [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1181649, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1181653, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1181654, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1181656, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1181657, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1181659, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1181660, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1181665]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/06_COMPILATION__172800]
PushedFilters: [EqualNullSafe(COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7,+)]
ReadSchema: struct<COL_EB47ADCA_4440_4090_8691_F8499DB4555E:string,COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7:string,COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E:string,COL_06545D41_928E_4A54_93BF_65904FCF81AA:string,COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394:timestamp,COL_6FA3C539_F981_4B55_80EE_5B06D96ED482:string,COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6:double,COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299:double>

(33) ColumnarToRow [codegen id : 5]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1181649, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1181653, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1181654, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1181656, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1181657, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1181659, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1181660, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1181665]

(34) Filter [codegen id : 5]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1181649, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1181653, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1181654, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1181656, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1181657, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1181659, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1181660, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1181665]
Condition : (COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1181653 <=> +)

(35) Project [codegen id : 5]
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1181649 AS COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1181654 AS COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1181656 AS COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1181657 AS COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1181659 AS COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1181660 AS COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1181665 AS COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1181649, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1181653, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1181654, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1181656, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1181657, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1181659, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1181660, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1181665]

(36) Exchange
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526]
Arguments: hashpartitioning(COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, 10), ENSURE_REQUIREMENTS, [plan_id=667492]

(37) ShuffleQueryStage
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526]
Arguments: 2

(38) AQEShuffleRead
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526]
Arguments: coalesced

(39) Sort [codegen id : 14]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526]
Arguments: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515 ASC NULLS FIRST], false, 0

(40) Scan parquet 
Output [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1173929, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1173933, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_172496]
PushedFilters: [IsNotNull(COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB)]
ReadSchema: struct<COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA:string,COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56:string,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB:string>

(41) ColumnarToRow [codegen id : 6]
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1173929, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1173933, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934]

(42) Filter [codegen id : 6]
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1173929, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1173933, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934]
Condition : isnotnull(COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934)

(43) Project [codegen id : 6]
Output [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1173929 AS COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1173933 AS COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934 AS COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1173929, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1173933, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934]

(44) Exchange
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Arguments: hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, 10), ENSURE_REQUIREMENTS, [plan_id=667513]

(45) ShuffleQueryStage
Output [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Arguments: 3

(46) AQEShuffleRead
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Arguments: coalesced

(47) Sort [codegen id : 7]
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Arguments: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210 ASC NULLS FIRST, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(48) Window
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Arguments: [row_number() windowspecdefinition(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1174222], [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209], [1 DESC NULLS LAST]

(49) Filter [codegen id : 8]
Input [4]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1174222]
Condition : (COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1174222 <=> 1)

(50) Project [codegen id : 8]
Output [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209 <=> C), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, LEFT, 67), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_extract_middle(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, 135, 27))), null) AS COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209 <=> B), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, LEFT, 67), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@TypePrest@CoefMCO@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_extract_middle(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, 141, 24))), null) AS COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209 <=> A), COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, null) AS COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305]
Input [4]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1174222]

(51) ObjectHashAggregate
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305]
Keys [1]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Functions [3]: [partial_collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305, 0, 0), partial_collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, 0, 0), partial_collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, 0, 0)]
Aggregate Attributes [3]: [buf#1185637, buf#1185638, buf#1185639]
Results [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, buf#1185640, buf#1185641, buf#1185642]

(52) Exchange
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, buf#1185640, buf#1185641, buf#1185642]
Arguments: hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, 10), ENSURE_REQUIREMENTS, [plan_id=668044]

(53) ShuffleQueryStage
Output [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, buf#1185640, buf#1185641, buf#1185642]
Arguments: 4

(54) AQEShuffleRead
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, buf#1185640, buf#1185641, buf#1185642]
Arguments: coalesced

(55) ObjectHashAggregate
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, buf#1185640, buf#1185641, buf#1185642]
Keys [1]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Functions [3]: [collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305, 0, 0), collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, 0, 0), collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, 0, 0)]
Aggregate Attributes [3]: [collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305, 0, 0)#1174321, collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, 0, 0)#1174323, collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, 0, 0)#1174325]
Results [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210 AS COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174345, str_remove_space(str_list_get(collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305, 0, 0)#1174321, 0), LEFT) AS COL_658F143C_7372_42DE_925A_644EBED14EE5#1174353, str_remove_space(str_list_get(collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, 0, 0)#1174323, 0), LEFT) AS COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1174359, str_remove_space(str_list_get(collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, 0, 0)#1174325, 0), LEFT) AS COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174366]

(56) Project [codegen id : 15]
Output [3]: [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174345 AS 02_F_TRONC_COMM_172701_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174597, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174366 AS 02_F_TRONC_COMM_172701_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174599, str_if_with_rule(((COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1174359 <=> ) OR isnull(COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1174359)), str_concat(array(B, str_extract_middle(COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174366, 2, 66), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@TypePrest@CoefMCO@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_complete( ,  , 15, LEFT), str_extract_middle(COL_658F143C_7372_42DE_925A_644EBED14EE5#1174353, 302, 9))), COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1174359) AS 02_F_TRONC_COMM_172701_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1174600]
Input [4]: [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174345, COL_658F143C_7372_42DE_925A_644EBED14EE5#1174353, COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1174359, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174366]

(57) Sort [codegen id : 15]
Input [3]: [02_F_TRONC_COMM_172701_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174597, 02_F_TRONC_COMM_172701_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174599, 02_F_TRONC_COMM_172701_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1174600]
Arguments: [02_F_TRONC_COMM_172701_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174597 ASC NULLS FIRST], false, 0

(58) SortMergeJoin [codegen id : 16]
Left keys [1]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515]
Right keys [1]: [02_F_TRONC_COMM_172701_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174597]
Join type: LeftOuter
Join condition: None

(59) Project [codegen id : 16]
Output [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> B), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, 0.0) AS COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> C), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, 0.0) AS COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, 02_F_TRONC_COMM_172701_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1174600 AS COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> B), COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526, 0.0) AS COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> C), COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526, 0.0) AS COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845, str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> C), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522 <=> ), str_replace(02_F_TRONC_COMM_172701_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174599, @SpeExec, 01), str_replace(02_F_TRONC_COMM_172701_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174599, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520,  , 5, RIGHT)), @Quantité, 001), @Coefficient, 000100), @Denomb, 01), @PrixUnitaire, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., RIGHT), 0, 2, RIGHT)))) AS COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1175034]
Input [10]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526, 02_F_TRONC_COMM_172701_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174597, 02_F_TRONC_COMM_172701_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174599, 02_F_TRONC_COMM_172701_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1174600]

(60) Project [codegen id : 16]
Output [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPU) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPL)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPM)), str_replace(COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1175034, @TauxApp, 000), str_replace(COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1175034, @TauxApp, 100)) AS COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1175062]
Input [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845, COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1175034]

(61) Project [codegen id : 16]
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPU)), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1175062, @MntRembAMO, 00000000), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1175062, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)) AS COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1175351, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> B), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522 <=> ), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, @SpeExec, 01), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520,  , 5, RIGHT)), @Quantité, 001), @Coefficient, 000100), @TypePrest,  ), @CoefMCO, 00000), @Denomb, 01), @PrixUnitaire, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., RIGHT), 0, 2, RIGHT)))) AS COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1175593]
Input [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845, COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1175062]

(62) Project [codegen id : 16]
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1175351, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPU)), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1175593, @TauxApp, 000), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1175593, @TauxApp, 100)) AS COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1175622]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1175351, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1175593]

(63) Project [codegen id : 16]
Output [4]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1185462, str_concat(array(str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPU)), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1175622, @MntRembAMO, 00000000), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1175622, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#1174844), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#1174844), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)), COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1175351)) AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#1185464, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840 AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1185465, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841 AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1185466]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1175351, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1175622]

(64) Union

(65) Scan csv 
Output [1]: [REGLES#1181712]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_172102/REGLES-A-TTT new Aigle.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,FP-TO-LC)]
ReadSchema: struct<REGLES:string>

(66) Filter [codegen id : 17]
Input [1]: [REGLES#1181712]
Condition : (isnotnull(REGLES#1181712) AND (FP-TO-LC = REGLES#1181712))

(67) Project [codegen id : 17]
Output: []
Input [1]: [REGLES#1181712]

(68) CartesianProduct
Join type: Inner
Join condition: None

(69) Exchange
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678]
Arguments: hashpartitioning(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, 10), ENSURE_REQUIREMENTS, [plan_id=668551]

(70) ShuffleQueryStage
Output [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678]
Arguments: 6

(71) AQEShuffleRead
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678]
Arguments: coalesced

(72) Sort [codegen id : 18]
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678]
Arguments: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(73) Window
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678]
Arguments: [sum(COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, sum(COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350], [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674], [1 DESC NULLS LAST]

(74) Filter [codegen id : 19]
Input [6]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678, COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350]
Condition : (NOT (str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 1, 105), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 138, 173))), COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676) <=> ) AND isnotnull(str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 1, 105), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 138, 173))), COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676)))

(75) Project [codegen id : 19]
Output: []
Input [6]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678, COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350]

(76) Scan parquet 
Output [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1176304, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1176314]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_D_DETERMINAT_172725]
PushedFilters: [EqualNullSafe(COL_FC10C112_88B1_45B9_AA4E_B279540F2D09,Non Eligible), Not(EqualNullSafe(COL_016E6242_B446_46F7_97DC_5F775D66196E,)), IsNotNull(COL_016E6242_B446_46F7_97DC_5F775D66196E)]
ReadSchema: struct<COL_016E6242_B446_46F7_97DC_5F775D66196E:string,COL_FC10C112_88B1_45B9_AA4E_B279540F2D09:string>

(77) ColumnarToRow [codegen id : 20]
Input [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1176304, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1176314]

(78) Filter [codegen id : 20]
Input [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1176304, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1176314]
Condition : (((COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1176314 <=> Non Eligible) AND NOT (COL_016E6242_B446_46F7_97DC_5F775D66196E#1176304 <=> )) AND isnotnull(COL_016E6242_B446_46F7_97DC_5F775D66196E#1176304))

(79) Project [codegen id : 20]
Output: []
Input [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1176304, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1176314]

(80) Union

(81) HashAggregate [codegen id : 21]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1185635L]
Results [1]: [count#1185636L]

(82) Exchange
Input [1]: [count#1185636L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=669722]

(83) ShuffleQueryStage
Output [1]: [count#1185636L]
Arguments: 7

(84) HashAggregate [codegen id : 22]
Input [1]: [count#1185636L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1185432L]
Results [1]: [count(1)#1185432L AS count#1185433L]

(85) Project
Output [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1176670 AS COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1176674 AS COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1176675 AS COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1176725 AS COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1176724 AS COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788]
Input [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1176670, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1176674, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1176675, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1176724, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1176725]

(86) Filter
Input [2]: [REGLES#1179436, APPLICABLE#1179437]
Condition : (isnotnull(REGLES#1179436) AND (FP-TO-LC = REGLES#1179436))

(87) Project
Output [1]: [APPLICABLE#1179437 AS 14_E_REGLES_EFF_172829_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1179863]
Input [2]: [REGLES#1179436, APPLICABLE#1179437]

(88) CartesianProduct
Join type: Inner
Join condition: None

(89) Project
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, 14_E_REGLES_EFF_172829_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1179863 AS COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> B)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, 78, 5), RIGHT), ) AS COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958]
Input [6]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, 14_E_REGLES_EFF_172829_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1179863]

(90) Project
Output [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> B)), str_if_with_rule((((((COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SIC) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SIM)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SAS)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SSN)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 <=> SSF)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, 68, 2), RIGHT), ), ) AS COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958]

(91) Exchange
Input [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948]
Arguments: hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, 10), ENSURE_REQUIREMENTS, [plan_id=667254]

(92) Sort
Input [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948]
Arguments: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757 ASC NULLS FIRST, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958 ASC NULLS FIRST, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075 ASC NULLS FIRST], false, 0

(93) Filter
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1174391, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1174395, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1174396, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1174398, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1174402, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1174406]
Condition : (((((COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1174395 <=> -) AND isnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#1174406)) AND isnotnull(COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1174391)) AND isnotnull(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1174396)) AND isnotnull(COL_06545D41_928E_4A54_93BF_65904FCF81AA#1174398))

(94) Project
Output [4]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1174391 AS 09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1174396 AS 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1174398 AS 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1174402 AS 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127]
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1174391, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1174395, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1174396, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1174398, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1174402, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1174406]

(95) Exchange
Input [4]: [09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127]
Arguments: hashpartitioning(09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, 10), ENSURE_REQUIREMENTS, [plan_id=667255]

(96) Sort
Input [4]: [09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127]
Arguments: [09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116 ASC NULLS FIRST, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121 ASC NULLS FIRST, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123 ASC NULLS FIRST], false, 0

(97) SortMergeJoin
Left keys [3]: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075]
Right keys [3]: [09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123]
Join type: LeftOuter
Join condition: None

(98) Project
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, 09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116 AS COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948, dec_if_with_rule(NOT (COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> A), dec_sum(array(CASE WHEN isnull(09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127) THEN 0.0 ELSE CASE WHEN isnan(09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127) THEN 0.0 ELSE 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127 END END, CASE WHEN isnull(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788) THEN 0.0 ELSE CASE WHEN isnan(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788) THEN 0.0 ELSE COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788 END END)), 0.0) AS COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1180313]
Input [12]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1179958, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1180075, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1179788, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948, 09_A_LES_ACTES__172745_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1180116, 09_A_LES_ACTES__172745_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1180121, 09_A_LES_ACTES__172745_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1180123, 09_A_LES_ACTES__172745_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1180127]

(99) Project
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> B) AND (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948 <=> N)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1180313, 0.0) AS COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> C) OR (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948 <=> O)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1180313, 0.0) AS COL_484809BD_733B_4872_89AD_F55431EFA656#1180512]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1179948, COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1180313]

(100) Exchange
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, COL_484809BD_733B_4872_89AD_F55431EFA656#1180512]
Arguments: hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, 10), ENSURE_REQUIREMENTS, [plan_id=667262]

(101) Sort
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, COL_484809BD_733B_4872_89AD_F55431EFA656#1180512]
Arguments: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(102) Window
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, COL_484809BD_733B_4872_89AD_F55431EFA656#1180512]
Arguments: [sum(COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1180876, sum(COL_484809BD_733B_4872_89AD_F55431EFA656#1180512) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1180957], [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757], [1 DESC NULLS LAST]

(103) Filter
Input [9]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, COL_484809BD_733B_4872_89AD_F55431EFA656#1180512, COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1180876, COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1180957]
Condition : (str_if_with_rule(((COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787 <=> 1) OR isnotnull(COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286)), O, N) <=> N)

(104) Project
Output [4]: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752 AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> A), COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1180876, 0.0) AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756 <=> A), COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1180957, 0.0) AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678]
Input [9]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1179752, COL_49C593BD_38E0_430F_B107_3316C1E82875#1179756, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1179757, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1180286, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1179787, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1180511, COL_484809BD_733B_4872_89AD_F55431EFA656#1180512, COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1180876, COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1180957]

(105) Filter
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1181649, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1181653, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1181654, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1181656, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1181657, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1181659, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1181660, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1181665]
Condition : (COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1181653 <=> +)

(106) Project
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1181649 AS COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1181654 AS COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1181656 AS COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1181657 AS COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1181659 AS COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1181660 AS COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1181665 AS COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1181649, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1181653, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1181654, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1181656, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1181657, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1181659, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1181660, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1181665]

(107) Exchange
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526]
Arguments: hashpartitioning(COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, 10), ENSURE_REQUIREMENTS, [plan_id=667279]

(108) Sort
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526]
Arguments: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515 ASC NULLS FIRST], false, 0

(109) Filter
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1173929, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1173933, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934]
Condition : isnotnull(COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934)

(110) Project
Output [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1173929 AS COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1173933 AS COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934 AS COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1173929, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1173933, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1173934]

(111) Exchange
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Arguments: hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, 10), ENSURE_REQUIREMENTS, [plan_id=667267]

(112) Sort
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Arguments: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210 ASC NULLS FIRST, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(113) Window
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Arguments: [row_number() windowspecdefinition(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1174222], [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209], [1 DESC NULLS LAST]

(114) Filter
Input [4]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1174222]
Condition : (COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1174222 <=> 1)

(115) Project
Output [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209 <=> C), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, LEFT, 67), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_extract_middle(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, 135, 27))), null) AS COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209 <=> B), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, LEFT, 67), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@TypePrest@CoefMCO@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_extract_middle(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, 141, 24))), null) AS COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209 <=> A), COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, null) AS COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305]
Input [4]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1174208, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1174209, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1174222]

(116) ObjectHashAggregate
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305]
Keys [1]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Functions [3]: [partial_collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305, 0, 0), partial_collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, 0, 0), partial_collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, 0, 0)]
Aggregate Attributes [3]: [buf#1185637, buf#1185638, buf#1185639]
Results [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, buf#1185640, buf#1185641, buf#1185642]

(117) Exchange
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, buf#1185640, buf#1185641, buf#1185642]
Arguments: hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, 10), ENSURE_REQUIREMENTS, [plan_id=667274]

(118) ObjectHashAggregate
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210, buf#1185640, buf#1185641, buf#1185642]
Keys [1]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210]
Functions [3]: [collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305, 0, 0), collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, 0, 0), collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, 0, 0)]
Aggregate Attributes [3]: [collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305, 0, 0)#1174321, collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, 0, 0)#1174323, collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, 0, 0)#1174325]
Results [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1174210 AS COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174345, str_remove_space(str_list_get(collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1174305, 0, 0)#1174321, 0), LEFT) AS COL_658F143C_7372_42DE_925A_644EBED14EE5#1174353, str_remove_space(str_list_get(collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1174304, 0, 0)#1174323, 0), LEFT) AS COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1174359, str_remove_space(str_list_get(collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1174303, 0, 0)#1174325, 0), LEFT) AS COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174366]

(119) Project
Output [3]: [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174345 AS 02_F_TRONC_COMM_172701_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174597, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174366 AS 02_F_TRONC_COMM_172701_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174599, str_if_with_rule(((COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1174359 <=> ) OR isnull(COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1174359)), str_concat(array(B, str_extract_middle(COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174366, 2, 66), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@TypePrest@CoefMCO@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_complete( ,  , 15, LEFT), str_extract_middle(COL_658F143C_7372_42DE_925A_644EBED14EE5#1174353, 302, 9))), COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1174359) AS 02_F_TRONC_COMM_172701_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1174600]
Input [4]: [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174345, COL_658F143C_7372_42DE_925A_644EBED14EE5#1174353, COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1174359, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174366]

(120) Sort
Input [3]: [02_F_TRONC_COMM_172701_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174597, 02_F_TRONC_COMM_172701_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174599, 02_F_TRONC_COMM_172701_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1174600]
Arguments: [02_F_TRONC_COMM_172701_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174597 ASC NULLS FIRST], false, 0

(121) SortMergeJoin
Left keys [1]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515]
Right keys [1]: [02_F_TRONC_COMM_172701_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174597]
Join type: LeftOuter
Join condition: None

(122) Project
Output [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> B), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, 0.0) AS COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> C), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, 0.0) AS COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, 02_F_TRONC_COMM_172701_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1174600 AS COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> B), COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526, 0.0) AS COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> C), COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526, 0.0) AS COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845, str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> C), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522 <=> ), str_replace(02_F_TRONC_COMM_172701_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174599, @SpeExec, 01), str_replace(02_F_TRONC_COMM_172701_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174599, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520,  , 5, RIGHT)), @Quantité, 001), @Coefficient, 000100), @Denomb, 01), @PrixUnitaire, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., RIGHT), 0, 2, RIGHT)))) AS COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1175034]
Input [10]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1174526, 02_F_TRONC_COMM_172701_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1174597, 02_F_TRONC_COMM_172701_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1174599, 02_F_TRONC_COMM_172701_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1174600]

(123) Project
Output [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPU) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPL)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPM)), str_replace(COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1175034, @TauxApp, 000), str_replace(COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1175034, @TauxApp, 100)) AS COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1175062]
Input [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845, COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1175034]

(124) Project
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPU)), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1175062, @MntRembAMO, 00000000), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1175062, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)) AS COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1175351, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524 <=> B), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522 <=> ), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, @SpeExec, 01), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520,  , 5, RIGHT)), @Quantité, 001), @Coefficient, 000100), @TypePrest,  ), @CoefMCO, 00000), @Denomb, 01), @PrixUnitaire, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., RIGHT), 0, 2, RIGHT)))) AS COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1175593]
Input [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1174522, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1174523, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1174524, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1174525, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, COL_2B929673_22CB_450B_B74A_0F768B941049#1174842, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, COL_E88F299F_F911_45D3_9E58_F11F3531B510#1174845, COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1175062]

(125) Project
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1175351, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPU)), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1175593, @TauxApp, 000), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1175593, @TauxApp, 100)) AS COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1175622]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1175351, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1175593]

(126) Project
Output [4]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1185462, str_concat(array(str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520 <=> FPU)), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1175622, @MntRembAMO, 00000000), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1175622, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#1174844), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#1174844), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)), COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1175351)) AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#1185464, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840 AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1185465, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841 AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1185466]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1174515, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1174520, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1174840, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1174841, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1175351, COL_14988743_983B_477F_9919_A2848C8D7B09#1174844, COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1175622]

(127) Union

(128) Filter
Input [1]: [REGLES#1181712]
Condition : (isnotnull(REGLES#1181712) AND (FP-TO-LC = REGLES#1181712))

(129) Project
Output: []
Input [1]: [REGLES#1181712]

(130) CartesianProduct
Join type: Inner
Join condition: None

(131) Exchange
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678]
Arguments: hashpartitioning(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, 10), ENSURE_REQUIREMENTS, [plan_id=667291]

(132) Sort
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678]
Arguments: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(133) Window
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678]
Arguments: [sum(COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, sum(COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350], [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674], [1 DESC NULLS LAST]

(134) Filter
Input [6]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678, COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350]
Condition : (NOT (str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 1, 105), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 138, 173))), COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676) <=> ) AND isnotnull(str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 1, 105), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_concat(array(str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, 138, 173))), COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676)))

(135) Project
Output: []
Input [6]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1181674, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1181676, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1181677, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1181678, COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1181813, COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1182350]

(136) Filter
Input [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1176304, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1176314]
Condition : (((COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1176314 <=> Non Eligible) AND NOT (COL_016E6242_B446_46F7_97DC_5F775D66196E#1176304 <=> )) AND isnotnull(COL_016E6242_B446_46F7_97DC_5F775D66196E#1176304))

(137) Project
Output: []
Input [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1176304, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1176314]

(138) Union

(139) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1185635L]
Results [1]: [count#1185636L]

(140) Exchange
Input [1]: [count#1185636L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=667299]

(141) HashAggregate
Input [1]: [count#1185636L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1185432L]
Results [1]: [count(1)#1185432L AS count#1185433L]

(142) AdaptiveSparkPlan
Output [1]: [count#1185433L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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