digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
1 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time: 0 ms<br>number of written files: 1<br>job commit time: 10 ms<br>number of output rows: 21,421<br>number of dynamic part: 0<br>written output: 814.9 KiB"];
2 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster3 {
isCluster="true";
label="WholeStageCodegen (32)\n \nduration: 176 ms";
4 [labelType="html" label="<br><b>Project</b><br><br>"];
5 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 21,421<br>spill size: 0.0 B"];
}
subgraph cluster6 {
isCluster="true";
label="WholeStageCodegen (30)\n \nduration: 213 ms";
7 [labelType="html" label="<b>Sort</b><br><br>sort time: 3 ms<br>peak memory: 16.5 MiB<br>spill size: 0.0 B"];
}
8 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 1478.4 KiB<br>number of coalesced partitions: 1"];
9 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 21,421<br>local merged chunks fetched: 0<br>shuffle write time: 3 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 21,421<br>local bytes read: 1435.6 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 6.5 MiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 1435.6 KiB"];
subgraph cluster10 {
isCluster="true";
label="WholeStageCodegen (29)\n \nduration: 70 ms";
11 [labelType="html" label="<br><b>Project</b><br><br>"];
12 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 21,421<br>spill size: 0.0 B"];
}
subgraph cluster13 {
isCluster="true";
label="WholeStageCodegen (27)\n \nduration: 72 ms";
14 [labelType="html" label="<b>Sort</b><br><br>sort time: 1 ms<br>peak memory: 16.5 MiB<br>spill size: 0.0 B"];
}
15 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 1545.3 KiB<br>number of coalesced partitions: 1"];
16 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 21,421<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>16 ms (0 ms, 0 ms, 2 ms (stage 42908.0: task 60664))<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 21,421<br>local bytes read: 1431.3 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 18<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>6.0 MiB (232.0 B, 1288.0 B, 3.5 MiB (stage 42908.0: task 60664))<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written total (min, med, max (stageId: taskId))<br>1431.3 KiB (249.0 B, 474.0 B, 832.0 KiB (stage 42908.0: task 60664))"];
17 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster18 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 5 ms";
19 [labelType="html" label="<br><b>Project</b><br><br>"];
20 [labelType="html" label="<br><b>Project</b><br><br>"];
21 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 0"];
}
22 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 0<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 2.0 B"];
subgraph cluster23 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 5 ms";
24 [labelType="html" label="<br><b>Project</b><br><br>"];
25 [labelType="html" label="<br><b>Project</b><br><br>"];
26 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 2"];
27 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 2<br>number of input batches: 1"];
}
28 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 2 ms<br>metadata time: 0 ms<br>size of files read: 1601.0 B<br>number of output rows: 2"];
subgraph cluster29 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: 4 ms";
30 [labelType="html" label="<br><b>Project</b><br><br>"];
31 [labelType="html" label="<br><b>Project</b><br><br>"];
32 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 0"];
33 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 0<br>number of input batches: 0"];
}
34 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 2 ms<br>metadata time: 0 ms<br>size of files read: 689.0 B<br>number of output rows: 0"];
subgraph cluster35 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 9 ms";
36 [labelType="html" label="<br><b>Project</b><br><br>"];
37 [labelType="html" label="<br><b>Project</b><br><br>"];
38 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 78"];
39 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 78<br>number of input batches: 1"];
}
40 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 3 ms<br>metadata time: 0 ms<br>size of files read: 3.1 KiB<br>number of output rows: 78"];
subgraph cluster41 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 31 ms";
42 [labelType="html" label="<br><b>Project</b><br><br>"];
43 [labelType="html" label="<br><b>Project</b><br><br>"];
44 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 945"];
45 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 945<br>number of input batches: 1"];
}
46 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 2 ms<br>metadata time: 0 ms<br>size of files read: 18.3 KiB<br>number of output rows: 945"];
subgraph cluster47 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: 7 ms";
48 [labelType="html" label="<br><b>Project</b><br><br>"];
49 [labelType="html" label="<br><b>Project</b><br><br>"];
50 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 99"];
51 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 99<br>number of input batches: 1"];
}
52 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 2 ms<br>metadata time: 0 ms<br>size of files read: 3.9 KiB<br>number of output rows: 99"];
subgraph cluster53 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: 4 ms";
54 [labelType="html" label="<br><b>Project</b><br><br>"];
55 [labelType="html" label="<br><b>Project</b><br><br>"];
56 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 0"];
57 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 0<br>number of input batches: 0"];
}
58 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 2 ms<br>metadata time: 0 ms<br>size of files read: 689.0 B<br>number of output rows: 0"];
subgraph cluster59 {
isCluster="true";
label="WholeStageCodegen (8)\n \nduration: 3 ms";
60 [labelType="html" label="<br><b>Project</b><br><br>"];
61 [labelType="html" label="<br><b>Project</b><br><br>"];
62 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 0"];
63 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 0<br>number of input batches: 0"];
}
64 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 2 ms<br>metadata time: 0 ms<br>size of files read: 689.0 B<br>number of output rows: 0"];
subgraph cluster65 {
isCluster="true";
label="WholeStageCodegen (9)\n \nduration: total (min, med, max (stageId: taskId))\n39 ms (2 ms, 4 ms, 6 ms (stage 42908.0: task 60651))";
66 [labelType="html" label="<br><b>Project</b><br><br>"];
67 [labelType="html" label="<br><b>Project</b><br><br>"];
68 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 52"];
69 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 52<br>number of input batches: 10"];
}
70 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 10<br>scan time total (min, med, max (stageId: taskId))<br>19 ms (1 ms, 2 ms, 3 ms (stage 42908.0: task 60651))<br>metadata time: 0 ms<br>size of files read: 19.9 KiB<br>number of output rows: 52"];
subgraph cluster71 {
isCluster="true";
label="WholeStageCodegen (10)\n \nduration: 3 ms";
72 [labelType="html" label="<br><b>Project</b><br><br>"];
73 [labelType="html" label="<br><b>Project</b><br><br>"];
74 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 31"];
75 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 31<br>number of input batches: 1"];
}
76 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 1 ms<br>metadata time: 0 ms<br>size of files read: 2.2 KiB<br>number of output rows: 31"];
subgraph cluster77 {
isCluster="true";
label="WholeStageCodegen (11)\n \nduration: 3 ms";
78 [labelType="html" label="<br><b>Project</b><br><br>"];
79 [labelType="html" label="<br><b>Project</b><br><br>"];
80 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 1"];
81 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 1<br>number of input batches: 1"];
}
82 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 1 ms<br>metadata time: 0 ms<br>size of files read: 1910.0 B<br>number of output rows: 1"];
subgraph cluster83 {
isCluster="true";
label="WholeStageCodegen (12)\n \nduration: total (min, med, max (stageId: taskId))\n413 ms (181 ms, 232 ms, 232 ms (stage 42908.0: task 60664))";
84 [labelType="html" label="<br><b>Project</b><br><br>"];
85 [labelType="html" label="<br><b>Project</b><br><br>"];
86 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 20,213"];
87 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 20,213<br>number of input batches: 5"];
}
88 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 2<br>scan time total (min, med, max (stageId: taskId))<br>8 ms (3 ms, 5 ms, 5 ms (stage 42908.0: task 60664))<br>metadata time: 0 ms<br>size of files read: 629.0 KiB<br>number of output rows: 20,213"];
subgraph cluster89 {
isCluster="true";
label="WholeStageCodegen (28)\n \nduration: 0 ms";
90 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
91 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 4.1 KiB<br>number of coalesced partitions: 1"];
92 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 210<br>local merged chunks fetched: 0<br>shuffle write time: 1 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 420<br>local bytes read total (min, med, max (stageId: taskId))<br>7.8 KiB (3.9 KiB, 3.9 KiB, 3.9 KiB (stage 42918.0: task 60667))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 42918.0: task 60667))<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 2<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 9.8 KiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 3.9 KiB"];
subgraph cluster93 {
isCluster="true";
label="WholeStageCodegen (23)\n \nduration: 12 ms";
94 [labelType="html" label="<br><b>Project</b><br><br>"];
95 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 210<br>spill size: 0.0 B"];
}
subgraph cluster96 {
isCluster="true";
label="WholeStageCodegen (21)\n \nduration: 17 ms";
97 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
98 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 8.7 KiB<br>number of coalesced partitions: 1"];
99 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 532<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>2 ms (0 ms, 0 ms, 0 ms (stage 42909.0: task 60655))<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 532<br>local bytes read: 8.3 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 3<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>55.3 KiB (16.9 KiB, 18.1 KiB, 20.3 KiB (stage 42909.0: task 60656))<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written total (min, med, max (stageId: taskId))<br>8.3 KiB (2.6 KiB, 2.6 KiB, 3.1 KiB (stage 42909.0: task 60656))"];
100 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster101 {
isCluster="true";
label="WholeStageCodegen (13)\n \nduration: 10 ms";
102 [labelType="html" label="<br><b>Project</b><br><br>"];
103 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 166"];
104 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 166<br>number of input batches: 1"];
}
105 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 3 ms<br>metadata time: 0 ms<br>size of files read: 4.3 KiB<br>number of output rows: 166"];
subgraph cluster106 {
isCluster="true";
label="WholeStageCodegen (14)\n \nduration: 17 ms";
107 [labelType="html" label="<br><b>Project</b><br><br>"];
108 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 166"];
109 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 166<br>number of input batches: 1"];
}
110 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 3 ms<br>metadata time: 0 ms<br>size of files read: 4.3 KiB<br>number of output rows: 166"];
subgraph cluster111 {
isCluster="true";
label="WholeStageCodegen (15)\n \nduration: 13 ms";
112 [labelType="html" label="<br><b>Project</b><br><br>"];
113 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 200"];
114 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 201<br>number of input batches: 1"];
}
115 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 2 ms<br>metadata time: 0 ms<br>size of files read: 4.4 KiB<br>number of output rows: 201"];
subgraph cluster116 {
isCluster="true";
label="WholeStageCodegen (22)\n \nduration: 5 ms";
117 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
118 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 72.0 B<br>number of coalesced partitions: 1"];
119 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 1<br>local merged chunks fetched: 0<br>shuffle write time: 0 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 1<br>local bytes read: 68.0 B<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 24.0 B<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 68.0 B"];
subgraph cluster120 {
isCluster="true";
label="WholeStageCodegen (16)\n \nduration: 3 ms";
121 [labelType="html" label="<br><b>Project</b><br><br>"];
}
122 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 1<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 61.0 B"];
subgraph cluster123 {
isCluster="true";
label="WholeStageCodegen (31)\n \nduration: 0 ms";
124 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
125 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 4.1 KiB<br>number of coalesced partitions: 1"];
1->0;
2->1;
4->2;
5->4;
7->5;
8->7;
9->8;
11->9;
12->11;
14->12;
15->14;
16->15;
17->16;
19->17;
20->19;
21->20;
22->21;
24->17;
25->24;
26->25;
27->26;
28->27;
30->17;
31->30;
32->31;
33->32;
34->33;
36->17;
37->36;
38->37;
39->38;
40->39;
42->17;
43->42;
44->43;
45->44;
46->45;
48->17;
49->48;
50->49;
51->50;
52->51;
54->17;
55->54;
56->55;
57->56;
58->57;
60->17;
61->60;
62->61;
63->62;
64->63;
66->17;
67->66;
68->67;
69->68;
70->69;
72->17;
73->72;
74->73;
75->74;
76->75;
78->17;
79->78;
80->79;
81->80;
82->81;
84->17;
85->84;
86->85;
87->86;
88->87;
90->12;
91->90;
92->91;
94->92;
95->94;
97->95;
98->97;
99->98;
100->99;
102->100;
103->102;
104->103;
105->104;
107->100;
108->107;
109->108;
110->109;
112->100;
113->112;
114->113;
115->114;
117->95;
118->117;
119->118;
121->119;
122->121;
124->5;
125->124;
92->125;
}
126
AdaptiveSparkPlan isFinalPlan=true
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/10_CONSOLIDATIO_209771, false, Parquet, [path=file:///data/output/cache/parquet/datablock/10_CONSOLIDATIO_209771], Overwrite, [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68, COL_0D6B804F_6E4E_4106_963C_2054075E1F48, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8, COL_D37472E7_F883_4730_86AA_8A7F19313463, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8, COL_7CD5EDED_CB5C_4904_AE08_AA033F2C5E99]
WriteFiles
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, dec_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236 <=> APC), dec_diff(array(COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715454)), COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430) AS COL_7CD5EDED_CB5C_4904_AE08_AA033F2C5E99#3715562]
SortMergeJoin [COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434], [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453], LeftOuter, ((COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289 >= 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715456) AND (COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289 <= 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715457))
WholeStageCodegen (32)
Sort [COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434 ASC NULLS FIRST], false, 0
WholeStageCodegen (30)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, 10), ENSURE_REQUIREMENTS, [plan_id=1751434]
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306 AS COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236 <=> APC), CS, null) AS COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
SortMergeJoin [COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236], [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305], LeftOuter, ((COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289 >= 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308) AND (COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289 <= 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309))
WholeStageCodegen (29)
Sort [COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236 ASC NULLS FIRST], false, 0
WholeStageCodegen (27)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, 10), ENSURE_REQUIREMENTS, [plan_id=1750710]
Union
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Project [c0#3715005 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, c0#3715005 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, c0#3715005 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, str_extract_by_str(c0#3715005, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, str_extract_by_str(c0#3715005, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, str_if_with_rule(CASE WHEN isnull(Contains(c0#3715005, -)) THEN false ELSE Contains(c0#3715005, -) END, str_extract_by_str(c0#3715005, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242]
Filter NOT CASE WHEN isnull(Contains(c0#3715005, 99)) THEN false ELSE Contains(c0#3715005, 99) END
WholeStageCodegen (1)
FileScan csv [c0#3715005] Batched: false, DataFilters: [NOT CASE WHEN isnull(Contains(c0#3715005, 99)) THEN false ELSE Contains(c0#3715005, 99) END], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/empty.csv], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<c0:string>
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715841, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715780, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715782, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715842, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715843, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715842 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715894, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715895]
Project [COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8#3714469 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715780, COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715782, str_extract_by_str(COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8#3714469, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715841, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715842, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715843]
Filter NOT CASE WHEN isnull(Contains(COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471, 99)) THEN false ELSE Contains(COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471, 99) END
ColumnarToRow
WholeStageCodegen (2)
FileScan parquet [COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8#3714469,COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470,COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471] Batched: true, DataFilters: [NOT CASE WHEN isnull(Contains(COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471, 99)) THEN false ..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/05_A_REGLE_MOP_209924], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:s...
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715844, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715783, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715785, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715845, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715846, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715845 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715896, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715897]
Project [COL_56500440_A62D_438C_9CE5_D51F8C919C3F#3714481 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715783, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715785, str_extract_by_str(COL_56500440_A62D_438C_9CE5_D51F8C919C3F#3714481, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715844, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715845, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715846]
Filter NOT CASE WHEN isnull(Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483, 99)) THEN false ELSE Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483, 99) END
ColumnarToRow
WholeStageCodegen (3)
FileScan parquet [COL_56500440_A62D_438C_9CE5_D51F8C919C3F#3714481,COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482,COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483] Batched: true, DataFilters: [NOT CASE WHEN isnull(Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483, 99)) THEN false ..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/05_B_REGLE_MCC_209928], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_56500440_A62D_438C_9CE5_D51F8C919C3F:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:s...
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715847, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715786, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715788, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715848, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715849, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715848 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715898, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715899]
Project [COL_AD937A80_F70E_46B1_BDE6_634F409294B2#3715022 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715786, COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715788, str_extract_by_str(COL_AD937A80_F70E_46B1_BDE6_634F409294B2#3715022, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715847, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715848, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715849]
Filter NOT CASE WHEN isnull(Contains(COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024, 99)) THEN false ELSE Contains(COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024, 99) END
ColumnarToRow
WholeStageCodegen (4)
FileScan parquet [COL_AD937A80_F70E_46B1_BDE6_634F409294B2#3715022,COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023,COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024] Batched: true, DataFilters: [NOT CASE WHEN isnull(Contains(COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024, 99)) THEN false ..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/05_D_REGLE_MCG_209911], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_AD937A80_F70E_46B1_BDE6_634F409294B2:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:s...
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715850, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715789, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715791, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715851, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715852, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715851 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715900, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715901]
Project [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#3714475 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715789, COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715791, str_extract_by_str(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#3714475, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715850, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715851, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715852]
Filter NOT CASE WHEN isnull(Contains(COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477, 99)) THEN false ELSE Contains(COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477, 99) END
ColumnarToRow
WholeStageCodegen (5)
FileScan parquet [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#3714475,COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476,COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477] Batched: true, DataFilters: [NOT CASE WHEN isnull(Contains(COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477, 99)) THEN false ..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/05_E_REGLE_MCS_209737], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:s...
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715853, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715792, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715794, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715854, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715855, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715854 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715902, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715903]
Project [COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5#3714487 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715792, COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715794, str_extract_by_str(COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5#3714487, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715853, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715854, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715855]
Filter NOT CASE WHEN isnull(Contains(COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489, 99)) THEN false ELSE Contains(COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489, 99) END
ColumnarToRow
WholeStageCodegen (6)
FileScan parquet [COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5#3714487,COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488,COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489] Batched: true, DataFilters: [NOT CASE WHEN isnull(Contains(COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489, 99)) THEN false ..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/05_F_REGLE_MEG_209824], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:s...
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715856, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715795, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715797, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715857, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715858, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715857 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715904, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715905]
Project [COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683#3714976 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715795, COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715797, str_extract_by_str(COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683#3714976, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715856, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715857, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715858]
Filter NOT CASE WHEN isnull(Contains(COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978, 99)) THEN false ELSE Contains(COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978, 99) END
ColumnarToRow
WholeStageCodegen (7)
FileScan parquet [COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683#3714976,COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977,COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978] Batched: true, DataFilters: [NOT CASE WHEN isnull(Contains(COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978, 99)) THEN false ..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/05_G_REGLE_MM_209873], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:s...
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715859, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715798, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715800, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715860, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715861, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715860 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715906, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715907]
Project [COL_54E1D459_5C7A_48F5_B170_4370018BB091#3714455 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715798, COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715800, str_extract_by_str(COL_54E1D459_5C7A_48F5_B170_4370018BB091#3714455, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715859, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715860, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715861]
Filter NOT CASE WHEN isnull(Contains(COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457, 99)) THEN false ELSE Contains(COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457, 99) END
ColumnarToRow
WholeStageCodegen (8)
FileScan parquet [COL_54E1D459_5C7A_48F5_B170_4370018BB091#3714455,COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456,COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457] Batched: true, DataFilters: [NOT CASE WHEN isnull(Contains(COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457, 99)) THEN false ..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/05_H_REGLE_MSF_209915], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_54E1D459_5C7A_48F5_B170_4370018BB091:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:s...
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715862, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715801, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715803, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715863, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715864, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715863 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715908, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715909]
Project [COL_4E865553_FD41_4B77_99E1_104A3436CCD6#3714461 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715801, COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715803, str_extract_by_str(COL_4E865553_FD41_4B77_99E1_104A3436CCD6#3714461, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715862, str_extract_by_str(COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715863, str_if_with_rule(CASE WHEN isnull(Contains(COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, -)) THEN false ELSE Contains(COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, -) END, str_extract_by_str(COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715864]
Filter NOT CASE WHEN isnull(Contains(COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463, 99)) THEN false ELSE Contains(COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463, 99) END
ColumnarToRow
WholeStageCodegen (9)
FileScan parquet [COL_4E865553_FD41_4B77_99E1_104A3436CCD6#3714461,COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462,COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463] Batched: true, DataFilters: [NOT CASE WHEN isnull(Contains(COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463, 99)) THEN false ..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/05_I_REGLE_SE_209919], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_4E865553_FD41_4B77_99E1_104A3436CCD6:string,COL_50257357_7A5D_4C96_8D2D_E5E477545A1D:s...
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715865, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715804, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715806, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715866, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715867, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715866 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715910, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715911]
Project [COL_8255700E_3CA6_43EA_BAA4_724B9D967C63#3714982 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715804, COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715806, str_extract_by_str(COL_8255700E_3CA6_43EA_BAA4_724B9D967C63#3714982, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715865, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715866, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715867]
Filter NOT CASE WHEN isnull(Contains(COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984, 99)) THEN false ELSE Contains(COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984, 99) END
ColumnarToRow
WholeStageCodegen (10)
FileScan parquet [COL_8255700E_3CA6_43EA_BAA4_724B9D967C63#3714982,COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983,COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984] Batched: true, DataFilters: [NOT CASE WHEN isnull(Contains(COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984, 99)) THEN false ..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/05_J_REGLE_FSD_209877], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_8255700E_3CA6_43EA_BAA4_724B9D967C63:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:s...
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715868, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715807, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715809, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715869, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715870, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715869 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715912, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715913]
Project [COL_47873A3A_2DB8_46D8_93C8_592195F7E54D#3714501 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715807, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715809, str_extract_by_str(COL_47873A3A_2DB8_46D8_93C8_592195F7E54D#3714501, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715868, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715869, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715870]
Filter NOT CASE WHEN isnull(Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503, 99)) THEN false ELSE Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503, 99) END
ColumnarToRow
WholeStageCodegen (11)
FileScan parquet [COL_47873A3A_2DB8_46D8_93C8_592195F7E54D#3714501,COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502,COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503] Batched: true, DataFilters: [NOT CASE WHEN isnull(Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503, 99)) THEN false ..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/05_C_REGLE_MCC__209838], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_47873A3A_2DB8_46D8_93C8_592195F7E54D:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:s...
Project [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715871, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715810, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715812, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715872, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715873, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715872 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715914, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715915]
Project [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714493 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715810, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715812, str_extract_by_str(COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714493, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715871, str_extract_by_str(COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715872, str_if_with_rule(CASE WHEN isnull(Contains(COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, -)) THEN false ELSE Contains(COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, -) END, str_extract_by_str(COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715873]
Filter NOT CASE WHEN isnull(Contains(COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495, 99)) THEN false ELSE Contains(COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495, 99) END
ColumnarToRow
WholeStageCodegen (12)
FileScan parquet [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714493,COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494,COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495] Batched: true, DataFilters: [NOT CASE WHEN isnull(Contains(COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495, 99)) THEN false ..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/05_K_REGLE_APC__209834], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_D05A5A65_F564_4122_87B0_3083E0B30F75:string,COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86:s...
Sort [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305 ASC NULLS FIRST], false, 0
WholeStageCodegen (28)
AQEShuffleRead coalesced
Exchange hashpartitioning(99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, 10), ENSURE_REQUIREMENTS, [plan_id=1751260]
Project [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883 AS 99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, str_to_dec(str_replace(COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, ., ,), ##,##) AS 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306, str_to_datez(COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, dd/MM/yyyy, Europe/Paris, fr_FR) AS 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308, str_to_datez(COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, dd/MM/yyyy, Europe/Paris, fr_FR) AS 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309]
SortMergeJoin [coalesce(COL_402418E3_610B_427B_99E9_757F2815930F#3714888, ), isnull(COL_402418E3_610B_427B_99E9_757F2815930F#3714888)], [coalesce(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900, ), isnull(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900)], Cross
WholeStageCodegen (23)
Sort [coalesce(COL_402418E3_610B_427B_99E9_757F2815930F#3714888, ) ASC NULLS FIRST, isnull(COL_402418E3_610B_427B_99E9_757F2815930F#3714888) ASC NULLS FIRST], false, 0
WholeStageCodegen (21)
AQEShuffleRead coalesced
Exchange hashpartitioning(coalesce(COL_402418E3_610B_427B_99E9_757F2815930F#3714888, ), isnull(COL_402418E3_610B_427B_99E9_757F2815930F#3714888), 10), ENSURE_REQUIREMENTS, [plan_id=1750850]
Union
Project [Code+Acte#3714581 AS COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, Montant#3714582 AS COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, Date_effet#3714584 AS COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, Date_r%C3%A9vocation#3714585 AS COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, Trigramme#3714586 AS COL_402418E3_610B_427B_99E9_757F2815930F#3714888]
Filter ((isnotnull(Code+Acte#3714581) AND isnotnull(str_to_datez(Date_effet#3714584, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#3714585, dd/MM/yyyy, Europe/Paris, fr_FR)))
ColumnarToRow
WholeStageCodegen (13)
FileScan parquet [Code+Acte#3714581,Montant#3714582,Date_effet#3714584,Date_r%C3%A9vocation#3714585,Trigramme#3714586] Batched: true, DataFilters: [isnotnull(Code+Acte#3714581), isnotnull(str_to_datez(Date_effet#3714584, dd/MM/yyyy, Europe/Pari..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/TARIF_FORFAITS__209680_68aece093db7..., PartitionFilters: [], PushedFilters: [IsNotNull(`Code+Acte`)], ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:st...
Project [Code+Acte#3714652 AS COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715874, Montant#3714653 AS COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715875, Date_effet#3714655 AS COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715876, Date_r%C3%A9vocation#3714656 AS COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715877, Trigramme#3714657 AS COL_402418E3_610B_427B_99E9_757F2815930F#3715878]
Filter ((isnotnull(Code+Acte#3714652) AND isnotnull(str_to_datez(Date_effet#3714655, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#3714656, dd/MM/yyyy, Europe/Paris, fr_FR)))
ColumnarToRow
WholeStageCodegen (14)
FileScan parquet [Code+Acte#3714652,Montant#3714653,Date_effet#3714655,Date_r%C3%A9vocation#3714656,Trigramme#3714657] Batched: true, DataFilters: [isnotnull(Code+Acte#3714652), isnotnull(str_to_datez(Date_effet#3714655, dd/MM/yyyy, Europe/Pari..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/TARIF_FORFAITS__209680_487d9620aef9..., PartitionFilters: [], PushedFilters: [IsNotNull(`Code+Acte`)], ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:st...
Project [Code+Acte#3714730 AS COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715879, Montant#3714731 AS COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715880, Date_effet#3714733 AS COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715881, Date_r%C3%A9vocation#3714734 AS COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715882, Trigramme#3714735 AS COL_402418E3_610B_427B_99E9_757F2815930F#3715883]
Filter ((isnotnull(Code+Acte#3714730) AND isnotnull(str_to_datez(Date_effet#3714733, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#3714734, dd/MM/yyyy, Europe/Paris, fr_FR)))
ColumnarToRow
WholeStageCodegen (15)
FileScan parquet [Code+Acte#3714730,Montant#3714731,Date_effet#3714733,Date_r%C3%A9vocation#3714734,Trigramme#3714735] Batched: true, DataFilters: [isnotnull(Code+Acte#3714730), isnotnull(str_to_datez(Date_effet#3714733, dd/MM/yyyy, Europe/Pari..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/TARIF_FORFAITS__209680_beb651606f1b..., PartitionFilters: [], PushedFilters: [IsNotNull(`Code+Acte`)], ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:st...
Sort [coalesce(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900, ) ASC NULLS FIRST, isnull(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900) ASC NULLS FIRST], false, 0
WholeStageCodegen (22)
AQEShuffleRead coalesced
Exchange hashpartitioning(coalesce(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900, ), isnull(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900), 10), ENSURE_REQUIREMENTS, [plan_id=1750880]
Project [region-tarif#3714525 AS INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
WholeStageCodegen (16)
FileScan csv [region-tarif#3714525] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/INFOETAB_DATAAP_209667/current/in..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<region-tarif:string>
Sort [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453 ASC NULLS FIRST], false, 0
WholeStageCodegen (31)
AQEShuffleRead coalesced
== Physical Plan ==
AdaptiveSparkPlan (191)
+- == Final Plan ==
Execute InsertIntoHadoopFsRelationCommand (107)
+- WriteFiles (106)
+- * Project (105)
+- * SortMergeJoin LeftOuter (104)
:- * Sort (99)
: +- AQEShuffleRead (98)
: +- ShuffleQueryStage (97), Statistics(sizeInBytes=6.5 MiB, rowCount=2.14E+4)
: +- Exchange (96)
: +- * Project (95)
: +- * SortMergeJoin LeftOuter (94)
: :- * Sort (64)
: : +- AQEShuffleRead (63)
: : +- ShuffleQueryStage (62), Statistics(sizeInBytes=6.0 MiB, rowCount=2.14E+4)
: : +- Exchange (61)
: : +- Union (60)
: : :- * Project (4)
: : : +- * Project (3)
: : : +- * Filter (2)
: : : +- Scan csv (1)
: : :- * Project (9)
: : : +- * Project (8)
: : : +- * Filter (7)
: : : +- * ColumnarToRow (6)
: : : +- Scan parquet (5)
: : :- * Project (14)
: : : +- * Project (13)
: : : +- * Filter (12)
: : : +- * ColumnarToRow (11)
: : : +- Scan parquet (10)
: : :- * Project (19)
: : : +- * Project (18)
: : : +- * Filter (17)
: : : +- * ColumnarToRow (16)
: : : +- Scan parquet (15)
: : :- * Project (24)
: : : +- * Project (23)
: : : +- * Filter (22)
: : : +- * ColumnarToRow (21)
: : : +- Scan parquet (20)
: : :- * Project (29)
: : : +- * Project (28)
: : : +- * Filter (27)
: : : +- * ColumnarToRow (26)
: : : +- Scan parquet (25)
: : :- * Project (34)
: : : +- * Project (33)
: : : +- * Filter (32)
: : : +- * ColumnarToRow (31)
: : : +- Scan parquet (30)
: : :- * Project (39)
: : : +- * Project (38)
: : : +- * Filter (37)
: : : +- * ColumnarToRow (36)
: : : +- Scan parquet (35)
: : :- * Project (44)
: : : +- * Project (43)
: : : +- * Filter (42)
: : : +- * ColumnarToRow (41)
: : : +- Scan parquet (40)
: : :- * Project (49)
: : : +- * Project (48)
: : : +- * Filter (47)
: : : +- * ColumnarToRow (46)
: : : +- Scan parquet (45)
: : :- * Project (54)
: : : +- * Project (53)
: : : +- * Filter (52)
: : : +- * ColumnarToRow (51)
: : : +- Scan parquet (50)
: : +- * Project (59)
: : +- * Project (58)
: : +- * Filter (57)
: : +- * ColumnarToRow (56)
: : +- Scan parquet (55)
: +- * Sort (93)
: +- AQEShuffleRead (92)
: +- ShuffleQueryStage (91), Statistics(sizeInBytes=9.8 KiB, rowCount=210)
: +- Exchange (90)
: +- * Project (89)
: +- * SortMergeJoin Cross (88)
: :- * Sort (81)
: : +- AQEShuffleRead (80)
: : +- ShuffleQueryStage (79), Statistics(sizeInBytes=55.3 KiB, rowCount=532)
: : +- Exchange (78)
: : +- Union (77)
: : :- * Project (68)
: : : +- * Filter (67)
: : : +- * ColumnarToRow (66)
: : : +- Scan parquet (65)
: : :- * Project (72)
: : : +- * Filter (71)
: : : +- * ColumnarToRow (70)
: : : +- Scan parquet (69)
: : +- * Project (76)
: : +- * Filter (75)
: : +- * ColumnarToRow (74)
: : +- Scan parquet (73)
: +- * Sort (87)
: +- AQEShuffleRead (86)
: +- ShuffleQueryStage (85), Statistics(sizeInBytes=24.0 B, rowCount=1)
: +- Exchange (84)
: +- * Project (83)
: +- Scan csv (82)
+- * Sort (103)
+- AQEShuffleRead (102)
+- ShuffleQueryStage (101), Statistics(sizeInBytes=9.8 KiB, rowCount=210)
+- ReusedExchange (100)
+- == Initial Plan ==
Execute InsertIntoHadoopFsRelationCommand (190)
+- WriteFiles (189)
+- Project (188)
+- SortMergeJoin LeftOuter (187)
:- Sort (166)
: +- Exchange (165)
: +- Project (164)
: +- SortMergeJoin LeftOuter (163)
: :- Sort (146)
: : +- Exchange (145)
: : +- Union (144)
: : :- Project (110)
: : : +- Project (109)
: : : +- Filter (108)
: : : +- Scan csv (1)
: : :- Project (113)
: : : +- Project (112)
: : : +- Filter (111)
: : : +- Scan parquet (5)
: : :- Project (116)
: : : +- Project (115)
: : : +- Filter (114)
: : : +- Scan parquet (10)
: : :- Project (119)
: : : +- Project (118)
: : : +- Filter (117)
: : : +- Scan parquet (15)
: : :- Project (122)
: : : +- Project (121)
: : : +- Filter (120)
: : : +- Scan parquet (20)
: : :- Project (125)
: : : +- Project (124)
: : : +- Filter (123)
: : : +- Scan parquet (25)
: : :- Project (128)
: : : +- Project (127)
: : : +- Filter (126)
: : : +- Scan parquet (30)
: : :- Project (131)
: : : +- Project (130)
: : : +- Filter (129)
: : : +- Scan parquet (35)
: : :- Project (134)
: : : +- Project (133)
: : : +- Filter (132)
: : : +- Scan parquet (40)
: : :- Project (137)
: : : +- Project (136)
: : : +- Filter (135)
: : : +- Scan parquet (45)
: : :- Project (140)
: : : +- Project (139)
: : : +- Filter (138)
: : : +- Scan parquet (50)
: : +- Project (143)
: : +- Project (142)
: : +- Filter (141)
: : +- Scan parquet (55)
: +- Sort (162)
: +- Exchange (161)
: +- Project (160)
: +- SortMergeJoin Cross (159)
: :- Sort (155)
: : +- Exchange (154)
: : +- Union (153)
: : :- Project (148)
: : : +- Filter (147)
: : : +- Scan parquet (65)
: : :- Project (150)
: : : +- Filter (149)
: : : +- Scan parquet (69)
: : +- Project (152)
: : +- Filter (151)
: : +- Scan parquet (73)
: +- Sort (158)
: +- Exchange (157)
: +- Project (156)
: +- Scan csv (82)
+- Sort (186)
+- Exchange (185)
+- Project (184)
+- SortMergeJoin Cross (183)
:- Sort (178)
: +- Exchange (177)
: +- Union (176)
: :- Project (169)
: : +- Filter (168)
: : +- Scan parquet (167)
: :- Project (172)
: : +- Filter (171)
: : +- Scan parquet (170)
: +- Project (175)
: +- Filter (174)
: +- Scan parquet (173)
+- Sort (182)
+- Exchange (181)
+- Project (180)
+- Scan csv (179)
(1) Scan csv
Output [1]: [c0#3715005]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/empty.csv]
ReadSchema: struct<c0:string>
(2) Filter [codegen id : 1]
Input [1]: [c0#3715005]
Condition : NOT CASE WHEN isnull(Contains(c0#3715005, 99)) THEN false ELSE Contains(c0#3715005, 99) END
(3) Project [codegen id : 1]
Output [6]: [c0#3715005 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, c0#3715005 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, c0#3715005 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, str_extract_by_str(c0#3715005, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, str_extract_by_str(c0#3715005, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, str_if_with_rule(CASE WHEN isnull(Contains(c0#3715005, -)) THEN false ELSE Contains(c0#3715005, -) END, str_extract_by_str(c0#3715005, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242]
Input [1]: [c0#3715005]
(4) Project [codegen id : 1]
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242]
(5) Scan parquet
Output [3]: [COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8#3714469, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_A_REGLE_MOP_209924]
ReadSchema: struct<COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:string,COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9:string>
(6) ColumnarToRow [codegen id : 2]
Input [3]: [COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8#3714469, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471]
(7) Filter [codegen id : 2]
Input [3]: [COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8#3714469, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471]
Condition : NOT CASE WHEN isnull(Contains(COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471, 99)) THEN false ELSE Contains(COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471, 99) END
(8) Project [codegen id : 2]
Output [6]: [COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8#3714469 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715780, COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715782, str_extract_by_str(COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8#3714469, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715841, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715842, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715843]
Input [3]: [COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8#3714469, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471]
(9) Project [codegen id : 2]
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715841, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715780, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715782, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715842, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715843, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715842 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715894, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715895]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715780, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715782, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715841, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715842, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715843]
(10) Scan parquet
Output [3]: [COL_56500440_A62D_438C_9CE5_D51F8C919C3F#3714481, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_B_REGLE_MCC_209928]
ReadSchema: struct<COL_56500440_A62D_438C_9CE5_D51F8C919C3F:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:string,COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388:string>
(11) ColumnarToRow [codegen id : 3]
Input [3]: [COL_56500440_A62D_438C_9CE5_D51F8C919C3F#3714481, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483]
(12) Filter [codegen id : 3]
Input [3]: [COL_56500440_A62D_438C_9CE5_D51F8C919C3F#3714481, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483]
Condition : NOT CASE WHEN isnull(Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483, 99)) THEN false ELSE Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483, 99) END
(13) Project [codegen id : 3]
Output [6]: [COL_56500440_A62D_438C_9CE5_D51F8C919C3F#3714481 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715783, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715785, str_extract_by_str(COL_56500440_A62D_438C_9CE5_D51F8C919C3F#3714481, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715844, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715845, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715846]
Input [3]: [COL_56500440_A62D_438C_9CE5_D51F8C919C3F#3714481, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483]
(14) Project [codegen id : 3]
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715844, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715783, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715785, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715845, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715846, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715845 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715896, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715897]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715783, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715785, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715844, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715845, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715846]
(15) Scan parquet
Output [3]: [COL_AD937A80_F70E_46B1_BDE6_634F409294B2#3715022, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_D_REGLE_MCG_209911]
ReadSchema: struct<COL_AD937A80_F70E_46B1_BDE6_634F409294B2:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:string,COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5:string>
(16) ColumnarToRow [codegen id : 4]
Input [3]: [COL_AD937A80_F70E_46B1_BDE6_634F409294B2#3715022, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024]
(17) Filter [codegen id : 4]
Input [3]: [COL_AD937A80_F70E_46B1_BDE6_634F409294B2#3715022, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024]
Condition : NOT CASE WHEN isnull(Contains(COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024, 99)) THEN false ELSE Contains(COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024, 99) END
(18) Project [codegen id : 4]
Output [6]: [COL_AD937A80_F70E_46B1_BDE6_634F409294B2#3715022 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715786, COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715788, str_extract_by_str(COL_AD937A80_F70E_46B1_BDE6_634F409294B2#3715022, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715847, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715848, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715849]
Input [3]: [COL_AD937A80_F70E_46B1_BDE6_634F409294B2#3715022, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024]
(19) Project [codegen id : 4]
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715847, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715786, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715788, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715848, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715849, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715848 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715898, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715899]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715786, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715788, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715847, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715848, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715849]
(20) Scan parquet
Output [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#3714475, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_E_REGLE_MCS_209737]
ReadSchema: struct<COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:string,COL_B71AED96_D44A_4496_B1D2_F66096545E56:string>
(21) ColumnarToRow [codegen id : 5]
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#3714475, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477]
(22) Filter [codegen id : 5]
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#3714475, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477]
Condition : NOT CASE WHEN isnull(Contains(COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477, 99)) THEN false ELSE Contains(COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477, 99) END
(23) Project [codegen id : 5]
Output [6]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#3714475 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715789, COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715791, str_extract_by_str(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#3714475, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715850, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715851, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715852]
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#3714475, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477]
(24) Project [codegen id : 5]
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715850, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715789, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715791, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715851, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715852, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715851 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715900, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715901]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715789, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715791, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715850, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715851, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715852]
(25) Scan parquet
Output [3]: [COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5#3714487, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_F_REGLE_MEG_209824]
ReadSchema: struct<COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:string,COL_7C97C649_D9E7_4237_BB70_110DF25D01AA:string>
(26) ColumnarToRow [codegen id : 6]
Input [3]: [COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5#3714487, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489]
(27) Filter [codegen id : 6]
Input [3]: [COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5#3714487, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489]
Condition : NOT CASE WHEN isnull(Contains(COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489, 99)) THEN false ELSE Contains(COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489, 99) END
(28) Project [codegen id : 6]
Output [6]: [COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5#3714487 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715792, COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715794, str_extract_by_str(COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5#3714487, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715853, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715854, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715855]
Input [3]: [COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5#3714487, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489]
(29) Project [codegen id : 6]
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715853, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715792, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715794, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715854, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715855, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715854 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715902, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715903]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715792, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715794, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715853, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715854, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715855]
(30) Scan parquet
Output [3]: [COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683#3714976, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_G_REGLE_MM_209873]
ReadSchema: struct<COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:string,COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83:string>
(31) ColumnarToRow [codegen id : 7]
Input [3]: [COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683#3714976, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978]
(32) Filter [codegen id : 7]
Input [3]: [COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683#3714976, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978]
Condition : NOT CASE WHEN isnull(Contains(COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978, 99)) THEN false ELSE Contains(COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978, 99) END
(33) Project [codegen id : 7]
Output [6]: [COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683#3714976 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715795, COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715797, str_extract_by_str(COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683#3714976, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715856, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715857, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715858]
Input [3]: [COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683#3714976, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978]
(34) Project [codegen id : 7]
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715856, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715795, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715797, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715857, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715858, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715857 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715904, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715905]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715795, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715797, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715856, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715857, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715858]
(35) Scan parquet
Output [3]: [COL_54E1D459_5C7A_48F5_B170_4370018BB091#3714455, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_H_REGLE_MSF_209915]
ReadSchema: struct<COL_54E1D459_5C7A_48F5_B170_4370018BB091:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:string,COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1:string>
(36) ColumnarToRow [codegen id : 8]
Input [3]: [COL_54E1D459_5C7A_48F5_B170_4370018BB091#3714455, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457]
(37) Filter [codegen id : 8]
Input [3]: [COL_54E1D459_5C7A_48F5_B170_4370018BB091#3714455, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457]
Condition : NOT CASE WHEN isnull(Contains(COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457, 99)) THEN false ELSE Contains(COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457, 99) END
(38) Project [codegen id : 8]
Output [6]: [COL_54E1D459_5C7A_48F5_B170_4370018BB091#3714455 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715798, COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715800, str_extract_by_str(COL_54E1D459_5C7A_48F5_B170_4370018BB091#3714455, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715859, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715860, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715861]
Input [3]: [COL_54E1D459_5C7A_48F5_B170_4370018BB091#3714455, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457]
(39) Project [codegen id : 8]
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715859, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715798, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715800, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715860, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715861, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715860 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715906, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715907]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715798, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715800, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715859, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715860, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715861]
(40) Scan parquet
Output [3]: [COL_4E865553_FD41_4B77_99E1_104A3436CCD6#3714461, COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_I_REGLE_SE_209919]
ReadSchema: struct<COL_4E865553_FD41_4B77_99E1_104A3436CCD6:string,COL_50257357_7A5D_4C96_8D2D_E5E477545A1D:string,COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB:string>
(41) ColumnarToRow [codegen id : 9]
Input [3]: [COL_4E865553_FD41_4B77_99E1_104A3436CCD6#3714461, COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463]
(42) Filter [codegen id : 9]
Input [3]: [COL_4E865553_FD41_4B77_99E1_104A3436CCD6#3714461, COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463]
Condition : NOT CASE WHEN isnull(Contains(COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463, 99)) THEN false ELSE Contains(COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463, 99) END
(43) Project [codegen id : 9]
Output [6]: [COL_4E865553_FD41_4B77_99E1_104A3436CCD6#3714461 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715801, COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715803, str_extract_by_str(COL_4E865553_FD41_4B77_99E1_104A3436CCD6#3714461, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715862, str_extract_by_str(COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715863, str_if_with_rule(CASE WHEN isnull(Contains(COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, -)) THEN false ELSE Contains(COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, -) END, str_extract_by_str(COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715864]
Input [3]: [COL_4E865553_FD41_4B77_99E1_104A3436CCD6#3714461, COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463]
(44) Project [codegen id : 9]
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715862, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715801, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715803, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715863, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715864, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715863 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715908, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715909]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715801, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715803, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715862, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715863, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715864]
(45) Scan parquet
Output [3]: [COL_8255700E_3CA6_43EA_BAA4_724B9D967C63#3714982, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_J_REGLE_FSD_209877]
ReadSchema: struct<COL_8255700E_3CA6_43EA_BAA4_724B9D967C63:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:string,COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1:string>
(46) ColumnarToRow [codegen id : 10]
Input [3]: [COL_8255700E_3CA6_43EA_BAA4_724B9D967C63#3714982, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984]
(47) Filter [codegen id : 10]
Input [3]: [COL_8255700E_3CA6_43EA_BAA4_724B9D967C63#3714982, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984]
Condition : NOT CASE WHEN isnull(Contains(COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984, 99)) THEN false ELSE Contains(COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984, 99) END
(48) Project [codegen id : 10]
Output [6]: [COL_8255700E_3CA6_43EA_BAA4_724B9D967C63#3714982 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715804, COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715806, str_extract_by_str(COL_8255700E_3CA6_43EA_BAA4_724B9D967C63#3714982, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715865, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715866, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715867]
Input [3]: [COL_8255700E_3CA6_43EA_BAA4_724B9D967C63#3714982, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984]
(49) Project [codegen id : 10]
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715865, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715804, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715806, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715866, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715867, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715866 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715910, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715911]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715804, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715806, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715865, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715866, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715867]
(50) Scan parquet
Output [3]: [COL_47873A3A_2DB8_46D8_93C8_592195F7E54D#3714501, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_C_REGLE_MCC__209838]
ReadSchema: struct<COL_47873A3A_2DB8_46D8_93C8_592195F7E54D:string,COL_6841DD78_881F_4FF5_8139_B45CB0535307:string,COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388:string>
(51) ColumnarToRow [codegen id : 11]
Input [3]: [COL_47873A3A_2DB8_46D8_93C8_592195F7E54D#3714501, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503]
(52) Filter [codegen id : 11]
Input [3]: [COL_47873A3A_2DB8_46D8_93C8_592195F7E54D#3714501, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503]
Condition : NOT CASE WHEN isnull(Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503, 99)) THEN false ELSE Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503, 99) END
(53) Project [codegen id : 11]
Output [6]: [COL_47873A3A_2DB8_46D8_93C8_592195F7E54D#3714501 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715807, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715809, str_extract_by_str(COL_47873A3A_2DB8_46D8_93C8_592195F7E54D#3714501, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715868, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715869, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715870]
Input [3]: [COL_47873A3A_2DB8_46D8_93C8_592195F7E54D#3714501, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503]
(54) Project [codegen id : 11]
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715868, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715807, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715809, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715869, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715870, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715869 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715912, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715913]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715807, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715809, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715868, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715869, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715870]
(55) Scan parquet
Output [3]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714493, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_K_REGLE_APC__209834]
ReadSchema: struct<COL_D05A5A65_F564_4122_87B0_3083E0B30F75:string,COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86:string,COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24:string>
(56) ColumnarToRow [codegen id : 12]
Input [3]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714493, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495]
(57) Filter [codegen id : 12]
Input [3]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714493, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495]
Condition : NOT CASE WHEN isnull(Contains(COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495, 99)) THEN false ELSE Contains(COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495, 99) END
(58) Project [codegen id : 12]
Output [6]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714493 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715810, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715812, str_extract_by_str(COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714493, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715871, str_extract_by_str(COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715872, str_if_with_rule(CASE WHEN isnull(Contains(COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, -)) THEN false ELSE Contains(COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, -) END, str_extract_by_str(COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715873]
Input [3]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714493, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495]
(59) Project [codegen id : 12]
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715871, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715810, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715812, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715872, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715873, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715872 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715914, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715915]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715810, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715812, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715871, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715872, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715873]
(60) Union
(61) Exchange
Input [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Arguments: hashpartitioning(COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, 10), ENSURE_REQUIREMENTS, [plan_id=1750710]
(62) ShuffleQueryStage
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Arguments: 0
(63) AQEShuffleRead
Input [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Arguments: coalesced
(64) Sort [codegen id : 27]
Input [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Arguments: [COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236 ASC NULLS FIRST], false, 0
(65) Scan parquet
Output [5]: [Code+Acte#3714581, Montant#3714582, Date_effet#3714584, Date_r%C3%A9vocation#3714585, Trigramme#3714586]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/TARIF_FORFAITS__209680_68aece093db7651829d169b47d8f1007/Region-PUBGUAMAR_tarifs_forfait_urgences.xlsx_f248a746ae6749541de5cb400779b610]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>
(66) ColumnarToRow [codegen id : 13]
Input [5]: [Code+Acte#3714581, Montant#3714582, Date_effet#3714584, Date_r%C3%A9vocation#3714585, Trigramme#3714586]
(67) Filter [codegen id : 13]
Input [5]: [Code+Acte#3714581, Montant#3714582, Date_effet#3714584, Date_r%C3%A9vocation#3714585, Trigramme#3714586]
Condition : ((isnotnull(Code+Acte#3714581) AND isnotnull(str_to_datez(Date_effet#3714584, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#3714585, dd/MM/yyyy, Europe/Paris, fr_FR)))
(68) Project [codegen id : 13]
Output [5]: [Code+Acte#3714581 AS COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, Montant#3714582 AS COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, Date_effet#3714584 AS COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, Date_r%C3%A9vocation#3714585 AS COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, Trigramme#3714586 AS COL_402418E3_610B_427B_99E9_757F2815930F#3714888]
Input [5]: [Code+Acte#3714581, Montant#3714582, Date_effet#3714584, Date_r%C3%A9vocation#3714585, Trigramme#3714586]
(69) Scan parquet
Output [5]: [Code+Acte#3714652, Montant#3714653, Date_effet#3714655, Date_r%C3%A9vocation#3714656, Trigramme#3714657]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/TARIF_FORFAITS__209680_487d9620aef977a35caf0785aba1224a/Region-PUBGUYRE_tarifs_forfait_urgences.xlsx_345e824a0977600a1bf1e23b20890e4c]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>
(70) ColumnarToRow [codegen id : 14]
Input [5]: [Code+Acte#3714652, Montant#3714653, Date_effet#3714655, Date_r%C3%A9vocation#3714656, Trigramme#3714657]
(71) Filter [codegen id : 14]
Input [5]: [Code+Acte#3714652, Montant#3714653, Date_effet#3714655, Date_r%C3%A9vocation#3714656, Trigramme#3714657]
Condition : ((isnotnull(Code+Acte#3714652) AND isnotnull(str_to_datez(Date_effet#3714655, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#3714656, dd/MM/yyyy, Europe/Paris, fr_FR)))
(72) Project [codegen id : 14]
Output [5]: [Code+Acte#3714652 AS COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715874, Montant#3714653 AS COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715875, Date_effet#3714655 AS COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715876, Date_r%C3%A9vocation#3714656 AS COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715877, Trigramme#3714657 AS COL_402418E3_610B_427B_99E9_757F2815930F#3715878]
Input [5]: [Code+Acte#3714652, Montant#3714653, Date_effet#3714655, Date_r%C3%A9vocation#3714656, Trigramme#3714657]
(73) Scan parquet
Output [5]: [Code+Acte#3714730, Montant#3714731, Date_effet#3714733, Date_r%C3%A9vocation#3714734, Trigramme#3714735]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/TARIF_FORFAITS__209680_beb651606f1bb0edcd76b2deb99a9e71/Region-PUBMET_tarifs_forfait_urgences.xlsx_a4be18433008c3bf2d62edb56173900d]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>
(74) ColumnarToRow [codegen id : 15]
Input [5]: [Code+Acte#3714730, Montant#3714731, Date_effet#3714733, Date_r%C3%A9vocation#3714734, Trigramme#3714735]
(75) Filter [codegen id : 15]
Input [5]: [Code+Acte#3714730, Montant#3714731, Date_effet#3714733, Date_r%C3%A9vocation#3714734, Trigramme#3714735]
Condition : ((isnotnull(Code+Acte#3714730) AND isnotnull(str_to_datez(Date_effet#3714733, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#3714734, dd/MM/yyyy, Europe/Paris, fr_FR)))
(76) Project [codegen id : 15]
Output [5]: [Code+Acte#3714730 AS COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715879, Montant#3714731 AS COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715880, Date_effet#3714733 AS COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715881, Date_r%C3%A9vocation#3714734 AS COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715882, Trigramme#3714735 AS COL_402418E3_610B_427B_99E9_757F2815930F#3715883]
Input [5]: [Code+Acte#3714730, Montant#3714731, Date_effet#3714733, Date_r%C3%A9vocation#3714734, Trigramme#3714735]
(77) Union
(78) Exchange
Input [5]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, COL_402418E3_610B_427B_99E9_757F2815930F#3714888]
Arguments: hashpartitioning(coalesce(COL_402418E3_610B_427B_99E9_757F2815930F#3714888, ), isnull(COL_402418E3_610B_427B_99E9_757F2815930F#3714888), 10), ENSURE_REQUIREMENTS, [plan_id=1750850]
(79) ShuffleQueryStage
Output [5]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, COL_402418E3_610B_427B_99E9_757F2815930F#3714888]
Arguments: 1
(80) AQEShuffleRead
Input [5]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, COL_402418E3_610B_427B_99E9_757F2815930F#3714888]
Arguments: coalesced
(81) Sort [codegen id : 21]
Input [5]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, COL_402418E3_610B_427B_99E9_757F2815930F#3714888]
Arguments: [coalesce(COL_402418E3_610B_427B_99E9_757F2815930F#3714888, ) ASC NULLS FIRST, isnull(COL_402418E3_610B_427B_99E9_757F2815930F#3714888) ASC NULLS FIRST], false, 0
(82) Scan csv
Output [1]: [region-tarif#3714525]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/INFOETAB_DATAAP_209667/current/info_dataapps.csv]
ReadSchema: struct<region-tarif:string>
(83) Project [codegen id : 16]
Output [1]: [region-tarif#3714525 AS INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
Input [1]: [region-tarif#3714525]
(84) Exchange
Input [1]: [INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
Arguments: hashpartitioning(coalesce(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900, ), isnull(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900), 10), ENSURE_REQUIREMENTS, [plan_id=1750880]
(85) ShuffleQueryStage
Output [1]: [INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
Arguments: 2
(86) AQEShuffleRead
Input [1]: [INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
Arguments: coalesced
(87) Sort [codegen id : 22]
Input [1]: [INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
Arguments: [coalesce(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900, ) ASC NULLS FIRST, isnull(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900) ASC NULLS FIRST], false, 0
(88) SortMergeJoin [codegen id : 23]
Left keys [2]: [coalesce(COL_402418E3_610B_427B_99E9_757F2815930F#3714888, ), isnull(COL_402418E3_610B_427B_99E9_757F2815930F#3714888)]
Right keys [2]: [coalesce(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900, ), isnull(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900)]
Join type: Cross
Join condition: None
(89) Project [codegen id : 23]
Output [4]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883 AS 99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, str_to_dec(str_replace(COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, ., ,), ##,##) AS 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306, str_to_datez(COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, dd/MM/yyyy, Europe/Paris, fr_FR) AS 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308, str_to_datez(COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, dd/MM/yyyy, Europe/Paris, fr_FR) AS 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309]
Input [6]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, COL_402418E3_610B_427B_99E9_757F2815930F#3714888, INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
(90) Exchange
Input [4]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309]
Arguments: hashpartitioning(99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, 10), ENSURE_REQUIREMENTS, [plan_id=1751260]
(91) ShuffleQueryStage
Output [4]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309]
Arguments: 7
(92) AQEShuffleRead
Input [4]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309]
Arguments: coalesced
(93) Sort [codegen id : 28]
Input [4]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309]
Arguments: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305 ASC NULLS FIRST], false, 0
(94) SortMergeJoin [codegen id : 29]
Left keys [1]: [COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236]
Right keys [1]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305]
Join type: LeftOuter
Join condition: ((COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289 >= 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308) AND (COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289 <= 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309))
(95) Project [codegen id : 29]
Output [10]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306 AS COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236 <=> APC), CS, null) AS COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Input [12]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289, 99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309]
(96) Exchange
Input [10]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Arguments: hashpartitioning(COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, 10), ENSURE_REQUIREMENTS, [plan_id=1751434]
(97) ShuffleQueryStage
Output [10]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Arguments: 10
(98) AQEShuffleRead
Input [10]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Arguments: coalesced
(99) Sort [codegen id : 30]
Input [10]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Arguments: [COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434 ASC NULLS FIRST], false, 0
(100) ReusedExchange [Reuses operator id: 90]
Output [4]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715454, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715456, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715457]
(101) ShuffleQueryStage
Output [4]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715454, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715456, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715457]
Arguments: 9
(102) AQEShuffleRead
Input [4]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715454, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715456, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715457]
Arguments: coalesced
(103) Sort [codegen id : 31]
Input [4]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715454, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715456, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715457]
Arguments: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453 ASC NULLS FIRST], false, 0
(104) SortMergeJoin [codegen id : 32]
Left keys [1]: [COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434]
Right keys [1]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453]
Join type: LeftOuter
Join condition: ((COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289 >= 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715456) AND (COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289 <= 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715457))
(105) Project [codegen id : 32]
Output [9]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, dec_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236 <=> APC), dec_diff(array(COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715454)), COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430) AS COL_7CD5EDED_CB5C_4904_AE08_AA033F2C5E99#3715562]
Input [14]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289, 99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715454, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715456, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715457]
(106) WriteFiles
Input [9]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_7CD5EDED_CB5C_4904_AE08_AA033F2C5E99#3715562]
(107) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/10_CONSOLIDATIO_209771, false, Parquet, [path=file:///data/output/cache/parquet/datablock/10_CONSOLIDATIO_209771], Overwrite, [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68, COL_0D6B804F_6E4E_4106_963C_2054075E1F48, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8, COL_D37472E7_F883_4730_86AA_8A7F19313463, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8, COL_7CD5EDED_CB5C_4904_AE08_AA033F2C5E99]
(108) Filter
Input [1]: [c0#3715005]
Condition : NOT CASE WHEN isnull(Contains(c0#3715005, 99)) THEN false ELSE Contains(c0#3715005, 99) END
(109) Project
Output [6]: [c0#3715005 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, c0#3715005 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, c0#3715005 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, str_extract_by_str(c0#3715005, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, str_extract_by_str(c0#3715005, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, str_if_with_rule(CASE WHEN isnull(Contains(c0#3715005, -)) THEN false ELSE Contains(c0#3715005, -) END, str_extract_by_str(c0#3715005, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242]
Input [1]: [c0#3715005]
(110) Project
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242]
(111) Filter
Input [3]: [COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8#3714469, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471]
Condition : NOT CASE WHEN isnull(Contains(COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471, 99)) THEN false ELSE Contains(COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471, 99) END
(112) Project
Output [6]: [COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8#3714469 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715780, COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715782, str_extract_by_str(COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8#3714469, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715841, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715842, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715843]
Input [3]: [COL_6C6BBF93_BAB3_4DCE_8503_C01EE89888B8#3714469, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714470, COL_C2BD1E30_8C02_46F9_8ED2_7266AAC3FCB9#3714471]
(113) Project
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715841, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715780, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715782, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715842, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715843, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715842 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715894, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715895]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715780, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715781, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715782, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715841, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715842, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715843]
(114) Filter
Input [3]: [COL_56500440_A62D_438C_9CE5_D51F8C919C3F#3714481, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483]
Condition : NOT CASE WHEN isnull(Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483, 99)) THEN false ELSE Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483, 99) END
(115) Project
Output [6]: [COL_56500440_A62D_438C_9CE5_D51F8C919C3F#3714481 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715783, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715785, str_extract_by_str(COL_56500440_A62D_438C_9CE5_D51F8C919C3F#3714481, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715844, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715845, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715846]
Input [3]: [COL_56500440_A62D_438C_9CE5_D51F8C919C3F#3714481, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714482, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714483]
(116) Project
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715844, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715783, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715785, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715845, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715846, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715845 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715896, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715897]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715783, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715784, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715785, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715844, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715845, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715846]
(117) Filter
Input [3]: [COL_AD937A80_F70E_46B1_BDE6_634F409294B2#3715022, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024]
Condition : NOT CASE WHEN isnull(Contains(COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024, 99)) THEN false ELSE Contains(COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024, 99) END
(118) Project
Output [6]: [COL_AD937A80_F70E_46B1_BDE6_634F409294B2#3715022 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715786, COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715788, str_extract_by_str(COL_AD937A80_F70E_46B1_BDE6_634F409294B2#3715022, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715847, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715848, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715849]
Input [3]: [COL_AD937A80_F70E_46B1_BDE6_634F409294B2#3715022, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3715023, COL_D590B2A5_B4CD_4BB4_A63C_524CDF762CC5#3715024]
(119) Project
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715847, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715786, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715788, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715848, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715849, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715848 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715898, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715899]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715786, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715787, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715788, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715847, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715848, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715849]
(120) Filter
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#3714475, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477]
Condition : NOT CASE WHEN isnull(Contains(COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477, 99)) THEN false ELSE Contains(COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477, 99) END
(121) Project
Output [6]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#3714475 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715789, COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715791, str_extract_by_str(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#3714475, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715850, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715851, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715852]
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#3714475, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714476, COL_B71AED96_D44A_4496_B1D2_F66096545E56#3714477]
(122) Project
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715850, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715789, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715791, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715851, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715852, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715851 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715900, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715901]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715789, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715790, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715791, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715850, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715851, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715852]
(123) Filter
Input [3]: [COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5#3714487, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489]
Condition : NOT CASE WHEN isnull(Contains(COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489, 99)) THEN false ELSE Contains(COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489, 99) END
(124) Project
Output [6]: [COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5#3714487 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715792, COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715794, str_extract_by_str(COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5#3714487, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715853, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715854, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715855]
Input [3]: [COL_AFAEDFEE_2D3D_4C9F_AD9F_F26F5B1358C5#3714487, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714488, COL_7C97C649_D9E7_4237_BB70_110DF25D01AA#3714489]
(125) Project
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715853, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715792, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715794, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715854, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715855, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715854 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715902, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715903]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715792, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715793, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715794, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715853, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715854, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715855]
(126) Filter
Input [3]: [COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683#3714976, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978]
Condition : NOT CASE WHEN isnull(Contains(COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978, 99)) THEN false ELSE Contains(COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978, 99) END
(127) Project
Output [6]: [COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683#3714976 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715795, COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715797, str_extract_by_str(COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683#3714976, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715856, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715857, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715858]
Input [3]: [COL_1C4780FF_5410_42A9_8DF2_B826D7FA3683#3714976, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714977, COL_6237B5F1_DE75_404A_9B3A_6AB64296EF83#3714978]
(128) Project
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715856, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715795, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715797, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715857, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715858, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715857 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715904, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715905]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715795, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715796, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715797, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715856, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715857, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715858]
(129) Filter
Input [3]: [COL_54E1D459_5C7A_48F5_B170_4370018BB091#3714455, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457]
Condition : NOT CASE WHEN isnull(Contains(COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457, 99)) THEN false ELSE Contains(COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457, 99) END
(130) Project
Output [6]: [COL_54E1D459_5C7A_48F5_B170_4370018BB091#3714455 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715798, COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715800, str_extract_by_str(COL_54E1D459_5C7A_48F5_B170_4370018BB091#3714455, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715859, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715860, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715861]
Input [3]: [COL_54E1D459_5C7A_48F5_B170_4370018BB091#3714455, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714456, COL_F2A257CC_D5A1_438C_B746_5A49E2EA9AB1#3714457]
(131) Project
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715859, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715798, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715800, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715860, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715861, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715860 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715906, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715907]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715798, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715799, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715800, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715859, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715860, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715861]
(132) Filter
Input [3]: [COL_4E865553_FD41_4B77_99E1_104A3436CCD6#3714461, COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463]
Condition : NOT CASE WHEN isnull(Contains(COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463, 99)) THEN false ELSE Contains(COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463, 99) END
(133) Project
Output [6]: [COL_4E865553_FD41_4B77_99E1_104A3436CCD6#3714461 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715801, COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715803, str_extract_by_str(COL_4E865553_FD41_4B77_99E1_104A3436CCD6#3714461, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715862, str_extract_by_str(COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715863, str_if_with_rule(CASE WHEN isnull(Contains(COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, -)) THEN false ELSE Contains(COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, -) END, str_extract_by_str(COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715864]
Input [3]: [COL_4E865553_FD41_4B77_99E1_104A3436CCD6#3714461, COL_50257357_7A5D_4C96_8D2D_E5E477545A1D#3714462, COL_61CD573A_84B4_4052_BF0E_08DBDFB0F3EB#3714463]
(134) Project
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715862, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715801, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715803, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715863, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715864, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715863 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715908, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715909]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715801, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715802, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715803, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715862, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715863, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715864]
(135) Filter
Input [3]: [COL_8255700E_3CA6_43EA_BAA4_724B9D967C63#3714982, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984]
Condition : NOT CASE WHEN isnull(Contains(COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984, 99)) THEN false ELSE Contains(COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984, 99) END
(136) Project
Output [6]: [COL_8255700E_3CA6_43EA_BAA4_724B9D967C63#3714982 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715804, COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715806, str_extract_by_str(COL_8255700E_3CA6_43EA_BAA4_724B9D967C63#3714982, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715865, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715866, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715867]
Input [3]: [COL_8255700E_3CA6_43EA_BAA4_724B9D967C63#3714982, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714983, COL_822BD024_DE8D_48AC_9E22_15EB11ACD3D1#3714984]
(137) Project
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715865, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715804, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715806, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715866, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715867, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715866 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715910, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715911]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715804, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715805, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715806, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715865, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715866, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715867]
(138) Filter
Input [3]: [COL_47873A3A_2DB8_46D8_93C8_592195F7E54D#3714501, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503]
Condition : NOT CASE WHEN isnull(Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503, 99)) THEN false ELSE Contains(COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503, 99) END
(139) Project
Output [6]: [COL_47873A3A_2DB8_46D8_93C8_592195F7E54D#3714501 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715807, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715809, str_extract_by_str(COL_47873A3A_2DB8_46D8_93C8_592195F7E54D#3714501, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715868, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715869, str_if_with_rule(CASE WHEN isnull(Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, -)) THEN false ELSE Contains(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, -) END, str_extract_by_str(COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715870]
Input [3]: [COL_47873A3A_2DB8_46D8_93C8_592195F7E54D#3714501, COL_6841DD78_881F_4FF5_8139_B45CB0535307#3714502, COL_C019193D_93FE_40E9_BE1E_F83BC0DFF388#3714503]
(140) Project
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715868, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715807, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715809, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715869, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715870, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715869 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715912, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715913]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715807, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715808, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715809, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715868, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715869, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715870]
(141) Filter
Input [3]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714493, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495]
Condition : NOT CASE WHEN isnull(Contains(COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495, 99)) THEN false ELSE Contains(COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495, 99) END
(142) Project
Output [6]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714493 AS COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715810, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495 AS COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494 AS COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715812, str_extract_by_str(COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714493, -, RIGHT) AS COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715871, str_extract_by_str(COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, -, LEFT) AS COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715872, str_if_with_rule(CASE WHEN isnull(Contains(COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, -)) THEN false ELSE Contains(COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, -) END, str_extract_by_str(COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, -, RIGHT), ) AS COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715873]
Input [3]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714493, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714494, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714495]
(143) Project
Output [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715871, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715810, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715812, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715872, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715873, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715872 <=> APC), str_if_with_rule(CASE WHEN isnull(StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, Proposition)) THEN false ELSE StartsWith(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, Proposition) END, P, V), V) AS COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715914, str_to_datez(str_remove_space(str_extract_by_str(COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, @, RIGHT), ALL), yyyy-MM-dd, Europe/Paris, fr_FR) AS COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715915]
Input [6]: [COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715810, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715811, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715812, COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715871, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715872, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715873]
(144) Union
(145) Exchange
Input [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Arguments: hashpartitioning(COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, 10), ENSURE_REQUIREMENTS, [plan_id=1750435]
(146) Sort
Input [8]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Arguments: [COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236 ASC NULLS FIRST], false, 0
(147) Filter
Input [5]: [Code+Acte#3714581, Montant#3714582, Date_effet#3714584, Date_r%C3%A9vocation#3714585, Trigramme#3714586]
Condition : ((isnotnull(Code+Acte#3714581) AND isnotnull(str_to_datez(Date_effet#3714584, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#3714585, dd/MM/yyyy, Europe/Paris, fr_FR)))
(148) Project
Output [5]: [Code+Acte#3714581 AS COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, Montant#3714582 AS COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, Date_effet#3714584 AS COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, Date_r%C3%A9vocation#3714585 AS COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, Trigramme#3714586 AS COL_402418E3_610B_427B_99E9_757F2815930F#3714888]
Input [5]: [Code+Acte#3714581, Montant#3714582, Date_effet#3714584, Date_r%C3%A9vocation#3714585, Trigramme#3714586]
(149) Filter
Input [5]: [Code+Acte#3714652, Montant#3714653, Date_effet#3714655, Date_r%C3%A9vocation#3714656, Trigramme#3714657]
Condition : ((isnotnull(Code+Acte#3714652) AND isnotnull(str_to_datez(Date_effet#3714655, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#3714656, dd/MM/yyyy, Europe/Paris, fr_FR)))
(150) Project
Output [5]: [Code+Acte#3714652 AS COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715874, Montant#3714653 AS COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715875, Date_effet#3714655 AS COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715876, Date_r%C3%A9vocation#3714656 AS COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715877, Trigramme#3714657 AS COL_402418E3_610B_427B_99E9_757F2815930F#3715878]
Input [5]: [Code+Acte#3714652, Montant#3714653, Date_effet#3714655, Date_r%C3%A9vocation#3714656, Trigramme#3714657]
(151) Filter
Input [5]: [Code+Acte#3714730, Montant#3714731, Date_effet#3714733, Date_r%C3%A9vocation#3714734, Trigramme#3714735]
Condition : ((isnotnull(Code+Acte#3714730) AND isnotnull(str_to_datez(Date_effet#3714733, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#3714734, dd/MM/yyyy, Europe/Paris, fr_FR)))
(152) Project
Output [5]: [Code+Acte#3714730 AS COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715879, Montant#3714731 AS COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715880, Date_effet#3714733 AS COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715881, Date_r%C3%A9vocation#3714734 AS COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715882, Trigramme#3714735 AS COL_402418E3_610B_427B_99E9_757F2815930F#3715883]
Input [5]: [Code+Acte#3714730, Montant#3714731, Date_effet#3714733, Date_r%C3%A9vocation#3714734, Trigramme#3714735]
(153) Union
(154) Exchange
Input [5]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, COL_402418E3_610B_427B_99E9_757F2815930F#3714888]
Arguments: hashpartitioning(coalesce(COL_402418E3_610B_427B_99E9_757F2815930F#3714888, ), isnull(COL_402418E3_610B_427B_99E9_757F2815930F#3714888), 10), ENSURE_REQUIREMENTS, [plan_id=1750425]
(155) Sort
Input [5]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, COL_402418E3_610B_427B_99E9_757F2815930F#3714888]
Arguments: [coalesce(COL_402418E3_610B_427B_99E9_757F2815930F#3714888, ) ASC NULLS FIRST, isnull(COL_402418E3_610B_427B_99E9_757F2815930F#3714888) ASC NULLS FIRST], false, 0
(156) Project
Output [1]: [region-tarif#3714525 AS INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
Input [1]: [region-tarif#3714525]
(157) Exchange
Input [1]: [INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
Arguments: hashpartitioning(coalesce(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900, ), isnull(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900), 10), ENSURE_REQUIREMENTS, [plan_id=1750426]
(158) Sort
Input [1]: [INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
Arguments: [coalesce(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900, ) ASC NULLS FIRST, isnull(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900) ASC NULLS FIRST], false, 0
(159) SortMergeJoin
Left keys [2]: [coalesce(COL_402418E3_610B_427B_99E9_757F2815930F#3714888, ), isnull(COL_402418E3_610B_427B_99E9_757F2815930F#3714888)]
Right keys [2]: [coalesce(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900, ), isnull(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900)]
Join type: Cross
Join condition: None
(160) Project
Output [4]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883 AS 99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, str_to_dec(str_replace(COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, ., ,), ##,##) AS 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306, str_to_datez(COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, dd/MM/yyyy, Europe/Paris, fr_FR) AS 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308, str_to_datez(COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, dd/MM/yyyy, Europe/Paris, fr_FR) AS 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309]
Input [6]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, COL_402418E3_610B_427B_99E9_757F2815930F#3714888, INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
(161) Exchange
Input [4]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309]
Arguments: hashpartitioning(99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, 10), ENSURE_REQUIREMENTS, [plan_id=1750436]
(162) Sort
Input [4]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309]
Arguments: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305 ASC NULLS FIRST], false, 0
(163) SortMergeJoin
Left keys [1]: [COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236]
Right keys [1]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305]
Join type: LeftOuter
Join condition: ((COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289 >= 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308) AND (COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289 <= 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309))
(164) Project
Output [10]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306 AS COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, str_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236 <=> APC), CS, null) AS COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Input [12]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289, 99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715305, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715306, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715308, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715309]
(165) Exchange
Input [10]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Arguments: hashpartitioning(COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, 10), ENSURE_REQUIREMENTS, [plan_id=1750454]
(166) Sort
Input [10]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289]
Arguments: [COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434 ASC NULLS FIRST], false, 0
(167) Scan parquet
Output [5]: [Code+Acte#3715467, Montant#3715468, Date_effet#3715470, Date_r%C3%A9vocation#3715471, Trigramme#3715472]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/TARIF_FORFAITS__209680_68aece093db7651829d169b47d8f1007/Region-PUBGUAMAR_tarifs_forfait_urgences.xlsx_f248a746ae6749541de5cb400779b610]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>
(168) Filter
Input [5]: [Code+Acte#3715467, Montant#3715468, Date_effet#3715470, Date_r%C3%A9vocation#3715471, Trigramme#3715472]
Condition : ((isnotnull(Code+Acte#3715467) AND isnotnull(str_to_datez(Date_effet#3715470, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#3715471, dd/MM/yyyy, Europe/Paris, fr_FR)))
(169) Project
Output [5]: [Code+Acte#3715467 AS COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, Montant#3715468 AS COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, Date_effet#3715470 AS COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, Date_r%C3%A9vocation#3715471 AS COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, Trigramme#3715472 AS COL_402418E3_610B_427B_99E9_757F2815930F#3714888]
Input [5]: [Code+Acte#3715467, Montant#3715468, Date_effet#3715470, Date_r%C3%A9vocation#3715471, Trigramme#3715472]
(170) Scan parquet
Output [5]: [Code+Acte#3715474, Montant#3715475, Date_effet#3715477, Date_r%C3%A9vocation#3715478, Trigramme#3715479]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/TARIF_FORFAITS__209680_487d9620aef977a35caf0785aba1224a/Region-PUBGUYRE_tarifs_forfait_urgences.xlsx_345e824a0977600a1bf1e23b20890e4c]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>
(171) Filter
Input [5]: [Code+Acte#3715474, Montant#3715475, Date_effet#3715477, Date_r%C3%A9vocation#3715478, Trigramme#3715479]
Condition : ((isnotnull(Code+Acte#3715474) AND isnotnull(str_to_datez(Date_effet#3715477, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#3715478, dd/MM/yyyy, Europe/Paris, fr_FR)))
(172) Project
Output [5]: [Code+Acte#3715474 AS COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715884, Montant#3715475 AS COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715885, Date_effet#3715477 AS COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715886, Date_r%C3%A9vocation#3715478 AS COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715887, Trigramme#3715479 AS COL_402418E3_610B_427B_99E9_757F2815930F#3715888]
Input [5]: [Code+Acte#3715474, Montant#3715475, Date_effet#3715477, Date_r%C3%A9vocation#3715478, Trigramme#3715479]
(173) Scan parquet
Output [5]: [Code+Acte#3715481, Montant#3715482, Date_effet#3715484, Date_r%C3%A9vocation#3715485, Trigramme#3715486]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/TARIF_FORFAITS__209680_beb651606f1bb0edcd76b2deb99a9e71/Region-PUBMET_tarifs_forfait_urgences.xlsx_a4be18433008c3bf2d62edb56173900d]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>
(174) Filter
Input [5]: [Code+Acte#3715481, Montant#3715482, Date_effet#3715484, Date_r%C3%A9vocation#3715485, Trigramme#3715486]
Condition : ((isnotnull(Code+Acte#3715481) AND isnotnull(str_to_datez(Date_effet#3715484, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#3715485, dd/MM/yyyy, Europe/Paris, fr_FR)))
(175) Project
Output [5]: [Code+Acte#3715481 AS COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715889, Montant#3715482 AS COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715890, Date_effet#3715484 AS COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715891, Date_r%C3%A9vocation#3715485 AS COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715892, Trigramme#3715486 AS COL_402418E3_610B_427B_99E9_757F2815930F#3715893]
Input [5]: [Code+Acte#3715481, Montant#3715482, Date_effet#3715484, Date_r%C3%A9vocation#3715485, Trigramme#3715486]
(176) Union
(177) Exchange
Input [5]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, COL_402418E3_610B_427B_99E9_757F2815930F#3714888]
Arguments: hashpartitioning(coalesce(COL_402418E3_610B_427B_99E9_757F2815930F#3714888, ), isnull(COL_402418E3_610B_427B_99E9_757F2815930F#3714888), 10), ENSURE_REQUIREMENTS, [plan_id=1750444]
(178) Sort
Input [5]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, COL_402418E3_610B_427B_99E9_757F2815930F#3714888]
Arguments: [coalesce(COL_402418E3_610B_427B_99E9_757F2815930F#3714888, ) ASC NULLS FIRST, isnull(COL_402418E3_610B_427B_99E9_757F2815930F#3714888) ASC NULLS FIRST], false, 0
(179) Scan csv
Output [1]: [region-tarif#3715489]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/INFOETAB_DATAAP_209667/current/info_dataapps.csv]
ReadSchema: struct<region-tarif:string>
(180) Project
Output [1]: [region-tarif#3715489 AS INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
Input [1]: [region-tarif#3715489]
(181) Exchange
Input [1]: [INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
Arguments: hashpartitioning(coalesce(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900, ), isnull(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900), 10), ENSURE_REQUIREMENTS, [plan_id=1750445]
(182) Sort
Input [1]: [INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
Arguments: [coalesce(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900, ) ASC NULLS FIRST, isnull(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900) ASC NULLS FIRST], false, 0
(183) SortMergeJoin
Left keys [2]: [coalesce(COL_402418E3_610B_427B_99E9_757F2815930F#3714888, ), isnull(COL_402418E3_610B_427B_99E9_757F2815930F#3714888)]
Right keys [2]: [coalesce(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900, ), isnull(INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900)]
Join type: Cross
Join condition: None
(184) Project
Output [4]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883 AS 99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453, str_to_dec(str_replace(COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, ., ,), ##,##) AS 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715454, str_to_datez(COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, dd/MM/yyyy, Europe/Paris, fr_FR) AS 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715456, str_to_datez(COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, dd/MM/yyyy, Europe/Paris, fr_FR) AS 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715457]
Input [6]: [COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3714883, COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3714884, COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3714886, COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3714887, COL_402418E3_610B_427B_99E9_757F2815930F#3714888, INFO_DATAAPPS_209885_COL_ABDE39AA_1E54_4EE2_AB64_E61819CAEA37#3714900]
(185) Exchange
Input [4]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715454, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715456, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715457]
Arguments: hashpartitioning(99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453, 10), ENSURE_REQUIREMENTS, [plan_id=1750455]
(186) Sort
Input [4]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715454, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715456, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715457]
Arguments: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453 ASC NULLS FIRST], false, 0
(187) SortMergeJoin
Left keys [1]: [COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434]
Right keys [1]: [99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453]
Join type: LeftOuter
Join condition: ((COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289 >= 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715456) AND (COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289 <= 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715457))
(188) Project
Output [9]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, dec_if_with_rule((COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236 <=> APC), dec_diff(array(COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715454)), COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430) AS COL_7CD5EDED_CB5C_4904_AE08_AA033F2C5E99#3715562]
Input [14]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_D97AE06F_6181_42CF_B20D_455C4648BB68#3715434, COL_24EF8090_481F_45DD_BE73_AA45C3EBB291#3715289, 99_TARIF_HISTOR_209850_COL_43C661B5_922E_4FB1_BAF1_7B3000C756FA#3715453, 99_TARIF_HISTOR_209850_COL_E3D31EEF_3623_4828_829E_71E55DE7281F#3715454, 99_TARIF_HISTOR_209850_COL_F3D97D49_7BE9_48F6_B9E3_F3C8DC833F09#3715456, 99_TARIF_HISTOR_209850_COL_A154FB84_E41C_41E2_A24F_E70D8172718F#3715457]
(189) WriteFiles
Input [9]: [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68#3715231, COL_0D6B804F_6E4E_4106_963C_2054075E1F48#3715219, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219#3715220, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8#3715221, COL_D37472E7_F883_4730_86AA_8A7F19313463#3715430, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512#3715236, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA#3715242, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8#3715288, COL_7CD5EDED_CB5C_4904_AE08_AA033F2C5E99#3715562]
(190) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/10_CONSOLIDATIO_209771, false, Parquet, [path=file:///data/output/cache/parquet/datablock/10_CONSOLIDATIO_209771], Overwrite, [COL_FC1DEDDD_F6E8_477D_ACDE_FE69F7E9BC68, COL_0D6B804F_6E4E_4106_963C_2054075E1F48, COL_F8F4501B_9215_45B8_8482_A6D00C7E1219, COL_CE32BA7E_7F3E_45CB_9B4F_02D94DF188B8, COL_D37472E7_F883_4730_86AA_8A7F19313463, COL_26C5613E_4B62_48B0_BC4B_AAC5E01A0512, COL_0CDDF5AD_C26B_495C_8DED_7E817D243BEA, COL_E653E27B_68E4_45D1_9CE1_5C6AB9E346D8, COL_7CD5EDED_CB5C_4904_AE08_AA033F2C5E99]
(191) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true