SP1 - Details for Query 5696

Submitted Time: 2026/10/22 14:08:44
Duration: 17 s
Succeeded Jobs: 8680 8681 8682 8683 8684 8685 8692 8694 8696

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (22)\n \nduration: 1 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 15 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 5 ms (0 ms, 0 ms, 0 ms (stage 17335.0: task 22344)) 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: 15 local bytes read: 885.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 15 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 240.0 B (16.0 B, 16.0 B, 16.0 B (stage 17335.0: task 22339)) 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)) 885.0 B (59.0 B, 59.0 B, 59.0 B (stage 17335.0: task 22339))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (21)\n \nduration: total (min, med, max (stageId: taskId))\n48.7 s (175 ms, 247 ms, 9.6 s (stage 17335.0: task 22346))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 48.7 s (174 ms, 247 ms, 9.6 s (stage 17335.0: task 22346)) number of output rows: 15"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (19)\n \nduration: total (min, med, max (stageId: taskId))\n46.5 s (9.1 s, 9.2 s, 9.6 s (stage 17335.0: task 22346))"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 171,856"]; } 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 17335.0: task 22350))"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (18)\n \nduration: total (min, med, max (stageId: taskId))\n50.6 s (9.8 s, 10.1 s, 10.5 s (stage 17335.0: task 22346))"; 12 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 28 ms (3 ms, 6 ms, 8 ms (stage 17335.0: task 22346)) peak memory total (min, med, max (stageId: taskId)) 85.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 17335.0: task 22346)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 17335.0: task 22346))"]; } 13 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 7.9 MiB (1608.3 KiB, 1611.1 KiB, 1682.0 KiB (driver)) number of coalesced partitions: 5"]; 14 [labelType="html" label="Exchange shuffle records written: 171,879 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 45 ms (0 ms, 3 ms, 12 ms (stage 17320.0: task 22308)) 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: 171,879 local bytes read total (min, med, max (stageId: taskId)) 7.5 MiB (1531.0 KiB, 1539.7 KiB, 1563.4 KiB (stage 17335.0: task 22348)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 17335.0: task 22346)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 15 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 42.7 MiB (265.9 KiB, 4.1 MiB, 4.2 MiB (stage 17320.0: task 22306)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 7.5 MiB (58.2 KiB, 735.2 KiB, 753.8 KiB (stage 17320.0: task 22309))"]; 15 [labelType="html" label="CartesianProduct number of output rows: 171,879"]; 16 [labelType="html" label=" Union "]; subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: total (min, med, max (stageId: taskId))\n3.8 s (191 ms, 368 ms, 517 ms (stage 17320.0: task 22304))"; 18 [labelType="html" label=" Project "]; 19 [labelType="html" label="Filter number of output rows: 165,880"]; } 20 [labelType="html" label="Window spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 17320.0: task 22307))"]; subgraph cluster21 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: total (min, med, max (stageId: taskId))\n4.6 s (340 ms, 407 ms, 652 ms (stage 17320.0: task 22304))"; 22 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 109 ms (4 ms, 10 ms, 20 ms (stage 17320.0: task 22304)) peak memory total (min, med, max (stageId: taskId)) 165.0 MiB (16.5 MiB, 16.5 MiB, 16.5 MiB (stage 17320.0: task 22307)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 17320.0: task 22307))"]; } 23 [labelType="html" label="Exchange shuffle records written: 165,923 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 232 ms (5 ms, 15 ms, 83 ms (stage 17304.0: task 22260)) 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: 165,923 local bytes read total (min, med, max (stageId: taskId)) 10.8 MiB (1071.7 KiB, 1108.2 KiB, 1123.1 KiB (stage 17320.0: task 22309)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 17320.0: task 22307)) 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)) 47.7 MiB (4.7 MiB, 4.8 MiB, 4.8 MiB (stage 17304.0: task 22261)) 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.8 MiB (1090.8 KiB, 1106.7 KiB, 1114.3 KiB (stage 17304.0: task 22273))"]; subgraph cluster24 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: total (min, med, max (stageId: taskId))\n4.8 s (146 ms, 570 ms, 650 ms (stage 17304.0: task 22260))"; 25 [labelType="html" label=" Project "]; 26 [labelType="html" label=" Project "]; 27 [labelType="html" label="SortMergeJoin number of output rows: 165,923 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 17304.0: task 22262))"]; } subgraph cluster28 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: total (min, med, max (stageId: taskId))\n5.3 s (199 ms, 630 ms, 707 ms (stage 17304.0: task 22260))"; 29 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 90 ms (5 ms, 8 ms, 14 ms (stage 17304.0: task 22274)) peak memory total (min, med, max (stageId: taskId)) 165.0 MiB (16.5 MiB, 16.5 MiB, 16.5 MiB (stage 17304.0: task 22262)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 17304.0: task 22262))"]; } 30 [labelType="html" label="Exchange shuffle records written: 165,923 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 97 ms (4 ms, 6 ms, 37 ms (stage 17296.0: task 22232)) 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: 165,923 local bytes read total (min, med, max (stageId: taskId)) 12.5 MiB (1261.3 KiB, 1282.3 KiB, 1290.8 KiB (stage 17304.0: task 22261)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 17304.0: task 22262)) 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)) 51.4 MiB (5.0 MiB, 5.1 MiB, 5.2 MiB (stage 17296.0: task 22232)) 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)) 12.5 MiB (1250.8 KiB, 1279.6 KiB, 1300.7 KiB (stage 17296.0: task 22232))"]; subgraph cluster31 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n4.0 s (336 ms, 435 ms, 444 ms (stage 17296.0: task 22235))"; 32 [labelType="html" label=" Project "]; 33 [labelType="html" label=" Project "]; } 34 [labelType="html" label="CartesianProduct number of output rows: 165,923"]; subgraph cluster35 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n4.9 s (430 ms, 529 ms, 537 ms (stage 17296.0: task 22235))"; 36 [labelType="html" label=" Project "]; 37 [labelType="html" label="ColumnarToRow number of output rows: 165,923 number of input batches: 49"]; } 38 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 727 ms (26 ms, 81 ms, 97 ms (stage 17296.0: task 22237)) metadata time: 0 ms size of files read: 20.0 MiB number of output rows: 165,923"]; subgraph cluster39 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n181 ms (12 ms, 20 ms, 23 ms (stage 17296.0: task 22234))"; 40 [labelType="html" label=" Project "]; 41 [labelType="html" label="Filter number of output rows: 10"]; } 42 [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 cluster43 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: total (min, med, max (stageId: taskId))\n4.89 h (2.4 m, 12.4 m, 1.88 h (stage 17304.0: task 22259))"; 44 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 17304.0: task 22262)) peak memory total (min, med, max (stageId: taskId)) 160.6 MiB (16.1 MiB, 16.1 MiB, 16.1 MiB (stage 17304.0: task 22262)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 17304.0: task 22262))"]; } 45 [labelType="html" label="Exchange shuffle records written: 33 local merged chunks fetched: 0 shuffle write time: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 33 local bytes read total (min, med, max (stageId: taskId)) 1691.0 B (107.0 B, 158.0 B, 234.0 B (stage 17304.0: task 22264)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 17304.0: task 22262)) 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: 2.3 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 1691.0 B"]; subgraph cluster46 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 10 ms"; 47 [labelType="html" label=" Project "]; 48 [labelType="html" label="Filter number of output rows: 33"]; 49 [labelType="html" label="ColumnarToRow number of output rows: 6,042 number of input batches: 2"]; } 50 [labelType="html" label="Scan parquet number of files read: 1 scan time: 6 ms metadata time: 0 ms size of files read: 246.9 KiB number of output rows: 6,042"]; subgraph cluster51 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: total (min, med, max (stageId: taskId))\n4.2 s (704 ms, 858 ms, 898 ms (stage 17320.0: task 22318))"; 52 [labelType="html" label=" Project "]; 53 [labelType="html" label=" Project "]; 54 [labelType="html" label=" Project "]; 55 [labelType="html" label=" Project "]; 56 [labelType="html" label=" Project "]; 57 [labelType="html" label="SortMergeJoin number of output rows: 5,999 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 17320.0: task 22319))"]; } subgraph cluster58 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: total (min, med, max (stageId: taskId))\n5.3 s (935 ms, 1.1 s, 1.1 s (stage 17320.0: task 22317))"; 59 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 8 ms (0 ms, 2 ms, 3 ms (stage 17320.0: task 22318)) peak memory total (min, med, max (stageId: taskId)) 80.3 MiB (16.1 MiB, 16.1 MiB, 16.1 MiB (stage 17320.0: task 22319)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 17320.0: task 22319))"]; } 60 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 138.6 KiB (26.9 KiB, 28.3 KiB, 28.3 KiB (driver)) number of coalesced partitions: 5"]; 61 [labelType="html" label="Exchange shuffle records written: 5,999 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: 5,999 local bytes read total (min, med, max (stageId: taskId)) 134.7 KiB (26.4 KiB, 26.7 KiB, 27.6 KiB (stage 17320.0: task 22317)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 17320.0: task 22319)) 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: 610.0 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: 134.7 KiB"]; subgraph cluster62 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 75 ms"; 63 [labelType="html" label=" Project "]; 64 [labelType="html" label="Filter number of output rows: 5,999"]; 65 [labelType="html" label="ColumnarToRow number of output rows: 6,042 number of input batches: 2"]; } 66 [labelType="html" label="Scan parquet number of files read: 1 scan time: 62 ms metadata time: 0 ms size of files read: 246.9 KiB number of output rows: 6,042"]; subgraph cluster67 { isCluster="true"; label="WholeStageCodegen (15)\n \nduration: 0 ms"; 68 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 39 ms (7 ms, 8 ms, 9 ms (stage 17320.0: task 22317)) peak memory total (min, med, max (stageId: taskId)) 81.3 MiB (16.3 MiB, 16.3 MiB, 16.3 MiB (stage 17320.0: task 22319)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 17320.0: task 22319))"]; 69 [labelType="html" label=" Project "]; } 70 [labelType="html" label="ObjectHashAggregate number of output rows: 33,845 time in aggregation build total (min, med, max (stageId: taskId)) 283 ms (44 ms, 47 ms, 88 ms (stage 17320.0: task 22317)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 17320.0: task 22319)) number of sort fallback tasks: 5"]; 71 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 7.7 MiB (1531.0 KiB, 1589.3 KiB, 1603.9 KiB (driver)) number of coalesced partitions: 5"]; 72 [labelType="html" label="Exchange shuffle records written: 82,690 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 50 ms (6 ms, 6 ms, 24 ms (stage 17301.0: task 22258)) 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: 82,690 local bytes read total (min, med, max (stageId: taskId)) 7.3 MiB (1470.8 KiB, 1484.7 KiB, 1511.5 KiB (stage 17320.0: task 22318)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 17320.0: task 22319)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 25 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 36.5 MiB (7.3 MiB, 7.3 MiB, 7.4 MiB (stage 17301.0: task 22258)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 7.3 MiB (1479.3 KiB, 1481.7 KiB, 1496.2 KiB (stage 17301.0: task 22257))"]; 73 [labelType="html" label="ObjectHashAggregate number of output rows: 82,690 time in aggregation build total (min, med, max (stageId: taskId)) 4.0 s (599 ms, 834 ms, 910 ms (stage 17301.0: task 22258)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 17301.0: task 22255)) number of sort fallback tasks: 5"]; subgraph cluster74 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: total (min, med, max (stageId: taskId))\n4.0 s (593 ms, 832 ms, 909 ms (stage 17301.0: task 22258))"; 75 [labelType="html" label=" Project "]; 76 [labelType="html" label="Filter number of output rows: 101,478"]; } 77 [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 17301.0: task 22255))"]; subgraph cluster78 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n5.0 s (801 ms, 1.0 s, 1.1 s (stage 17301.0: task 22258))"; 79 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 75 ms (8 ms, 18 ms, 21 ms (stage 17301.0: task 22255)) peak memory total (min, med, max (stageId: taskId)) 85.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 17301.0: task 22255)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 17301.0: task 22255))"]; } 80 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 9.5 MiB (1928.4 KiB, 1946.5 KiB, 1964.6 KiB (driver)) number of coalesced partitions: 5"]; 81 [labelType="html" label="Exchange shuffle records written: 165,923 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 44 ms (3 ms, 4 ms, 6 ms (stage 17299.0: task 22252)) 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: 165,923 local bytes read total (min, med, max (stageId: taskId)) 9.0 MiB (1835.0 KiB, 1841.1 KiB, 1864.3 KiB (stage 17301.0: task 22258)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 17301.0: task 22255)) 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)) 41.4 MiB (4.0 MiB, 4.2 MiB, 4.2 MiB (stage 17299.0: task 22245)) 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)) 9.0 MiB (903.5 KiB, 927.5 KiB, 943.1 KiB (stage 17299.0: task 22245))"]; subgraph cluster82 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n800 ms (30 ms, 84 ms, 128 ms (stage 17299.0: task 22247))"; 83 [labelType="html" label=" Project "]; 84 [labelType="html" label="Filter number of output rows: 165,923"]; 85 [labelType="html" label="ColumnarToRow number of output rows: 165,923 number of input batches: 48"]; } 86 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 183 ms (8 ms, 10 ms, 46 ms (stage 17299.0: task 22252)) metadata time: 0 ms size of files read: 11.4 MiB number of output rows: 165,923"]; subgraph cluster87 { isCluster="true"; label="WholeStageCodegen (17)\n \nduration: total (min, med, max (stageId: taskId))\n165 ms (3 ms, 6 ms, 41 ms (stage 17320.0: task 22308))"; 88 [labelType="html" label=" Project "]; 89 [labelType="html" label="Filter number of output rows: 15"]; } 90 [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 cluster91 { isCluster="true"; label="WholeStageCodegen (20)\n \nduration: total (min, med, max (stageId: taskId))\n2.2 s (180 ms, 225 ms, 255 ms (stage 17335.0: task 22343))"; 92 [labelType="html" label=" Project "]; 93 [labelType="html" label="Filter number of output rows: 430,120"]; 94 [labelType="html" label="ColumnarToRow number of output rows: 596,043 number of input batches: 150"]; } 95 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 406 ms (22 ms, 31 ms, 107 ms (stage 17335.0: task 22342)) metadata time: 0 ms size of files read: 32.3 MiB number of output rows: 596,043"]; 2->0; 3->2; 5->3; 6->5; 8->6; 9->8; 10->9; 12->10; 13->12; 14->13; 15->14; 16->15; 18->16; 19->18; 20->19; 22->20; 23->22; 25->23; 26->25; 27->26; 29->27; 30->29; 32->30; 33->32; 34->33; 36->34; 37->36; 38->37; 40->34; 41->40; 42->41; 44->27; 45->44; 47->45; 48->47; 49->48; 50->49; 52->16; 53->52; 54->53; 55->54; 56->55; 57->56; 59->57; 60->59; 61->60; 63->61; 64->63; 65->64; 66->65; 68->57; 69->68; 70->69; 71->70; 72->71; 73->72; 75->73; 76->75; 77->76; 79->77; 80->79; 81->80; 83->81; 84->83; 85->84; 86->85; 88->15; 89->88; 90->89; 92->6; 93->92; 94->93; 95->94; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (22)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=839374]

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

WholeStageCodegen (21)

Union

Project

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

WholeStageCodegen (19)

Window [sum(COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1265697, sum(COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1265865], [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762], [1 DESC NULLS LAST]

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

WholeStageCodegen (18)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, 10), ENSURE_REQUIREMENTS, [plan_id=838718]

CartesianProduct

Union

Project [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463 AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#1264764, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> A), COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1258587, 0.0) AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> A), COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1258668, 0.0) AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766]

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

WholeStageCodegen (13)

Window [sum(COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1258587, sum(COL_484809BD_733B_4872_89AD_F55431EFA656#1258223) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1258668], [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468], [1 DESC NULLS LAST]

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

WholeStageCodegen (12)

Exchange hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, 10), ENSURE_REQUIREMENTS, [plan_id=837552]

Project [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> B) AND (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659 <=> N)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1258024, 0.0) AS COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> C) OR (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659 <=> O)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1258024, 0.0) AS COL_484809BD_733B_4872_89AD_F55431EFA656#1258223]

Project [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, 09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827 AS COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659, dec_if_with_rule(NOT (COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> A), dec_sum(array(CASE WHEN isnull(09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838) THEN 0.0 ELSE CASE WHEN isnan(09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838) THEN 0.0 ELSE 09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838 END END, CASE WHEN isnull(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499) THEN 0.0 ELSE CASE WHEN isnan(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499) THEN 0.0 ELSE COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499 END END)), 0.0) AS COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1258024]

SortMergeJoin [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786], [09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834], LeftOuter

WholeStageCodegen (11)

Sort [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468 ASC NULLS FIRST, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 ASC NULLS FIRST, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786 ASC NULLS FIRST], false, 0

WholeStageCodegen (9)

Exchange hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786, 10), ENSURE_REQUIREMENTS, [plan_id=836739]

Project [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> B)), str_if_with_rule((((((COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SIC) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SIM)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SAS)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SSN)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SSF)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, 68, 2), RIGHT), ), ) AS COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659]

Project [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, 14_E_REGLES_EFF_176409_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1257574 AS COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> B)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, 78, 5), RIGHT), ) AS COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669]

WholeStageCodegen (3)

CartesianProduct

Project [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1256955 AS COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1256959 AS COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1256960 AS COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1257010 AS COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1257009 AS COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1256955,COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1256959,COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1256960,COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1257009,COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1257010] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_176212], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_497B3BF1_A9CE_4411_8889_2F0461FEE049:string,COL_A213E432_2691_4225_8DF4_C45A67AF4D9C:s...

Project [APPLICABLE#1256648 AS 14_E_REGLES_EFF_176409_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1257574]

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

WholeStageCodegen (2)

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

Sort [09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827 ASC NULLS FIRST, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832 ASC NULLS FIRST, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834 ASC NULLS FIRST], false, 0

WholeStageCodegen (10)

Exchange hashpartitioning(09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834, 10), ENSURE_REQUIREMENTS, [plan_id=836771]

Project [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1256058 AS 09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1256063 AS 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1256065 AS 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1256069 AS 09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838]

Filter (((((COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1256062 <=> -) AND isnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#1256073)) AND isnotnull(COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1256058)) AND isnotnull(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1256063)) AND isnotnull(COL_06545D41_928E_4A54_93BF_65904FCF81AA#1256065))

ColumnarToRow

WholeStageCodegen (4)

FileScan parquet [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1256058,COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1256062,COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1256063,COL_06545D41_928E_4A54_93BF_65904FCF81AA#1256065,COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1256069,COL_A2516838_D999_49FB_A245_E9F9B72D742A#1256073] Batched: true, DataFilters: [(COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1256062 <=> -), isnull(COL_A2516838_D999_49FB_A245_E9F..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/06_COMPILATION__176380], 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#1260706 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1267761, str_concat(array(str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPU)), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1263075, @MntRembAMO, 00000000), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1263075, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#1261344), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#1261344), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)), COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1262440)) AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#1267763, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340 AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1267764, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341 AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1267765]

Project [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1262440, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPU)), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1263012, @TauxApp, 000), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1263012, @TauxApp, 100)) AS COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1263075]

Project [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPU)), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1261872, @MntRembAMO, 00000000), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1261872, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)) AS COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1262440, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, 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#1260715 <=> B), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713 <=> ), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, @SpeExec, 01), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, , 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#1261340), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., RIGHT), 0, 2, RIGHT)))) AS COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1263012]

Project [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> B), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, 0.0) AS COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> C), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, 0.0) AS COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, 02_F_TRONC_COMM_176281_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1260791 AS COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> B), COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717, 0.0) AS COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> C), COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717, 0.0) AS COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345, str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> C), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713 <=> ), str_replace(02_F_TRONC_COMM_176281_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260790, @SpeExec, 01), str_replace(02_F_TRONC_COMM_176281_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260790, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, , 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#1260716), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., RIGHT), 0, 2, RIGHT)))) AS COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1261793]

SortMergeJoin [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706], [02_F_TRONC_COMM_176281_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260788], LeftOuter

WholeStageCodegen (16)

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

WholeStageCodegen (14)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, 10), ENSURE_REQUIREMENTS, [plan_id=836800]

Project [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1264631 AS COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1264636 AS COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1264638 AS COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1264639 AS COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1264641 AS COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1264642 AS COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1264647 AS COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717]

Filter (COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1264635 <=> +)

ColumnarToRow

WholeStageCodegen (5)

FileScan parquet [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1264631,COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1264635,COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1264636,COL_06545D41_928E_4A54_93BF_65904FCF81AA#1264638,COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1264639,COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1264641,COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1264642,COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1264647] Batched: true, DataFilters: [(COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1264635 <=> +)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/06_COMPILATION__176380], 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_176281_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260788 ASC NULLS FIRST], false, 0

Project [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260551 AS 02_F_TRONC_COMM_176281_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260788, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260591 AS 02_F_TRONC_COMM_176281_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260790, str_if_with_rule(((COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1260584 <=> ) OR isnull(COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1260584)), str_concat(array(B, str_extract_middle(COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260591, 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#1260559, 302, 9))), COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1260584) AS 02_F_TRONC_COMM_176281_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1260791]

WholeStageCodegen (15)

ObjectHashAggregate(keys=[COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193], functions=[collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426, 0, 0), collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, 0, 0), collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, 10), ENSURE_REQUIREMENTS, [plan_id=837355]

ObjectHashAggregate(keys=[COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193], functions=[partial_collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426, 0, 0), partial_collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, 0, 0), partial_collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, 0, 0)])

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

Filter (COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1260219 <=> 1)

WholeStageCodegen (8)

Window [row_number() windowspecdefinition(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1260219], [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192], [1 DESC NULLS LAST]

Sort [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193 ASC NULLS FIRST, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, 10), ENSURE_REQUIREMENTS, [plan_id=836821]

Project [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1259898 AS COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1259902 AS COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1259903 AS COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]

Filter isnotnull(COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1259903)

ColumnarToRow

WholeStageCodegen (6)

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

WholeStageCodegen (17)

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

ColumnarToRow

WholeStageCodegen (20)

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


(1) Scan parquet 
Output [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1256955, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1256959, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1256960, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1257009, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1257010]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_176212]
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#1256955, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1256959, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1256960, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1257009, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1257010]

(3) Project [codegen id : 1]
Output [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1256955 AS COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1256959 AS COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1256960 AS COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1257010 AS COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1257009 AS COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499]
Input [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1256955, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1256959, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1256960, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1257009, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1257010]

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

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

(6) Project [codegen id : 2]
Output [1]: [APPLICABLE#1256648 AS 14_E_REGLES_EFF_176409_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1257574]
Input [2]: [REGLES#1256647, APPLICABLE#1256648]

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

(8) Project [codegen id : 3]
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, 14_E_REGLES_EFF_176409_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1257574 AS COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> B)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, 78, 5), RIGHT), ) AS COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669]
Input [6]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, 14_E_REGLES_EFF_176409_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1257574]

(9) Project [codegen id : 3]
Output [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> B)), str_if_with_rule((((((COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SIC) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SIM)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SAS)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SSN)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SSF)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, 68, 2), RIGHT), ), ) AS COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669]

(10) Exchange
Input [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659]
Arguments: hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786, 10), ENSURE_REQUIREMENTS, [plan_id=836739]

(11) ShuffleQueryStage
Output [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659]
Arguments: 0

(12) Sort [codegen id : 9]
Input [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659]
Arguments: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468 ASC NULLS FIRST, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 ASC NULLS FIRST, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786 ASC NULLS FIRST], false, 0

(13) Scan parquet 
Output [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1256058, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1256062, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1256063, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1256065, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1256069, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1256073]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/06_COMPILATION__176380]
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#1256058, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1256062, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1256063, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1256065, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1256069, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1256073]

(15) Filter [codegen id : 4]
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1256058, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1256062, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1256063, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1256065, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1256069, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1256073]
Condition : (((((COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1256062 <=> -) AND isnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#1256073)) AND isnotnull(COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1256058)) AND isnotnull(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1256063)) AND isnotnull(COL_06545D41_928E_4A54_93BF_65904FCF81AA#1256065))

(16) Project [codegen id : 4]
Output [4]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1256058 AS 09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1256063 AS 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1256065 AS 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1256069 AS 09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838]
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1256058, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1256062, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1256063, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1256065, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1256069, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1256073]

(17) Exchange
Input [4]: [09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834, 09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838]
Arguments: hashpartitioning(09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834, 10), ENSURE_REQUIREMENTS, [plan_id=836771]

(18) ShuffleQueryStage
Output [4]: [09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834, 09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838]
Arguments: 1

(19) Sort [codegen id : 10]
Input [4]: [09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834, 09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838]
Arguments: [09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827 ASC NULLS FIRST, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832 ASC NULLS FIRST, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834 ASC NULLS FIRST], false, 0

(20) SortMergeJoin [codegen id : 11]
Left keys [3]: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786]
Right keys [3]: [09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834]
Join type: LeftOuter
Join condition: None

(21) Project [codegen id : 11]
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, 09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827 AS COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659, dec_if_with_rule(NOT (COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> A), dec_sum(array(CASE WHEN isnull(09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838) THEN 0.0 ELSE CASE WHEN isnan(09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838) THEN 0.0 ELSE 09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838 END END, CASE WHEN isnull(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499) THEN 0.0 ELSE CASE WHEN isnan(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499) THEN 0.0 ELSE COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499 END END)), 0.0) AS COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1258024]
Input [12]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659, 09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834, 09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838]

(22) Project [codegen id : 11]
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> B) AND (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659 <=> N)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1258024, 0.0) AS COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> C) OR (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659 <=> O)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1258024, 0.0) AS COL_484809BD_733B_4872_89AD_F55431EFA656#1258223]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659, COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1258024]

(23) Exchange
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, COL_484809BD_733B_4872_89AD_F55431EFA656#1258223]
Arguments: hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, 10), ENSURE_REQUIREMENTS, [plan_id=837552]

(24) ShuffleQueryStage
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, COL_484809BD_733B_4872_89AD_F55431EFA656#1258223]
Arguments: 5

(25) Sort [codegen id : 12]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, COL_484809BD_733B_4872_89AD_F55431EFA656#1258223]
Arguments: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(26) Window
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, COL_484809BD_733B_4872_89AD_F55431EFA656#1258223]
Arguments: [sum(COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1258587, sum(COL_484809BD_733B_4872_89AD_F55431EFA656#1258223) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1258668], [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468], [1 DESC NULLS LAST]

(27) Filter [codegen id : 13]
Input [9]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, COL_484809BD_733B_4872_89AD_F55431EFA656#1258223, COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1258587, COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1258668]
Condition : (str_if_with_rule(((COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498 <=> 1) OR isnotnull(COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997)), O, N) <=> N)

(28) Project [codegen id : 13]
Output [4]: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463 AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#1264764, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> A), COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1258587, 0.0) AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> A), COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1258668, 0.0) AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766]
Input [9]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, COL_484809BD_733B_4872_89AD_F55431EFA656#1258223, COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1258587, COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1258668]

(29) Scan parquet 
Output [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1264631, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1264635, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1264636, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1264638, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1264639, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1264641, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1264642, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1264647]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/06_COMPILATION__176380]
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#1264631, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1264635, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1264636, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1264638, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1264639, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1264641, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1264642, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1264647]

(31) Filter [codegen id : 5]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1264631, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1264635, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1264636, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1264638, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1264639, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1264641, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1264642, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1264647]
Condition : (COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1264635 <=> +)

(32) Project [codegen id : 5]
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1264631 AS COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1264636 AS COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1264638 AS COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1264639 AS COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1264641 AS COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1264642 AS COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1264647 AS COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1264631, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1264635, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1264636, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1264638, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1264639, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1264641, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1264642, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1264647]

(33) Exchange
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717]
Arguments: hashpartitioning(COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, 10), ENSURE_REQUIREMENTS, [plan_id=836800]

(34) ShuffleQueryStage
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717]
Arguments: 2

(35) AQEShuffleRead
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717]
Arguments: coalesced

(36) Sort [codegen id : 14]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717]
Arguments: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706 ASC NULLS FIRST], false, 0

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

(39) Filter [codegen id : 6]
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1259898, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1259902, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1259903]
Condition : isnotnull(COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1259903)

(40) Project [codegen id : 6]
Output [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1259898 AS COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1259902 AS COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1259903 AS COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1259898, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1259902, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1259903]

(41) Exchange
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Arguments: hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, 10), ENSURE_REQUIREMENTS, [plan_id=836821]

(42) ShuffleQueryStage
Output [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Arguments: 3

(43) AQEShuffleRead
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Arguments: coalesced

(44) Sort [codegen id : 7]
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Arguments: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193 ASC NULLS FIRST, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(45) Window
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Arguments: [row_number() windowspecdefinition(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1260219], [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192], [1 DESC NULLS LAST]

(46) Filter [codegen id : 8]
Input [4]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1260219]
Condition : (COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1260219 <=> 1)

(47) Project [codegen id : 8]
Output [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192 <=> C), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, LEFT, 67), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_extract_middle(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, 135, 27))), null) AS COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192 <=> B), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, 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#1260191, 141, 24))), null) AS COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192 <=> A), COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, null) AS COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426]
Input [4]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1260219]

(48) ObjectHashAggregate
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426]
Keys [1]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Functions [3]: [partial_collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426, 0, 0), partial_collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, 0, 0), partial_collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, 0, 0)]
Aggregate Attributes [3]: [buf#1260990, buf#1260991, buf#1260992]
Results [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, buf#1260993, buf#1260994, buf#1260995]

(49) Exchange
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, buf#1260993, buf#1260994, buf#1260995]
Arguments: hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, 10), ENSURE_REQUIREMENTS, [plan_id=837355]

(50) ShuffleQueryStage
Output [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, buf#1260993, buf#1260994, buf#1260995]
Arguments: 4

(51) AQEShuffleRead
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, buf#1260993, buf#1260994, buf#1260995]
Arguments: coalesced

(52) ObjectHashAggregate
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, buf#1260993, buf#1260994, buf#1260995]
Keys [1]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Functions [3]: [collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426, 0, 0), collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, 0, 0), collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, 0, 0)]
Aggregate Attributes [3]: [collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426, 0, 0)#1260459, collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, 0, 0)#1260461, collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, 0, 0)#1260463]
Results [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193 AS COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260551, str_remove_space(str_list_get(collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426, 0, 0)#1260459, 0), LEFT) AS COL_658F143C_7372_42DE_925A_644EBED14EE5#1260559, str_remove_space(str_list_get(collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, 0, 0)#1260461, 0), LEFT) AS COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1260584, str_remove_space(str_list_get(collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, 0, 0)#1260463, 0), LEFT) AS COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260591]

(53) Project [codegen id : 15]
Output [3]: [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260551 AS 02_F_TRONC_COMM_176281_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260788, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260591 AS 02_F_TRONC_COMM_176281_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260790, str_if_with_rule(((COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1260584 <=> ) OR isnull(COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1260584)), str_concat(array(B, str_extract_middle(COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260591, 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#1260559, 302, 9))), COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1260584) AS 02_F_TRONC_COMM_176281_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1260791]
Input [4]: [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260551, COL_658F143C_7372_42DE_925A_644EBED14EE5#1260559, COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1260584, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260591]

(54) Sort [codegen id : 15]
Input [3]: [02_F_TRONC_COMM_176281_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260788, 02_F_TRONC_COMM_176281_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260790, 02_F_TRONC_COMM_176281_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1260791]
Arguments: [02_F_TRONC_COMM_176281_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260788 ASC NULLS FIRST], false, 0

(55) SortMergeJoin [codegen id : 16]
Left keys [1]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706]
Right keys [1]: [02_F_TRONC_COMM_176281_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260788]
Join type: LeftOuter
Join condition: None

(56) Project [codegen id : 16]
Output [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> B), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, 0.0) AS COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> C), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, 0.0) AS COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, 02_F_TRONC_COMM_176281_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1260791 AS COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> B), COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717, 0.0) AS COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> C), COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717, 0.0) AS COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345, str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> C), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713 <=> ), str_replace(02_F_TRONC_COMM_176281_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260790, @SpeExec, 01), str_replace(02_F_TRONC_COMM_176281_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260790, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711,  , 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#1260716), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., RIGHT), 0, 2, RIGHT)))) AS COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1261793]
Input [10]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717, 02_F_TRONC_COMM_176281_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260788, 02_F_TRONC_COMM_176281_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260790, 02_F_TRONC_COMM_176281_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1260791]

(57) Project [codegen id : 16]
Output [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPU) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPL)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPM)), str_replace(COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1261793, @TauxApp, 000), str_replace(COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1261793, @TauxApp, 100)) AS COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1261872]
Input [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345, COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1261793]

(58) Project [codegen id : 16]
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPU)), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1261872, @MntRembAMO, 00000000), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1261872, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)) AS COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1262440, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, 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#1260715 <=> B), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713 <=> ), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, @SpeExec, 01), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711,  , 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#1261340), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., RIGHT), 0, 2, RIGHT)))) AS COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1263012]
Input [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345, COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1261872]

(59) Project [codegen id : 16]
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1262440, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPU)), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1263012, @TauxApp, 000), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1263012, @TauxApp, 100)) AS COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1263075]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1262440, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1263012]

(60) Project [codegen id : 16]
Output [4]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1267761, str_concat(array(str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPU)), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1263075, @MntRembAMO, 00000000), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1263075, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#1261344), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#1261344), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)), COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1262440)) AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#1267763, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340 AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1267764, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341 AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1267765]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1262440, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1263075]

(61) Union

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

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

(64) Project [codegen id : 17]
Output: []
Input [1]: [REGLES#1264937]

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

(66) Exchange
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1264764, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766]
Arguments: hashpartitioning(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, 10), ENSURE_REQUIREMENTS, [plan_id=838718]

(67) ShuffleQueryStage
Output [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1264764, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766]
Arguments: 6

(68) AQEShuffleRead
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1264764, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766]
Arguments: coalesced

(69) Sort [codegen id : 18]
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1264764, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766]
Arguments: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(70) Window
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1264764, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766]
Arguments: [sum(COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1265697, sum(COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1265865], [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762], [1 DESC NULLS LAST]

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

(72) Project [codegen id : 19]
Output: []
Input [6]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1264764, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766, COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1265697, COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1265865]

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

(74) ColumnarToRow [codegen id : 20]
Input [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1255872, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1255882]

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

(76) Project [codegen id : 20]
Output: []
Input [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1255872, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1255882]

(77) Union

(78) HashAggregate [codegen id : 21]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1267835L]
Results [1]: [count#1267836L]

(79) Exchange
Input [1]: [count#1267836L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=839374]

(80) ShuffleQueryStage
Output [1]: [count#1267836L]
Arguments: 7

(81) HashAggregate [codegen id : 22]
Input [1]: [count#1267836L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1267695L]
Results [1]: [count(1)#1267695L AS count#1267696L]

(82) Project
Output [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1256955 AS COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1256959 AS COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1256960 AS COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1257010 AS COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1257009 AS COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499]
Input [5]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1256955, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1256959, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1256960, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1257009, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1257010]

(83) Filter
Input [2]: [REGLES#1256647, APPLICABLE#1256648]
Condition : (isnotnull(REGLES#1256647) AND (FP-TO-LC = REGLES#1256647))

(84) Project
Output [1]: [APPLICABLE#1256648 AS 14_E_REGLES_EFF_176409_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1257574]
Input [2]: [REGLES#1256647, APPLICABLE#1256648]

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

(86) Project
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, 14_E_REGLES_EFF_176409_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1257574 AS COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> B)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, 78, 5), RIGHT), ) AS COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669]
Input [6]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, 14_E_REGLES_EFF_176409_COL_63BFCE62_2B26_4E95_8882_70D2EF26A577#1257574]

(87) Project
Output [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, str_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> C) OR (COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> B)), str_if_with_rule((((((COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SIC) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SIM)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SAS)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SSN)) OR (COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 <=> SSF)), str_remove_space(str_extract_middle(COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, 68, 2), RIGHT), ), ) AS COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669]

(88) Exchange
Input [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659]
Arguments: hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786, 10), ENSURE_REQUIREMENTS, [plan_id=836562]

(89) Sort
Input [8]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659]
Arguments: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468 ASC NULLS FIRST, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669 ASC NULLS FIRST, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786 ASC NULLS FIRST], false, 0

(90) Filter
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1256058, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1256062, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1256063, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1256065, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1256069, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1256073]
Condition : (((((COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1256062 <=> -) AND isnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#1256073)) AND isnotnull(COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1256058)) AND isnotnull(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1256063)) AND isnotnull(COL_06545D41_928E_4A54_93BF_65904FCF81AA#1256065))

(91) Project
Output [4]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1256058 AS 09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1256063 AS 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1256065 AS 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1256069 AS 09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838]
Input [6]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1256058, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1256062, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1256063, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1256065, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1256069, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1256073]

(92) Exchange
Input [4]: [09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834, 09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838]
Arguments: hashpartitioning(09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834, 10), ENSURE_REQUIREMENTS, [plan_id=836563]

(93) Sort
Input [4]: [09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834, 09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838]
Arguments: [09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827 ASC NULLS FIRST, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832 ASC NULLS FIRST, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834 ASC NULLS FIRST], false, 0

(94) SortMergeJoin
Left keys [3]: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786]
Right keys [3]: [09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834]
Join type: LeftOuter
Join condition: None

(95) Project
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, 09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827 AS COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659, dec_if_with_rule(NOT (COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> A), dec_sum(array(CASE WHEN isnull(09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838) THEN 0.0 ELSE CASE WHEN isnan(09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838) THEN 0.0 ELSE 09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838 END END, CASE WHEN isnull(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499) THEN 0.0 ELSE CASE WHEN isnan(COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499) THEN 0.0 ELSE COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499 END END)), 0.0) AS COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1258024]
Input [12]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_FBEBA149_308C_4095_8CD9_B59B90EADF4B#1257669, COL_5DFAF789_A285_4340_B161_F8CD673E5AB3#1257786, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_A589EA29_F69F_4347_8ADE_A90605DA9878#1257499, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659, 09_A_LES_ACTES__176325_COL_838ACB87_AC0A_40CB_B23B_8CB639F6D746#1257827, 09_A_LES_ACTES__176325_COL_14DEB4C6_5C6A_45DD_A0FB_AB5BB1B58A2F#1257832, 09_A_LES_ACTES__176325_COL_884DBB99_5FDF_4956_8504_CC0A3416F266#1257834, 09_A_LES_ACTES__176325_COL_47B18781_35B0_4439_BF20_AEC051FE879C#1257838]

(96) Project
Output [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> B) AND (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659 <=> N)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1258024, 0.0) AS COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, dec_if_with_rule(((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> C) OR (COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659 <=> O)), COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1258024, 0.0) AS COL_484809BD_733B_4872_89AD_F55431EFA656#1258223]
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_83E2C350_798D_4B07_B7BA_A667E9DFE1BD#1257659, COL_EDB9505B_CFC8_490F_B638_42DDBA98355F#1258024]

(97) Exchange
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, COL_484809BD_733B_4872_89AD_F55431EFA656#1258223]
Arguments: hashpartitioning(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, 10), ENSURE_REQUIREMENTS, [plan_id=836570]

(98) Sort
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, COL_484809BD_733B_4872_89AD_F55431EFA656#1258223]
Arguments: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(99) Window
Input [7]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, COL_484809BD_733B_4872_89AD_F55431EFA656#1258223]
Arguments: [sum(COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1258587, sum(COL_484809BD_733B_4872_89AD_F55431EFA656#1258223) windowspecdefinition(COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1258668], [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468], [1 DESC NULLS LAST]

(100) Filter
Input [9]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, COL_484809BD_733B_4872_89AD_F55431EFA656#1258223, COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1258587, COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1258668]
Condition : (str_if_with_rule(((COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498 <=> 1) OR isnotnull(COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997)), O, N) <=> N)

(101) Project
Output [4]: [COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463 AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#1264764, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> A), COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1258587, 0.0) AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765, dec_if_with_rule((COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467 <=> A), COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1258668, 0.0) AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766]
Input [9]: [COL_6ABD26E7_F64E_4D04_A417_90F6D3B0F752#1257463, COL_49C593BD_38E0_430F_B107_3316C1E82875#1257467, COL_E244B867_0D31_4D1D_B4C3_E2C1B48357B5#1257468, COL_F280AEB7_5624_4B96_B6D7_2CE8D47D212F#1257997, COL_A73C0D63_4F8A_4C03_B72D_7C451C098165#1257498, COL_19AA758A_B7A1_4132_B24D_4C2CBB0D91CE#1258222, COL_484809BD_733B_4872_89AD_F55431EFA656#1258223, COL_A6380C7B_0D05_403E_88DD_643BD310D3A2#1258587, COL_E72A8194_39A3_4E13_82FC_BDE7472EA96E#1258668]

(102) Filter
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1264631, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1264635, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1264636, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1264638, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1264639, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1264641, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1264642, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1264647]
Condition : (COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1264635 <=> +)

(103) Project
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1264631 AS COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1264636 AS COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1264638 AS COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1264639 AS COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1264641 AS COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1264642 AS COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1264647 AS COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1264631, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1264635, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1264636, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1264638, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1264639, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1264641, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1264642, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1264647]

(104) Exchange
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717]
Arguments: hashpartitioning(COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, 10), ENSURE_REQUIREMENTS, [plan_id=836587]

(105) Sort
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717]
Arguments: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706 ASC NULLS FIRST], false, 0

(106) Filter
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1259898, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1259902, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1259903]
Condition : isnotnull(COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1259903)

(107) Project
Output [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1259898 AS COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1259902 AS COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1259903 AS COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Input [3]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1259898, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1259902, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1259903]

(108) Exchange
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Arguments: hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, 10), ENSURE_REQUIREMENTS, [plan_id=836575]

(109) Sort
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Arguments: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193 ASC NULLS FIRST, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(110) Window
Input [3]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Arguments: [row_number() windowspecdefinition(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1260219], [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192], [1 DESC NULLS LAST]

(111) Filter
Input [4]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1260219]
Condition : (COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1260219 <=> 1)

(112) Project
Output [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192 <=> C), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, LEFT, 67), @SpeExec@DateSoins@CodeActe@Quantité@Coefficient@Denomb@PrixUnitaire@MontantBase@TauxApp@MntRembAMO@MntHono@MntAMC, str_extract_middle(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, 135, 27))), null) AS COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192 <=> B), str_concat(array(str_extract(COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, 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#1260191, 141, 24))), null) AS COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, str_if_with_rule((COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192 <=> A), COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, null) AS COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426]
Input [4]: [COL_E2989F8C_7F6B_469D_9315_E5097460DCC5#1260191, COL_C92E8CC0_1EA0_46E2_B785_2634103EDA67#1260192, COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_1316F327_759E_4952_B03E_5C9EFE388DA4#1260219]

(113) ObjectHashAggregate
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426]
Keys [1]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Functions [3]: [partial_collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426, 0, 0), partial_collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, 0, 0), partial_collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, 0, 0)]
Aggregate Attributes [3]: [buf#1260990, buf#1260991, buf#1260992]
Results [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, buf#1260993, buf#1260994, buf#1260995]

(114) Exchange
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, buf#1260993, buf#1260994, buf#1260995]
Arguments: hashpartitioning(COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, 10), ENSURE_REQUIREMENTS, [plan_id=836582]

(115) ObjectHashAggregate
Input [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193, buf#1260993, buf#1260994, buf#1260995]
Keys [1]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193]
Functions [3]: [collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426, 0, 0), collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, 0, 0), collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, 0, 0)]
Aggregate Attributes [3]: [collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426, 0, 0)#1260459, collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, 0, 0)#1260461, collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, 0, 0)#1260463]
Results [4]: [COL_FABECDC2_0362_4CDD_9393_7F33D85F6ADB#1260193 AS COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260551, str_remove_space(str_list_get(collect_set(COL_6D64F256_C80C_4064_8585_C6A20F6A1B0F#1260426, 0, 0)#1260459, 0), LEFT) AS COL_658F143C_7372_42DE_925A_644EBED14EE5#1260559, str_remove_space(str_list_get(collect_set(COL_BF730902_ECE4_4750_B2FA_B468244E28E1#1260425, 0, 0)#1260461, 0), LEFT) AS COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1260584, str_remove_space(str_list_get(collect_set(COL_736505FF_450F_44C5_A6F6_1D881519385C#1260424, 0, 0)#1260463, 0), LEFT) AS COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260591]

(116) Project
Output [3]: [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260551 AS 02_F_TRONC_COMM_176281_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260788, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260591 AS 02_F_TRONC_COMM_176281_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260790, str_if_with_rule(((COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1260584 <=> ) OR isnull(COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1260584)), str_concat(array(B, str_extract_middle(COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260591, 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#1260559, 302, 9))), COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1260584) AS 02_F_TRONC_COMM_176281_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1260791]
Input [4]: [COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260551, COL_658F143C_7372_42DE_925A_644EBED14EE5#1260559, COL_F84F4639_881C_49E2_9AF5_59F802E09B2A#1260584, COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260591]

(117) Sort
Input [3]: [02_F_TRONC_COMM_176281_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260788, 02_F_TRONC_COMM_176281_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260790, 02_F_TRONC_COMM_176281_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1260791]
Arguments: [02_F_TRONC_COMM_176281_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260788 ASC NULLS FIRST], false, 0

(118) SortMergeJoin
Left keys [1]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706]
Right keys [1]: [02_F_TRONC_COMM_176281_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260788]
Join type: LeftOuter
Join condition: None

(119) Project
Output [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> B), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, 0.0) AS COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> C), COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, 0.0) AS COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, 02_F_TRONC_COMM_176281_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1260791 AS COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> B), COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717, 0.0) AS COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, dec_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> C), COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717, 0.0) AS COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345, str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_replace(str_if_with_rule((COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715 <=> C), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713 <=> ), str_replace(02_F_TRONC_COMM_176281_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260790, @SpeExec, 01), str_replace(02_F_TRONC_COMM_176281_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260790, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711,  , 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#1260716), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., RIGHT), 0, 2, RIGHT)))) AS COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1261793]
Input [10]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_92190B0C_B014_43F8_86E5_23FAEB753005#1260717, 02_F_TRONC_COMM_176281_COL_F12FABFD_1E88_4FEC_891B_899D4908976F#1260788, 02_F_TRONC_COMM_176281_COL_45DAB47E_27F6_470F_B34B_8752C83975F1#1260790, 02_F_TRONC_COMM_176281_COL_0C324F78_E238_4A28_BD1A_05BB75282EA1#1260791]

(120) Project
Output [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPU) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPL)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPM)), str_replace(COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1261793, @TauxApp, 000), str_replace(COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1261793, @TauxApp, 100)) AS COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1261872]
Input [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345, COL_536A3AE1_023E_46BC_8F22_ED492AB04340#1261793]

(121) Project
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPU)), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1261872, @MntRembAMO, 00000000), str_replace(COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1261872, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)) AS COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1262440, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, 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#1260715 <=> B), str_if_with_rule((COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713 <=> ), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, @SpeExec, 01), str_replace(COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, @SpeExec, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713)), null), @DateSoins, date_time_to_str(COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, ddMMyyyy, Europe/Paris, fr_FR)), @CodeActe, str_complete(COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711,  , 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#1261340), ., LEFT), 0, 5, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., RIGHT), 0, 2, RIGHT)))), @MontantBase, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., RIGHT), 0, 2, RIGHT)))) AS COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1263012]
Input [12]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_4C13B6A3_131C_40CB_BC1E_E9B62FC17440#1260713, COL_602EA843_F573_4D41_A4AC_9FC8CD7A8231#1260714, COL_5EB38C23_7C1A_4694_A6E3_75F55691CB95#1260715, COL_D5AE7D05_E711_435A_9B14_BD2D306F8254#1260716, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, COL_2B929673_22CB_450B_B74A_0F768B941049#1261342, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, COL_E88F299F_F911_45D3_9E58_F11F3531B510#1261345, COL_5EDDFD1D_8D54_4A7E_8FF5_5FF838E08DD7#1261872]

(122) Project
Output [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1262440, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPU)), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1263012, @TauxApp, 000), str_replace(COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1263012, @TauxApp, 100)) AS COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1263075]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1262440, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, COL_C964EFB0_7B81_4FFB_A05A_FC378E713BA8#1263012]

(123) Project
Output [4]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706 AS COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1267761, str_concat(array(str_create(str_replace(str_replace(str_if_with_rule((((COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPL) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPM)) OR (COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711 <=> FPU)), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1263075, @MntRembAMO, 00000000), str_replace(COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1263075, @MntRembAMO, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#1261344), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_14988743_983B_477F_9919_A2848C8D7B09#1261344), ., RIGHT), 0, 2, RIGHT))))), @MntHono, str_concat(array(str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., LEFT), 0, 6, LEFT), str_complete(str_extract_by_str(dec_to_str(COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340), ., RIGHT), 0, 2, RIGHT)))), @MntAMC, 0000000)), COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1262440)) AS COL_FAE7F59C_474A_4EBB_A705_154180C93239#1267763, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340 AS COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1267764, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341 AS COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1267765]
Input [7]: [COL_45CA265A_6D2E_4DA8_B7BE_6E4222B6692B#1260706, COL_31A6A56E_E02B_43A7_86AC_E869E996B999#1260711, COL_BAEF054C_10BC_4F09_82B6_CD19825E8BB4#1261340, COL_259710EF_1DB2_4533_A130_2AFA013EDE70#1261341, COL_2A6519E4_9CC1_4DAB_97AC_55A0F92D896F#1262440, COL_14988743_983B_477F_9919_A2848C8D7B09#1261344, COL_32B42BE1_9296_4FFA_9546_7907E56347C7#1263075]

(124) Union

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

(126) Project
Output: []
Input [1]: [REGLES#1264937]

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

(128) Exchange
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1264764, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766]
Arguments: hashpartitioning(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, 10), ENSURE_REQUIREMENTS, [plan_id=836599]

(129) Sort
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1264764, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766]
Arguments: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(130) Window
Input [4]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1264764, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766]
Arguments: [sum(COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1265697, sum(COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766) windowspecdefinition(COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1265865], [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762], [1 DESC NULLS LAST]

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

(132) Project
Output: []
Input [6]: [COL_CF8D1ED8_F608_41EA_9492_046A7D55EE46#1264762, COL_FAE7F59C_474A_4EBB_A705_154180C93239#1264764, COL_BA7C363A_951B_4CCE_9403_84794CD40CB8#1264765, COL_AB4B4B5A_1240_47C5_97D0_5DAD445DD147#1264766, COL_A7B263A7_8AD5_40CD_909C_AF098DCF4C5F#1265697, COL_39B8CFA4_FD75_4F03_9338_76D6F6A32FDF#1265865]

(133) Filter
Input [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1255872, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1255882]
Condition : (((COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1255882 <=> Non Eligible) AND NOT (COL_016E6242_B446_46F7_97DC_5F775D66196E#1255872 <=> )) AND isnotnull(COL_016E6242_B446_46F7_97DC_5F775D66196E#1255872))

(134) Project
Output: []
Input [2]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1255872, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1255882]

(135) Union

(136) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1267835L]
Results [1]: [count#1267836L]

(137) Exchange
Input [1]: [count#1267836L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=836607]

(138) HashAggregate
Input [1]: [count#1267836L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1267695L]
Results [1]: [count(1)#1267695L AS count#1267696L]

(139) AdaptiveSparkPlan
Output [1]: [count#1267696L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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