SP1 - Details for Query 5189

Submitted Time: 2026/03/25 16:57:11
Duration: 2 s
Succeeded Jobs: 7915 7916 7917

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15075.0: task 20773)) number of written files: 1 job commit time: 10 ms number of output rows: 0 number of dynamic part: 0 written output: 1934.0 B"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n3.8 s (716 ms, 1.4 s, 1.7 s (stage 15075.0: task 20774))"; 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: 0 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15075.0: task 20773))"]; } subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n6.2 s (1.2 s, 2.3 s, 2.7 s (stage 15075.0: task 20774))"; 10 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15075.0: task 20772)) peak memory total (min, med, max (stageId: taskId)) 49.5 MiB (16.5 MiB, 16.5 MiB, 16.5 MiB (stage 15075.0: task 20772)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15075.0: task 20772))"]; } 11 [labelType="html" label="ObjectHashAggregate number of output rows: 37,268 time in aggregation build total (min, med, max (stageId: taskId)) 139 ms (42 ms, 47 ms, 50 ms (stage 15075.0: task 20772)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15075.0: task 20773)) number of sort fallback tasks: 3"]; 12 [labelType="html" label="AQEShuffleRead number of partitions: 3 partition data size total (min, med, max (stageId: taskId)) 823.0 KiB (246.9 KiB, 246.9 KiB, 329.2 KiB (driver)) number of coalesced partitions: 3"]; 13 [labelType="html" label="Exchange shuffle records written: 37,268 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 7 ms (1 ms, 1 ms, 2 ms (stage 15071.0: task 20758)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 37,268 local bytes read total (min, med, max (stageId: taskId)) 790.5 KiB (235.9 KiB, 237.8 KiB, 316.8 KiB (stage 15075.0: task 20774)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15075.0: task 20772)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 6 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 4.4 MiB (883.7 KiB, 898.3 KiB, 904.1 KiB (stage 15071.0: task 20757)) 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)) 790.5 KiB (156.8 KiB, 157.5 KiB, 159.6 KiB (stage 15071.0: task 20757))"]; 14 [labelType="html" label="ObjectHashAggregate number of output rows: 37,268 time in aggregation build total (min, med, max (stageId: taskId)) 605 ms (105 ms, 125 ms, 130 ms (stage 15071.0: task 20761)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15071.0: task 20757)) number of sort fallback tasks: 5"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n602 ms (104 ms, 124 ms, 130 ms (stage 15071.0: task 20761))"; 16 [labelType="html" label=" Project "]; } 17 [labelType="html" label="CartesianProduct number of output rows: 85,895"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n605 ms (105 ms, 125 ms, 130 ms (stage 15071.0: task 20758))"; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label="Filter number of output rows: 85,895"]; 21 [labelType="html" label="ColumnarToRow number of output rows: 85,895 number of input batches: 25"]; } 22 [labelType="html" label="Scan parquet number of files read: 5 scan time total (min, med, max (stageId: taskId)) 37 ms (4 ms, 7 ms, 12 ms (stage 15071.0: task 20758)) metadata time: 0 ms size of files read: 4.6 MiB number of output rows: 85,895"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n29 ms (3 ms, 6 ms, 9 ms (stage 15071.0: task 20758))"; 24 [labelType="html" label=" Project "]; 25 [labelType="html" label="Filter number of output rows: 5"]; } 26 [labelType="html" label="Scan csv number of output rows: 5 number of files read: 1 metadata time: 0 ms size of files read: 175.0 B"]; subgraph cluster27 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n3.6 s (1.1 s, 1.2 s, 1.3 s (stage 15075.0: task 20774))"; 28 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 3 ms (1 ms, 1 ms, 1 ms (stage 15075.0: task 20772)) peak memory total (min, med, max (stageId: taskId)) 49.0 MiB (16.3 MiB, 16.3 MiB, 16.5 MiB (stage 15075.0: task 20774)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15075.0: task 20772))"]; } 29 [labelType="html" label="AQEShuffleRead number of partitions: 3 partition data size total (min, med, max (stageId: taskId)) 2.8 MiB (853.1 KiB, 860.7 KiB, 1140.0 KiB (driver)) number of coalesced partitions: 3"]; 30 [labelType="html" label="Exchange shuffle records written: 34,259 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 31 ms (2 ms, 3 ms, 4 ms (stage 15072.0: task 20769)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 34,259 local bytes read total (min, med, max (stageId: taskId)) 2.7 MiB (812.3 KiB, 820.0 KiB, 1085.3 KiB (stage 15075.0: task 20774)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15075.0: task 20772)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 30 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 8.2 MiB (817.8 KiB, 849.3 KiB, 855.9 KiB (stage 15072.0: task 20759)) 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)) 2.7 MiB (263.9 KiB, 274.3 KiB, 277.7 KiB (stage 15072.0: task 20759))"]; subgraph cluster31 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n278 ms (12 ms, 32 ms, 38 ms (stage 15072.0: task 20770))"; 32 [labelType="html" label=" Project "]; 33 [labelType="html" label="Filter number of output rows: 34,259"]; 34 [labelType="html" label="ColumnarToRow number of output rows: 34,259 number of input batches: 10"]; } 35 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 60 ms (4 ms, 6 ms, 9 ms (stage 15072.0: task 20768)) metadata time: 0 ms size of files read: 5.7 MiB number of output rows: 34,259"]; 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__176131, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR3_SUB_SB2__176131], 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#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1165560, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, str_if_with_rule((isnotnull(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544) AND NOT (COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, +)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, -) END, Switch de forfait (SU Bio*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, -) END, Suppression de Forfait, )), COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#1165524), @), ) AS COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1165643, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]

Project [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#1165524, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178, str_if_with_rule((isnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523)), null, str_if_with_rule((COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523 <=> COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522), null, str_if_with_rule((isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523)), str_concat(array(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522, +)), str_if_with_rule(NOT (COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522 <=> COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523), str_concat(array(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523, -, str_if_with_rule(isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522), str_concat(array(,, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522, +)), null))), null)))) AS COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, str_create(RC-SUB) AS COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1165560]

Project [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#1165377 <=> 1), str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 <= 44.99))) THEN false ELSE ((COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 >= 45.0) END, SB3, null))), null) AS COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522, str_list_get(str_list_intersect_fixed(str_split(COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#1165365, ;), [SUB,SB2,SB3]), 0) AS COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523, date_time_to_str(COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, ddMMyyyy, Europe/Paris, fr_FR) AS COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#1165524, str_join(array(str_join(array(Age (en Année) , dec_to_str(COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364)), : ), , str_join(array(Date Naissance , str_join(array(str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, LEFT, 2), str_extract_middle(COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, 3, 2), str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, RIGHT, 4)), -)), : ), str_join(array(Date Entrée, str_join(array(str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, LEFT, 2), str_extract_middle(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, 3, 2), str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, RIGHT, 4)), -)), : ), str_join(array(Date Biologie, str_list_as_str(COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178)), : ), str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#1165377 <=> 1), Eligible Bio : OUI, Eligible Bio : NON)), - ) AS COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]

Project [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178, 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222 AS COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225 AS COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227 AS COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 AS COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364, 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234 AS COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#1165365, 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237 AS COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) AS COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#1165377]

SortMergeJoin [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175], [03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226], Inner, (isnotnull(str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 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#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 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#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 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#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null), +)), null))), null)))) <=> ))

WholeStageCodegen (7)

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

WholeStageCodegen (5)

ObjectHashAggregate(keys=[COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833], functions=[min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103), collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, 0, 0), collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, 10), ENSURE_REQUIREMENTS, [plan_id=608433]

ObjectHashAggregate(keys=[COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833], functions=[partial_min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103), partial_collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, 0, 0), partial_collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, 0, 0)])

Project [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, str_to_datez(COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#1164837, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103]

WholeStageCodegen (3)

CartesianProduct

Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1164437 AS COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1164455 AS COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#1164837, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1164456 AS COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#1164481 AS COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853]

Filter isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1164437)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1164437,COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1164455,COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1164456,COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#1164481] Batched: true, DataFilters: [isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1164437)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_176158], PartitionFilters: [], PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)], ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C:s...

Project

Filter ((isnotnull(REGLES#1164418) AND (RC-SUB = REGLES#1164418)) AND (APPLICABLE#1164419 <=> O))

WholeStageCodegen (2)

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

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

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, 10), ENSURE_REQUIREMENTS, [plan_id=608474]

Project [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1164548 AS 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1164551 AS 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1164552 AS 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1164553 AS 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1164555 AS 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229, COL_60F7C888_9836_4535_A22F_D43D2994E019#1164560 AS 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1164563 AS 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237]

Filter (isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1164548) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1164552))

ColumnarToRow

WholeStageCodegen (4)

FileScan parquet [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1164548,COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1164551,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1164552,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1164553,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1164555,COL_60F7C888_9836_4535_A22F_D43D2994E019#1164560,COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1164563] Batched: true, DataFilters: [isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1164548), isnotnull(COL_582B8737_1AAE_44AC_AF..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_175988], 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=4.4 MiB, rowCount=3.73E+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=8.2 MiB, rowCount=3.43E+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#1164437, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1164455, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1164456, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#1164481]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_176158]
PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_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#1164437, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1164455, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1164456, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#1164481]

(3) Filter [codegen id : 1]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1164437, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1164455, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1164456, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#1164481]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1164437)

(4) Project [codegen id : 1]
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1164437 AS COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1164455 AS COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#1164837, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1164456 AS COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#1164481 AS COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1164437, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1164455, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1164456, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#1164481]

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

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

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

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

(9) Project [codegen id : 3]
Output [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, str_to_datez(COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#1164837, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103]
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#1164837, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853]

(10) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833]
Functions [3]: [partial_min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103), partial_collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, 0, 0), partial_collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, 0, 0)]
Aggregate Attributes [3]: [min#1165675, buf#1167915, buf#1167916]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, min#1165678, buf#1167917, buf#1167918]

(11) Exchange
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, min#1165678, buf#1167917, buf#1167918]
Arguments: hashpartitioning(COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, 10), ENSURE_REQUIREMENTS, [plan_id=608433]

(12) ShuffleQueryStage
Output [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, min#1165678, buf#1167917, buf#1167918]
Arguments: 0

(13) AQEShuffleRead
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, min#1165678, buf#1167917, buf#1167918]
Arguments: coalesced

(14) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, min#1165678, buf#1167917, buf#1167918]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833]
Functions [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103), collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, 0, 0), collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, 0, 0)]
Aggregate Attributes [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103)#1165151, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, 0, 0)#1165153, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, 0, 0)#1165155]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833 AS COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103)#1165151 AS COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, 0, 0)#1165153 AS COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, 0, 0)#1165155 AS COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]

(15) Sort [codegen id : 5]
Input [4]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]
Arguments: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175 ASC NULLS FIRST], false, 0

(16) Scan parquet 
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1164548, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1164551, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1164552, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1164553, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1164555, COL_60F7C888_9836_4535_A22F_D43D2994E019#1164560, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1164563]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_175988]
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#1164548, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1164551, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1164552, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1164553, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1164555, COL_60F7C888_9836_4535_A22F_D43D2994E019#1164560, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1164563]

(18) Filter [codegen id : 4]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1164548, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1164551, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1164552, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1164553, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1164555, COL_60F7C888_9836_4535_A22F_D43D2994E019#1164560, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1164563]
Condition : (isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1164548) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1164552))

(19) Project [codegen id : 4]
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1164548 AS 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1164551 AS 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1164552 AS 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1164553 AS 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1164555 AS 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229, COL_60F7C888_9836_4535_A22F_D43D2994E019#1164560 AS 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1164563 AS 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1164548, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1164551, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1164552, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1164553, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1164555, COL_60F7C888_9836_4535_A22F_D43D2994E019#1164560, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1164563]

(20) Exchange
Input [7]: [03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222, 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227, 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229, 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237]
Arguments: hashpartitioning(03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, 10), ENSURE_REQUIREMENTS, [plan_id=608474]

(21) ShuffleQueryStage
Output [7]: [03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222, 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227, 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229, 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237]
Arguments: 1

(22) AQEShuffleRead
Input [7]: [03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222, 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227, 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229, 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237]
Arguments: coalesced

(23) Sort [codegen id : 6]
Input [7]: [03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222, 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227, 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229, 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237]
Arguments: [03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226 ASC NULLS FIRST], false, 0

(24) SortMergeJoin [codegen id : 7]
Left keys [1]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175]
Right keys [1]: [03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226]
Join type: Inner
Join condition: (isnotnull(str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 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#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 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#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 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#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null), +)), null))), null)))) <=> ))

(25) Project [codegen id : 7]
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178, 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222 AS COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225 AS COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227 AS COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 AS COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364, 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234 AS COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#1165365, 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237 AS COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) AS COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#1165377]
Input [11]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178, 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222, 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227, 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229, 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237]

(26) Project [codegen id : 7]
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#1165377 <=> 1), str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 <= 44.99))) THEN false ELSE ((COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 >= 45.0) END, SB3, null))), null) AS COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522, str_list_get(str_list_intersect_fixed(str_split(COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#1165365, ;), [SUB,SB2,SB3]), 0) AS COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523, date_time_to_str(COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, ddMMyyyy, Europe/Paris, fr_FR) AS COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#1165524, str_join(array(str_join(array(Age (en Année) , dec_to_str(COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364)),  : ), , str_join(array(Date Naissance , str_join(array(str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, LEFT, 2), str_extract_middle(COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, 3, 2), str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, RIGHT, 4)), -)),  : ), str_join(array(Date Entrée, str_join(array(str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, LEFT, 2), str_extract_middle(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, 3, 2), str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, RIGHT, 4)), -)),  : ), str_join(array(Date Biologie, str_list_as_str(COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178)),  : ), str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#1165377 <=> 1), Eligible Bio : OUI, Eligible Bio : NON)),  - ) AS COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364, COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#1165365, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#1165377]

(27) Project [codegen id : 7]
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#1165524, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178, str_if_with_rule((isnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523)), null, str_if_with_rule((COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523 <=> COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522), null, str_if_with_rule((isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523)), str_concat(array(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522, +)), str_if_with_rule(NOT (COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522 <=> COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523), str_concat(array(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523, -, str_if_with_rule(isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522), str_concat(array(,, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522, +)), null))), null)))) AS COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, str_create(RC-SUB) AS COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1165560]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522, COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#1165524, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]

(28) Project [codegen id : 7]
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1165560, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, str_if_with_rule((isnotnull(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544) AND NOT (COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, +)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, -) END, Switch de forfait (SU Bio*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, -) END, Suppression de Forfait, )), COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#1165524), @), ) AS COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1165643, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#1165524, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1165560]

(29) WriteFiles
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1165560, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1165643, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]

(30) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR3_SUB_SB2__176131, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR3_SUB_SB2__176131], 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#1164437, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1164455, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1164456, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#1164481]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1164437)

(32) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1164437 AS COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1164455 AS COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#1164837, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1164456 AS COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#1164481 AS COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1164437, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1164455, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1164456, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#1164481]

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

(34) Project
Output: []
Input [2]: [REGLES#1164418, APPLICABLE#1164419]

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

(36) Project
Output [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, str_to_datez(COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#1164837, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103]
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#1164837, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853]

(37) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833]
Functions [3]: [partial_min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103), partial_collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, 0, 0), partial_collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, 0, 0)]
Aggregate Attributes [3]: [min#1165675, buf#1167915, buf#1167916]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, min#1165678, buf#1167917, buf#1167918]

(38) Exchange
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, min#1165678, buf#1167917, buf#1167918]
Arguments: hashpartitioning(COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, 10), ENSURE_REQUIREMENTS, [plan_id=608382]

(39) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833, min#1165678, buf#1167917, buf#1167918]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833]
Functions [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103), collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, 0, 0), collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, 0, 0)]
Aggregate Attributes [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103)#1165151, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, 0, 0)#1165153, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, 0, 0)#1165155]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#1164833 AS COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#1165103)#1165151 AS COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#1164852, 0, 0)#1165153 AS COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#1164853, 0, 0)#1165155 AS COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]

(40) Sort
Input [4]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]
Arguments: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175 ASC NULLS FIRST], false, 0

(41) Filter
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1164548, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1164551, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1164552, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1164553, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1164555, COL_60F7C888_9836_4535_A22F_D43D2994E019#1164560, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1164563]
Condition : (isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1164548) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1164552))

(42) Project
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1164548 AS 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1164551 AS 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1164552 AS 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1164553 AS 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1164555 AS 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229, COL_60F7C888_9836_4535_A22F_D43D2994E019#1164560 AS 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1164563 AS 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1164548, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1164551, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1164552, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1164553, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1164555, COL_60F7C888_9836_4535_A22F_D43D2994E019#1164560, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1164563]

(43) Exchange
Input [7]: [03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222, 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227, 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229, 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237]
Arguments: hashpartitioning(03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, 10), ENSURE_REQUIREMENTS, [plan_id=608386]

(44) Sort
Input [7]: [03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222, 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227, 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229, 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237]
Arguments: [03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226 ASC NULLS FIRST], false, 0

(45) SortMergeJoin
Left keys [1]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175]
Right keys [1]: [03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226]
Join type: Inner
Join condition: (isnotnull(str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 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#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 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#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 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#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 16.0) AND (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229) THEN false ELSE (03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 >= 45.0) END, SB3, null))), null), +)), null))), null)))) <=> ))

(46) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178, 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222 AS COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225 AS COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227 AS COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229 AS COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364, 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234 AS COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#1165365, 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237 AS COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, 0) AS COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#1165377]
Input [11]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, COL_504D9344_0D6D_448F_B93B_8070A8498F87#1165177, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178, 03_PIVOT_INFORM_175988_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1165222, 03_PIVOT_INFORM_175988_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1165225, 03_PIVOT_INFORM_175988_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1165226, 03_PIVOT_INFORM_175988_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1165227, 03_PIVOT_INFORM_175988_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1165229, 03_PIVOT_INFORM_175988_COL_60F7C888_9836_4535_A22F_D43D2994E019#1165234, 03_PIVOT_INFORM_175988_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1165237]

(47) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#1165377 <=> 1), str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 <= 44.99))) THEN false ELSE ((COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364 >= 45.0) END, SB3, null))), null) AS COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522, str_list_get(str_list_intersect_fixed(str_split(COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#1165365, ;), [SUB,SB2,SB3]), 0) AS COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523, date_time_to_str(COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, ddMMyyyy, Europe/Paris, fr_FR) AS COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#1165524, str_join(array(str_join(array(Age (en Année) , dec_to_str(COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364)),  : ), , str_join(array(Date Naissance , str_join(array(str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, LEFT, 2), str_extract_middle(COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, 3, 2), str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, RIGHT, 4)), -)),  : ), str_join(array(Date Entrée, str_join(array(str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, LEFT, 2), str_extract_middle(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, 3, 2), str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, RIGHT, 4)), -)),  : ), str_join(array(Date Biologie, str_list_as_str(COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178)),  : ), str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#1165377 <=> 1), Eligible Bio : OUI, Eligible Bio : NON)),  - ) AS COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#1165176, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_50001E33_210D_4379_9D53_00CD383D4C9E#1165364, COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#1165365, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#1165377]

(48) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#1165524, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178, str_if_with_rule((isnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523)), null, str_if_with_rule((COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523 <=> COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522), null, str_if_with_rule((isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523)), str_concat(array(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522, +)), str_if_with_rule(NOT (COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522 <=> COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523), str_concat(array(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523, -, str_if_with_rule(isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522), str_concat(array(,, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522, +)), null))), null)))) AS COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, str_create(RC-SUB) AS COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1165560]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#1165522, COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#1165523, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#1165524, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]

(49) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1165560, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, str_if_with_rule((isnotnull(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544) AND NOT (COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, +)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, -) END, Switch de forfait (SU Bio*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, -) END, Suppression de Forfait, )), COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#1165524), @), ) AS COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1165643, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#1165524, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1165560]

(50) WriteFiles
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1165175, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1165361, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1165560, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1165544, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1165643, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1165525, COL_2F038993_76B5_4030_8D3B_7718F322492A#1165362, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#1165363, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#1165366, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#1165178]

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