SP1 - Details for Query 2318

Submitted Time: 2026/09/17 16:20:14
Duration: 1 s
Succeeded Jobs: 3369 3370 3373

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: 0 ms number of written files: 1 job commit time: 16 ms number of output rows: 250 number of dynamic part: 0 written output: 24.4 KiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 523 ms"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label="SortMergeJoin number of output rows: 250 spill size: 0.0 B"]; } subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; 10 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 11 [labelType="html" label="ObjectHashAggregate number of output rows: 18,969 time in aggregation build: 34 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 12 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 422.4 KiB number of coalesced partitions: 1"]; 13 [labelType="html" label="Exchange shuffle records written: 18,969 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 2 ms (1 ms, 1 ms, 1 ms (stage 6947.0: task 8998)) 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: 18,969 local bytes read: 414.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)) 2.3 MiB (949.1 KiB, 1424.0 KiB, 1424.0 KiB (stage 6947.0: task 8998)) 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)) 414.0 KiB (165.4 KiB, 248.6 KiB, 248.6 KiB (stage 6947.0: task 8998))"]; 14 [labelType="html" label="ObjectHashAggregate number of output rows: 18,969 time in aggregation build total (min, med, max (stageId: taskId)) 274 ms (98 ms, 176 ms, 176 ms (stage 6947.0: task 8998)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 6947.0: task 8999)) number of sort fallback tasks: 2"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n268 ms (97 ms, 171 ms, 171 ms (stage 6947.0: task 8998))"; 16 [labelType="html" label=" Project "]; } 17 [labelType="html" label="CartesianProduct number of output rows: 70,650"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n269 ms (97 ms, 172 ms, 172 ms (stage 6947.0: task 8998))"; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label="Filter number of output rows: 70,650"]; 21 [labelType="html" label="ColumnarToRow number of output rows: 70,654 number of input batches: 18"]; } 22 [labelType="html" label="Scan parquet number of files read: 2 scan time total (min, med, max (stageId: taskId)) 24 ms (10 ms, 14 ms, 14 ms (stage 6947.0: task 8998)) metadata time: 0 ms size of files read: 2.3 MiB number of output rows: 70,654"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n15 ms (7 ms, 8 ms, 8 ms (stage 6947.0: task 8998))"; 24 [labelType="html" label=" Project "]; 25 [labelType="html" label="Filter number of output rows: 2"]; } 26 [labelType="html" label="Scan csv number of output rows: 2 number of files read: 1 metadata time: 0 ms size of files read: 175.0 B"]; subgraph cluster27 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 1.7 s"; 28 [labelType="html" label="Sort sort time: 79 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 29 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 984.0 KiB number of coalesced partitions: 1"]; 30 [labelType="html" label="Exchange shuffle records written: 12,897 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 95 ms (1 ms, 10 ms, 18 ms (stage 6948.0: task 9000)) 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: 12,897 local bytes read: 942.2 KiB fetch wait time: 0 ms 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)) 2.9 MiB (280.9 KiB, 297.5 KiB, 312.2 KiB (stage 6948.0: task 9000)) 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)) 942.2 KiB (88.5 KiB, 93.8 KiB, 99.8 KiB (stage 6948.0: task 9000))"]; subgraph cluster31 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n132 ms (7 ms, 14 ms, 17 ms (stage 6948.0: task 9005))"; 32 [labelType="html" label=" Project "]; 33 [labelType="html" label="Filter number of output rows: 12,897"]; 34 [labelType="html" label="ColumnarToRow number of output rows: 12,897 number of input batches: 10"]; } 35 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 75 ms (4 ms, 8 ms, 10 ms (stage 6948.0: task 9002)) metadata time: 0 ms size of files read: 2041.6 KiB number of output rows: 12,897"]; 1->0; 2->1; 4->2; 5->4; 6->5; 7->6; 8->7; 10->8; 11->10; 12->11; 13->12; 14->13; 16->14; 17->16; 19->17; 20->19; 21->20; 22->21; 24->17; 25->24; 26->25; 28->8; 29->28; 30->29; 32->30; 33->32; 34->33; 35->34; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_GR3_SUB_SB2__226357, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR3_SUB_SB2__226357], Overwrite, [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08, COL_46598A01_D8BC_436B_975B_00D168E3C4D6, COL_2F038993_76B5_4030_8D3B_7718F322492A, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9]

WriteFiles

Project [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#578453, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, str_if_with_rule((isnotnull(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429) AND NOT (COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, +)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, -) END, Switch de forfait (SU Bio*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, -) END, Suppression de Forfait, )), COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#578409), @), ) AS COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#578536, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]

Project [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#578409, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058, str_if_with_rule((isnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408)), null, str_if_with_rule((COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408 <=> COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407), null, str_if_with_rule((isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408)), str_concat(array(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407, +)), str_if_with_rule(NOT (COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407 <=> COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408), str_concat(array(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408, -, str_if_with_rule(isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407), str_concat(array(,, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407, +)), null))), null)))) AS COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, str_create(RC-SUB) AS COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#578453]

Project [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#578260 <=> 1), str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 <= 44.99))) THEN false ELSE ((COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 >= 45.0) END, SB3, null))), null) AS COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407, str_list_get(str_list_intersect_fixed(str_split(COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#578242, ;), [SUB,SB2,SB3]), 0) AS COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408, date_time_to_str(COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, ddMMyyyy, Europe/Paris, fr_FR) AS COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#578409, str_join(array(str_join(array(Age (en Année) , dec_to_str(COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241)), : ), , str_join(array(Date Naissance , str_join(array(str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, LEFT, 2), str_extract_middle(COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, 3, 2), str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, RIGHT, 4)), -)), : ), str_join(array(Date Entrée, str_join(array(str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, LEFT, 2), str_extract_middle(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, 3, 2), str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, RIGHT, 4)), -)), : ), str_join(array(Date Biologie, str_list_as_str(COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058)), : ), str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#578260 <=> 1), Eligible Bio : OUI, Eligible Bio : NON)), - ) AS COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]

Project [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100 AS COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103 AS COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105 AS COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 AS COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112 AS COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#578242, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115 AS COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) AS COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#578260]

SortMergeJoin [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055], [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104], Inner, (isnotnull(str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null), +)), null))), null))))) AND NOT (str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null), +)), null))), null)))) <=> ))

WholeStageCodegen (7)

Sort [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

ObjectHashAggregate(keys=[COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713], functions=[min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983), collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, 0, 0), collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, 10), ENSURE_REQUIREMENTS, [plan_id=358486]

ObjectHashAggregate(keys=[COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713], functions=[partial_min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983), partial_collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, 0, 0), partial_collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, 0, 0)])

Project [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, str_to_datez(COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#577717, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983]

WholeStageCodegen (3)

CartesianProduct

Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293 AS COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#577311 AS COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#577717, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#577312 AS COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#577337 AS COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733]

Filter isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293,COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#577311,COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#577312,COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#577337] Batched: true, DataFilters: [isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_225863], PartitionFilters: [], PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)], ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C:s...

Project

Filter ((isnotnull(REGLES#577274) AND (RC-SUB = REGLES#577274)) AND (APPLICABLE#577275 <=> O))

WholeStageCodegen (2)

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

Sort [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104 ASC NULLS FIRST], false, 0

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, 10), ENSURE_REQUIREMENTS, [plan_id=358527]

Project [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413 AS 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#577416 AS 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#577417 AS 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#577418 AS 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#577420 AS 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107, COL_60F7C888_9836_4535_A22F_D43D2994E019#577425 AS 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#577428 AS 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115]

Filter (isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#577417))

ColumnarToRow

WholeStageCodegen (4)

FileScan parquet [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413,COL_8761272F_9915_40EB_8429_20EFEF6A9A31#577416,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#577417,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#577418,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#577420,COL_60F7C888_9836_4535_A22F_D43D2994E019#577425,COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#577428] Batched: true, DataFilters: [isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413), isnotnull(COL_582B8737_1AAE_44AC_AF5..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_225663], PartitionFilters: [], PushedFilters: [IsNotNull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F), IsNotNull(COL_582B8737_1AAE_44AC_AF57_EB71A..., ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_8761272F_9915_40EB_8429_20EFEF6A9A31:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (52)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (30)
   +- WriteFiles (29)
      +- * Project (28)
         +- * Project (27)
            +- * Project (26)
               +- * Project (25)
                  +- * SortMergeJoin Inner (24)
                     :- * Sort (15)
                     :  +- ObjectHashAggregate (14)
                     :     +- AQEShuffleRead (13)
                     :        +- ShuffleQueryStage (12), Statistics(sizeInBytes=2.3 MiB, rowCount=1.90E+4)
                     :           +- Exchange (11)
                     :              +- ObjectHashAggregate (10)
                     :                 +- * Project (9)
                     :                    +- CartesianProduct Inner (8)
                     :                       :- * Project (4)
                     :                       :  +- * Filter (3)
                     :                       :     +- * ColumnarToRow (2)
                     :                       :        +- Scan parquet  (1)
                     :                       +- * Project (7)
                     :                          +- * Filter (6)
                     :                             +- Scan csv  (5)
                     +- * Sort (23)
                        +- AQEShuffleRead (22)
                           +- ShuffleQueryStage (21), Statistics(sizeInBytes=2.9 MiB, rowCount=1.29E+4)
                              +- Exchange (20)
                                 +- * Project (19)
                                    +- * Filter (18)
                                       +- * ColumnarToRow (17)
                                          +- Scan parquet  (16)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (51)
   +- WriteFiles (50)
      +- Project (49)
         +- Project (48)
            +- Project (47)
               +- Project (46)
                  +- SortMergeJoin Inner (45)
                     :- Sort (40)
                     :  +- ObjectHashAggregate (39)
                     :     +- Exchange (38)
                     :        +- ObjectHashAggregate (37)
                     :           +- Project (36)
                     :              +- CartesianProduct Inner (35)
                     :                 :- Project (32)
                     :                 :  +- Filter (31)
                     :                 :     +- Scan parquet  (1)
                     :                 +- Project (34)
                     :                    +- Filter (33)
                     :                       +- Scan csv  (5)
                     +- Sort (44)
                        +- Exchange (43)
                           +- Project (42)
                              +- Filter (41)
                                 +- Scan parquet  (16)


(1) Scan parquet 
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#577311, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#577312, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#577337]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_225863]
PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C:string,COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE:string,COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799:string>

(2) ColumnarToRow [codegen id : 1]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#577311, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#577312, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#577337]

(3) Filter [codegen id : 1]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#577311, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#577312, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#577337]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293)

(4) Project [codegen id : 1]
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293 AS COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#577311 AS COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#577717, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#577312 AS COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#577337 AS COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#577311, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#577312, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#577337]

(5) Scan csv 
Output [2]: [REGLES#577274, APPLICABLE#577275]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_225515/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUB), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(6) Filter [codegen id : 2]
Input [2]: [REGLES#577274, APPLICABLE#577275]
Condition : ((isnotnull(REGLES#577274) AND (RC-SUB = REGLES#577274)) AND (APPLICABLE#577275 <=> O))

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

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

(9) Project [codegen id : 3]
Output [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, str_to_datez(COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#577717, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983]
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#577717, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733]

(10) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713]
Functions [3]: [partial_min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983), partial_collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, 0, 0), partial_collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, 0, 0)]
Aggregate Attributes [3]: [min#578254, buf#580123, buf#580124]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, min#578257, buf#580125, buf#580126]

(11) Exchange
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, min#578257, buf#580125, buf#580126]
Arguments: hashpartitioning(COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, 10), ENSURE_REQUIREMENTS, [plan_id=358486]

(12) ShuffleQueryStage
Output [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, min#578257, buf#580125, buf#580126]
Arguments: 0

(13) AQEShuffleRead
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, min#578257, buf#580125, buf#580126]
Arguments: coalesced

(14) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, min#578257, buf#580125, buf#580126]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713]
Functions [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983), collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, 0, 0), collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, 0, 0)]
Aggregate Attributes [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983)#578031, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, 0, 0)#578033, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, 0, 0)#578035]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713 AS COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983)#578031 AS COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, 0, 0)#578033 AS COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, 0, 0)#578035 AS COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]

(15) Sort [codegen id : 5]
Input [4]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]
Arguments: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055 ASC NULLS FIRST], false, 0

(16) Scan parquet 
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#577416, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#577417, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#577418, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#577420, COL_60F7C888_9836_4535_A22F_D43D2994E019#577425, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#577428]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_225663]
PushedFilters: [IsNotNull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F), IsNotNull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8)]
ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_8761272F_9915_40EB_8429_20EFEF6A9A31:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:string,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46:string,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A:double,COL_60F7C888_9836_4535_A22F_D43D2994E019:string,COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3:array<string>>

(17) ColumnarToRow [codegen id : 4]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#577416, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#577417, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#577418, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#577420, COL_60F7C888_9836_4535_A22F_D43D2994E019#577425, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#577428]

(18) Filter [codegen id : 4]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#577416, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#577417, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#577418, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#577420, COL_60F7C888_9836_4535_A22F_D43D2994E019#577425, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#577428]
Condition : (isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#577417))

(19) Project [codegen id : 4]
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413 AS 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#577416 AS 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#577417 AS 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#577418 AS 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#577420 AS 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107, COL_60F7C888_9836_4535_A22F_D43D2994E019#577425 AS 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#577428 AS 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#577416, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#577417, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#577418, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#577420, COL_60F7C888_9836_4535_A22F_D43D2994E019#577425, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#577428]

(20) Exchange
Input [7]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115]
Arguments: hashpartitioning(03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, 10), ENSURE_REQUIREMENTS, [plan_id=358527]

(21) ShuffleQueryStage
Output [7]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115]
Arguments: 1

(22) AQEShuffleRead
Input [7]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115]
Arguments: coalesced

(23) Sort [codegen id : 6]
Input [7]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115]
Arguments: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104 ASC NULLS FIRST], false, 0

(24) SortMergeJoin [codegen id : 7]
Left keys [1]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055]
Right keys [1]: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104]
Join type: Inner
Join condition: (isnotnull(str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null), +)), null))), null))))) AND NOT (str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null), +)), null))), null)))) <=> ))

(25) Project [codegen id : 7]
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100 AS COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103 AS COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105 AS COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 AS COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112 AS COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#578242, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115 AS COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) AS COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#578260]
Input [11]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115]

(26) Project [codegen id : 7]
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#578260 <=> 1), str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 <= 44.99))) THEN false ELSE ((COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 >= 45.0) END, SB3, null))), null) AS COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407, str_list_get(str_list_intersect_fixed(str_split(COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#578242, ;), [SUB,SB2,SB3]), 0) AS COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408, date_time_to_str(COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, ddMMyyyy, Europe/Paris, fr_FR) AS COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#578409, str_join(array(str_join(array(Age (en Année) , dec_to_str(COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241)),  : ), , str_join(array(Date Naissance , str_join(array(str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, LEFT, 2), str_extract_middle(COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, 3, 2), str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, RIGHT, 4)), -)),  : ), str_join(array(Date Entrée, str_join(array(str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, LEFT, 2), str_extract_middle(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, 3, 2), str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, RIGHT, 4)), -)),  : ), str_join(array(Date Biologie, str_list_as_str(COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058)),  : ), str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#578260 <=> 1), Eligible Bio : OUI, Eligible Bio : NON)),  - ) AS COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241, COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#578242, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#578260]

(27) Project [codegen id : 7]
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#578409, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058, str_if_with_rule((isnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408)), null, str_if_with_rule((COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408 <=> COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407), null, str_if_with_rule((isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408)), str_concat(array(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407, +)), str_if_with_rule(NOT (COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407 <=> COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408), str_concat(array(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408, -, str_if_with_rule(isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407), str_concat(array(,, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407, +)), null))), null)))) AS COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, str_create(RC-SUB) AS COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#578453]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407, COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#578409, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]

(28) Project [codegen id : 7]
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#578453, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, str_if_with_rule((isnotnull(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429) AND NOT (COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, +)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, -) END, Switch de forfait (SU Bio*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, -) END, Suppression de Forfait, )), COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#578409), @), ) AS COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#578536, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#578409, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#578453]

(29) WriteFiles
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#578453, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#578536, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]

(30) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR3_SUB_SB2__226357, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR3_SUB_SB2__226357], Overwrite, [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08, COL_46598A01_D8BC_436B_975B_00D168E3C4D6, COL_2F038993_76B5_4030_8D3B_7718F322492A, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9]

(31) Filter
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#577311, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#577312, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#577337]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293)

(32) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293 AS COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#577311 AS COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#577717, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#577312 AS COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#577337 AS COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#577293, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#577311, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#577312, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#577337]

(33) Filter
Input [2]: [REGLES#577274, APPLICABLE#577275]
Condition : ((isnotnull(REGLES#577274) AND (RC-SUB = REGLES#577274)) AND (APPLICABLE#577275 <=> O))

(34) Project
Output: []
Input [2]: [REGLES#577274, APPLICABLE#577275]

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

(36) Project
Output [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, str_to_datez(COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#577717, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983]
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#577717, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733]

(37) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713]
Functions [3]: [partial_min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983), partial_collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, 0, 0), partial_collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, 0, 0)]
Aggregate Attributes [3]: [min#578254, buf#580123, buf#580124]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, min#578257, buf#580125, buf#580126]

(38) Exchange
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, min#578257, buf#580125, buf#580126]
Arguments: hashpartitioning(COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, 10), ENSURE_REQUIREMENTS, [plan_id=358435]

(39) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713, min#578257, buf#580125, buf#580126]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713]
Functions [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983), collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, 0, 0), collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, 0, 0)]
Aggregate Attributes [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983)#578031, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, 0, 0)#578033, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, 0, 0)#578035]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#577713 AS COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#577983)#578031 AS COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#577732, 0, 0)#578033 AS COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#577733, 0, 0)#578035 AS COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]

(40) Sort
Input [4]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]
Arguments: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055 ASC NULLS FIRST], false, 0

(41) Filter
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#577416, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#577417, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#577418, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#577420, COL_60F7C888_9836_4535_A22F_D43D2994E019#577425, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#577428]
Condition : (isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#577417))

(42) Project
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413 AS 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#577416 AS 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#577417 AS 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#577418 AS 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#577420 AS 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107, COL_60F7C888_9836_4535_A22F_D43D2994E019#577425 AS 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#577428 AS 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#577413, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#577416, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#577417, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#577418, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#577420, COL_60F7C888_9836_4535_A22F_D43D2994E019#577425, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#577428]

(43) Exchange
Input [7]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115]
Arguments: hashpartitioning(03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, 10), ENSURE_REQUIREMENTS, [plan_id=358439]

(44) Sort
Input [7]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115]
Arguments: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104 ASC NULLS FIRST], false, 0

(45) SortMergeJoin
Left keys [1]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055]
Right keys [1]: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104]
Join type: Inner
Join condition: (isnotnull(str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null), +)), null))), null))))) AND NOT (str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 >= 45.0) END, SB3, null))), null), +)), null))), null)))) <=> ))

(46) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100 AS COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103 AS COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105 AS COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107 AS COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112 AS COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#578242, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115 AS COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, 0) AS COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#578260]
Input [11]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, COL_504D9344_0D6D_448F_B93B_8070A8498F87#578057, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#578100, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#578103, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#578104, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#578105, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#578107, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#578112, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#578115]

(47) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#578260 <=> 1), str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 <= 44.99))) THEN false ELSE ((COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241 >= 45.0) END, SB3, null))), null) AS COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407, str_list_get(str_list_intersect_fixed(str_split(COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#578242, ;), [SUB,SB2,SB3]), 0) AS COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408, date_time_to_str(COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, ddMMyyyy, Europe/Paris, fr_FR) AS COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#578409, str_join(array(str_join(array(Age (en Année) , dec_to_str(COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241)),  : ), , str_join(array(Date Naissance , str_join(array(str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, LEFT, 2), str_extract_middle(COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, 3, 2), str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, RIGHT, 4)), -)),  : ), str_join(array(Date Entrée, str_join(array(str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, LEFT, 2), str_extract_middle(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, 3, 2), str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, RIGHT, 4)), -)),  : ), str_join(array(Date Biologie, str_list_as_str(COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058)),  : ), str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#578260 <=> 1), Eligible Bio : OUI, Eligible Bio : NON)),  - ) AS COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#578056, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_50001E33_210D_4379_9D53_00CD383D4C9E#578241, COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#578242, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#578260]

(48) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#578409, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058, str_if_with_rule((isnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408)), null, str_if_with_rule((COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408 <=> COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407), null, str_if_with_rule((isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408)), str_concat(array(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407, +)), str_if_with_rule(NOT (COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407 <=> COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408), str_concat(array(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408, -, str_if_with_rule(isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407), str_concat(array(,, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407, +)), null))), null)))) AS COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, str_create(RC-SUB) AS COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#578453]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#578407, COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#578408, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#578409, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]

(49) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#578453, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, str_if_with_rule((isnotnull(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429) AND NOT (COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, +)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, -) END, Switch de forfait (SU Bio*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, -) END, Suppression de Forfait, )), COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#578409), @), ) AS COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#578536, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#578409, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#578453]

(50) WriteFiles
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#578055, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#578238, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#578453, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#578429, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#578536, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#578410, COL_2F038993_76B5_4030_8D3B_7718F322492A#578239, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#578240, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#578243, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#578058]

(51) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR3_SUB_SB2__226357, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR3_SUB_SB2__226357], Overwrite, [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08, COL_46598A01_D8BC_436B_975B_00D168E3C4D6, COL_2F038993_76B5_4030_8D3B_7718F322492A, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9]

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

SQL / DataFrame Properties

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