SP1 - Details for Query 2902

Submitted Time: 2026/09/22 06:28:07
Duration: 11 s
Succeeded Jobs: 4244 4245 4246 4247 4248 4249 4250 4257 4260

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: 0 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: 20 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 8 ms (0 ms, 0 ms, 1 ms (stage 8607.0: task 11814)) 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: 20 local bytes read: 1180.0 B fetch wait time: 0 ms 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)) 320.0 B (16.0 B, 16.0 B, 16.0 B (stage 8607.0: task 11807)) 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)) 1180.0 B (59.0 B, 59.0 B, 59.0 B (stage 8607.0: task 11807))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (21)\n \nduration: total (min, med, max (stageId: taskId))\n1.1 m (188 ms, 6.0 s, 6.9 s (stage 8607.0: task 11818))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 1.1 m (188 ms, 6.0 s, 6.9 s (stage 8607.0: task 11818)) number of output rows: 20"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (19)\n \nduration: total (min, med, max (stageId: taskId))\n1.1 m (6.0 s, 6.3 s, 6.9 s (stage 8607.0: task 11818))"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 262,405"]; } 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 8607.0: task 11814))"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (18)\n \nduration: total (min, med, max (stageId: taskId))\n1.2 m (6.6 s, 7.1 s, 7.5 s (stage 8607.0: task 11818))"; 12 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 11 ms (1 ms, 1 ms, 2 ms (stage 8607.0: task 11810)) peak memory total (min, med, max (stageId: taskId)) 170.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 8607.0: task 11814)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 8607.0: task 11814))"]; } 13 [labelType="html" label="Exchange shuffle records written: 262,408 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 59 ms (0 ms, 4 ms, 11 ms (stage 8590.0: task 11751)) 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: 262,408 local bytes read total (min, med, max (stageId: taskId)) 10.4 MiB (1037.5 KiB, 1066.1 KiB, 1087.1 KiB (stage 8607.0: task 11816)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 8607.0: task 11814)) 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)) 64.7 MiB (139.6 KiB, 6.4 MiB, 6.5 MiB (stage 8590.0: task 11749)) 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)) 10.4 MiB (32.7 KiB, 1037.6 KiB, 1068.9 KiB (stage 8590.0: task 11749))"]; 14 [labelType="html" label="CartesianProduct number of output rows: 262,408"]; 15 [labelType="html" label=" Union "]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: total (min, med, max (stageId: taskId))\n3.2 s (306 ms, 327 ms, 338 ms (stage 8590.0: task 11744))"; 17 [labelType="html" label=" Project "]; 18 [labelType="html" label="Filter number of output rows: 259,237"]; } 19 [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 8590.0: task 11743))"]; subgraph cluster20 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: total (min, med, max (stageId: taskId))\n4.3 s (411 ms, 432 ms, 443 ms (stage 8590.0: task 11744))"; 21 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 166 ms (9 ms, 17 ms, 23 ms (stage 8590.0: task 11743)) peak memory total (min, med, max (stageId: taskId)) 170.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 8590.0: task 11743)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 8590.0: task 11743))"]; } 22 [labelType="html" label="Exchange shuffle records written: 259,485 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 216 ms (4 ms, 5 ms, 95 ms (stage 8583.0: task 11735)) 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: 259,485 local bytes read total (min, med, max (stageId: taskId)) 15.9 MiB (1592.0 KiB, 1634.7 KiB, 1665.2 KiB (stage 8590.0: task 11749)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 8590.0: task 11743)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 100 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 74.0 MiB (7.3 MiB, 7.4 MiB, 7.4 MiB (stage 8583.0: task 11739)) 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)) 15.9 MiB (1600.4 KiB, 1633.0 KiB, 1642.9 KiB (stage 8583.0: task 11736))"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: total (min, med, max (stageId: taskId))\n2.6 s (232 ms, 261 ms, 303 ms (stage 8583.0: task 11735))"; 24 [labelType="html" label=" Project "]; 25 [labelType="html" label=" Project "]; 26 [labelType="html" label="SortMergeJoin number of output rows: 259,485 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 8583.0: task 11733))"]; } subgraph cluster27 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: total (min, med, max (stageId: taskId))\n2.7 s (234 ms, 264 ms, 323 ms (stage 8583.0: task 11734))"; 28 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 52 ms (4 ms, 5 ms, 7 ms (stage 8583.0: task 11733)) peak memory total (min, med, max (stageId: taskId)) 170.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 8583.0: task 11733)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 8583.0: task 11733))"]; } 29 [labelType="html" label="Exchange shuffle records written: 259,485 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 72 ms (5 ms, 6 ms, 11 ms (stage 8575.0: task 11704)) 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: 259,485 local bytes read total (min, med, max (stageId: taskId)) 18.8 MiB (1890.7 KiB, 1929.3 KiB, 1941.5 KiB (stage 8583.0: task 11736)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 8583.0: task 11733)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 100 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 79.8 MiB (7.9 MiB, 8.0 MiB, 8.1 MiB (stage 8575.0: task 11701)) 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)) 18.8 MiB (1910.3 KiB, 1927.3 KiB, 1943.7 KiB (stage 8575.0: task 11701))"]; subgraph cluster30 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n4.1 s (383 ms, 414 ms, 418 ms (stage 8575.0: task 11709))"; 31 [labelType="html" label=" Project "]; 32 [labelType="html" label=" Project "]; } 33 [labelType="html" label="CartesianProduct number of output rows: 259,485"]; subgraph cluster34 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n4.3 s (407 ms, 437 ms, 441 ms (stage 8575.0: task 11704))"; 35 [labelType="html" label=" Project "]; 36 [labelType="html" label="ColumnarToRow number of output rows: 259,485 number of input batches: 70"]; } 37 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 252 ms (12 ms, 27 ms, 33 ms (stage 8575.0: task 11709)) metadata time: 0 ms size of files read: 33.7 MiB number of output rows: 259,485"]; subgraph cluster38 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n211 ms (12 ms, 22 ms, 26 ms (stage 8575.0: task 11709))"; 39 [labelType="html" label=" Project "]; 40 [labelType="html" label="Filter number of output rows: 10"]; } 41 [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 cluster42 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: total (min, med, max (stageId: taskId))\n34.3 m (578 ms, 3.7 m, 8.9 m (stage 8583.0: task 11736))"; 43 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 8583.0: task 11733)) peak memory total (min, med, max (stageId: taskId)) 160.6 MiB (16.1 MiB, 16.1 MiB, 16.1 MiB (stage 8583.0: task 11733)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 8583.0: task 11733))"]; } 44 [labelType="html" label="Exchange shuffle records written: 207 local merged chunks fetched: 0 shuffle write time: 3 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 207 local bytes read total (min, med, max (stageId: taskId)) 5.6 KiB (401.0 B, 539.0 B, 772.0 B (stage 8583.0: task 11739)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 8583.0: task 11733)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size: 14.6 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: 5.6 KiB"]; subgraph cluster45 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 9 ms"; 46 [labelType="html" label=" Project "]; 47 [labelType="html" label="Filter number of output rows: 207"]; 48 [labelType="html" label="ColumnarToRow number of output rows: 3,419 number of input batches: 1"]; } 49 [labelType="html" label="Scan parquet number of files read: 1 scan time: 4 ms metadata time: 0 ms size of files read: 134.7 KiB number of output rows: 3,419"]; subgraph cluster50 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: total (min, med, max (stageId: taskId))\n1.3 s (228 ms, 242 ms, 285 ms (stage 8590.0: task 11754))"; 51 [labelType="html" label=" Project "]; 52 [labelType="html" label=" Project "]; 53 [labelType="html" label=" Project "]; 54 [labelType="html" label=" Project "]; 55 [labelType="html" label=" Project "]; 56 [labelType="html" label="SortMergeJoin number of output rows: 3,171 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 8590.0: task 11753))"]; } subgraph cluster57 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: total (min, med, max (stageId: taskId))\n1.6 s (260 ms, 284 ms, 397 ms (stage 8590.0: task 11754))"; 58 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 8590.0: task 11753)) peak memory total (min, med, max (stageId: taskId)) 80.3 MiB (16.1 MiB, 16.1 MiB, 16.1 MiB (stage 8590.0: task 11753)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 8590.0: task 11753))"]; } 59 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 86.9 KiB (16.7 KiB, 17.5 KiB, 17.5 KiB (driver)) number of coalesced partitions: 5"]; 60 [labelType="html" label="Exchange shuffle records written: 3,171 local merged chunks fetched: 0 shuffle write time: 2 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 3,171 local bytes read total (min, med, max (stageId: taskId)) 82.8 KiB (16.1 KiB, 16.6 KiB, 17.1 KiB (stage 8590.0: task 11756)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 8590.0: task 11753)) 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: 331.9 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: 82.8 KiB"]; subgraph cluster61 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 21 ms"; 62 [labelType="html" label=" Project "]; 63 [labelType="html" label="Filter number of output rows: 3,171"]; 64 [labelType="html" label="ColumnarToRow number of output rows: 3,419 number of input batches: 1"]; } 65 [labelType="html" label="Scan parquet number of files read: 1 scan time: 10 ms metadata time: 0 ms size of files read: 134.7 KiB number of output rows: 3,419"]; subgraph cluster66 { isCluster="true"; label="WholeStageCodegen (15)\n \nduration: total (min, med, max (stageId: taskId))\n479 ms (236 ms, 243 ms, 243 ms (stage 8590.0: task 11756))"; 67 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 8590.0: task 11753)) peak memory total (min, med, max (stageId: taskId)) 81.3 MiB (16.3 MiB, 16.3 MiB, 16.3 MiB (stage 8590.0: task 11753)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 8590.0: task 11753))"]; 68 [labelType="html" label=" Project "]; } 69 [labelType="html" label="ObjectHashAggregate number of output rows: 48,482 time in aggregation build total (min, med, max (stageId: taskId)) 164 ms (29 ms, 33 ms, 39 ms (stage 8590.0: task 11755)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 8590.0: task 11753)) number of sort fallback tasks: 5"]; 70 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 9.1 MiB (1846.9 KiB, 1856.8 KiB, 1910.3 KiB (driver)) number of coalesced partitions: 5"]; 71 [labelType="html" label="Exchange shuffle records written: 95,952 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 42 ms (3 ms, 4 ms, 5 ms (stage 8580.0: task 11732)) 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: 95,952 local bytes read total (min, med, max (stageId: taskId)) 8.7 MiB (1762.9 KiB, 1775.9 KiB, 1810.7 KiB (stage 8590.0: task 11756)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 8590.0: task 11753)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 50 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 39.4 MiB (3.9 MiB, 4.0 MiB, 4.0 MiB (stage 8580.0: task 11723)) 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)) 8.7 MiB (871.9 KiB, 893.5 KiB, 899.8 KiB (stage 8580.0: task 11723))"]; 72 [labelType="html" label="ObjectHashAggregate number of output rows: 95,952 time in aggregation build total (min, med, max (stageId: taskId)) 3.2 s (295 ms, 312 ms, 352 ms (stage 8580.0: task 11731)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 8580.0: task 11728)) number of sort fallback tasks: 10"]; subgraph cluster73 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: total (min, med, max (stageId: taskId))\n3.2 s (294 ms, 312 ms, 347 ms (stage 8580.0: task 11731))"; 74 [labelType="html" label=" Project "]; 75 [labelType="html" label="Filter number of output rows: 101,601"]; } 76 [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 8580.0: task 11728))"]; subgraph cluster77 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n5.1 s (490 ms, 508 ms, 543 ms (stage 8580.0: task 11731))"; 78 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 32 ms (3 ms, 3 ms, 4 ms (stage 8580.0: task 11728)) peak memory total (min, med, max (stageId: taskId)) 170.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 8580.0: task 11728)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 8580.0: task 11728))"]; } 79 [labelType="html" label="Exchange shuffle records written: 259,485 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 47 ms (3 ms, 4 ms, 9 ms (stage 8578.0: task 11714)) 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: 259,485 local bytes read total (min, med, max (stageId: taskId)) 11.6 MiB (1170.5 KiB, 1192.7 KiB, 1201.9 KiB (stage 8580.0: task 11727)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 8580.0: task 11728)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 100 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 64.1 MiB (6.2 MiB, 6.4 MiB, 6.5 MiB (stage 8578.0: task 11713)) 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)) 11.6 MiB (1158.8 KiB, 1190.0 KiB, 1212.1 KiB (stage 8578.0: task 11713))"]; subgraph cluster80 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n473 ms (38 ms, 39 ms, 81 ms (stage 8578.0: task 11713))"; 81 [labelType="html" label=" Project "]; 82 [labelType="html" label="Filter number of output rows: 259,485"]; 83 [labelType="html" label="ColumnarToRow number of output rows: 259,485 number of input batches: 70"]; } 84 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 110 ms (10 ms, 10 ms, 14 ms (stage 8578.0: task 11716)) metadata time: 0 ms size of files read: 18.7 MiB number of output rows: 259,485"]; subgraph cluster85 { isCluster="true"; label="WholeStageCodegen (17)\n \nduration: total (min, med, max (stageId: taskId))\n40 ms (2 ms, 3 ms, 3 ms (stage 8590.0: task 11753))"; 86 [labelType="html" label=" Project "]; 87 [labelType="html" label="Filter number of output rows: 15"]; } 88 [labelType="html" label="Scan csv number of output rows: 15 number of files read: 1 metadata time: 0 ms size of files read: 175.0 B"]; subgraph cluster89 { isCluster="true"; label="WholeStageCodegen (20)\n \nduration: total (min, med, max (stageId: taskId))\n2.5 s (188 ms, 259 ms, 279 ms (stage 8607.0: task 11801))"; 90 [labelType="html" label=" Project "]; 91 [labelType="html" label="Filter number of output rows: 1,872,533"]; 92 [labelType="html" label="ColumnarToRow number of output rows: 2,132,018 number of input batches: 524"]; } 93 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 578 ms (54 ms, 57 ms, 68 ms (stage 8607.0: task 11801)) metadata time: 0 ms size of files read: 113.4 MiB number of output rows: 2,132,018"]; 2->0; 3->2; 5->3; 6->5; 8->6; 9->8; 10->9; 12->10; 13->12; 14->13; 15->14; 17->15; 18->17; 19->18; 21->19; 22->21; 24->22; 25->24; 26->25; 28->26; 29->28; 31->29; 32->31; 33->32; 35->33; 36->35; 37->36; 39->33; 40->39; 41->40; 43->26; 44->43; 46->44; 47->46; 48->47; 49->48; 51->15; 52->51; 53->52; 54->53; 55->54; 56->55; 58->56; 59->58; 60->59; 62->60; 63->62; 64->63; 65->64; 67->56; 68->67; 69->68; 70->69; 71->70; 72->71; 74->72; 75->74; 76->75; 78->76; 79->78; 81->79; 82->81; 83->82; 84->83; 86->14; 87->86; 88->87; 90->6; 91->90; 92->91; 93->92; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (22)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=437352]

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

WholeStageCodegen (21)

Union

Project

Filter (NOT (str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_concat(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 1, 105), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 138, 173))), COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889) <=> ) AND isnotnull(str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_concat(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 1, 105), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 138, 173))), COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889)))

WholeStageCodegen (19)

Window [sum(COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, sum(COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465], [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887], [1 DESC NULLS LAST]

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

WholeStageCodegen (18)

Exchange hashpartitioning(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, 10), ENSURE_REQUIREMENTS, [plan_id=436750]

CartesianProduct

Union

Project [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154 AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> A), COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#698348, 0.0) AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> A), COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#698429, 0.0) AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891]

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

WholeStageCodegen (13)

Window [sum(COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#698348, sum(COL_484809BD_733B_4872_89AD_F55431EFA656#697931) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#698429], [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159], [1 DESC NULLS LAST]

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

WholeStageCodegen (12)

Exchange hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, 10), ENSURE_REQUIREMENTS, [plan_id=436455]

Project [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> B) AND (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350 <=> N)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#697715, 0.0) AS COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> C) OR (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350 <=> O)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#697715, 0.0) AS COL_484809BD_733B_4872_89AD_F55431EFA656#697931]

Project [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, 09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518 AS COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350, dec_if_with_rule(NOT (COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> A), dec_sum(array(CASE WHEN isnull(09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529) THEN 0.0 ELSE CASE WHEN isnan(09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529) THEN 0.0 ELSE 09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529 END END, CASE WHEN isnull(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190) THEN 0.0 ELSE CASE WHEN isnan(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190) THEN 0.0 ELSE COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190 END END)), 0.0) AS COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#697715]

SortMergeJoin [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477], [09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525], LeftOuter

WholeStageCodegen (11)

Sort [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159 ASC NULLS FIRST, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 ASC NULLS FIRST, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477 ASC NULLS FIRST], false, 0

WholeStageCodegen (9)

Exchange hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477, 10), ENSURE_REQUIREMENTS, [plan_id=435653]

Project [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> B)), str_if_with_rule((((((COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SIC) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SIM)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SAS)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SSN)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SSF)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, 68, 2), RIGHT), ), ) AS COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350]

Project [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, 14_E_REGLES_EFF_188649_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#697265 AS COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> B)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, 78, 5), RIGHT), ) AS COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360]

WholeStageCodegen (3)

CartesianProduct

Project [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#696403 AS COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#696407 AS COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#696408 AS COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#696458 AS COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#696457 AS COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#696403,COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#696407,COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#696408,COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#696457,COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#696458] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_188454], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_497B3BF1_A9CE_4411_8889_2F0461FEE049:string,COL_A213E432_2691_4225_8DF4_C45A67AF4D9C:s...

Project [APPLICABLE#694274 AS 14_E_REGLES_EFF_188649_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#697265]

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

WholeStageCodegen (2)

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

Sort [09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518 ASC NULLS FIRST, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523 ASC NULLS FIRST, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525 ASC NULLS FIRST], false, 0

WholeStageCodegen (10)

Exchange hashpartitioning(09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525, 10), ENSURE_REQUIREMENTS, [plan_id=435685]

Project [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#694292 AS 09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#694297 AS 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, COL_06545D41_928E_4A54_93BF_65904FCF81AA#694299 AS 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#694303 AS 09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529]

Filter (((((COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#694296 <=> -) AND isnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#694307)) AND isnotnull(COL_EB47ADCA_4440_4090_8691_F8499DB4555E#694292)) AND isnotnull(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#694297)) AND isnotnull(COL_06545D41_928E_4A54_93BF_65904FCF81AA#694299))

ColumnarToRow

WholeStageCodegen (4)

FileScan parquet [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#694292,COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#694296,COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#694297,COL_06545D41_928E_4A54_93BF_65904FCF81AA#694299,COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#694303,COL_A2516838_D999_49FB_A245_E9F9B72D742A#694307] Batched: true, DataFilters: [(COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#694296 <=> -), isnull(COL_A2516838_D999_49FB_A245_E9F9..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/06_COMPILATION__188627], 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#694878 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#705676, str_concat(array(str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPU)), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#695991, @MntRembAMO, 00000000), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#695991, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#695213), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#695213), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)), COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#695720)) AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#705678, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209 AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#705679, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210 AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#705680]

Project [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#695720, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPU)), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#695962, @TauxApp, 000), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#695962, @TauxApp, 100)) AS COL_32B42BE1_9296_4FFA_9546_7907E56347C7#695991]

Project [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPU)), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#695431, @MntRembAMO, 00000000), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#695431, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)) AS COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#695720, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, 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#694887 <=> B), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885 <=> ), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#695211, @SpeExec, 01), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#695211, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, , 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#695209), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., RIGHT), 0, 2, RIGHT)))) AS COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#695962]

Project [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> B), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, 0.0) AS COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> C), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, 0.0) AS COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, 02_F_TRONC_COMM_188523_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#694963 AS COL_2B929673_22CB_450B_B74A_0F768B941049#695211, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> B), COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889, 0.0) AS COL_14988743_983B_477F_9919_A2848C8D7B09#695213, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> C), COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889, 0.0) AS COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214, str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> C), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885 <=> ), str_replace(02_F_TRONC_COMM_188523_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694962, @SpeExec, 01), str_replace(02_F_TRONC_COMM_188523_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694962, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, , 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#694888), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., RIGHT), 0, 2, RIGHT)))) AS COL_536A3AE1_023E_46BC_8F22_ED492AB04340#695403]

SortMergeJoin [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878], [02_F_TRONC_COMM_188523_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694960], LeftOuter

WholeStageCodegen (16)

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

WholeStageCodegen (14)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, 10), ENSURE_REQUIREMENTS, [plan_id=435714]

Project [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#700748 AS COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#700753 AS COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_06545D41_928E_4A54_93BF_65904FCF81AA#700755 AS COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#700756 AS COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#700758 AS COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#700759 AS COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#700764 AS COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889]

Filter (COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#700752 <=> +)

ColumnarToRow

WholeStageCodegen (5)

FileScan parquet [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#700748,COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#700752,COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#700753,COL_06545D41_928E_4A54_93BF_65904FCF81AA#700755,COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#700756,COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#700758,COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#700759,COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#700764] Batched: true, DataFilters: [(COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#700752 <=> +)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/06_COMPILATION__188627], 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_188523_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694960 ASC NULLS FIRST], false, 0

Project [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694742 AS 02_F_TRONC_COMM_188523_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694960, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694763 AS 02_F_TRONC_COMM_188523_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694962, str_if_with_rule(((COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#694756 <=> ) OR isnull(COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#694756)), str_concat(array(B, str_extract_middle(COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694763, 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#694750, 302, 9))), COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#694756) AS 02_F_TRONC_COMM_188523_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#694963]

WholeStageCodegen (15)

ObjectHashAggregate(keys=[COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607], functions=[collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702, 0, 0), collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, 0, 0), collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, 10), ENSURE_REQUIREMENTS, [plan_id=436259]

ObjectHashAggregate(keys=[COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607], functions=[partial_collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702, 0, 0), partial_collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, 0, 0), partial_collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, 0, 0)])

Project [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606 <=> C), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, LEFT, 67), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_extract_middle(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, 135, 27))), null) AS COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606 <=> B), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, 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#694605, 141, 24))), null) AS COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606 <=> A), COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, null) AS COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702]

Filter (COL_1316F327_759E_4952_B03E_5C9EFE388DA4#694619 <=> 1)

WholeStageCodegen (8)

Window [row_number() windowspecdefinition(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1316F327_759E_4952_B03E_5C9EFE388DA4#694619], [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606], [1 DESC NULLS LAST]

Sort [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607 ASC NULLS FIRST, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (7)

Exchange hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, 10), ENSURE_REQUIREMENTS, [plan_id=435735]

Project [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#694326 AS COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#694330 AS COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331 AS COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]

Filter isnotnull(COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331)

ColumnarToRow

WholeStageCodegen (6)

FileScan parquet [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#694326,COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#694330,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331] Batched: true, DataFilters: [isnotnull(COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_188318], 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#701007) AND (FP-TO-LC = REGLES#701007))

WholeStageCodegen (17)

FileScan csv [REGLES#701007] Batched: false, DataFilters: [isnotnull(REGLES#701007), (FP-TO-LC = REGLES#701007)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_187903/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#700071 <=> Non Eligible) AND NOT (COL_016E6242_B446_46F7_97DC_5F775D66196E#700061 <=> )) AND isnotnull(COL_016E6242_B446_46F7_97DC_5F775D66196E#700061))

ColumnarToRow

WholeStageCodegen (20)

FileScan parquet [COL_016E6242_B446_46F7_97DC_5F775D66196E#700061,COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#700071] Batched: true, DataFilters: [(COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#700071 <=> Non Eligible), NOT (COL_016E6242_B446_46F7_..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_D_DETERMINAT_188547], 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 (137)
+- == Final Plan ==
   * HashAggregate (79)
   +- ShuffleQueryStage (78), Statistics(sizeInBytes=320.0 B, rowCount=20)
      +- Exchange (77)
         +- * HashAggregate (76)
            +- Union (75)
               :- * Project (70)
               :  +- * Filter (69)
               :     +- Window (68)
               :        +- * Sort (67)
               :           +- ShuffleQueryStage (66), Statistics(sizeInBytes=64.7 MiB, rowCount=2.62E+5)
               :              +- Exchange (65)
               :                 +- CartesianProduct Inner (64)
               :                    :- Union (60)
               :                    :  :- * Project (28)
               :                    :  :  +- * Filter (27)
               :                    :  :     +- Window (26)
               :                    :  :        +- * Sort (25)
               :                    :  :           +- ShuffleQueryStage (24), Statistics(sizeInBytes=74.0 MiB, rowCount=2.59E+5)
               :                    :  :              +- Exchange (23)
               :                    :  :                 +- * Project (22)
               :                    :  :                    +- * Project (21)
               :                    :  :                       +- * SortMergeJoin LeftOuter (20)
               :                    :  :                          :- * Sort (12)
               :                    :  :                          :  +- ShuffleQueryStage (11), Statistics(sizeInBytes=79.8 MiB, rowCount=2.59E+5)
               :                    :  :                          :     +- Exchange (10)
               :                    :  :                          :        +- * Project (9)
               :                    :  :                          :           +- * Project (8)
               :                    :  :                          :              +- CartesianProduct Inner (7)
               :                    :  :                          :                 :- * Project (3)
               :                    :  :                          :                 :  +- * ColumnarToRow (2)
               :                    :  :                          :                 :     +- Scan parquet  (1)
               :                    :  :                          :                 +- * Project (6)
               :                    :  :                          :                    +- * Filter (5)
               :                    :  :                          :                       +- Scan csv  (4)
               :                    :  :                          +- * Sort (19)
               :                    :  :                             +- ShuffleQueryStage (18), Statistics(sizeInBytes=14.6 KiB, rowCount=207)
               :                    :  :                                +- Exchange (17)
               :                    :  :                                   +- * Project (16)
               :                    :  :                                      +- * Filter (15)
               :                    :  :                                         +- * ColumnarToRow (14)
               :                    :  :                                            +- Scan parquet  (13)
               :                    :  +- * Project (59)
               :                    :     +- * Project (58)
               :                    :        +- * Project (57)
               :                    :           +- * Project (56)
               :                    :              +- * Project (55)
               :                    :                 +- * SortMergeJoin LeftOuter (54)
               :                    :                    :- * Sort (36)
               :                    :                    :  +- AQEShuffleRead (35)
               :                    :                    :     +- ShuffleQueryStage (34), Statistics(sizeInBytes=331.9 KiB, rowCount=3.17E+3)
               :                    :                    :        +- Exchange (33)
               :                    :                    :           +- * Project (32)
               :                    :                    :              +- * Filter (31)
               :                    :                    :                 +- * ColumnarToRow (30)
               :                    :                    :                    +- Scan parquet  (29)
               :                    :                    +- * Sort (53)
               :                    :                       +- * Project (52)
               :                    :                          +- ObjectHashAggregate (51)
               :                    :                             +- AQEShuffleRead (50)
               :                    :                                +- ShuffleQueryStage (49), Statistics(sizeInBytes=39.4 MiB, rowCount=9.60E+4)
               :                    :                                   +- Exchange (48)
               :                    :                                      +- ObjectHashAggregate (47)
               :                    :                                         +- * Project (46)
               :                    :                                            +- * Filter (45)
               :                    :                                               +- Window (44)
               :                    :                                                  +- * Sort (43)
               :                    :                                                     +- ShuffleQueryStage (42), Statistics(sizeInBytes=64.1 MiB, rowCount=2.59E+5)
               :                    :                                                        +- Exchange (41)
               :                    :                                                           +- * Project (40)
               :                    :                                                              +- * Filter (39)
               :                    :                                                                 +- * ColumnarToRow (38)
               :                    :                                                                    +- Scan parquet  (37)
               :                    +- * Project (63)
               :                       +- * Filter (62)
               :                          +- Scan csv  (61)
               +- * Project (74)
                  +- * Filter (73)
                     +- * ColumnarToRow (72)
                        +- Scan parquet  (71)
+- == Initial Plan ==
   HashAggregate (136)
   +- Exchange (135)
      +- HashAggregate (134)
         +- Union (133)
            :- Project (130)
            :  +- Filter (129)
            :     +- Window (128)
            :        +- Sort (127)
            :           +- Exchange (126)
            :              +- CartesianProduct Inner (125)
            :                 :- Union (122)
            :                 :  :- Project (99)
            :                 :  :  +- Filter (98)
            :                 :  :     +- Window (97)
            :                 :  :        +- Sort (96)
            :                 :  :           +- Exchange (95)
            :                 :  :              +- Project (94)
            :                 :  :                 +- Project (93)
            :                 :  :                    +- SortMergeJoin LeftOuter (92)
            :                 :  :                       :- Sort (87)
            :                 :  :                       :  +- Exchange (86)
            :                 :  :                       :     +- Project (85)
            :                 :  :                       :        +- Project (84)
            :                 :  :                       :           +- CartesianProduct Inner (83)
            :                 :  :                       :              :- Project (80)
            :                 :  :                       :              :  +- Scan parquet  (1)
            :                 :  :                       :              +- Project (82)
            :                 :  :                       :                 +- Filter (81)
            :                 :  :                       :                    +- Scan csv  (4)
            :                 :  :                       +- Sort (91)
            :                 :  :                          +- Exchange (90)
            :                 :  :                             +- Project (89)
            :                 :  :                                +- Filter (88)
            :                 :  :                                   +- Scan parquet  (13)
            :                 :  +- Project (121)
            :                 :     +- Project (120)
            :                 :        +- Project (119)
            :                 :           +- Project (118)
            :                 :              +- Project (117)
            :                 :                 +- SortMergeJoin LeftOuter (116)
            :                 :                    :- Sort (103)
            :                 :                    :  +- Exchange (102)
            :                 :                    :     +- Project (101)
            :                 :                    :        +- Filter (100)
            :                 :                    :           +- Scan parquet  (29)
            :                 :                    +- Sort (115)
            :                 :                       +- Project (114)
            :                 :                          +- ObjectHashAggregate (113)
            :                 :                             +- Exchange (112)
            :                 :                                +- ObjectHashAggregate (111)
            :                 :                                   +- Project (110)
            :                 :                                      +- Filter (109)
            :                 :                                         +- Window (108)
            :                 :                                            +- Sort (107)
            :                 :                                               +- Exchange (106)
            :                 :                                                  +- Project (105)
            :                 :                                                     +- Filter (104)
            :                 :                                                        +- Scan parquet  (37)
            :                 +- Project (124)
            :                    +- Filter (123)
            :                       +- Scan csv  (61)
            +- Project (132)
               +- Filter (131)
                  +- Scan parquet  (71)


(1) Scan parquet 
Output [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#696403, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#696407, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#696408, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#696457, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#696458]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_188454]
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#696403, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#696407, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#696408, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#696457, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#696458]

(3) Project [codegen id : 1]
Output [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#696403 AS COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#696407 AS COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#696408 AS COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#696458 AS COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#696457 AS COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190]
Input [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#696403, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#696407, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#696408, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#696457, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#696458]

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

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

(6) Project [codegen id : 2]
Output [1]: [APPLICABLE#694274 AS 14_E_REGLES_EFF_188649_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#697265]
Input [2]: [REGLES#694273, APPLICABLE#694274]

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

(8) Project [codegen id : 3]
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, 14_E_REGLES_EFF_188649_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#697265 AS COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> B)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, 78, 5), RIGHT), ) AS COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360]
Input [6]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, 14_E_REGLES_EFF_188649_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#697265]

(9) Project [codegen id : 3]
Output [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> B)), str_if_with_rule((((((COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SIC) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SIM)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SAS)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SSN)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SSF)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, 68, 2), RIGHT), ), ) AS COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360]

(10) Exchange
Input [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350]
Arguments: hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477, 10), ENSURE_REQUIREMENTS, [plan_id=435653]

(11) ShuffleQueryStage
Output [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350]
Arguments: 0

(12) Sort [codegen id : 9]
Input [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350]
Arguments: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159 ASC NULLS FIRST, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 ASC NULLS FIRST, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477 ASC NULLS FIRST], false, 0

(13) Scan parquet 
Output [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#694292, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#694296, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#694297, COL_06545D41_928E_4A54_93BF_65904FCF81AA#694299, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#694303, COL_A2516838_D999_49FB_A245_E9F9B72D742A#694307]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/06_COMPILATION__188627]
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>

(14) ColumnarToRow [codegen id : 4]
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#694292, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#694296, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#694297, COL_06545D41_928E_4A54_93BF_65904FCF81AA#694299, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#694303, COL_A2516838_D999_49FB_A245_E9F9B72D742A#694307]

(15) Filter [codegen id : 4]
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#694292, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#694296, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#694297, COL_06545D41_928E_4A54_93BF_65904FCF81AA#694299, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#694303, COL_A2516838_D999_49FB_A245_E9F9B72D742A#694307]
Condition : (((((COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#694296 <=> -) AND isnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#694307)) AND isnotnull(COL_EB47ADCA_4440_4090_8691_F8499DB4555E#694292)) AND isnotnull(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#694297)) AND isnotnull(COL_06545D41_928E_4A54_93BF_65904FCF81AA#694299))

(16) Project [codegen id : 4]
Output [4]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#694292 AS 09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#694297 AS 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, COL_06545D41_928E_4A54_93BF_65904FCF81AA#694299 AS 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#694303 AS 09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529]
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#694292, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#694296, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#694297, COL_06545D41_928E_4A54_93BF_65904FCF81AA#694299, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#694303, COL_A2516838_D999_49FB_A245_E9F9B72D742A#694307]

(17) Exchange
Input [4]: [09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525, 09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529]
Arguments: hashpartitioning(09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525, 10), ENSURE_REQUIREMENTS, [plan_id=435685]

(18) ShuffleQueryStage
Output [4]: [09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525, 09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529]
Arguments: 1

(19) Sort [codegen id : 10]
Input [4]: [09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525, 09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529]
Arguments: [09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518 ASC NULLS FIRST, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523 ASC NULLS FIRST, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525 ASC NULLS FIRST], false, 0

(20) SortMergeJoin [codegen id : 11]
Left keys [3]: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477]
Right keys [3]: [09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525]
Join type: LeftOuter
Join condition: None

(21) Project [codegen id : 11]
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, 09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518 AS COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350, dec_if_with_rule(NOT (COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> A), dec_sum(array(CASE WHEN isnull(09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529) THEN 0.0 ELSE CASE WHEN isnan(09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529) THEN 0.0 ELSE 09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529 END END, CASE WHEN isnull(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190) THEN 0.0 ELSE CASE WHEN isnan(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190) THEN 0.0 ELSE COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190 END END)), 0.0) AS COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#697715]
Input [12]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350, 09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525, 09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529]

(22) Project [codegen id : 11]
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> B) AND (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350 <=> N)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#697715, 0.0) AS COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> C) OR (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350 <=> O)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#697715, 0.0) AS COL_484809BD_733B_4872_89AD_F55431EFA656#697931]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350, COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#697715]

(23) Exchange
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, COL_484809BD_733B_4872_89AD_F55431EFA656#697931]
Arguments: hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, 10), ENSURE_REQUIREMENTS, [plan_id=436455]

(24) ShuffleQueryStage
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, COL_484809BD_733B_4872_89AD_F55431EFA656#697931]
Arguments: 5

(25) Sort [codegen id : 12]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, COL_484809BD_733B_4872_89AD_F55431EFA656#697931]
Arguments: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(26) Window
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, COL_484809BD_733B_4872_89AD_F55431EFA656#697931]
Arguments: [sum(COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#698348, sum(COL_484809BD_733B_4872_89AD_F55431EFA656#697931) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#698429], [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159], [1 DESC NULLS LAST]

(27) Filter [codegen id : 13]
Input [9]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, COL_484809BD_733B_4872_89AD_F55431EFA656#697931, COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#698348, COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#698429]
Condition : (str_if_with_rule(((COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189 <=> 1) OR isnotnull(COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688)), O, N) <=> N)

(28) Project [codegen id : 13]
Output [4]: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154 AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> A), COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#698348, 0.0) AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> A), COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#698429, 0.0) AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891]
Input [9]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, COL_484809BD_733B_4872_89AD_F55431EFA656#697931, COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#698348, COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#698429]

(29) Scan parquet 
Output [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#700748, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#700752, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#700753, COL_06545D41_928E_4A54_93BF_65904FCF81AA#700755, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#700756, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#700758, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#700759, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#700764]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/06_COMPILATION__188627]
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>

(30) ColumnarToRow [codegen id : 5]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#700748, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#700752, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#700753, COL_06545D41_928E_4A54_93BF_65904FCF81AA#700755, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#700756, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#700758, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#700759, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#700764]

(31) Filter [codegen id : 5]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#700748, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#700752, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#700753, COL_06545D41_928E_4A54_93BF_65904FCF81AA#700755, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#700756, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#700758, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#700759, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#700764]
Condition : (COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#700752 <=> +)

(32) Project [codegen id : 5]
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#700748 AS COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#700753 AS COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_06545D41_928E_4A54_93BF_65904FCF81AA#700755 AS COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#700756 AS COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#700758 AS COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#700759 AS COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#700764 AS COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#700748, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#700752, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#700753, COL_06545D41_928E_4A54_93BF_65904FCF81AA#700755, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#700756, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#700758, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#700759, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#700764]

(33) Exchange
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889]
Arguments: hashpartitioning(COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, 10), ENSURE_REQUIREMENTS, [plan_id=435714]

(34) ShuffleQueryStage
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889]
Arguments: 2

(35) AQEShuffleRead
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889]
Arguments: coalesced

(36) Sort [codegen id : 14]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889]
Arguments: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878 ASC NULLS FIRST], false, 0

(37) Scan parquet 
Output [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#694326, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#694330, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_188318]
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>

(38) ColumnarToRow [codegen id : 6]
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#694326, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#694330, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331]

(39) Filter [codegen id : 6]
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#694326, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#694330, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331]
Condition : isnotnull(COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331)

(40) Project [codegen id : 6]
Output [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#694326 AS COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#694330 AS COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331 AS COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#694326, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#694330, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331]

(41) Exchange
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]
Arguments: hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, 10), ENSURE_REQUIREMENTS, [plan_id=435735]

(42) ShuffleQueryStage
Output [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]
Arguments: 3

(43) Sort [codegen id : 7]
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]
Arguments: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607 ASC NULLS FIRST, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(44) Window
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]
Arguments: [row_number() windowspecdefinition(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1316F327_759E_4952_B03E_5C9EFE388DA4#694619], [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606], [1 DESC NULLS LAST]

(45) Filter [codegen id : 8]
Input [4]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_1316F327_759E_4952_B03E_5C9EFE388DA4#694619]
Condition : (COL_1316F327_759E_4952_B03E_5C9EFE388DA4#694619 <=> 1)

(46) Project [codegen id : 8]
Output [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606 <=> C), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, LEFT, 67), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_extract_middle(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, 135, 27))), null) AS COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606 <=> B), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, 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#694605, 141, 24))), null) AS COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606 <=> A), COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, null) AS COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702]
Input [4]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_1316F327_759E_4952_B03E_5C9EFE388DA4#694619]

(47) ObjectHashAggregate
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702]
Keys [1]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]
Functions [3]: [partial_collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702, 0, 0), partial_collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, 0, 0), partial_collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, 0, 0)]
Aggregate Attributes [3]: [buf#695019, buf#695020, buf#695021]
Results [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, buf#695022, buf#695023, buf#695024]

(48) Exchange
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, buf#695022, buf#695023, buf#695024]
Arguments: hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, 10), ENSURE_REQUIREMENTS, [plan_id=436259]

(49) ShuffleQueryStage
Output [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, buf#695022, buf#695023, buf#695024]
Arguments: 4

(50) AQEShuffleRead
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, buf#695022, buf#695023, buf#695024]
Arguments: coalesced

(51) ObjectHashAggregate
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, buf#695022, buf#695023, buf#695024]
Keys [1]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]
Functions [3]: [collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702, 0, 0), collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, 0, 0), collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, 0, 0)]
Aggregate Attributes [3]: [collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702, 0, 0)#694718, collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, 0, 0)#694720, collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, 0, 0)#694722]
Results [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607 AS COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694742, str_remove_space(str_list_get(collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702, 0, 0)#694718, 0), LEFT) AS COL_658F143C_7372_42DE_925A_644EBED14EE5#694750, str_remove_space(str_list_get(collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, 0, 0)#694720, 0), LEFT) AS COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#694756, str_remove_space(str_list_get(collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, 0, 0)#694722, 0), LEFT) AS COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694763]

(52) Project [codegen id : 15]
Output [3]: [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694742 AS 02_F_TRONC_COMM_188523_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694960, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694763 AS 02_F_TRONC_COMM_188523_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694962, str_if_with_rule(((COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#694756 <=> ) OR isnull(COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#694756)), str_concat(array(B, str_extract_middle(COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694763, 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#694750, 302, 9))), COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#694756) AS 02_F_TRONC_COMM_188523_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#694963]
Input [4]: [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694742, COL_658F143C_7372_42DE_925A_644EBED14EE5#694750, COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#694756, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694763]

(53) Sort [codegen id : 15]
Input [3]: [02_F_TRONC_COMM_188523_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694960, 02_F_TRONC_COMM_188523_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694962, 02_F_TRONC_COMM_188523_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#694963]
Arguments: [02_F_TRONC_COMM_188523_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694960 ASC NULLS FIRST], false, 0

(54) SortMergeJoin [codegen id : 16]
Left keys [1]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878]
Right keys [1]: [02_F_TRONC_COMM_188523_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694960]
Join type: LeftOuter
Join condition: None

(55) Project [codegen id : 16]
Output [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> B), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, 0.0) AS COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> C), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, 0.0) AS COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, 02_F_TRONC_COMM_188523_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#694963 AS COL_2B929673_22CB_450B_B74A_0F768B941049#695211, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> B), COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889, 0.0) AS COL_14988743_983B_477F_9919_A2848C8D7B09#695213, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> C), COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889, 0.0) AS COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214, str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> C), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885 <=> ), str_replace(02_F_TRONC_COMM_188523_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694962, @SpeExec, 01), str_replace(02_F_TRONC_COMM_188523_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694962, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883,  , 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#694888), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., RIGHT), 0, 2, RIGHT)))) AS COL_536A3AE1_023E_46BC_8F22_ED492AB04340#695403]
Input [10]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889, 02_F_TRONC_COMM_188523_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694960, 02_F_TRONC_COMM_188523_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694962, 02_F_TRONC_COMM_188523_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#694963]

(56) Project [codegen id : 16]
Output [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, COL_2B929673_22CB_450B_B74A_0F768B941049#695211, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPU) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPL)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPM)), str_replace(COL_536A3AE1_023E_46BC_8F22_ED492AB04340#695403, @TauxApp, 000), str_replace(COL_536A3AE1_023E_46BC_8F22_ED492AB04340#695403, @TauxApp, 100)) AS COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#695431]
Input [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, COL_2B929673_22CB_450B_B74A_0F768B941049#695211, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214, COL_536A3AE1_023E_46BC_8F22_ED492AB04340#695403]

(57) Project [codegen id : 16]
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPU)), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#695431, @MntRembAMO, 00000000), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#695431, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)) AS COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#695720, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, 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#694887 <=> B), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885 <=> ), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#695211, @SpeExec, 01), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#695211, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883,  , 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#695209), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., RIGHT), 0, 2, RIGHT)))) AS COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#695962]
Input [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, COL_2B929673_22CB_450B_B74A_0F768B941049#695211, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214, COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#695431]

(58) Project [codegen id : 16]
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#695720, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPU)), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#695962, @TauxApp, 000), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#695962, @TauxApp, 100)) AS COL_32B42BE1_9296_4FFA_9546_7907E56347C7#695991]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#695720, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#695962]

(59) Project [codegen id : 16]
Output [4]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#705676, str_concat(array(str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPU)), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#695991, @MntRembAMO, 00000000), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#695991, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#695213), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#695213), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)), COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#695720)) AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#705678, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209 AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#705679, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210 AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#705680]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#695720, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, COL_32B42BE1_9296_4FFA_9546_7907E56347C7#695991]

(60) Union

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

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

(63) Project [codegen id : 17]
Output: []
Input [1]: [REGLES#701007]

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

(65) Exchange
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891]
Arguments: hashpartitioning(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, 10), ENSURE_REQUIREMENTS, [plan_id=436750]

(66) ShuffleQueryStage
Output [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891]
Arguments: 6

(67) Sort [codegen id : 18]
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891]
Arguments: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(68) Window
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891]
Arguments: [sum(COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, sum(COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465], [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887], [1 DESC NULLS LAST]

(69) Filter [codegen id : 19]
Input [6]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891, COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465]
Condition : (NOT (str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_concat(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 1, 105), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 138, 173))), COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889) <=> ) AND isnotnull(str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_concat(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 1, 105), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 138, 173))), COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889)))

(70) Project [codegen id : 19]
Output: []
Input [6]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891, COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465]

(71) Scan parquet 
Output [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#700061, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#700071]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_D_DETERMINAT_188547]
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>

(72) ColumnarToRow [codegen id : 20]
Input [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#700061, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#700071]

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

(74) Project [codegen id : 20]
Output: []
Input [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#700061, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#700071]

(75) Union

(76) HashAggregate [codegen id : 21]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#705752L]
Results [1]: [count#705753L]

(77) Exchange
Input [1]: [count#705753L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=437352]

(78) ShuffleQueryStage
Output [1]: [count#705753L]
Arguments: 7

(79) HashAggregate [codegen id : 22]
Input [1]: [count#705753L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#705652L]
Results [1]: [count(1)#705652L AS count#705653L]

(80) Project
Output [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#696403 AS COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#696407 AS COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#696408 AS COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#696458 AS COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#696457 AS COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190]
Input [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#696403, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#696407, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#696408, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#696457, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#696458]

(81) Filter
Input [2]: [REGLES#694273, APPLICABLE#694274]
Condition : (isnotnull(REGLES#694273) AND (FP-TO-LC = REGLES#694273))

(82) Project
Output [1]: [APPLICABLE#694274 AS 14_E_REGLES_EFF_188649_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#697265]
Input [2]: [REGLES#694273, APPLICABLE#694274]

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

(84) Project
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, 14_E_REGLES_EFF_188649_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#697265 AS COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> B)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, 78, 5), RIGHT), ) AS COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360]
Input [6]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, 14_E_REGLES_EFF_188649_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#697265]

(85) Project
Output [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> B)), str_if_with_rule((((((COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SIC) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SIM)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SAS)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SSN)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 <=> SSF)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, 68, 2), RIGHT), ), ) AS COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360]

(86) Exchange
Input [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350]
Arguments: hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477, 10), ENSURE_REQUIREMENTS, [plan_id=435476]

(87) Sort
Input [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350]
Arguments: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159 ASC NULLS FIRST, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360 ASC NULLS FIRST, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477 ASC NULLS FIRST], false, 0

(88) Filter
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#694292, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#694296, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#694297, COL_06545D41_928E_4A54_93BF_65904FCF81AA#694299, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#694303, COL_A2516838_D999_49FB_A245_E9F9B72D742A#694307]
Condition : (((((COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#694296 <=> -) AND isnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#694307)) AND isnotnull(COL_EB47ADCA_4440_4090_8691_F8499DB4555E#694292)) AND isnotnull(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#694297)) AND isnotnull(COL_06545D41_928E_4A54_93BF_65904FCF81AA#694299))

(89) Project
Output [4]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#694292 AS 09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#694297 AS 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, COL_06545D41_928E_4A54_93BF_65904FCF81AA#694299 AS 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#694303 AS 09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529]
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#694292, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#694296, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#694297, COL_06545D41_928E_4A54_93BF_65904FCF81AA#694299, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#694303, COL_A2516838_D999_49FB_A245_E9F9B72D742A#694307]

(90) Exchange
Input [4]: [09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525, 09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529]
Arguments: hashpartitioning(09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525, 10), ENSURE_REQUIREMENTS, [plan_id=435477]

(91) Sort
Input [4]: [09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525, 09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529]
Arguments: [09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518 ASC NULLS FIRST, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523 ASC NULLS FIRST, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525 ASC NULLS FIRST], false, 0

(92) SortMergeJoin
Left keys [3]: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477]
Right keys [3]: [09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525]
Join type: LeftOuter
Join condition: None

(93) Project
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, 09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518 AS COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350, dec_if_with_rule(NOT (COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> A), dec_sum(array(CASE WHEN isnull(09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529) THEN 0.0 ELSE CASE WHEN isnan(09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529) THEN 0.0 ELSE 09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529 END END, CASE WHEN isnull(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190) THEN 0.0 ELSE CASE WHEN isnan(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190) THEN 0.0 ELSE COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190 END END)), 0.0) AS COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#697715]
Input [12]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#697360, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#697477, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#697190, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350, 09_A_LES_ACTES__188567_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#697518, 09_A_LES_ACTES__188567_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#697523, 09_A_LES_ACTES__188567_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#697525, 09_A_LES_ACTES__188567_COL_47B18781_35B0_4439_BF20_AEC051FE879C#697529]

(94) Project
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> B) AND (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350 <=> N)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#697715, 0.0) AS COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> C) OR (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350 <=> O)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#697715, 0.0) AS COL_484809BD_733B_4872_89AD_F55431EFA656#697931]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#697350, COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#697715]

(95) Exchange
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, COL_484809BD_733B_4872_89AD_F55431EFA656#697931]
Arguments: hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, 10), ENSURE_REQUIREMENTS, [plan_id=435484]

(96) Sort
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, COL_484809BD_733B_4872_89AD_F55431EFA656#697931]
Arguments: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(97) Window
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, COL_484809BD_733B_4872_89AD_F55431EFA656#697931]
Arguments: [sum(COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#698348, sum(COL_484809BD_733B_4872_89AD_F55431EFA656#697931) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#698429], [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159], [1 DESC NULLS LAST]

(98) Filter
Input [9]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, COL_484809BD_733B_4872_89AD_F55431EFA656#697931, COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#698348, COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#698429]
Condition : (str_if_with_rule(((COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189 <=> 1) OR isnotnull(COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688)), O, N) <=> N)

(99) Project
Output [4]: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154 AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> A), COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#698348, 0.0) AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#697158 <=> A), COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#698429, 0.0) AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891]
Input [9]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#697154, COL_49C593BD_38E0_430F_B107_3316C1E82875#697158, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#697159, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#697688, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#697189, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#697930, COL_484809BD_733B_4872_89AD_F55431EFA656#697931, COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#698348, COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#698429]

(100) Filter
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#700748, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#700752, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#700753, COL_06545D41_928E_4A54_93BF_65904FCF81AA#700755, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#700756, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#700758, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#700759, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#700764]
Condition : (COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#700752 <=> +)

(101) Project
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#700748 AS COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#700753 AS COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_06545D41_928E_4A54_93BF_65904FCF81AA#700755 AS COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#700756 AS COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#700758 AS COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#700759 AS COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#700764 AS COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#700748, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#700752, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#700753, COL_06545D41_928E_4A54_93BF_65904FCF81AA#700755, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#700756, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#700758, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#700759, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#700764]

(102) Exchange
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889]
Arguments: hashpartitioning(COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, 10), ENSURE_REQUIREMENTS, [plan_id=435501]

(103) Sort
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889]
Arguments: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878 ASC NULLS FIRST], false, 0

(104) Filter
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#694326, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#694330, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331]
Condition : isnotnull(COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331)

(105) Project
Output [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#694326 AS COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#694330 AS COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331 AS COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#694326, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#694330, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#694331]

(106) Exchange
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]
Arguments: hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, 10), ENSURE_REQUIREMENTS, [plan_id=435489]

(107) Sort
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]
Arguments: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607 ASC NULLS FIRST, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(108) Window
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]
Arguments: [row_number() windowspecdefinition(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1316F327_759E_4952_B03E_5C9EFE388DA4#694619], [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606], [1 DESC NULLS LAST]

(109) Filter
Input [4]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_1316F327_759E_4952_B03E_5C9EFE388DA4#694619]
Condition : (COL_1316F327_759E_4952_B03E_5C9EFE388DA4#694619 <=> 1)

(110) Project
Output [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606 <=> C), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, LEFT, 67), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_extract_middle(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, 135, 27))), null) AS COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606 <=> B), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, 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#694605, 141, 24))), null) AS COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606 <=> A), COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, null) AS COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702]
Input [4]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#694605, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#694606, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_1316F327_759E_4952_B03E_5C9EFE388DA4#694619]

(111) ObjectHashAggregate
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702]
Keys [1]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]
Functions [3]: [partial_collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702, 0, 0), partial_collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, 0, 0), partial_collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, 0, 0)]
Aggregate Attributes [3]: [buf#695019, buf#695020, buf#695021]
Results [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, buf#695022, buf#695023, buf#695024]

(112) Exchange
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, buf#695022, buf#695023, buf#695024]
Arguments: hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, 10), ENSURE_REQUIREMENTS, [plan_id=435496]

(113) ObjectHashAggregate
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607, buf#695022, buf#695023, buf#695024]
Keys [1]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607]
Functions [3]: [collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702, 0, 0), collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, 0, 0), collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, 0, 0)]
Aggregate Attributes [3]: [collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702, 0, 0)#694718, collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, 0, 0)#694720, collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, 0, 0)#694722]
Results [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#694607 AS COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694742, str_remove_space(str_list_get(collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#694702, 0, 0)#694718, 0), LEFT) AS COL_658F143C_7372_42DE_925A_644EBED14EE5#694750, str_remove_space(str_list_get(collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#694701, 0, 0)#694720, 0), LEFT) AS COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#694756, str_remove_space(str_list_get(collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#694700, 0, 0)#694722, 0), LEFT) AS COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694763]

(114) Project
Output [3]: [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694742 AS 02_F_TRONC_COMM_188523_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694960, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694763 AS 02_F_TRONC_COMM_188523_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694962, str_if_with_rule(((COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#694756 <=> ) OR isnull(COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#694756)), str_concat(array(B, str_extract_middle(COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694763, 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#694750, 302, 9))), COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#694756) AS 02_F_TRONC_COMM_188523_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#694963]
Input [4]: [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694742, COL_658F143C_7372_42DE_925A_644EBED14EE5#694750, COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#694756, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694763]

(115) Sort
Input [3]: [02_F_TRONC_COMM_188523_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694960, 02_F_TRONC_COMM_188523_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694962, 02_F_TRONC_COMM_188523_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#694963]
Arguments: [02_F_TRONC_COMM_188523_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694960 ASC NULLS FIRST], false, 0

(116) SortMergeJoin
Left keys [1]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878]
Right keys [1]: [02_F_TRONC_COMM_188523_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694960]
Join type: LeftOuter
Join condition: None

(117) Project
Output [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> B), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, 0.0) AS COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> C), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, 0.0) AS COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, 02_F_TRONC_COMM_188523_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#694963 AS COL_2B929673_22CB_450B_B74A_0F768B941049#695211, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> B), COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889, 0.0) AS COL_14988743_983B_477F_9919_A2848C8D7B09#695213, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> C), COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889, 0.0) AS COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214, str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887 <=> C), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885 <=> ), str_replace(02_F_TRONC_COMM_188523_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694962, @SpeExec, 01), str_replace(02_F_TRONC_COMM_188523_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694962, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883,  , 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#694888), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., RIGHT), 0, 2, RIGHT)))) AS COL_536A3AE1_023E_46BC_8F22_ED492AB04340#695403]
Input [10]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_92190B0C_B014_43F8_86E5_23FAEB753005#694889, 02_F_TRONC_COMM_188523_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#694960, 02_F_TRONC_COMM_188523_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#694962, 02_F_TRONC_COMM_188523_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#694963]

(118) Project
Output [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, COL_2B929673_22CB_450B_B74A_0F768B941049#695211, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPU) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPL)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPM)), str_replace(COL_536A3AE1_023E_46BC_8F22_ED492AB04340#695403, @TauxApp, 000), str_replace(COL_536A3AE1_023E_46BC_8F22_ED492AB04340#695403, @TauxApp, 100)) AS COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#695431]
Input [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, COL_2B929673_22CB_450B_B74A_0F768B941049#695211, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214, COL_536A3AE1_023E_46BC_8F22_ED492AB04340#695403]

(119) Project
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPU)), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#695431, @MntRembAMO, 00000000), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#695431, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)) AS COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#695720, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, 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#694887 <=> B), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885 <=> ), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#695211, @SpeExec, 01), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#695211, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883,  , 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#695209), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., RIGHT), 0, 2, RIGHT)))) AS COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#695962]
Input [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#694885, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#694886, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#694887, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#694888, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, COL_2B929673_22CB_450B_B74A_0F768B941049#695211, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, COL_E88F299F_F911_45D3_9E58_F11F3531B510#695214, COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#695431]

(120) Project
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#695720, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPU)), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#695962, @TauxApp, 000), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#695962, @TauxApp, 100)) AS COL_32B42BE1_9296_4FFA_9546_7907E56347C7#695991]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#695720, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#695962]

(121) Project
Output [4]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#705676, str_concat(array(str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883 <=> FPU)), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#695991, @MntRembAMO, 00000000), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#695991, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#695213), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#695213), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)), COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#695720)) AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#705678, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209 AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#705679, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210 AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#705680]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#694878, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#694883, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#695209, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#695210, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#695720, COL_14988743_983B_477F_9919_A2848C8D7B09#695213, COL_32B42BE1_9296_4FFA_9546_7907E56347C7#695991]

(122) Union

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

(124) Project
Output: []
Input [1]: [REGLES#701007]

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

(126) Exchange
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891]
Arguments: hashpartitioning(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, 10), ENSURE_REQUIREMENTS, [plan_id=435513]

(127) Sort
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891]
Arguments: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(128) Window
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891]
Arguments: [sum(COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, sum(COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465], [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887], [1 DESC NULLS LAST]

(129) Filter
Input [6]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891, COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465]
Condition : (NOT (str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_concat(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 1, 105), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 138, 173))), COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889) <=> ) AND isnotnull(str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_concat(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 1, 105), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 106, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 112, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 114, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 120, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 122, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 128, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, 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#700889, LEFT, 1) <=> A), dec_sum(array(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), str_to_dec(str_join(array(str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 130, 6), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 136, 2)), .), ##.##), null), dec_round(dec_if_with_rule((str_extract(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, LEFT, 1) <=> A), COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465, null), 2))), null), 2)), ., RIGHT), 0, 2, RIGHT))), ), str_extract_middle(COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, 138, 173))), COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889)))

(130) Project
Output: []
Input [6]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#700887, COL_FAE7F59C_474A_4EBB_A705_154180C93239#700889, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#700890, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#700891, COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#701986, COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#702465]

(131) Filter
Input [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#700061, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#700071]
Condition : (((COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#700071 <=> Non Eligible) AND NOT (COL_016E6242_B446_46F7_97DC_5F775D66196E#700061 <=> )) AND isnotnull(COL_016E6242_B446_46F7_97DC_5F775D66196E#700061))

(132) Project
Output: []
Input [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#700061, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#700071]

(133) Union

(134) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#705752L]
Results [1]: [count#705753L]

(135) Exchange
Input [1]: [count#705753L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=435521]

(136) HashAggregate
Input [1]: [count#705753L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#705652L]
Results [1]: [count(1)#705652L AS count#705653L]

(137) AdaptiveSparkPlan
Output [1]: [count#705653L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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