SP1 - Details for Query 5260

Submitted Time: 2026/05/22 14:22:04
Duration: 3 s
Succeeded Jobs: 8238 8239 8240 8243 8244

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16946.0: task 23658)) number of written files: 5 job commit time: 11 ms number of output rows: 733 number of dynamic part: 0 written output: 42.8 KiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: total (min, med, max (stageId: taskId))\n6.4 s (1.3 s, 1.3 s, 1.3 s (stage 16946.0: task 23661))"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="SortMergeJoin number of output rows: 733 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16946.0: task 23658))"]; } subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: total (min, med, max (stageId: taskId))\n8.2 s (1.6 s, 1.6 s, 1.7 s (stage 16946.0: task 23661))"; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="SortMergeJoin number of output rows: 48,276 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16946.0: task 23658))"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 0 ms"; 12 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 2 ms (0 ms, 0 ms, 1 ms (stage 16946.0: task 23658)) peak memory total (min, med, max (stageId: taskId)) 82.5 MiB (16.5 MiB, 16.5 MiB, 16.5 MiB (stage 16946.0: task 23658)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16946.0: task 23658))"]; } 13 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 748.2 KiB (149.6 KiB, 149.6 KiB, 149.6 KiB (driver)) number of coalesced partitions: 5"]; 14 [labelType="html" label="Exchange shuffle records written: 76,289 local merged chunks fetched: 0 shuffle write time: 3 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 76,289 local bytes read total (min, med, max (stageId: taskId)) 704.5 KiB (139.5 KiB, 140.8 KiB, 142.2 KiB (stage 16946.0: task 23661)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16946.0: task 23658)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 5 remote merged chunks fetched: 0 remote blocks read: 0 data size: 4.6 MiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 704.5 KiB"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 83 ms"; 16 [labelType="html" label=" Project "]; } 17 [labelType="html" label="CartesianProduct number of output rows: 76,289"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 83 ms"; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label="Filter number of output rows: 76,289"]; } 21 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 120 ms"; 23 [labelType="html" label="Sort sort time: 15 ms peak memory: 18.0 MiB spill size: 0.0 B"]; } 24 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 830.0 KiB number of coalesced partitions: 1"]; 25 [labelType="html" label="Exchange shuffle records written: 76,289 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 5 ms (2 ms, 3 ms, 3 ms (stage 16935.0: task 23631)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 76,289 local bytes read: 799.0 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 3.5 MiB (865.8 KiB, 2.6 MiB, 2.6 MiB (stage 16935.0: task 23631)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 799.0 KiB (196.0 KiB, 603.0 KiB, 603.0 KiB (stage 16935.0: task 23631))"]; subgraph cluster26 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n371 ms (79 ms, 292 ms, 292 ms (stage 16935.0: task 23631))"; 27 [labelType="html" label=" Project "]; 28 [labelType="html" label="Filter number of output rows: 76,289"]; } 29 [labelType="html" label="Scan csv number of output rows: 76,289 number of files read: 1 metadata time: 0 ms size of files read: 5.3 MiB"]; subgraph cluster30 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 3 ms"; 31 [labelType="html" label=" Project "]; 32 [labelType="html" label="Filter number of output rows: 1"]; } 33 [labelType="html" label="Scan csv number of output rows: 1 number of files read: 1 metadata time: 0 ms size of files read: 175.0 B"]; subgraph cluster34 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: total (min, med, max (stageId: taskId))\n16.3 s (3.2 s, 3.3 s, 3.3 s (stage 16946.0: task 23661))"; 35 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 7 ms (1 ms, 1 ms, 2 ms (stage 16946.0: task 23658)) peak memory total (min, med, max (stageId: taskId)) 81.3 MiB (16.3 MiB, 16.3 MiB, 16.3 MiB (stage 16946.0: task 23658)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16946.0: task 23658))"]; } 36 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 1808.7 KiB (358.6 KiB, 362.3 KiB, 363.9 KiB (driver)) number of coalesced partitions: 5"]; 37 [labelType="html" label="Exchange shuffle records written: 48,276 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 42 ms (2 ms, 5 ms, 6 ms (stage 16936.0: task 23638)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 48,276 local bytes read total (min, med, max (stageId: taskId)) 1713.9 KiB (341.5 KiB, 342.9 KiB, 343.8 KiB (stage 16946.0: task 23660)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16946.0: task 23658)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 50 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 4.3 MiB (433.6 KiB, 447.1 KiB, 456.5 KiB (stage 16936.0: task 23633)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 1713.9 KiB (167.5 KiB, 172.5 KiB, 176.6 KiB (stage 16936.0: task 23633))"]; subgraph cluster38 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n109 ms (8 ms, 11 ms, 14 ms (stage 16936.0: task 23636))"; 39 [labelType="html" label=" Project "]; 40 [labelType="html" label="Filter number of output rows: 48,276"]; 41 [labelType="html" label="ColumnarToRow number of output rows: 48,276 number of input batches: 20"]; } 42 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 56 ms (4 ms, 6 ms, 7 ms (stage 16936.0: task 23635)) metadata time: 0 ms size of files read: 8.7 MiB number of output rows: 48,276"]; subgraph cluster43 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 0 ms"; 44 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16946.0: task 23658)) peak memory total (min, med, max (stageId: taskId)) 90.0 MiB (18.0 MiB, 18.0 MiB, 18.0 MiB (stage 16946.0: task 23658)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16946.0: task 23658))"]; } 45 [labelType="html" label="ObjectHashAggregate number of output rows: 427,306 time in aggregation build total (min, med, max (stageId: taskId)) 285 ms (52 ms, 59 ms, 62 ms (stage 16946.0: task 23658)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16946.0: task 23658)) number of sort fallback tasks: 5"]; 46 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 6.5 MiB (1340.0 KiB, 1340.0 KiB, 1340.0 KiB (driver)) number of coalesced partitions: 5"]; 47 [labelType="html" label="Exchange shuffle records written: 427,306 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 26 ms (2 ms, 2 ms, 3 ms (stage 16937.0: task 23648)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 427,306 local bytes read total (min, med, max (stageId: taskId)) 6.0 MiB (1226.4 KiB, 1231.5 KiB, 1238.0 KiB (stage 16946.0: task 23660)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16946.0: task 23658)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 42.7 MiB (4.2 MiB, 4.3 MiB, 4.3 MiB (stage 16937.0: task 23653)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 6.0 MiB (612.1 KiB, 614.8 KiB, 625.9 KiB (stage 16937.0: task 23653))"]; 48 [labelType="html" label="ObjectHashAggregate number of output rows: 427,306 time in aggregation build total (min, med, max (stageId: taskId)) 844 ms (3 ms, 80 ms, 102 ms (stage 16937.0: task 23650)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16937.0: task 23646)) number of sort fallback tasks: 10"]; subgraph cluster49 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n804 ms (3 ms, 76 ms, 98 ms (stage 16937.0: task 23650))"; 50 [labelType="html" label=" Project "]; 51 [labelType="html" label="Filter number of output rows: 1,115,956"]; 52 [labelType="html" label="ColumnarToRow number of output rows: 1,115,956 number of input batches: 277"]; } 53 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 111 ms (3 ms, 11 ms, 12 ms (stage 16937.0: task 23643)) metadata time: 0 ms size of files read: 86.2 MiB number of output rows: 1,115,956"]; 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; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_GR5_SU2_SU3_188133, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR5_SU2_SU3_188133], 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#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, str_if_with_rule(isnotnull(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, +)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, -) END, Switch de forfait (SU*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, -) END, Suppression de Forfait, )), COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618), @), ) AS COL_EB745243_852A_470C_A1E1_722CE684E626#1314845, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755]

Project [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755, str_if_with_rule(CASE WHEN isnull(Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, >)) THEN false ELSE Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, >) END, str_join(array(str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, >, LEFT), -)), str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, >, RIGHT), +))), ,), COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751) AS COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769]

Project [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))) AS COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, str_create(RC-SU2-SU3) AS COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, 02_ACTES_PATIEN_188528_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1314585 AS COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, str_join(array(str_join(array(CCMU , COL_15586747_17B8_4040_ACEB_0A327605038C#1314302), : ), str_join(array(Acte Eligible SU2 , str_list_as_str(02_ACTES_PATIEN_188528_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1314586)), : )), - ) AS COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755]

SortMergeJoin [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299], [02_ACTES_PATIEN_188528_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1314582], 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))))))

WholeStageCodegen (12)

Project [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, 03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390 AS COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402 AS COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339]

SortMergeJoin [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299], [03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394], Inner

WholeStageCodegen (10)

Sort [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299 ASC NULLS FIRST], false, 0

WholeStageCodegen (8)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, 10), ENSURE_REQUIREMENTS, [plan_id=749335]

Project [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, REGLES_A_APPLIQ_188031_APPLICABLE_188033#1314309 AS COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339]

WholeStageCodegen (7)

CartesianProduct

Project [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219 AS COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222 AS COL_15586747_17B8_4040_ACEB_0A327605038C#1314302]

Filter (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1314235 <=> 1)

WholeStageCodegen (5)

Window [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1314235], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219], [1 DESC NULLS LAST]

Sort [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, 10), ENSURE_REQUIREMENTS, [plan_id=749050]

Project [Numéro Séjour#1314103 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, str_remove_space(str_list_get(str_extract_by_regex(Niveau CCMU#1314108, [+\d]+), 0), ALL) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222]

Filter (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#1314103, #)) THEN false ELSE StartsWith(Numéro Séjour#1314103, #) END AND isnotnull(Numéro Séjour#1314103))

WholeStageCodegen (1)

FileScan csv [Numéro Séjour#1314103,Niveau CCMU#1314108] Batched: false, DataFilters: [NOT CASE WHEN isnull(StartsWith(Numéro Séjour#1314103, #)) THEN false ELSE StartsWith(Numéro Séj..., Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/02_PASSAGE_PATI_187896/passage_patient_..., PartitionFilters: [], PushedFilters: [IsNotNull(Numéro Séjour)], ReadSchema: struct<Numéro Séjour:string,Niveau CCMU:string>

Project [APPLICABLE#1312034 AS REGLES_A_APPLIQ_188031_APPLICABLE_188033#1314309]

Filter ((isnotnull(REGLES#1312033) AND (RC-SU2-SU3 = REGLES#1312033)) AND (APPLICABLE#1312034 <=> O))

WholeStageCodegen (6)

FileScan csv [REGLES#1312033,APPLICABLE#1312034] Batched: false, DataFilters: [isnotnull(REGLES#1312033), (RC-SU2-SU3 = REGLES#1312033), (APPLICABLE#1312034 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_187903/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SU2-SU3), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>

Sort [03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394 ASC NULLS FIRST], false, 0

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, 10), ENSURE_REQUIREMENTS, [plan_id=749084]

Project [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1312203 AS 03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207 AS 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, COL_60F7C888_9836_4535_A22F_D43D2994E019#1312215 AS 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402]

Filter ((isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1312203) AND NOT CASE WHEN isnull(StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207, #)) THEN false ELSE StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207, #) END) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207))

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1312203,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207,COL_60F7C888_9836_4535_A22F_D43D2994E019#1312215] Batched: true, DataFilters: [isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1312203), NOT CASE WHEN isnull(StartsWith(COL..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_188182], 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_188528_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1314582 ASC NULLS FIRST], false, 0

WholeStageCodegen (11)

ObjectHashAggregate(keys=[COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576], functions=[collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, 0, 0), min(COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579), collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, 10), ENSURE_REQUIREMENTS, [plan_id=749118]

ObjectHashAggregate(keys=[COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576], functions=[partial_collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, 0, 0), partial_min(COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579), partial_collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580, 0, 0)])

Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, str_if_with_rule(((COL_F94DAC07_127C_4495_A440_68EF585E7F25#1312285 <=> 1) AND CASE WHEN isnull(Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299, 2)) THEN false ELSE Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299, 2) END), SU2, str_if_with_rule((((COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299 <=> 3) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299 <=> 4)) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299 <=> 5)), SU3, null)) AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#1312303 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579, COL_1996D387_9E74_479E_8427_83B4DBA88131#1312322 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580]

Filter (isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276) AND NOT CASE WHEN isnull(StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276, #)) THEN false ELSE StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276, #) END)

ColumnarToRow

WholeStageCodegen (3)

FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276,COL_F94DAC07_127C_4495_A440_68EF585E7F25#1312285,COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299,COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#1312303,COL_1996D387_9E74_479E_8427_83B4DBA88131#1312322] Batched: true, DataFilters: [isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276), NOT CASE WHEN isnull(StartsWith(COL..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_188400], 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...

Details

== 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=4.6 MiB, rowCount=7.63E+4)
                  :     :        +- Exchange (16)
                  :     :           +- * Project (15)
                  :     :              +- CartesianProduct Inner (14)
                  :     :                 :- * Project (10)
                  :     :                 :  +- * Filter (9)
                  :     :                 :     +- Window (8)
                  :     :                 :        +- * Sort (7)
                  :     :                 :           +- AQEShuffleRead (6)
                  :     :                 :              +- ShuffleQueryStage (5), Statistics(sizeInBytes=3.5 MiB, rowCount=7.63E+4)
                  :     :                 :                 +- Exchange (4)
                  :     :                 :                    +- * Project (3)
                  :     :                 :                       +- * Filter (2)
                  :     :                 :                          +- Scan csv  (1)
                  :     :                 +- * Project (13)
                  :     :                    +- * Filter (12)
                  :     :                       +- Scan csv  (11)
                  :     +- * Sort (27)
                  :        +- AQEShuffleRead (26)
                  :           +- ShuffleQueryStage (25), Statistics(sizeInBytes=4.3 MiB, rowCount=4.83E+4)
                  :              +- Exchange (24)
                  :                 +- * Project (23)
                  :                    +- * Filter (22)
                  :                       +- * ColumnarToRow (21)
                  :                          +- Scan parquet  (20)
                  +- * Sort (39)
                     +- ObjectHashAggregate (38)
                        +- AQEShuffleRead (37)
                           +- ShuffleQueryStage (36), Statistics(sizeInBytes=42.7 MiB, rowCount=4.27E+5)
                              +- 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#1314103, Niveau CCMU#1314108]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/02_PASSAGE_PATI_187896/passage_patient_Besancon_M122025.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#1314103, Niveau CCMU#1314108]
Condition : (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#1314103, #)) THEN false ELSE StartsWith(Numéro Séjour#1314103, #) END AND isnotnull(Numéro Séjour#1314103))

(3) Project [codegen id : 1]
Output [2]: [Numéro Séjour#1314103 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, str_remove_space(str_list_get(str_extract_by_regex(Niveau CCMU#1314108, [+\d]+), 0), ALL) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222]
Input [2]: [Numéro Séjour#1314103, Niveau CCMU#1314108]

(4) Exchange
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, 10), ENSURE_REQUIREMENTS, [plan_id=749050]

(5) ShuffleQueryStage
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222]
Arguments: 0

(6) AQEShuffleRead
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222]
Arguments: coalesced

(7) Sort [codegen id : 4]
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(8) Window
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1314235], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219], [1 DESC NULLS LAST]

(9) Filter [codegen id : 5]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1314235]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1314235 <=> 1)

(10) Project [codegen id : 5]
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219 AS COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222 AS COL_15586747_17B8_4040_ACEB_0A327605038C#1314302]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1314235]

(11) Scan csv 
Output [2]: [REGLES#1312033, APPLICABLE#1312034]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_187903/REGLES-A-TTT new BESANCON 050226.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SU2-SU3), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(12) Filter [codegen id : 6]
Input [2]: [REGLES#1312033, APPLICABLE#1312034]
Condition : ((isnotnull(REGLES#1312033) AND (RC-SU2-SU3 = REGLES#1312033)) AND (APPLICABLE#1312034 <=> O))

(13) Project [codegen id : 6]
Output [1]: [APPLICABLE#1312034 AS REGLES_A_APPLIQ_188031_APPLICABLE_188033#1314309]
Input [2]: [REGLES#1312033, APPLICABLE#1312034]

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

(15) Project [codegen id : 7]
Output [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, REGLES_A_APPLIQ_188031_APPLICABLE_188033#1314309 AS COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339]
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, REGLES_A_APPLIQ_188031_APPLICABLE_188033#1314309]

(16) Exchange
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339]
Arguments: hashpartitioning(COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, 10), ENSURE_REQUIREMENTS, [plan_id=749335]

(17) ShuffleQueryStage
Output [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339]
Arguments: 3

(18) AQEShuffleRead
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339]
Arguments: coalesced

(19) Sort [codegen id : 8]
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339]
Arguments: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299 ASC NULLS FIRST], false, 0

(20) Scan parquet 
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1312203, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207, COL_60F7C888_9836_4535_A22F_D43D2994E019#1312215]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_188182]
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#1312203, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207, COL_60F7C888_9836_4535_A22F_D43D2994E019#1312215]

(22) Filter [codegen id : 2]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1312203, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207, COL_60F7C888_9836_4535_A22F_D43D2994E019#1312215]
Condition : ((isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1312203) AND NOT CASE WHEN isnull(StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207, #)) THEN false ELSE StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207, #) END) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207))

(23) Project [codegen id : 2]
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1312203 AS 03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207 AS 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, COL_60F7C888_9836_4535_A22F_D43D2994E019#1312215 AS 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1312203, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207, COL_60F7C888_9836_4535_A22F_D43D2994E019#1312215]

(24) Exchange
Input [3]: [03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390, 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402]
Arguments: hashpartitioning(03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, 10), ENSURE_REQUIREMENTS, [plan_id=749084]

(25) ShuffleQueryStage
Output [3]: [03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390, 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402]
Arguments: 1

(26) AQEShuffleRead
Input [3]: [03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390, 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402]
Arguments: coalesced

(27) Sort [codegen id : 9]
Input [3]: [03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390, 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402]
Arguments: [03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394 ASC NULLS FIRST], false, 0

(28) SortMergeJoin [codegen id : 10]
Left keys [1]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299]
Right keys [1]: [03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394]
Join type: Inner
Join condition: None

(29) Project [codegen id : 10]
Output [5]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, 03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390 AS COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402 AS COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339]
Input [6]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, 03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390, 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402]

(30) Scan parquet 
Output [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1312285, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#1312303, COL_1996D387_9E74_479E_8427_83B4DBA88131#1312322]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_188400]
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#1312276, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1312285, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#1312303, COL_1996D387_9E74_479E_8427_83B4DBA88131#1312322]

(32) Filter [codegen id : 3]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1312285, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#1312303, COL_1996D387_9E74_479E_8427_83B4DBA88131#1312322]
Condition : (isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276) AND NOT CASE WHEN isnull(StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276, #)) THEN false ELSE StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276, #) END)

(33) Project [codegen id : 3]
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, str_if_with_rule(((COL_F94DAC07_127C_4495_A440_68EF585E7F25#1312285 <=> 1) AND CASE WHEN isnull(Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299, 2)) THEN false ELSE Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299, 2) END), SU2, str_if_with_rule((((COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299 <=> 3) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299 <=> 4)) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299 <=> 5)), SU3, null)) AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#1312303 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579, COL_1996D387_9E74_479E_8427_83B4DBA88131#1312322 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1312285, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#1312303, COL_1996D387_9E74_479E_8427_83B4DBA88131#1312322]

(34) ObjectHashAggregate
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580]
Keys [1]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576]
Functions [3]: [partial_collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, 0, 0), partial_min(COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579), partial_collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580, 0, 0)]
Aggregate Attributes [3]: [buf#1314913, min#1316808, buf#1316809]
Results [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, buf#1314916, min#1316810, buf#1316811]

(35) Exchange
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, buf#1314916, min#1316810, buf#1316811]
Arguments: hashpartitioning(COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, 10), ENSURE_REQUIREMENTS, [plan_id=749118]

(36) ShuffleQueryStage
Output [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, buf#1314916, min#1316810, buf#1316811]
Arguments: 2

(37) AQEShuffleRead
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, buf#1314916, min#1316810, buf#1316811]
Arguments: coalesced

(38) ObjectHashAggregate
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, buf#1314916, min#1316810, buf#1316811]
Keys [1]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576]
Functions [3]: [collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, 0, 0), min(COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579), collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580, 0, 0)]
Aggregate Attributes [3]: [collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, 0, 0)#1312679, min(COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579)#1312681, collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580, 0, 0)#1312683]
Results [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576 AS 02_ACTES_PATIEN_188528_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1314582, str_list_get(collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, 0, 0)#1312679, 0) AS 02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, date_time_to_str(min(COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579)#1312681, ddMMyyyy, Europe/Paris, fr_FR) AS 02_ACTES_PATIEN_188528_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1314585, collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580, 0, 0)#1312683 AS 02_ACTES_PATIEN_188528_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1314586]

(39) Sort [codegen id : 11]
Input [4]: [02_ACTES_PATIEN_188528_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1314582, 02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, 02_ACTES_PATIEN_188528_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1314585, 02_ACTES_PATIEN_188528_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1314586]
Arguments: [02_ACTES_PATIEN_188528_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1314582 ASC NULLS FIRST], false, 0

(40) SortMergeJoin [codegen id : 12]
Left keys [1]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299]
Right keys [1]: [02_ACTES_PATIEN_188528_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1314582]
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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))))))

(41) Project [codegen id : 12]
Output [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))) AS COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, str_create(RC-SU2-SU3) AS COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, 02_ACTES_PATIEN_188528_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1314585 AS COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, str_join(array(str_join(array(CCMU , COL_15586747_17B8_4040_ACEB_0A327605038C#1314302),  : ), str_join(array(Acte Eligible SU2 , str_list_as_str(02_ACTES_PATIEN_188528_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1314586)),  : )),  - ) AS COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755]
Input [9]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, 02_ACTES_PATIEN_188528_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1314582, 02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, 02_ACTES_PATIEN_188528_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1314585, 02_ACTES_PATIEN_188528_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1314586]

(42) Project [codegen id : 12]
Output [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755, str_if_with_rule(CASE WHEN isnull(Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, >)) THEN false ELSE Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, >) END, str_join(array(str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, >, LEFT), -)), str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, >, RIGHT), +))), ,), COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751) AS COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769]
Input [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755]

(43) Project [codegen id : 12]
Output [8]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, str_if_with_rule(isnotnull(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, +)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, -) END, Switch de forfait (SU*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, -) END, Suppression de Forfait, )), COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618), @), ) AS COL_EB745243_852A_470C_A1E1_722CE684E626#1314845, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755]
Input [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769]

(44) WriteFiles
Input [8]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, COL_EB745243_852A_470C_A1E1_722CE684E626#1314845, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755]

(45) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR5_SU2_SU3_188133, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR5_SU2_SU3_188133], 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#1314103, Niveau CCMU#1314108]
Condition : (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#1314103, #)) THEN false ELSE StartsWith(Numéro Séjour#1314103, #) END AND isnotnull(Numéro Séjour#1314103))

(47) Project
Output [2]: [Numéro Séjour#1314103 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, str_remove_space(str_list_get(str_extract_by_regex(Niveau CCMU#1314108, [+\d]+), 0), ALL) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222]
Input [2]: [Numéro Séjour#1314103, Niveau CCMU#1314108]

(48) Exchange
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, 10), ENSURE_REQUIREMENTS, [plan_id=748993]

(49) Sort
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(50) Window
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1314235], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219], [1 DESC NULLS LAST]

(51) Filter
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1314235]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1314235 <=> 1)

(52) Project
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219 AS COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222 AS COL_15586747_17B8_4040_ACEB_0A327605038C#1314302]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1314219, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1314222, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1314235]

(53) Scan csv 
Output [2]: [REGLES#1312033, APPLICABLE#1312034]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_187903/REGLES-A-TTT new BESANCON 050226.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SU2-SU3), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(54) Filter
Input [2]: [REGLES#1312033, APPLICABLE#1312034]
Condition : ((isnotnull(REGLES#1312033) AND (RC-SU2-SU3 = REGLES#1312033)) AND (APPLICABLE#1312034 <=> O))

(55) Project
Output [1]: [APPLICABLE#1312034 AS REGLES_A_APPLIQ_188031_APPLICABLE_188033#1314309]
Input [2]: [REGLES#1312033, APPLICABLE#1312034]

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

(57) Project
Output [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, REGLES_A_APPLIQ_188031_APPLICABLE_188033#1314309 AS COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339]
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, REGLES_A_APPLIQ_188031_APPLICABLE_188033#1314309]

(58) Exchange
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339]
Arguments: hashpartitioning(COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, 10), ENSURE_REQUIREMENTS, [plan_id=749004]

(59) Sort
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339]
Arguments: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299 ASC NULLS FIRST], false, 0

(60) Filter
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1312203, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207, COL_60F7C888_9836_4535_A22F_D43D2994E019#1312215]
Condition : ((isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1312203) AND NOT CASE WHEN isnull(StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207, #)) THEN false ELSE StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207, #) END) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207))

(61) Project
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1312203 AS 03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207 AS 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, COL_60F7C888_9836_4535_A22F_D43D2994E019#1312215 AS 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1312203, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1312207, COL_60F7C888_9836_4535_A22F_D43D2994E019#1312215]

(62) Exchange
Input [3]: [03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390, 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402]
Arguments: hashpartitioning(03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, 10), ENSURE_REQUIREMENTS, [plan_id=749005]

(63) Sort
Input [3]: [03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390, 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402]
Arguments: [03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394 ASC NULLS FIRST], false, 0

(64) SortMergeJoin
Left keys [1]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299]
Right keys [1]: [03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394]
Join type: Inner
Join condition: None

(65) Project
Output [5]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, 03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390 AS COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402 AS COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339]
Input [6]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, 03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1314390, 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1314394, 03_PIVOT_INFORM_188182_COL_60F7C888_9836_4535_A22F_D43D2994E019#1314402]

(66) Filter
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1312285, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#1312303, COL_1996D387_9E74_479E_8427_83B4DBA88131#1312322]
Condition : (isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276) AND NOT CASE WHEN isnull(StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276, #)) THEN false ELSE StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276, #) END)

(67) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, str_if_with_rule(((COL_F94DAC07_127C_4495_A440_68EF585E7F25#1312285 <=> 1) AND CASE WHEN isnull(Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299, 2)) THEN false ELSE Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299, 2) END), SU2, str_if_with_rule((((COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299 <=> 3) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299 <=> 4)) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299 <=> 5)), SU3, null)) AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#1312303 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579, COL_1996D387_9E74_479E_8427_83B4DBA88131#1312322 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1312276, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1312285, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1312299, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#1312303, COL_1996D387_9E74_479E_8427_83B4DBA88131#1312322]

(68) ObjectHashAggregate
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580]
Keys [1]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576]
Functions [3]: [partial_collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, 0, 0), partial_min(COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579), partial_collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580, 0, 0)]
Aggregate Attributes [3]: [buf#1314913, min#1316808, buf#1316809]
Results [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, buf#1314916, min#1316810, buf#1316811]

(69) Exchange
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, buf#1314916, min#1316810, buf#1316811]
Arguments: hashpartitioning(COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, 10), ENSURE_REQUIREMENTS, [plan_id=749010]

(70) ObjectHashAggregate
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576, buf#1314916, min#1316810, buf#1316811]
Keys [1]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576]
Functions [3]: [collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, 0, 0), min(COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579), collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580, 0, 0)]
Aggregate Attributes [3]: [collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, 0, 0)#1312679, min(COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579)#1312681, collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580, 0, 0)#1312683]
Results [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1312576 AS 02_ACTES_PATIEN_188528_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1314582, str_list_get(collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1312663, 0, 0)#1312679, 0) AS 02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, date_time_to_str(min(COL_FBB15BE3_311B_4A50_A657_811052E44533#1312579)#1312681, ddMMyyyy, Europe/Paris, fr_FR) AS 02_ACTES_PATIEN_188528_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1314585, collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1312580, 0, 0)#1312683 AS 02_ACTES_PATIEN_188528_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1314586]

(71) Sort
Input [4]: [02_ACTES_PATIEN_188528_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1314582, 02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, 02_ACTES_PATIEN_188528_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1314585, 02_ACTES_PATIEN_188528_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1314586]
Arguments: [02_ACTES_PATIEN_188528_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1314582 ASC NULLS FIRST], false, 0

(72) SortMergeJoin
Left keys [1]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299]
Right keys [1]: [02_ACTES_PATIEN_188528_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1314582]
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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, 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#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))))))

(73) Project
Output [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END) AND isnotnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584)), str_concat(array(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END AND (02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, SU3) END, SU3-, null)), null))))) AS COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, str_create(RC-SU2-SU3) AS COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, 02_ACTES_PATIEN_188528_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1314585 AS COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, str_join(array(str_join(array(CCMU , COL_15586747_17B8_4040_ACEB_0A327605038C#1314302),  : ), str_join(array(Acte Eligible SU2 , str_list_as_str(02_ACTES_PATIEN_188528_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1314586)),  : )),  - ) AS COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755]
Input [9]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_15586747_17B8_4040_ACEB_0A327605038C#1314302, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#1314568, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, 02_ACTES_PATIEN_188528_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1314582, 02_ACTES_PATIEN_188528_COL_98193CA9_9380_48E6_8792_463790C0A819#1314584, 02_ACTES_PATIEN_188528_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1314585, 02_ACTES_PATIEN_188528_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1314586]

(74) Project
Output [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755, str_if_with_rule(CASE WHEN isnull(Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, >)) THEN false ELSE Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, >) END, str_join(array(str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, >, LEFT), -)), str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, >, RIGHT), +))), ,), COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751) AS COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769]
Input [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#1314751, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755]

(75) Project
Output [8]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, str_if_with_rule(isnotnull(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, +)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, -) END, Switch de forfait (SU*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, -) END, Suppression de Forfait, )), COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618), @), ) AS COL_EB745243_852A_470C_A1E1_722CE684E626#1314845, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755]
Input [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769]

(76) WriteFiles
Input [8]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1314299, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1314567, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1314752, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1314769, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#1314618, COL_EB745243_852A_470C_A1E1_722CE684E626#1314845, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#1314339, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1314755]

(77) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR5_SU2_SU3_188133, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR5_SU2_SU3_188133], 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

SQL / DataFrame Properties

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