SP1 - Details for Query 395

Submitted Time: 2026/06/25 16:22:35
Duration: 0.5 s
Succeeded Jobs: 509

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

digraph G { 0 [labelType="html" label=" CollectLimit "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 155 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 0"]; 4 [labelType="html" label="ColumnarToRow number of output rows: 1,455 number of input batches: 1"]; } 5 [labelType="html" label="Scan parquet number of files read: 1 scan time: 11 ms metadata time: 0 ms size of files read: 312.5 KiB number of output rows: 1,455"]; 2->0; 3->2; 4->3; 5->4; }

CollectLimit 1500

Project [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152599 AS COL_COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152929, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152600 AS COL_COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152930, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152601 AS COL_COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152931, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152602 AS COL_COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152932, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152603 AS COL_COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152933, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152604 AS COL_COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152934, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152605 AS COL_COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152935, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152606 AS COL_COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152936, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152607 AS COL_COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152937, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152608 AS COL_COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152938, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152609 AS COL_COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152939, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152610 AS COL_COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152940, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152611 AS COL_COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152941, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152612 AS COL_COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152942, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152613 AS COL_COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152943, COL_98B2878A_418E_4331_B333_2493994BB807#152614 AS COL_COL_98B2878A_418E_4331_B333_2493994BB807#152944, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152615 AS COL_COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152945, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152616 AS COL_COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152946, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152617 AS COL_COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152947, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152618 AS COL_COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152948, COL_E722B691_2CA2_4160_A578_D9CD4920A842#152619 AS COL_COL_E722B691_2CA2_4160_A578_D9CD4920A842#152949, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152620 AS COL_COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152950, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152621 AS COL_COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152951, COL_D897344F_9AC3_429E_A95D_88390F445758#152622 AS COL_COL_D897344F_9AC3_429E_A95D_88390F445758#152952, ... 31 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152599)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152599)), --) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152600)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152600)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152601)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152601)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152602)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152602)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152603)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152603)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152604)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152604)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152605)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152605)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152606)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152606)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152607)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152607)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152608)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152608)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152609)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152609)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152610)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152610)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152611)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152611)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152612)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152612)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152613)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152613)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#152614)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#152614)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152615)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152615)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152616)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152616)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152617)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152617)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152618)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152618)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#152619)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#152619)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152620)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152620)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152621)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152621)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#152622)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#152622)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#152623)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#152623)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#152624)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#152624)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#152625)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#152625)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#152626)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#152626)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#152627)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#152627)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#152628)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#152628)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#152629)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#152629)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#152630)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#152630)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#152631)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#152631)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#152632)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#152632)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#152633)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#152633)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#152634)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#152634)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#152635)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#152635)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#152636)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#152636)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#152647)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#152647)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8068E186_2734_4730_8D2C_A788B2226179#152649)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_8068E186_2734_4730_8D2C_A788B2226179#152649)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DA667933_29E5_49E1_8724_A537DCE9735F#152650)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_DA667933_29E5_49E1_8724_A537DCE9735F#152650)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#152651)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#152651)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#152652)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#152652)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#152653)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#152653)), --) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152599,COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152600,COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152601,COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152602,COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152603,COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152604,COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152605,COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152606,COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152607,COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152608,COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152609,COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152610,COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152611,COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152612,COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152613,COL_98B2878A_418E_4331_B333_2493994BB807#152614,COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152615,COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152616,COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152617,COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152618,COL_E722B691_2CA2_4160_A578_D9CD4920A842#152619,COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152620,COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152621,COL_D897344F_9AC3_429E_A95D_88390F445758#152622,... 31 more fields] Batched: true, DataFilters: [(((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405366], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399:string,COL_956F91E2_2027_457F_A229_B9CF20D9FF63:s...

Details

== Physical Plan ==
CollectLimit (5)
+- * Project (4)
   +- * Filter (3)
      +- * ColumnarToRow (2)
         +- Scan parquet  (1)


(1) Scan parquet 
Output [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152599, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152600, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152601, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152602, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152603, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152604, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152605, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152606, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152607, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152608, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152609, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152610, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152611, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152612, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152613, COL_98B2878A_418E_4331_B333_2493994BB807#152614, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152615, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152616, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152617, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152618, COL_E722B691_2CA2_4160_A578_D9CD4920A842#152619, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152620, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152621, COL_D897344F_9AC3_429E_A95D_88390F445758#152622, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#152623, COL_52167438_70F6_4E26_B5CD_17C5990F8948#152624, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#152625, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#152626, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#152627, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#152628, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#152629, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#152630, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#152631, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#152632, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#152633, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#152634, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#152635, COL_1FF33786_C88A_4789_B428_364FF98B1905#152636, COL_35375170_B542_49DE_AFA2_0A2D31967891#152637L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#152638, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#152639, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#152640, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#152641, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#152642, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#152643, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#152644, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#152645, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#152646, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#152647, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#152648, COL_8068E186_2734_4730_8D2C_A788B2226179#152649, COL_DA667933_29E5_49E1_8724_A537DCE9735F#152650, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#152651, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#152652, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#152653]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405366]
ReadSchema: struct<COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399:string,COL_956F91E2_2027_457F_A229_B9CF20D9FF63:string,COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3:string,COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3:string,COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C:string,COL_FB65F162_1AB6_4971_99DA_F8A943944A66:string,COL_04BFCB87_D14B_4364_A366_6B179BF9CD20:string,COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C:string,COL_573E3A58_7401_4F3F_9EFA_058729D28B72:string,COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF:string,COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159:string,COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9:string,COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084:string,COL_C42F735E_237B_4569_996D_76FF5A4A65DF:string,COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214:string,COL_98B2878A_418E_4331_B333_2493994BB807:string,COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C:string,COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF:string,COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE:string,COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63:string,COL_E722B691_2CA2_4160_A578_D9CD4920A842:string,COL_D600764E_8D81_4891_BF21_ACC3F0938E57:string,COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5:string,COL_D897344F_9AC3_429E_A95D_88390F445758:string,COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9:string,COL_52167438_70F6_4E26_B5CD_17C5990F8948:string,COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17:string,COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3:string,COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539:string,COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9:string,COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6:string,COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9:string,COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49:string,COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7:string,COL_D0A8A26A_A602_4462_BBB1_8286F0724054:string,COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30:string,COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3:string,COL_1FF33786_C88A_4789_B428_364FF98B1905:string,COL_35375170_B542_49DE_AFA2_0A2D31967891:bigint,COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF:double,COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9:double,COL_C0CA120C_6738_4CF5_B569_FD209A7B518A:double,COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3:double,COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE:double,COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF:double,COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD:double,COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9:double,COL_23424D2C_0B0A_403F_9061_1D8B148D6A67:double,COL_5CDC74F0_3D28_463C_9042_237BDAB52540:string,COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028:double,COL_8068E186_2734_4730_8D2C_A788B2226179:string,COL_DA667933_29E5_49E1_8724_A537DCE9735F:string,COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4:string,COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7:string,COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458:string>

(2) ColumnarToRow [codegen id : 1]
Input [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152599, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152600, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152601, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152602, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152603, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152604, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152605, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152606, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152607, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152608, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152609, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152610, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152611, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152612, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152613, COL_98B2878A_418E_4331_B333_2493994BB807#152614, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152615, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152616, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152617, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152618, COL_E722B691_2CA2_4160_A578_D9CD4920A842#152619, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152620, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152621, COL_D897344F_9AC3_429E_A95D_88390F445758#152622, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#152623, COL_52167438_70F6_4E26_B5CD_17C5990F8948#152624, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#152625, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#152626, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#152627, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#152628, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#152629, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#152630, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#152631, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#152632, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#152633, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#152634, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#152635, COL_1FF33786_C88A_4789_B428_364FF98B1905#152636, COL_35375170_B542_49DE_AFA2_0A2D31967891#152637L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#152638, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#152639, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#152640, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#152641, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#152642, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#152643, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#152644, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#152645, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#152646, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#152647, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#152648, COL_8068E186_2734_4730_8D2C_A788B2226179#152649, COL_DA667933_29E5_49E1_8724_A537DCE9735F#152650, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#152651, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#152652, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#152653]

(3) Filter [codegen id : 1]
Input [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152599, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152600, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152601, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152602, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152603, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152604, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152605, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152606, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152607, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152608, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152609, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152610, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152611, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152612, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152613, COL_98B2878A_418E_4331_B333_2493994BB807#152614, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152615, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152616, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152617, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152618, COL_E722B691_2CA2_4160_A578_D9CD4920A842#152619, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152620, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152621, COL_D897344F_9AC3_429E_A95D_88390F445758#152622, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#152623, COL_52167438_70F6_4E26_B5CD_17C5990F8948#152624, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#152625, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#152626, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#152627, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#152628, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#152629, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#152630, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#152631, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#152632, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#152633, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#152634, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#152635, COL_1FF33786_C88A_4789_B428_364FF98B1905#152636, COL_35375170_B542_49DE_AFA2_0A2D31967891#152637L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#152638, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#152639, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#152640, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#152641, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#152642, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#152643, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#152644, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#152645, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#152646, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#152647, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#152648, COL_8068E186_2734_4730_8D2C_A788B2226179#152649, COL_DA667933_29E5_49E1_8724_A537DCE9735F#152650, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#152651, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#152652, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#152653]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152599)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152599)), --) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152600)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152600)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152601)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152601)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152602)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152602)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152603)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152603)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152604)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152604)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152605)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152605)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152606)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152606)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152607)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152607)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152608)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152608)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152609)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152609)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152610)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152610)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152611)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152611)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152612)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152612)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152613)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152613)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#152614)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#152614)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152615)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152615)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152616)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152616)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152617)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152617)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152618)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152618)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#152619)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#152619)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152620)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152620)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152621)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152621)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#152622)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#152622)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#152623)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#152623)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#152624)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#152624)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#152625)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#152625)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#152626)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#152626)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#152627)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#152627)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#152628)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#152628)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#152629)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#152629)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#152630)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#152630)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#152631)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#152631)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#152632)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#152632)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#152633)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#152633)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#152634)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#152634)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#152635)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#152635)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#152636)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#152636)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#152647)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#152647)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8068E186_2734_4730_8D2C_A788B2226179#152649)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_8068E186_2734_4730_8D2C_A788B2226179#152649)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DA667933_29E5_49E1_8724_A537DCE9735F#152650)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_DA667933_29E5_49E1_8724_A537DCE9735F#152650)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#152651)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#152651)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#152652)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#152652)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#152653)), --)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#152653)), --) END)

(4) Project [codegen id : 1]
Output [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152599 AS COL_COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152929, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152600 AS COL_COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152930, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152601 AS COL_COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152931, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152602 AS COL_COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152932, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152603 AS COL_COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152933, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152604 AS COL_COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152934, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152605 AS COL_COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152935, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152606 AS COL_COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152936, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152607 AS COL_COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152937, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152608 AS COL_COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152938, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152609 AS COL_COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152939, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152610 AS COL_COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152940, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152611 AS COL_COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152941, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152612 AS COL_COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152942, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152613 AS COL_COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152943, COL_98B2878A_418E_4331_B333_2493994BB807#152614 AS COL_COL_98B2878A_418E_4331_B333_2493994BB807#152944, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152615 AS COL_COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152945, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152616 AS COL_COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152946, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152617 AS COL_COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152947, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152618 AS COL_COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152948, COL_E722B691_2CA2_4160_A578_D9CD4920A842#152619 AS COL_COL_E722B691_2CA2_4160_A578_D9CD4920A842#152949, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152620 AS COL_COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152950, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152621 AS COL_COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152951, COL_D897344F_9AC3_429E_A95D_88390F445758#152622 AS COL_COL_D897344F_9AC3_429E_A95D_88390F445758#152952, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#152623 AS COL_COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#152953, COL_52167438_70F6_4E26_B5CD_17C5990F8948#152624 AS COL_COL_52167438_70F6_4E26_B5CD_17C5990F8948#152954, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#152625 AS COL_COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#152955, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#152626 AS COL_COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#152956, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#152627 AS COL_COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#152957, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#152628 AS COL_COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#152958, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#152629 AS COL_COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#152959, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#152630 AS COL_COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#152960, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#152631 AS COL_COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#152961, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#152632 AS COL_COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#152962, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#152633 AS COL_COL_D0A8A26A_A602_4462_BBB1_8286F0724054#152963, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#152634 AS COL_COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#152964, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#152635 AS COL_COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#152965, COL_1FF33786_C88A_4789_B428_364FF98B1905#152636 AS COL_COL_1FF33786_C88A_4789_B428_364FF98B1905#152966, COL_35375170_B542_49DE_AFA2_0A2D31967891#152637L AS COL_COL_35375170_B542_49DE_AFA2_0A2D31967891#152967L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#152638 AS COL_COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#152968, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#152639 AS COL_COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#152969, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#152640 AS COL_COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#152970, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#152641 AS COL_COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#152971, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#152642 AS COL_COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#152972, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#152643 AS COL_COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#152973, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#152644 AS COL_COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#152974, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#152645 AS COL_COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#152975, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#152646 AS COL_COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#152976, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#152647 AS COL_COL_5CDC74F0_3D28_463C_9042_237BDAB52540#152977, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#152648 AS COL_COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#152978, COL_8068E186_2734_4730_8D2C_A788B2226179#152649 AS COL_COL_8068E186_2734_4730_8D2C_A788B2226179#152979, COL_DA667933_29E5_49E1_8724_A537DCE9735F#152650 AS COL_COL_DA667933_29E5_49E1_8724_A537DCE9735F#152980, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#152651 AS COL_COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#152981, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#152652 AS COL_COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#152982, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#152653 AS COL_COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#152983]
Input [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152599, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152600, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152601, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152602, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152603, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152604, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152605, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152606, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152607, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152608, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152609, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152610, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152611, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152612, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152613, COL_98B2878A_418E_4331_B333_2493994BB807#152614, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152615, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152616, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152617, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152618, COL_E722B691_2CA2_4160_A578_D9CD4920A842#152619, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152620, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152621, COL_D897344F_9AC3_429E_A95D_88390F445758#152622, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#152623, COL_52167438_70F6_4E26_B5CD_17C5990F8948#152624, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#152625, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#152626, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#152627, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#152628, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#152629, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#152630, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#152631, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#152632, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#152633, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#152634, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#152635, COL_1FF33786_C88A_4789_B428_364FF98B1905#152636, COL_35375170_B542_49DE_AFA2_0A2D31967891#152637L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#152638, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#152639, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#152640, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#152641, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#152642, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#152643, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#152644, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#152645, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#152646, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#152647, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#152648, COL_8068E186_2734_4730_8D2C_A788B2226179#152649, COL_DA667933_29E5_49E1_8724_A537DCE9735F#152650, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#152651, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#152652, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#152653]

(5) CollectLimit
Input [55]: [COL_COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#152929, COL_COL_956F91E2_2027_457F_A229_B9CF20D9FF63#152930, COL_COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#152931, COL_COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#152932, COL_COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#152933, COL_COL_FB65F162_1AB6_4971_99DA_F8A943944A66#152934, COL_COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#152935, COL_COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#152936, COL_COL_573E3A58_7401_4F3F_9EFA_058729D28B72#152937, COL_COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#152938, COL_COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#152939, COL_COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#152940, COL_COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#152941, COL_COL_C42F735E_237B_4569_996D_76FF5A4A65DF#152942, COL_COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#152943, COL_COL_98B2878A_418E_4331_B333_2493994BB807#152944, COL_COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#152945, COL_COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#152946, COL_COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#152947, COL_COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#152948, COL_COL_E722B691_2CA2_4160_A578_D9CD4920A842#152949, COL_COL_D600764E_8D81_4891_BF21_ACC3F0938E57#152950, COL_COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#152951, COL_COL_D897344F_9AC3_429E_A95D_88390F445758#152952, COL_COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#152953, COL_COL_52167438_70F6_4E26_B5CD_17C5990F8948#152954, COL_COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#152955, COL_COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#152956, COL_COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#152957, COL_COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#152958, COL_COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#152959, COL_COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#152960, COL_COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#152961, COL_COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#152962, COL_COL_D0A8A26A_A602_4462_BBB1_8286F0724054#152963, COL_COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#152964, COL_COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#152965, COL_COL_1FF33786_C88A_4789_B428_364FF98B1905#152966, COL_COL_35375170_B542_49DE_AFA2_0A2D31967891#152967L, COL_COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#152968, COL_COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#152969, COL_COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#152970, COL_COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#152971, COL_COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#152972, COL_COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#152973, COL_COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#152974, COL_COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#152975, COL_COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#152976, COL_COL_5CDC74F0_3D28_463C_9042_237BDAB52540#152977, COL_COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#152978, COL_COL_8068E186_2734_4730_8D2C_A788B2226179#152979, COL_COL_DA667933_29E5_49E1_8724_A537DCE9735F#152980, COL_COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#152981, COL_COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#152982, COL_COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#152983]
Arguments: 1500

SQL / DataFrame Properties

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