SP1 - Details for Query 5008

Submitted Time: 2026/05/22 07:27:08
Duration: 1 s
Succeeded Jobs: 7801 7802 7803 7804 7807

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)) 2 ms (0 ms, 2 ms, 2 ms (stage 16010.0: task 22015)) number of written files: 2 job commit time: 10 ms number of output rows: 144 number of dynamic part: 0 written output: 13.5 KiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: total (min, med, max (stageId: taskId))\n732 ms (312 ms, 420 ms, 420 ms (stage 16010.0: task 22016))"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label="Generate number of output rows: 144"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="SortMergeJoin number of output rows: 114 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16010.0: task 22015))"]; } subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: total (min, med, max (stageId: taskId))\n842 ms (367 ms, 475 ms, 475 ms (stage 16010.0: task 22016))"; 11 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16010.0: task 22015)) peak memory total (min, med, max (stageId: taskId)) 33.5 MiB (16.5 MiB, 17.0 MiB, 17.0 MiB (stage 16010.0: task 22016)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16010.0: task 22015))"]; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label=" Project "]; } 14 [labelType="html" label="ObjectHashAggregate number of output rows: 37,268 time in aggregation build total (min, med, max (stageId: taskId)) 54 ms (26 ms, 28 ms, 28 ms (stage 16010.0: task 22016)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16010.0: task 22015)) number of sort fallback tasks: 2"]; 15 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 1764.3 KiB (705.7 KiB, 1058.6 KiB, 1058.6 KiB (driver)) number of coalesced partitions: 2"]; 16 [labelType="html" label="Exchange shuffle records written: 37,268 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 6 ms (2 ms, 3 ms, 3 ms (stage 16003.0: task 22012)) 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: 37,268 local bytes read total (min, med, max (stageId: taskId)) 1681.7 KiB (679.8 KiB, 1001.9 KiB, 1001.9 KiB (stage 16010.0: task 22016)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16010.0: task 22015)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 3 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 7.2 MiB (3.6 MiB, 3.6 MiB, 3.6 MiB (stage 16003.0: task 22011)) 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)) 1681.7 KiB (832.9 KiB, 848.8 KiB, 848.8 KiB (stage 16003.0: task 22011))"]; 17 [labelType="html" label="ObjectHashAggregate number of output rows: 37,268 time in aggregation build total (min, med, max (stageId: taskId)) 330 ms (161 ms, 169 ms, 169 ms (stage 16003.0: task 22012)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16003.0: task 22011)) number of sort fallback tasks: 2"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: total (min, med, max (stageId: taskId))\n324 ms (157 ms, 167 ms, 167 ms (stage 16003.0: task 22012))"; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label="SortMergeJoin number of output rows: 85,895 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16003.0: task 22011))"]; } subgraph cluster21 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n331 ms (161 ms, 170 ms, 170 ms (stage 16003.0: task 22012))"; 22 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 6 ms (3 ms, 3 ms, 3 ms (stage 16003.0: task 22011)) peak memory total (min, med, max (stageId: taskId)) 34.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 16003.0: task 22011)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16003.0: task 22011))"]; } 23 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 1940.7 KiB (970.4 KiB, 970.4 KiB, 970.4 KiB (driver)) number of coalesced partitions: 2"]; 24 [labelType="html" label="Exchange shuffle records written: 85,895 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 18 ms (2 ms, 2 ms, 6 ms (stage 15998.0: task 21999)) 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: 85,895 local bytes read total (min, med, max (stageId: taskId)) 1853.9 KiB (917.2 KiB, 936.7 KiB, 936.7 KiB (stage 16003.0: task 22011)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16003.0: task 22011)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 6 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 10.4 MiB (2.1 MiB, 2.1 MiB, 2.1 MiB (stage 15998.0: task 21995)) 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)) 1853.9 KiB (366.5 KiB, 368.7 KiB, 375.6 KiB (stage 15998.0: task 21995))"]; subgraph cluster25 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n242 ms (34 ms, 47 ms, 69 ms (stage 15998.0: task 21995))"; 26 [labelType="html" label=" Project "]; } 27 [labelType="html" label="CartesianProduct number of output rows: 85,895"]; 28 [labelType="html" label="CartesianProduct number of output rows: 85,895"]; subgraph cluster29 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n246 ms (34 ms, 48 ms, 70 ms (stage 15998.0: task 21995))"; 30 [labelType="html" label=" Project "]; 31 [labelType="html" label="Filter number of output rows: 85,895"]; 32 [labelType="html" label="ColumnarToRow number of output rows: 85,895 number of input batches: 25"]; } 33 [labelType="html" label="Scan parquet number of files read: 5 scan time total (min, med, max (stageId: taskId)) 42 ms (5 ms, 7 ms, 14 ms (stage 15998.0: task 21995)) metadata time: 0 ms size of files read: 4.6 MiB number of output rows: 85,895"]; subgraph cluster34 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n20 ms (2 ms, 4 ms, 6 ms (stage 15998.0: task 21997))"; 35 [labelType="html" label=" Project "]; 36 [labelType="html" label="Filter number of output rows: 5"]; } 37 [labelType="html" label="Scan csv number of output rows: 5 number of files read: 1 metadata time: 0 ms size of files read: 175.0 B"]; subgraph cluster38 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n28 ms (3 ms, 6 ms, 7 ms (stage 15998.0: task 21997))"; 39 [labelType="html" label=" Project "]; 40 [labelType="html" label="Filter number of output rows: 5"]; } 41 [labelType="html" label="Scan csv number of output rows: 5 number of files read: 1 metadata time: 0 ms size of files read: 175.0 B"]; subgraph cluster42 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: total (min, med, max (stageId: taskId))\n327 ms (158 ms, 169 ms, 169 ms (stage 16003.0: task 22012))"; 43 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 2 ms (1 ms, 1 ms, 1 ms (stage 16003.0: task 22011)) peak memory total (min, med, max (stageId: taskId)) 33.0 MiB (16.5 MiB, 16.5 MiB, 16.5 MiB (stage 16003.0: task 22011)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16003.0: task 22011))"]; } 44 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 366.5 KiB (178.0 KiB, 188.5 KiB, 188.5 KiB (driver)) number of coalesced partitions: 2"]; 45 [labelType="html" label="Exchange shuffle records written: 36,518 local merged chunks fetched: 0 shuffle write time: 11 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: 36,518 local bytes read total (min, med, max (stageId: taskId)) 347.3 KiB (172.5 KiB, 174.9 KiB, 174.9 KiB (stage 16003.0: task 22011)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16003.0: task 22011)) 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: 1682.8 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 347.3 KiB"]; subgraph cluster46 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 43 ms"; 47 [labelType="html" label=" Project "]; 48 [labelType="html" label="Filter number of output rows: 36,518"]; 49 [labelType="html" label="ColumnarToRow number of output rows: 36,518 number of input batches: 9"]; } 50 [labelType="html" label="Scan parquet number of files read: 1 scan time: 11 ms metadata time: 0 ms size of files read: 202.6 KiB number of output rows: 36,518"]; subgraph cluster51 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: total (min, med, max (stageId: taskId))\n813 ms (353 ms, 460 ms, 460 ms (stage 16010.0: task 22016))"; 52 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 3 ms (1 ms, 2 ms, 2 ms (stage 16010.0: task 22016)) peak memory total (min, med, max (stageId: taskId)) 33.0 MiB (16.5 MiB, 16.5 MiB, 16.5 MiB (stage 16010.0: task 22015)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16010.0: task 22015))"]; } 53 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 876.3 KiB (353.7 KiB, 522.6 KiB, 522.6 KiB (driver)) number of coalesced partitions: 2"]; 54 [labelType="html" label="Exchange shuffle records written: 34,035 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 51 ms (1 ms, 3 ms, 11 ms (stage 16000.0: task 22007)) 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: 34,035 local bytes read total (min, med, max (stageId: taskId)) 836.3 KiB (337.3 KiB, 499.0 KiB, 499.0 KiB (stage 16010.0: task 22016)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16010.0: task 22015)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 20 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 2.6 MiB (253.5 KiB, 262.2 KiB, 269.2 KiB (stage 16000.0: task 22001)) 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)) 836.3 KiB (81.0 KiB, 83.4 KiB, 85.3 KiB (stage 16000.0: task 22001))"]; subgraph cluster55 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n90 ms (5 ms, 8 ms, 14 ms (stage 16000.0: task 22002))"; 56 [labelType="html" label=" Project "]; 57 [labelType="html" label="Filter number of output rows: 34,035"]; 58 [labelType="html" label="ColumnarToRow number of output rows: 34,035 number of input batches: 10"]; } 59 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 42 ms (2 ms, 4 ms, 6 ms (stage 16000.0: task 22004)) metadata time: 0 ms size of files read: 5.7 MiB number of output rows: 34,035"]; 1->0; 2->1; 4->2; 5->4; 6->5; 7->6; 8->7; 9->8; 11->9; 12->11; 13->12; 14->13; 15->14; 16->15; 17->16; 19->17; 20->19; 22->20; 23->22; 24->23; 26->24; 27->26; 28->27; 30->28; 31->30; 32->31; 33->32; 35->28; 36->35; 37->36; 39->27; 40->39; 41->40; 43->20; 44->43; 45->44; 47->45; 48->47; 49->48; 50->49; 52->9; 53->52; 54->53; 56->54; 57->56; 58->57; 59->58; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_GR7_SUN_SUF_176142, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR7_SUN_SUF_176142], Overwrite, [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247, COL_680B8808_CA1F_43BB_9FD6_545FE101582E, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE, COL_D6EF6DFC_79A6_470E_BA52_073402820059, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24]

WriteFiles

Project [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, str_create(RC-SUF-SUN) AS COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1245212, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, str_if_with_rule(CASE WHEN isnull(Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, ,)) THEN false ELSE Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, ,) END, str_concat(array(Switch de forfait , COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, @, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, -)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, -) END, str_concat(array(Suppression de Forfait@, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, +)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, +) END, str_concat(array(Ajout de forfait@, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684)), null))) AS COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1245214, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029]

Generate explode(COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1245013), [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029], false, [COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087]

Project [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, str_split(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, ,) AS COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1245013, str_join(array(str_join(array(str_remove_extend(str_list_as_str(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640), [[,],,]), Déduit des Infos Patient), ), str_join(array(Présent dans le RSF , COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1244923), ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641)), : )), - ) AS COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029]

Project [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1244923, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1244936), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683), array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1244936)), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,) AS COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996]

Project [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734 AS COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 AS COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1244923, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null) AS COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1244936, str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, RIGHT) AS COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947]

SortMergeJoin [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638], [03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738], Inner, ((size(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683), array(str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,), ,), true) > 0) AND isnotnull(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683), array(str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,), ,)))

WholeStageCodegen (12)

Sort [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638 ASC NULLS FIRST], false, 0

Project [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, str_if_with_rule((NOT (COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646 <=> ) AND isnotnull(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646)), str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646, !, LEFT), null) AS COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683, str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646, !, RIGHT) AS COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641]

Project [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, str_list_get(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, 0) AS COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646]

WholeStageCodegen (10)

ObjectHashAggregate(keys=[COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562], functions=[collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, 0, 0), collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, 10), ENSURE_REQUIREMENTS, [plan_id=702740]

ObjectHashAggregate(keys=[COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562], functions=[partial_collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, 0, 0), partial_collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, 0, 0)])

Project [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, str_if_with_rule((COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949 <=> RC-SUN-AUTO), 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597) AS COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599]

SortMergeJoin [COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564], [00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994], LeftOuter

WholeStageCodegen (9)

Sort [COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564 ASC NULLS FIRST], false, 0

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, 10), ENSURE_REQUIREMENTS, [plan_id=702476]

Project [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, REGLES_A_APPLIQ_175810_REGLES_175811#1243727 AS COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949]

WholeStageCodegen (4)

CartesianProduct

Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107 AS COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1243109 AS COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1243144 AS COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1243155 AS COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599]

Filter isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107,COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1243109,COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1243144,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1243155] Batched: true, DataFilters: [isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_176158], PartitionFilters: [], PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)], ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990:s...

Project

Filter ((isnotnull(REGLES#1243088) AND (RC-SUF-SUN = REGLES#1243088)) AND (APPLICABLE#1243089 <=> O))

WholeStageCodegen (2)

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

Project [REGLES#1243730 AS REGLES_A_APPLIQ_175810_REGLES_175811#1243727]

Filter (isnotnull(REGLES#1243730) AND (RC-SUN-AUTO = REGLES#1243730))

WholeStageCodegen (3)

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

Sort [00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994 ASC NULLS FIRST], false, 0

WholeStageCodegen (8)

AQEShuffleRead coalesced

Exchange hashpartitioning(00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, 10), ENSURE_REQUIREMENTS, [plan_id=702514]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281 AS 00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243283 AS 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996]

Filter isnotnull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281)

ColumnarToRow

WholeStageCodegen (5)

FileScan parquet [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281,COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243283] Batched: true, DataFilters: [isnotnull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_G_ACTES_AUTO_176023], PartitionFilters: [], PushedFilters: [IsNotNull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D)], ReadSchema: struct<COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D:string,COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3:s...

Sort [03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738 ASC NULLS FIRST], false, 0

WholeStageCodegen (11)

AQEShuffleRead coalesced

Exchange hashpartitioning(03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, 10), ENSURE_REQUIREMENTS, [plan_id=702550]

Project [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1243218 AS 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222 AS 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1243242 AS 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758]

Filter isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222)

ColumnarToRow

WholeStageCodegen (6)

FileScan parquet [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1243218,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222,COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1243242] Batched: true, DataFilters: [isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_175988], PartitionFilters: [], PushedFilters: [IsNotNull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8)], ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (87)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (51)
   +- WriteFiles (50)
      +- * Project (49)
         +- * Generate (48)
            +- * Project (47)
               +- * Project (46)
                  +- * Project (45)
                     +- * SortMergeJoin Inner (44)
                        :- * Sort (35)
                        :  +- * Project (34)
                        :     +- * Project (33)
                        :        +- ObjectHashAggregate (32)
                        :           +- AQEShuffleRead (31)
                        :              +- ShuffleQueryStage (30), Statistics(sizeInBytes=7.2 MiB, rowCount=3.73E+4)
                        :                 +- Exchange (29)
                        :                    +- ObjectHashAggregate (28)
                        :                       +- * Project (27)
                        :                          +- * SortMergeJoin LeftOuter (26)
                        :                             :- * Sort (17)
                        :                             :  +- AQEShuffleRead (16)
                        :                             :     +- ShuffleQueryStage (15), Statistics(sizeInBytes=10.4 MiB, rowCount=8.59E+4)
                        :                             :        +- Exchange (14)
                        :                             :           +- * Project (13)
                        :                             :              +- CartesianProduct Inner (12)
                        :                             :                 :- CartesianProduct Inner (8)
                        :                             :                 :  :- * Project (4)
                        :                             :                 :  :  +- * Filter (3)
                        :                             :                 :  :     +- * ColumnarToRow (2)
                        :                             :                 :  :        +- Scan parquet  (1)
                        :                             :                 :  +- * Project (7)
                        :                             :                 :     +- * Filter (6)
                        :                             :                 :        +- Scan csv  (5)
                        :                             :                 +- * Project (11)
                        :                             :                    +- * Filter (10)
                        :                             :                       +- Scan csv  (9)
                        :                             +- * Sort (25)
                        :                                +- AQEShuffleRead (24)
                        :                                   +- ShuffleQueryStage (23), Statistics(sizeInBytes=1682.8 KiB, rowCount=3.65E+4)
                        :                                      +- Exchange (22)
                        :                                         +- * Project (21)
                        :                                            +- * Filter (20)
                        :                                               +- * ColumnarToRow (19)
                        :                                                  +- Scan parquet  (18)
                        +- * Sort (43)
                           +- AQEShuffleRead (42)
                              +- ShuffleQueryStage (41), Statistics(sizeInBytes=2.6 MiB, rowCount=3.40E+4)
                                 +- Exchange (40)
                                    +- * Project (39)
                                       +- * Filter (38)
                                          +- * ColumnarToRow (37)
                                             +- Scan parquet  (36)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (86)
   +- WriteFiles (85)
      +- Project (84)
         +- Generate (83)
            +- Project (82)
               +- Project (81)
                  +- Project (80)
                     +- SortMergeJoin Inner (79)
                        :- Sort (74)
                        :  +- Project (73)
                        :     +- Project (72)
                        :        +- ObjectHashAggregate (71)
                        :           +- Exchange (70)
                        :              +- ObjectHashAggregate (69)
                        :                 +- Project (68)
                        :                    +- SortMergeJoin LeftOuter (67)
                        :                       :- Sort (62)
                        :                       :  +- Exchange (61)
                        :                       :     +- Project (60)
                        :                       :        +- CartesianProduct Inner (59)
                        :                       :           :- CartesianProduct Inner (56)
                        :                       :           :  :- Project (53)
                        :                       :           :  :  +- Filter (52)
                        :                       :           :  :     +- Scan parquet  (1)
                        :                       :           :  +- Project (55)
                        :                       :           :     +- Filter (54)
                        :                       :           :        +- Scan csv  (5)
                        :                       :           +- Project (58)
                        :                       :              +- Filter (57)
                        :                       :                 +- Scan csv  (9)
                        :                       +- Sort (66)
                        :                          +- Exchange (65)
                        :                             +- Project (64)
                        :                                +- Filter (63)
                        :                                   +- Scan parquet  (18)
                        +- Sort (78)
                           +- Exchange (77)
                              +- Project (76)
                                 +- Filter (75)
                                    +- Scan parquet  (36)


(1) Scan parquet 
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1243109, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1243144, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1243155]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_176158]
PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990:string,COL_60F0AF6F_D3F7_485E_B349_92A30BE52743:string,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A:string>

(2) ColumnarToRow [codegen id : 1]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1243109, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1243144, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1243155]

(3) Filter [codegen id : 1]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1243109, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1243144, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1243155]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107)

(4) Project [codegen id : 1]
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107 AS COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1243109 AS COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1243144 AS COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1243155 AS COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1243109, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1243144, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1243155]

(5) Scan csv 
Output [2]: [REGLES#1243088, APPLICABLE#1243089]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_175682/REGLES-A-TTT new GRASSE 290126.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUF-SUN), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(6) Filter [codegen id : 2]
Input [2]: [REGLES#1243088, APPLICABLE#1243089]
Condition : ((isnotnull(REGLES#1243088) AND (RC-SUF-SUN = REGLES#1243088)) AND (APPLICABLE#1243089 <=> O))

(7) Project [codegen id : 2]
Output: []
Input [2]: [REGLES#1243088, APPLICABLE#1243089]

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

(9) Scan csv 
Output [1]: [REGLES#1243730]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_175682/REGLES-A-TTT new GRASSE 290126.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUN-AUTO)]
ReadSchema: struct<REGLES:string>

(10) Filter [codegen id : 3]
Input [1]: [REGLES#1243730]
Condition : (isnotnull(REGLES#1243730) AND (RC-SUN-AUTO = REGLES#1243730))

(11) Project [codegen id : 3]
Output [1]: [REGLES#1243730 AS REGLES_A_APPLIQ_175810_REGLES_175811#1243727]
Input [1]: [REGLES#1243730]

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

(13) Project [codegen id : 4]
Output [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, REGLES_A_APPLIQ_175810_REGLES_175811#1243727 AS COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949]
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, REGLES_A_APPLIQ_175810_REGLES_175811#1243727]

(14) Exchange
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949]
Arguments: hashpartitioning(COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, 10), ENSURE_REQUIREMENTS, [plan_id=702476]

(15) ShuffleQueryStage
Output [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949]
Arguments: 0

(16) AQEShuffleRead
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949]
Arguments: coalesced

(17) Sort [codegen id : 7]
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949]
Arguments: [COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564 ASC NULLS FIRST], false, 0

(18) Scan parquet 
Output [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243283]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_G_ACTES_AUTO_176023]
PushedFilters: [IsNotNull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D)]
ReadSchema: struct<COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D:string,COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3:string>

(19) ColumnarToRow [codegen id : 5]
Input [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243283]

(20) Filter [codegen id : 5]
Input [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243283]
Condition : isnotnull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281)

(21) Project [codegen id : 5]
Output [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281 AS 00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243283 AS 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996]
Input [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243283]

(22) Exchange
Input [2]: [00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996]
Arguments: hashpartitioning(00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, 10), ENSURE_REQUIREMENTS, [plan_id=702514]

(23) ShuffleQueryStage
Output [2]: [00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996]
Arguments: 1

(24) AQEShuffleRead
Input [2]: [00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996]
Arguments: coalesced

(25) Sort [codegen id : 8]
Input [2]: [00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996]
Arguments: [00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994 ASC NULLS FIRST], false, 0

(26) SortMergeJoin [codegen id : 9]
Left keys [1]: [COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564]
Right keys [1]: [00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994]
Join type: LeftOuter
Join condition: None

(27) Project [codegen id : 9]
Output [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, str_if_with_rule((COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949 <=> RC-SUN-AUTO), 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597) AS COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599]
Input [7]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949, 00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996]

(28) ObjectHashAggregate
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599]
Keys [1]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562]
Functions [2]: [partial_collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, 0, 0), partial_collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, 0, 0)]
Aggregate Attributes [2]: [buf#1245223, buf#1246533]
Results [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, buf#1245225, buf#1246534]

(29) Exchange
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, buf#1245225, buf#1246534]
Arguments: hashpartitioning(COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, 10), ENSURE_REQUIREMENTS, [plan_id=702740]

(30) ShuffleQueryStage
Output [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, buf#1245225, buf#1246534]
Arguments: 3

(31) AQEShuffleRead
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, buf#1245225, buf#1246534]
Arguments: coalesced

(32) ObjectHashAggregate
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, buf#1245225, buf#1246534]
Keys [1]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562]
Functions [2]: [collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, 0, 0), collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, 0, 0)]
Aggregate Attributes [2]: [collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, 0, 0)#1244620, collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, 0, 0)#1244622]
Results [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562 AS COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, 0, 0)#1244620 AS COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, 0, 0)#1244622 AS COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641]

(33) Project [codegen id : 10]
Output [4]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, str_list_get(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, 0) AS COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646]
Input [3]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641]

(34) Project [codegen id : 10]
Output [5]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, str_if_with_rule((NOT (COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646 <=> ) AND isnotnull(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646)), str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646, !, LEFT), null) AS COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683, str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646, !, RIGHT) AS COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641]
Input [4]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646]

(35) Sort [codegen id : 10]
Input [5]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641]
Arguments: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638 ASC NULLS FIRST], false, 0

(36) Scan parquet 
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1243218, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1243242]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_175988]
PushedFilters: [IsNotNull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8)]
ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:string,COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5:string>

(37) ColumnarToRow [codegen id : 6]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1243218, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1243242]

(38) Filter [codegen id : 6]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1243218, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1243242]
Condition : isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222)

(39) Project [codegen id : 6]
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1243218 AS 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222 AS 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1243242 AS 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1243218, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1243242]

(40) Exchange
Input [3]: [03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758]
Arguments: hashpartitioning(03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, 10), ENSURE_REQUIREMENTS, [plan_id=702550]

(41) ShuffleQueryStage
Output [3]: [03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758]
Arguments: 2

(42) AQEShuffleRead
Input [3]: [03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758]
Arguments: coalesced

(43) Sort [codegen id : 11]
Input [3]: [03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758]
Arguments: [03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738 ASC NULLS FIRST], false, 0

(44) SortMergeJoin [codegen id : 12]
Left keys [1]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638]
Right keys [1]: [03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738]
Join type: Inner
Join condition: ((size(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683), array(str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])),  ), ONLY_ONE),  , ,), ,), true) > 0) AND isnotnull(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683), array(str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])),  ), ONLY_ONE),  , ,), ,)))

(45) Project [codegen id : 12]
Output [9]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734 AS COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 AS COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1244923, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null) AS COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1244936, str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, RIGHT) AS COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947]
Input [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758]

(46) Project [codegen id : 12]
Output [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1244923, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1244936), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683), array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1244936)), 0), [SUF,SUN], [SUF+,SUN+])),  ), ONLY_ONE),  , ,) AS COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996]
Input [9]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1244923, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1244936, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947]

(47) Project [codegen id : 12]
Output [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, str_split(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, ,) AS COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1245013, str_join(array(str_join(array(str_remove_extend(str_list_as_str(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640), [[,],,]),  Déduit des Infos Patient), ), str_join(array(Présent dans le RSF , COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1244923), ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641)),  : )),  - ) AS COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029]
Input [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1244923, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996]

(48) Generate [codegen id : 12]
Input [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1245013, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029]
Arguments: explode(COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1245013), [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029], false, [COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087]

(49) Project [codegen id : 12]
Output [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, str_create(RC-SUF-SUN) AS COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1245212, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, str_if_with_rule(CASE WHEN isnull(Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, ,)) THEN false ELSE Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, ,) END, str_concat(array(Switch de forfait , COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, @, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, -)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, -) END, str_concat(array(Suppression de Forfait@, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, +)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, +) END, str_concat(array(Ajout de forfait@, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684)), null))) AS COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1245214, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029]
Input [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087]

(50) WriteFiles
Input [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1245212, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1245214, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029]

(51) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR7_SUN_SUF_176142, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR7_SUN_SUF_176142], Overwrite, [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247, COL_680B8808_CA1F_43BB_9FD6_545FE101582E, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE, COL_D6EF6DFC_79A6_470E_BA52_073402820059, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24]

(52) Filter
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1243109, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1243144, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1243155]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107)

(53) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107 AS COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1243109 AS COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1243144 AS COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1243155 AS COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1243107, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1243109, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1243144, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1243155]

(54) Filter
Input [2]: [REGLES#1243088, APPLICABLE#1243089]
Condition : ((isnotnull(REGLES#1243088) AND (RC-SUF-SUN = REGLES#1243088)) AND (APPLICABLE#1243089 <=> O))

(55) Project
Output: []
Input [2]: [REGLES#1243088, APPLICABLE#1243089]

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

(57) Filter
Input [1]: [REGLES#1243730]
Condition : (isnotnull(REGLES#1243730) AND (RC-SUN-AUTO = REGLES#1243730))

(58) Project
Output [1]: [REGLES#1243730 AS REGLES_A_APPLIQ_175810_REGLES_175811#1243727]
Input [1]: [REGLES#1243730]

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

(60) Project
Output [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, REGLES_A_APPLIQ_175810_REGLES_175811#1243727 AS COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949]
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, REGLES_A_APPLIQ_175810_REGLES_175811#1243727]

(61) Exchange
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949]
Arguments: hashpartitioning(COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, 10), ENSURE_REQUIREMENTS, [plan_id=702387]

(62) Sort
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949]
Arguments: [COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564 ASC NULLS FIRST], false, 0

(63) Filter
Input [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243283]
Condition : isnotnull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281)

(64) Project
Output [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281 AS 00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243283 AS 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996]
Input [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243281, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243283]

(65) Exchange
Input [2]: [00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996]
Arguments: hashpartitioning(00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, 10), ENSURE_REQUIREMENTS, [plan_id=702388]

(66) Sort
Input [2]: [00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996]
Arguments: [00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994 ASC NULLS FIRST], false, 0

(67) SortMergeJoin
Left keys [1]: [COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564]
Right keys [1]: [00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994]
Join type: LeftOuter
Join condition: None

(68) Project
Output [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, str_if_with_rule((COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949 <=> RC-SUN-AUTO), 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597) AS COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599]
Input [7]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_332A283C_1564_41E0_AC8C_5944B976139C#1243564, COL_C6711610_DFEE_4846_8053_60113001EF1E#1243597, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1243949, 00_G_ACTES_AUTO_176023_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1243994, 00_G_ACTES_AUTO_176023_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1243996]

(69) ObjectHashAggregate
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599]
Keys [1]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562]
Functions [2]: [partial_collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, 0, 0), partial_collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, 0, 0)]
Aggregate Attributes [2]: [buf#1245223, buf#1246533]
Results [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, buf#1245225, buf#1246534]

(70) Exchange
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, buf#1245225, buf#1246534]
Arguments: hashpartitioning(COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, 10), ENSURE_REQUIREMENTS, [plan_id=702395]

(71) ObjectHashAggregate
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562, buf#1245225, buf#1246534]
Keys [1]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562]
Functions [2]: [collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, 0, 0), collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, 0, 0)]
Aggregate Attributes [2]: [collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, 0, 0)#1244620, collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, 0, 0)#1244622]
Results [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1243562 AS COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1244526, 0, 0)#1244620 AS COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1243599, 0, 0)#1244622 AS COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641]

(72) Project
Output [4]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, str_list_get(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, 0) AS COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646]
Input [3]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641]

(73) Project
Output [5]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, str_if_with_rule((NOT (COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646 <=> ) AND isnotnull(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646)), str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646, !, LEFT), null) AS COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683, str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646, !, RIGHT) AS COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641]
Input [4]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1244646]

(74) Sort
Input [5]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641]
Arguments: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638 ASC NULLS FIRST], false, 0

(75) Filter
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1243218, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1243242]
Condition : isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222)

(76) Project
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1243218 AS 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222 AS 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1243242 AS 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1243218, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1243222, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1243242]

(77) Exchange
Input [3]: [03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758]
Arguments: hashpartitioning(03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, 10), ENSURE_REQUIREMENTS, [plan_id=702401]

(78) Sort
Input [3]: [03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758]
Arguments: [03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738 ASC NULLS FIRST], false, 0

(79) SortMergeJoin
Left keys [1]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638]
Right keys [1]: [03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738]
Join type: Inner
Join condition: ((size(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683), array(str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])),  ), ONLY_ONE),  , ,), ,), true) > 0) AND isnotnull(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683), array(str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])),  ), ONLY_ONE),  , ,), ,)))

(80) Project
Output [9]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734 AS COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 AS COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1244923, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, str_if_with_rule(NOT (03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758 <=> ), str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, LEFT), null) AS COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1244936, str_extract_by_str(03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758, !, RIGHT) AS COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947]
Input [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1244734, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1244738, 03_PIVOT_INFORM_175988_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1244758]

(81) Project
Output [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1244923, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1244936), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683), array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1244936)), 0), [SUF,SUN], [SUF+,SUN+])),  ), ONLY_ONE),  , ,) AS COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996]
Input [9]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1244683, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1244923, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1244936, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947]

(82) Project
Output [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, str_split(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, ,) AS COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1245013, str_join(array(str_join(array(str_remove_extend(str_list_as_str(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640), [[,],,]),  Déduit des Infos Patient), ), str_join(array(Présent dans le RSF , COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1244923), ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641)),  : )),  - ) AS COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029]
Input [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1244923, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1244640, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1244641, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996]

(83) Generate
Input [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1245013, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029]
Arguments: explode(COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1245013), [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029], false, [COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087]

(84) Project
Output [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, str_create(RC-SUF-SUN) AS COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1245212, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, str_if_with_rule(CASE WHEN isnull(Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, ,)) THEN false ELSE Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, ,) END, str_concat(array(Switch de forfait , COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, @, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, -)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, -) END, str_concat(array(Suppression de Forfait@, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, +)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, +) END, str_concat(array(Ajout de forfait@, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684)), null))) AS COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1245214, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029]
Input [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1244684, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1244947, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1244996, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087]

(85) WriteFiles
Input [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1244638, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1244922, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1245212, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1245087, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1245214, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1245029]

(86) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR7_SUN_SUF_176142, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR7_SUN_SUF_176142], Overwrite, [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247, COL_680B8808_CA1F_43BB_9FD6_545FE101582E, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE, COL_D6EF6DFC_79A6_470E_BA52_073402820059, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24]

(87) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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