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: 1 ms<br>number of written files: 1<br>job commit time: 14 ms<br>number of output rows: 1<br>number of dynamic part: 0<br>written output: 3.5 KiB"];
2 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster3 {
isCluster="true";
label="WholeStageCodegen (12)\n \nduration: 803 ms";
4 [labelType="html" label="<br><b>Project</b><br><br>"];
5 [labelType="html" label="<br><b>Project</b><br><br>"];
6 [labelType="html" label="<br><b>Project</b><br><br>"];
7 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 1<br>spill size: 0.0 B"];
}
subgraph cluster8 {
isCluster="true";
label="WholeStageCodegen (10)\n \nduration: 1.2 s";
9 [labelType="html" label="<br><b>Project</b><br><br>"];
10 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 12,897<br>spill size: 0.0 B"];
}
subgraph cluster11 {
isCluster="true";
label="WholeStageCodegen (8)\n \nduration: 0 ms";
12 [labelType="html" label="<b>Sort</b><br><br>sort time: 7 ms<br>peak memory: 17.0 MiB<br>spill size: 0.0 B"];
}
13 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 216.7 KiB<br>number of coalesced partitions: 1"];
14 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 33,279<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: 33,279<br>local bytes read: 204.5 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: 1819.9 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: 204.5 KiB"];
subgraph cluster15 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: 100 ms";
16 [labelType="html" label="<br><b>Project</b><br><br>"];
}
17 [labelType="html" label="<b>CartesianProduct</b><br><br>number of output rows: 33,279"];
subgraph cluster18 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 100 ms";
19 [labelType="html" label="<br><b>Project</b><br><br>"];
20 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 33,279"];
}
21 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster22 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 148 ms";
23 [labelType="html" label="<b>Sort</b><br><br>sort time: 15 ms<br>peak memory: 20.0 MiB<br>spill size: 0.0 B"];
}
24 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 317.3 KiB<br>number of coalesced partitions: 1"];
25 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 116,733<br>local merged chunks fetched: 0<br>shuffle write time: 2 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: 116,733<br>local bytes read: 304.8 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: 4.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: 304.8 KiB"];
subgraph cluster26 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 293 ms";
27 [labelType="html" label="<br><b>Project</b><br><br>"];
28 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 116,733"];
}
29 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 116,733<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 1938.1 KiB"];
subgraph cluster30 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: 7 ms";
31 [labelType="html" label="<br><b>Project</b><br><br>"];
32 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 1"];
}
33 [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: 175.0 B"];
subgraph cluster34 {
isCluster="true";
label="WholeStageCodegen (9)\n \nduration: 2.4 s";
35 [labelType="html" label="<b>Sort</b><br><br>sort time: 5 ms<br>peak memory: 16.5 MiB<br>spill size: 0.0 B"];
}
36 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 402.0 KiB<br>number of coalesced partitions: 1"];
37 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 12,897<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>72 ms (2 ms, 9 ms, 10 ms (stage 6982.0: task 9076))<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: 12,897<br>local bytes read: 384.1 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 10<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>1129.1 KiB (107.1 KiB, 113.6 KiB, 118.4 KiB (stage 6982.0: task 9071))<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>384.1 KiB (36.3 KiB, 38.6 KiB, 40.3 KiB (stage 6982.0: task 9071))"];
subgraph cluster38 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n153 ms (4 ms, 12 ms, 28 ms (stage 6982.0: task 9071))";
39 [labelType="html" label="<br><b>Project</b><br><br>"];
40 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 12,897"];
41 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 12,897<br>number of input batches: 10"];
}
42 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 10<br>scan time total (min, med, max (stageId: taskId))<br>99 ms (2 ms, 8 ms, 20 ms (stage 6982.0: task 9078))<br>metadata time: 0 ms<br>size of files read: 2041.6 KiB<br>number of output rows: 12,897"];
subgraph cluster43 {
isCluster="true";
label="WholeStageCodegen (11)\n \nduration: 0 ms";
44 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.5 MiB<br>spill size: 0.0 B"];
}
45 [labelType="html" label="<b>ObjectHashAggregate</b><br><br>number of output rows: 18,969<br>time in aggregation build: 29 ms<br>spill size: 0.0 B<br>number of sort fallback tasks: 1"];
46 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 262.2 KiB<br>number of coalesced partitions: 1"];
47 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 18,969<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>2 ms (1 ms, 1 ms, 1 ms (stage 6983.0: task 9081))<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: 18,969<br>local bytes read: 250.0 KiB<br>fetch wait time: 0 ms<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 total (min, med, max (stageId: taskId))<br>1926.6 KiB (772.5 KiB, 1154.1 KiB, 1154.1 KiB (stage 6983.0: task 9081))<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>250.0 KiB (100.0 KiB, 150.0 KiB, 150.0 KiB (stage 6983.0: task 9081))"];
48 [labelType="html" label="<b>ObjectHashAggregate</b><br><br>number of output rows: 18,969<br>time in aggregation build total (min, med, max (stageId: taskId))<br>207 ms (98 ms, 109 ms, 109 ms (stage 6983.0: task 9081))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 6983.0: task 9082))<br>number of sort fallback tasks: 2"];
subgraph cluster49 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n205 ms (97 ms, 108 ms, 108 ms (stage 6983.0: task 9081))";
50 [labelType="html" label="<br><b>Project</b><br><br>"];
51 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 70,650"];
52 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 70,654<br>number of input batches: 18"];
}
53 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 2<br>scan time total (min, med, max (stageId: taskId))<br>10 ms (4 ms, 6 ms, 6 ms (stage 6983.0: task 9081))<br>metadata time: 0 ms<br>size of files read: 2.3 MiB<br>number of output rows: 70,654"];
1->0;
2->1;
4->2;
5->4;
6->5;
7->6;
9->7;
10->9;
12->10;
13->12;
14->13;
16->14;
17->16;
19->17;
20->19;
21->20;
23->21;
24->23;
25->24;
27->25;
28->27;
29->28;
31->17;
32->31;
33->32;
35->10;
36->35;
37->36;
39->37;
40->39;
41->40;
42->41;
44->7;
45->44;
46->45;
47->46;
48->47;
50->48;
51->50;
52->51;
53->52;
}
54
AdaptiveSparkPlan isFinalPlan=true
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_GR5_SU2_SU3_226031, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR5_SU2_SU3_226031], Overwrite, [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4, COL_EB745243_852A_470C_A1E1_722CE684E626, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850, COL_EF5B8E51_0EA9_4466_A691_A2B708205606]
WriteFiles
Project [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, str_if_with_rule(isnotnull(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, +)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, -) END, Switch de forfait (SU*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, -) END, Suppression de Forfait, )), COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044), @), ) AS COL_EB745243_852A_470C_A1E1_722CE684E626#582924, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591]
Project [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591, str_if_with_rule(CASE WHEN isnull(Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, >)) THEN false ELSE Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, >) END, str_join(array(str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, >, LEFT), -)), str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, >, RIGHT), +))), ,), COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587) AS COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616]
Project [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))) AS COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, str_create(RC-SU2-SU3) AS COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, 02_ACTES_PATIEN_225933_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#582009 AS COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, str_join(array(str_join(array(CCMU , COL_15586747_17B8_4040_ACEB_0A327605038C#581712), : ), str_join(array(Acte Eligible SU2 , str_list_as_str(02_ACTES_PATIEN_225933_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#582010)), : )), - ) AS COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591]
SortMergeJoin [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709], [02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#582006], Inner, (NOT (str_if_with_rule(CASE WHEN isnull(Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >) END, str_join(array(str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >, LEFT), -)), str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null)))))) <=> ) AND isnotnull(str_if_with_rule(CASE WHEN isnull(Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >) END, str_join(array(str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >, LEFT), -)), str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))))))
WholeStageCodegen (12)
Project [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806 AS COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818 AS COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763]
SortMergeJoin [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709], [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810], Inner
WholeStageCodegen (10)
Sort [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709 ASC NULLS FIRST], false, 0
WholeStageCodegen (8)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, 10), ENSURE_REQUIREMENTS, [plan_id=361017]
Project [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, REGLES_A_APPLIQ_225642_APPLICABLE_225644#581719 AS COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763]
WholeStageCodegen (7)
CartesianProduct
Project [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924 AS COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927 AS COL_15586747_17B8_4040_ACEB_0A327605038C#581712]
Filter (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#580940 <=> 1)
WholeStageCodegen (5)
Window [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#580940], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924], [1 DESC NULLS LAST]
Sort [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (4)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, 10), ENSURE_REQUIREMENTS, [plan_id=360605]
Project [Numéro Séjour#580808 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, str_remove_space(str_list_get(str_extract_by_regex(Niveau CCMU#580813, [+\d]+), 0), ALL) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927]
Filter (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#580808, #)) THEN false ELSE StartsWith(Numéro Séjour#580808, #) END AND isnotnull(Numéro Séjour#580808))
WholeStageCodegen (1)
FileScan csv [Numéro Séjour#580808,Niveau CCMU#580813] Batched: false, DataFilters: [NOT CASE WHEN isnull(StartsWith(Numéro Séjour#580808, #)) THEN false ELSE StartsWith(Numéro Séjo..., Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/02_PASSAGE_PATI_225508/passage_Patient...., PartitionFilters: [], PushedFilters: [IsNotNull(Numéro Séjour)], ReadSchema: struct<Numéro Séjour:string,Niveau CCMU:string>
Project [APPLICABLE#580644 AS REGLES_A_APPLIQ_225642_APPLICABLE_225644#581719]
Filter ((isnotnull(REGLES#580643) AND (RC-SU2-SU3 = REGLES#580643)) AND (APPLICABLE#580644 <=> O))
WholeStageCodegen (6)
FileScan csv [REGLES#580643,APPLICABLE#580644] Batched: false, DataFilters: [isnotnull(REGLES#580643), (RC-SU2-SU3 = REGLES#580643), (APPLICABLE#580644 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_225515/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SU2-SU3), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>
Sort [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810 ASC NULLS FIRST], false, 0
WholeStageCodegen (9)
AQEShuffleRead coalesced
Exchange hashpartitioning(03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, 10), ENSURE_REQUIREMENTS, [plan_id=360639]
Project [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019 AS 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023 AS 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, COL_60F7C888_9836_4535_A22F_D43D2994E019#581031 AS 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818]
Filter ((isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019) AND NOT CASE WHEN isnull(StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023, #)) THEN false ELSE StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023, #) END) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023))
ColumnarToRow
WholeStageCodegen (2)
FileScan parquet [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023,COL_60F7C888_9836_4535_A22F_D43D2994E019#581031] Batched: true, DataFilters: [isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019), NOT CASE WHEN isnull(StartsWith(COL_..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_225663], PartitionFilters: [], PushedFilters: [IsNotNull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F), IsNotNull(COL_582B8737_1AAE_44AC_AF57_EB71A..., ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:s...
Sort [02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#582006 ASC NULLS FIRST], false, 0
WholeStageCodegen (11)
ObjectHashAggregate(keys=[COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494], functions=[collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, 0, 0), min(COL_FBB15BE3_311B_4A50_A657_811052E44533#581497), collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498, 0, 0)])
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, 10), ENSURE_REQUIREMENTS, [plan_id=360673]
ObjectHashAggregate(keys=[COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494], functions=[partial_collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, 0, 0), partial_min(COL_FBB15BE3_311B_4A50_A657_811052E44533#581497), partial_collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498, 0, 0)])
Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, str_if_with_rule(((COL_F94DAC07_127C_4495_A440_68EF585E7F25#581104 <=> 1) AND CASE WHEN isnull(Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118, 2)) THEN false ELSE Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118, 2) END), SU2, str_if_with_rule((((COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118 <=> 3) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118 <=> 4)) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118 <=> 5)), SU3, null)) AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#581122 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#581497, COL_1996D387_9E74_479E_8427_83B4DBA88131#581141 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498]
Filter (isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095) AND NOT CASE WHEN isnull(StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095, #)) THEN false ELSE StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095, #) END)
ColumnarToRow
WholeStageCodegen (3)
FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095,COL_F94DAC07_127C_4495_A440_68EF585E7F25#581104,COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118,COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#581122,COL_1996D387_9E74_479E_8427_83B4DBA88131#581141] Batched: true, DataFilters: [isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095), NOT CASE WHEN isnull(StartsWith(COL_..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_225863], PartitionFilters: [], PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)], ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_F94DAC07_127C_4495_A440_68EF585E7F25:s...
== Physical Plan ==
AdaptiveSparkPlan (78)
+- == Final Plan ==
Execute InsertIntoHadoopFsRelationCommand (45)
+- WriteFiles (44)
+- * Project (43)
+- * Project (42)
+- * Project (41)
+- * SortMergeJoin Inner (40)
:- * Project (29)
: +- * SortMergeJoin Inner (28)
: :- * Sort (19)
: : +- AQEShuffleRead (18)
: : +- ShuffleQueryStage (17), Statistics(sizeInBytes=1819.9 KiB, rowCount=3.33E+4)
: : +- Exchange (16)
: : +- * Project (15)
: : +- CartesianProduct Inner (14)
: : :- * Project (10)
: : : +- * Filter (9)
: : : +- Window (8)
: : : +- * Sort (7)
: : : +- AQEShuffleRead (6)
: : : +- ShuffleQueryStage (5), Statistics(sizeInBytes=4.5 MiB, rowCount=1.17E+5)
: : : +- Exchange (4)
: : : +- * Project (3)
: : : +- * Filter (2)
: : : +- Scan csv (1)
: : +- * Project (13)
: : +- * Filter (12)
: : +- Scan csv (11)
: +- * Sort (27)
: +- AQEShuffleRead (26)
: +- ShuffleQueryStage (25), Statistics(sizeInBytes=1129.1 KiB, rowCount=1.29E+4)
: +- Exchange (24)
: +- * Project (23)
: +- * Filter (22)
: +- * ColumnarToRow (21)
: +- Scan parquet (20)
+- * Sort (39)
+- ObjectHashAggregate (38)
+- AQEShuffleRead (37)
+- ShuffleQueryStage (36), Statistics(sizeInBytes=1926.6 KiB, rowCount=1.90E+4)
+- Exchange (35)
+- ObjectHashAggregate (34)
+- * Project (33)
+- * Filter (32)
+- * ColumnarToRow (31)
+- Scan parquet (30)
+- == Initial Plan ==
Execute InsertIntoHadoopFsRelationCommand (77)
+- WriteFiles (76)
+- Project (75)
+- Project (74)
+- Project (73)
+- SortMergeJoin Inner (72)
:- Project (65)
: +- SortMergeJoin Inner (64)
: :- Sort (59)
: : +- Exchange (58)
: : +- Project (57)
: : +- CartesianProduct Inner (56)
: : :- Project (52)
: : : +- Filter (51)
: : : +- Window (50)
: : : +- Sort (49)
: : : +- Exchange (48)
: : : +- Project (47)
: : : +- Filter (46)
: : : +- Scan csv (1)
: : +- Project (55)
: : +- Filter (54)
: : +- Scan csv (53)
: +- Sort (63)
: +- Exchange (62)
: +- Project (61)
: +- Filter (60)
: +- Scan parquet (20)
+- Sort (71)
+- ObjectHashAggregate (70)
+- Exchange (69)
+- ObjectHashAggregate (68)
+- Project (67)
+- Filter (66)
+- Scan parquet (30)
(1) Scan csv
Output [2]: [Numéro Séjour#580808, Niveau CCMU#580813]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/02_PASSAGE_PATI_225508/passage_Patient.csv]
PushedFilters: [IsNotNull(Numéro Séjour)]
ReadSchema: struct<Numéro Séjour:string,Niveau CCMU:string>
(2) Filter [codegen id : 1]
Input [2]: [Numéro Séjour#580808, Niveau CCMU#580813]
Condition : (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#580808, #)) THEN false ELSE StartsWith(Numéro Séjour#580808, #) END AND isnotnull(Numéro Séjour#580808))
(3) Project [codegen id : 1]
Output [2]: [Numéro Séjour#580808 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, str_remove_space(str_list_get(str_extract_by_regex(Niveau CCMU#580813, [+\d]+), 0), ALL) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927]
Input [2]: [Numéro Séjour#580808, Niveau CCMU#580813]
(4) Exchange
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, 10), ENSURE_REQUIREMENTS, [plan_id=360605]
(5) ShuffleQueryStage
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927]
Arguments: 0
(6) AQEShuffleRead
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927]
Arguments: coalesced
(7) Sort [codegen id : 4]
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(8) Window
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#580940], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924], [1 DESC NULLS LAST]
(9) Filter [codegen id : 5]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#580940]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#580940 <=> 1)
(10) Project [codegen id : 5]
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924 AS COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927 AS COL_15586747_17B8_4040_ACEB_0A327605038C#581712]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#580940]
(11) Scan csv
Output [2]: [REGLES#580643, APPLICABLE#580644]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_225515/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SU2-SU3), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(12) Filter [codegen id : 6]
Input [2]: [REGLES#580643, APPLICABLE#580644]
Condition : ((isnotnull(REGLES#580643) AND (RC-SU2-SU3 = REGLES#580643)) AND (APPLICABLE#580644 <=> O))
(13) Project [codegen id : 6]
Output [1]: [APPLICABLE#580644 AS REGLES_A_APPLIQ_225642_APPLICABLE_225644#581719]
Input [2]: [REGLES#580643, APPLICABLE#580644]
(14) CartesianProduct
Join type: Inner
Join condition: None
(15) Project [codegen id : 7]
Output [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, REGLES_A_APPLIQ_225642_APPLICABLE_225644#581719 AS COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763]
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, REGLES_A_APPLIQ_225642_APPLICABLE_225644#581719]
(16) Exchange
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763]
Arguments: hashpartitioning(COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, 10), ENSURE_REQUIREMENTS, [plan_id=361017]
(17) ShuffleQueryStage
Output [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763]
Arguments: 3
(18) AQEShuffleRead
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763]
Arguments: coalesced
(19) Sort [codegen id : 8]
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763]
Arguments: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709 ASC NULLS FIRST], false, 0
(20) Scan parquet
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023, COL_60F7C888_9836_4535_A22F_D43D2994E019#581031]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_225663]
PushedFilters: [IsNotNull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F), IsNotNull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8)]
ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:string,COL_60F7C888_9836_4535_A22F_D43D2994E019:string>
(21) ColumnarToRow [codegen id : 2]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023, COL_60F7C888_9836_4535_A22F_D43D2994E019#581031]
(22) Filter [codegen id : 2]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023, COL_60F7C888_9836_4535_A22F_D43D2994E019#581031]
Condition : ((isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019) AND NOT CASE WHEN isnull(StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023, #)) THEN false ELSE StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023, #) END) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023))
(23) Project [codegen id : 2]
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019 AS 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023 AS 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, COL_60F7C888_9836_4535_A22F_D43D2994E019#581031 AS 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023, COL_60F7C888_9836_4535_A22F_D43D2994E019#581031]
(24) Exchange
Input [3]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818]
Arguments: hashpartitioning(03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, 10), ENSURE_REQUIREMENTS, [plan_id=360639]
(25) ShuffleQueryStage
Output [3]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818]
Arguments: 1
(26) AQEShuffleRead
Input [3]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818]
Arguments: coalesced
(27) Sort [codegen id : 9]
Input [3]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818]
Arguments: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810 ASC NULLS FIRST], false, 0
(28) SortMergeJoin [codegen id : 10]
Left keys [1]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709]
Right keys [1]: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810]
Join type: Inner
Join condition: None
(29) Project [codegen id : 10]
Output [5]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806 AS COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818 AS COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763]
Input [6]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818]
(30) Scan parquet
Output [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095, COL_F94DAC07_127C_4495_A440_68EF585E7F25#581104, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#581122, COL_1996D387_9E74_479E_8427_83B4DBA88131#581141]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_225863]
PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_F94DAC07_127C_4495_A440_68EF585E7F25:string,COL_6A8C3138_77B0_404C_B949_FC01E1C85545:string,COL_EA6371C8_0F76_4199_B797_A5888F7D4D43:timestamp,COL_1996D387_9E74_479E_8427_83B4DBA88131:string>
(31) ColumnarToRow [codegen id : 3]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095, COL_F94DAC07_127C_4495_A440_68EF585E7F25#581104, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#581122, COL_1996D387_9E74_479E_8427_83B4DBA88131#581141]
(32) Filter [codegen id : 3]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095, COL_F94DAC07_127C_4495_A440_68EF585E7F25#581104, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#581122, COL_1996D387_9E74_479E_8427_83B4DBA88131#581141]
Condition : (isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095) AND NOT CASE WHEN isnull(StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095, #)) THEN false ELSE StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095, #) END)
(33) Project [codegen id : 3]
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, str_if_with_rule(((COL_F94DAC07_127C_4495_A440_68EF585E7F25#581104 <=> 1) AND CASE WHEN isnull(Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118, 2)) THEN false ELSE Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118, 2) END), SU2, str_if_with_rule((((COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118 <=> 3) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118 <=> 4)) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118 <=> 5)), SU3, null)) AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#581122 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#581497, COL_1996D387_9E74_479E_8427_83B4DBA88131#581141 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095, COL_F94DAC07_127C_4495_A440_68EF585E7F25#581104, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#581122, COL_1996D387_9E74_479E_8427_83B4DBA88131#581141]
(34) ObjectHashAggregate
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, COL_FBB15BE3_311B_4A50_A657_811052E44533#581497, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498]
Keys [1]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494]
Functions [3]: [partial_collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, 0, 0), partial_min(COL_FBB15BE3_311B_4A50_A657_811052E44533#581497), partial_collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498, 0, 0)]
Aggregate Attributes [3]: [buf#582057, min#585735, buf#585736]
Results [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, buf#582060, min#585737, buf#585738]
(35) Exchange
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, buf#582060, min#585737, buf#585738]
Arguments: hashpartitioning(COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, 10), ENSURE_REQUIREMENTS, [plan_id=360673]
(36) ShuffleQueryStage
Output [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, buf#582060, min#585737, buf#585738]
Arguments: 2
(37) AQEShuffleRead
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, buf#582060, min#585737, buf#585738]
Arguments: coalesced
(38) ObjectHashAggregate
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, buf#582060, min#585737, buf#585738]
Keys [1]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494]
Functions [3]: [collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, 0, 0), min(COL_FBB15BE3_311B_4A50_A657_811052E44533#581497), collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498, 0, 0)]
Aggregate Attributes [3]: [collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, 0, 0)#581542, min(COL_FBB15BE3_311B_4A50_A657_811052E44533#581497)#581544, collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498, 0, 0)#581546]
Results [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494 AS 02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#582006, str_list_get(collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, 0, 0)#581542, 0) AS 02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, date_time_to_str(min(COL_FBB15BE3_311B_4A50_A657_811052E44533#581497)#581544, ddMMyyyy, Europe/Paris, fr_FR) AS 02_ACTES_PATIEN_225933_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#582009, collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498, 0, 0)#581546 AS 02_ACTES_PATIEN_225933_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#582010]
(39) Sort [codegen id : 11]
Input [4]: [02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#582006, 02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, 02_ACTES_PATIEN_225933_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#582009, 02_ACTES_PATIEN_225933_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#582010]
Arguments: [02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#582006 ASC NULLS FIRST], false, 0
(40) SortMergeJoin [codegen id : 12]
Left keys [1]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709]
Right keys [1]: [02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#582006]
Join type: Inner
Join condition: (NOT (str_if_with_rule(CASE WHEN isnull(Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >) END, str_join(array(str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >, LEFT), -)), str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null)))))) <=> ) AND isnotnull(str_if_with_rule(CASE WHEN isnull(Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >) END, str_join(array(str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >, LEFT), -)), str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))))))
(41) Project [codegen id : 12]
Output [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))) AS COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, str_create(RC-SU2-SU3) AS COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, 02_ACTES_PATIEN_225933_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#582009 AS COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, str_join(array(str_join(array(CCMU , COL_15586747_17B8_4040_ACEB_0A327605038C#581712), : ), str_join(array(Acte Eligible SU2 , str_list_as_str(02_ACTES_PATIEN_225933_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#582010)), : )), - ) AS COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591]
Input [9]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, 02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#582006, 02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, 02_ACTES_PATIEN_225933_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#582009, 02_ACTES_PATIEN_225933_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#582010]
(42) Project [codegen id : 12]
Output [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591, str_if_with_rule(CASE WHEN isnull(Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, >)) THEN false ELSE Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, >) END, str_join(array(str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, >, LEFT), -)), str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, >, RIGHT), +))), ,), COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587) AS COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616]
Input [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591]
(43) Project [codegen id : 12]
Output [8]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, str_if_with_rule(isnotnull(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, +)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, -) END, Switch de forfait (SU*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, -) END, Suppression de Forfait, )), COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044), @), ) AS COL_EB745243_852A_470C_A1E1_722CE684E626#582924, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591]
Input [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616]
(44) WriteFiles
Input [8]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, COL_EB745243_852A_470C_A1E1_722CE684E626#582924, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591]
(45) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR5_SU2_SU3_226031, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR5_SU2_SU3_226031], Overwrite, [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4, COL_EB745243_852A_470C_A1E1_722CE684E626, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850, COL_EF5B8E51_0EA9_4466_A691_A2B708205606]
(46) Filter
Input [2]: [Numéro Séjour#580808, Niveau CCMU#580813]
Condition : (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#580808, #)) THEN false ELSE StartsWith(Numéro Séjour#580808, #) END AND isnotnull(Numéro Séjour#580808))
(47) Project
Output [2]: [Numéro Séjour#580808 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, str_remove_space(str_list_get(str_extract_by_regex(Niveau CCMU#580813, [+\d]+), 0), ALL) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927]
Input [2]: [Numéro Séjour#580808, Niveau CCMU#580813]
(48) Exchange
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, 10), ENSURE_REQUIREMENTS, [plan_id=360548]
(49) Sort
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(50) Window
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#580940], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924], [1 DESC NULLS LAST]
(51) Filter
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#580940]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#580940 <=> 1)
(52) Project
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924 AS COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927 AS COL_15586747_17B8_4040_ACEB_0A327605038C#581712]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#580924, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#580927, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#580940]
(53) Scan csv
Output [2]: [REGLES#580643, APPLICABLE#580644]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_225515/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SU2-SU3), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(54) Filter
Input [2]: [REGLES#580643, APPLICABLE#580644]
Condition : ((isnotnull(REGLES#580643) AND (RC-SU2-SU3 = REGLES#580643)) AND (APPLICABLE#580644 <=> O))
(55) Project
Output [1]: [APPLICABLE#580644 AS REGLES_A_APPLIQ_225642_APPLICABLE_225644#581719]
Input [2]: [REGLES#580643, APPLICABLE#580644]
(56) CartesianProduct
Join type: Inner
Join condition: None
(57) Project
Output [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, REGLES_A_APPLIQ_225642_APPLICABLE_225644#581719 AS COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763]
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, REGLES_A_APPLIQ_225642_APPLICABLE_225644#581719]
(58) Exchange
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763]
Arguments: hashpartitioning(COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, 10), ENSURE_REQUIREMENTS, [plan_id=360559]
(59) Sort
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763]
Arguments: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709 ASC NULLS FIRST], false, 0
(60) Filter
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023, COL_60F7C888_9836_4535_A22F_D43D2994E019#581031]
Condition : ((isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019) AND NOT CASE WHEN isnull(StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023, #)) THEN false ELSE StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023, #) END) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023))
(61) Project
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019 AS 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023 AS 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, COL_60F7C888_9836_4535_A22F_D43D2994E019#581031 AS 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581019, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581023, COL_60F7C888_9836_4535_A22F_D43D2994E019#581031]
(62) Exchange
Input [3]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818]
Arguments: hashpartitioning(03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, 10), ENSURE_REQUIREMENTS, [plan_id=360560]
(63) Sort
Input [3]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818]
Arguments: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810 ASC NULLS FIRST], false, 0
(64) SortMergeJoin
Left keys [1]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709]
Right keys [1]: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810]
Join type: Inner
Join condition: None
(65) Project
Output [5]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806 AS COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818 AS COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763]
Input [6]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#581806, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#581810, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#581818]
(66) Filter
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095, COL_F94DAC07_127C_4495_A440_68EF585E7F25#581104, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#581122, COL_1996D387_9E74_479E_8427_83B4DBA88131#581141]
Condition : (isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095) AND NOT CASE WHEN isnull(StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095, #)) THEN false ELSE StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095, #) END)
(67) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, str_if_with_rule(((COL_F94DAC07_127C_4495_A440_68EF585E7F25#581104 <=> 1) AND CASE WHEN isnull(Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118, 2)) THEN false ELSE Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118, 2) END), SU2, str_if_with_rule((((COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118 <=> 3) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118 <=> 4)) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118 <=> 5)), SU3, null)) AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#581122 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#581497, COL_1996D387_9E74_479E_8427_83B4DBA88131#581141 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#581095, COL_F94DAC07_127C_4495_A440_68EF585E7F25#581104, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#581118, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#581122, COL_1996D387_9E74_479E_8427_83B4DBA88131#581141]
(68) ObjectHashAggregate
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, COL_FBB15BE3_311B_4A50_A657_811052E44533#581497, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498]
Keys [1]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494]
Functions [3]: [partial_collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, 0, 0), partial_min(COL_FBB15BE3_311B_4A50_A657_811052E44533#581497), partial_collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498, 0, 0)]
Aggregate Attributes [3]: [buf#582057, min#585735, buf#585736]
Results [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, buf#582060, min#585737, buf#585738]
(69) Exchange
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, buf#582060, min#585737, buf#585738]
Arguments: hashpartitioning(COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, 10), ENSURE_REQUIREMENTS, [plan_id=360565]
(70) ObjectHashAggregate
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494, buf#582060, min#585737, buf#585738]
Keys [1]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494]
Functions [3]: [collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, 0, 0), min(COL_FBB15BE3_311B_4A50_A657_811052E44533#581497), collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498, 0, 0)]
Aggregate Attributes [3]: [collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, 0, 0)#581542, min(COL_FBB15BE3_311B_4A50_A657_811052E44533#581497)#581544, collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498, 0, 0)#581546]
Results [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#581494 AS 02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#582006, str_list_get(collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#581526, 0, 0)#581542, 0) AS 02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, date_time_to_str(min(COL_FBB15BE3_311B_4A50_A657_811052E44533#581497)#581544, ddMMyyyy, Europe/Paris, fr_FR) AS 02_ACTES_PATIEN_225933_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#582009, collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#581498, 0, 0)#581546 AS 02_ACTES_PATIEN_225933_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#582010]
(71) Sort
Input [4]: [02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#582006, 02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, 02_ACTES_PATIEN_225933_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#582009, 02_ACTES_PATIEN_225933_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#582010]
Arguments: [02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#582006 ASC NULLS FIRST], false, 0
(72) SortMergeJoin
Left keys [1]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709]
Right keys [1]: [02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#582006]
Join type: Inner
Join condition: (NOT (str_if_with_rule(CASE WHEN isnull(Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >) END, str_join(array(str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >, LEFT), -)), str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null)))))) <=> ) AND isnotnull(str_if_with_rule(CASE WHEN isnull(Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >) END, str_join(array(str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >, LEFT), -)), str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))))))
(73) Project
Output [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, SU3) END, SU3-, null)), null))))) AS COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, str_create(RC-SU2-SU3) AS COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, 02_ACTES_PATIEN_225933_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#582009 AS COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, str_join(array(str_join(array(CCMU , COL_15586747_17B8_4040_ACEB_0A327605038C#581712), : ), str_join(array(Acte Eligible SU2 , str_list_as_str(02_ACTES_PATIEN_225933_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#582010)), : )), - ) AS COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591]
Input [9]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_15586747_17B8_4040_ACEB_0A327605038C#581712, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#581975, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, 02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#582006, 02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#582008, 02_ACTES_PATIEN_225933_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#582009, 02_ACTES_PATIEN_225933_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#582010]
(74) Project
Output [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591, str_if_with_rule(CASE WHEN isnull(Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, >)) THEN false ELSE Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, >) END, str_join(array(str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, >, LEFT), -)), str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, >, RIGHT), +))), ,), COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587) AS COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616]
Input [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#582587, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591]
(75) Project
Output [8]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, str_if_with_rule(isnotnull(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, +)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, -) END, Switch de forfait (SU*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, -) END, Suppression de Forfait, )), COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044), @), ) AS COL_EB745243_852A_470C_A1E1_722CE684E626#582924, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591]
Input [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616]
(76) WriteFiles
Input [8]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#581709, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#581974, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#582588, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#582616, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#582044, COL_EB745243_852A_470C_A1E1_722CE684E626#582924, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#581763, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#582591]
(77) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR5_SU2_SU3_226031, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR5_SU2_SU3_226031], Overwrite, [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4, COL_EB745243_852A_470C_A1E1_722CE684E626, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850, COL_EF5B8E51_0EA9_4466_A691_A2B708205606]
(78) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true