SP1 - Details for Query 227

Submitted Time: 2026/06/25 15:47:49
Duration: 0.5 s
Succeeded Jobs: 291

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: 108 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 554"]; 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: 9 ms metadata time: 0 ms size of files read: 276.8 KiB number of output rows: 1,455"]; 2->0; 3->2; 4->3; 5->4; }

CollectLimit 1500

Project [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#73194 AS COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#73458, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#73195 AS COL_956F91E2_2027_457F_A229_B9CF20D9FF63#73459, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#73196 AS COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#73460, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#73197 AS COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#73461, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#73198 AS COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#73462, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#73199 AS COL_FB65F162_1AB6_4971_99DA_F8A943944A66#73463, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#73200 AS COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#73464, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#73201 AS COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#73465, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#73202 AS COL_573E3A58_7401_4F3F_9EFA_058729D28B72#73466, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#73203 AS COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#73467, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#73204 AS COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#73468, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#73205 AS COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#73469, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#73206 AS COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#73470, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#73207 AS COL_C42F735E_237B_4569_996D_76FF5A4A65DF#73471, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#73208 AS COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#73472, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#73209 AS COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#73473, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#73210 AS COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#73474, COL_0DB61D05_5348_40DB_8F16_C7916849A669#73211 AS COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#73475, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#73212 AS COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#73476, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#73213 AS COL_98B2878A_418E_4331_B333_2493994BB807#73477, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#73214 AS COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#73478, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#73215 AS COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#73479, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#73216 AS COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#73480, COL_33CEA792_75B9_44A1_896B_B422BD28B923#73217 AS COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#73481, ... 20 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#73194)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#73194)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#73195)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#73195)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#73196)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#73196)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#73197)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#73197)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#73198)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#73198)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#73199)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#73199)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#73200)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#73200)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#73201)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#73201)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#73202)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#73202)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#73203)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#73203)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#73204)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#73204)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#73205)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#73205)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#73206)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#73206)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#73207)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#73207)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#73208)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#73208)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#73209)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#73209)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#73210)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#73210)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#73211)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#73211)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#73212)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#73212)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#73213)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#73213)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#73214)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#73214)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#73215)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#73215)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#73216)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#73216)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#73217)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#73217)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#73218)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#73218)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#73219)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#73219)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#73220)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#73220)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#73221)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#73221)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#73222)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#73222)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#73223)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#73223)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#73224)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#73224)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#73225)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#73225)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#73226)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#73226)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#73227)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#73227)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#73228)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#73228)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#73229)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#73229)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#73230)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#73230)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#73231)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#73231)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#73232)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#73232)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#73233)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#73233)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#73234)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#73234)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#73235)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#73235)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#73236)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#73236)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#73237)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#73237)), MAISON) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#73194,COL_EC7474ED_A0A6_401C_BA97_20D63A467807#73195,COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#73196,COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#73197,COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#73198,COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#73199,COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#73200,COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#73201,COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#73202,COL_D4E1F01A_72C8_4621_905A_881FB0249F81#73203,COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#73204,COL_871E0000_AA32_4679_83B0_C8AA49007BCF#73205,COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#73206,COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#73207,COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#73208,COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#73209,COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#73210,COL_0DB61D05_5348_40DB_8F16_C7916849A669#73211,COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#73212,COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#73213,COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#73214,COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#73215,COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#73216,COL_33CEA792_75B9_44A1_896B_B422BD28B923#73217,... 20 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_405206], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_BA552F89_FE8A_4EC3_A09E_640A661C9019:string,COL_EC7474ED_A0A6_401C_BA97_20D63A467807:s...

Details

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


(1) Scan parquet 
Output [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#73194, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#73195, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#73196, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#73197, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#73198, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#73199, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#73200, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#73201, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#73202, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#73203, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#73204, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#73205, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#73206, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#73207, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#73208, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#73209, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#73210, COL_0DB61D05_5348_40DB_8F16_C7916849A669#73211, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#73212, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#73213, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#73214, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#73215, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#73216, COL_33CEA792_75B9_44A1_896B_B422BD28B923#73217, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#73218, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#73219, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#73220, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#73221, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#73222, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#73223, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#73224, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#73225, COL_924860D6_14C4_4F33_B84C_E428E89E2817#73226, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#73227, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#73228, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#73229, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#73230, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#73231, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#73232, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#73233, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#73234, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#73235, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#73236, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#73237]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405206]
ReadSchema: struct<COL_BA552F89_FE8A_4EC3_A09E_640A661C9019:string,COL_EC7474ED_A0A6_401C_BA97_20D63A467807:string,COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB:string,COL_8467C1BB_F0A2_44E6_88D6_8477052876CA:string,COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929:string,COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B:string,COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E:string,COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93:string,COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355:string,COL_D4E1F01A_72C8_4621_905A_881FB0249F81:string,COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED:string,COL_871E0000_AA32_4679_83B0_C8AA49007BCF:string,COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8:string,COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C:string,COL_9263F342_2220_4C7C_BA3D_B7B7386988B7:string,COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB:string,COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC:string,COL_0DB61D05_5348_40DB_8F16_C7916849A669:string,COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96:string,COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C:string,COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38:string,COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB:string,COL_BBEA900F_6FE8_40DA_B278_36CA822C312A:string,COL_33CEA792_75B9_44A1_896B_B422BD28B923:string,COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48:string,COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25:string,COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5:string,COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267:string,COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27:string,COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2:string,COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23:string,COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC:string,COL_924860D6_14C4_4F33_B84C_E428E89E2817:string,COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C:string,COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF:string,COL_730C7D9D_95B5_4388_983E_C4F260C553BD:string,COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D:string,COL_90791789_DD87_40BC_92F0_F5FB1BD5126F:string,COL_FB26292A_034B_4B72_8403_8A7AE83CFC56:string,COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E:string,COL_FC403537_BB94_4C83_AC18_B668C51A4E0A:string,COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142:string,COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4:string,COL_0798550D_6632_4F18_8CE3_72BAF75D68CC:string>

(2) ColumnarToRow [codegen id : 1]
Input [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#73194, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#73195, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#73196, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#73197, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#73198, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#73199, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#73200, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#73201, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#73202, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#73203, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#73204, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#73205, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#73206, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#73207, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#73208, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#73209, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#73210, COL_0DB61D05_5348_40DB_8F16_C7916849A669#73211, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#73212, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#73213, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#73214, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#73215, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#73216, COL_33CEA792_75B9_44A1_896B_B422BD28B923#73217, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#73218, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#73219, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#73220, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#73221, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#73222, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#73223, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#73224, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#73225, COL_924860D6_14C4_4F33_B84C_E428E89E2817#73226, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#73227, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#73228, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#73229, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#73230, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#73231, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#73232, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#73233, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#73234, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#73235, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#73236, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#73237]

(3) Filter [codegen id : 1]
Input [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#73194, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#73195, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#73196, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#73197, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#73198, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#73199, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#73200, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#73201, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#73202, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#73203, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#73204, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#73205, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#73206, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#73207, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#73208, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#73209, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#73210, COL_0DB61D05_5348_40DB_8F16_C7916849A669#73211, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#73212, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#73213, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#73214, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#73215, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#73216, COL_33CEA792_75B9_44A1_896B_B422BD28B923#73217, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#73218, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#73219, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#73220, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#73221, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#73222, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#73223, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#73224, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#73225, COL_924860D6_14C4_4F33_B84C_E428E89E2817#73226, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#73227, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#73228, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#73229, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#73230, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#73231, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#73232, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#73233, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#73234, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#73235, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#73236, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#73237]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#73194)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#73194)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#73195)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#73195)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#73196)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#73196)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#73197)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#73197)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#73198)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#73198)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#73199)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#73199)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#73200)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#73200)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#73201)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#73201)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#73202)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#73202)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#73203)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#73203)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#73204)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#73204)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#73205)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#73205)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#73206)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#73206)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#73207)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#73207)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#73208)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#73208)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#73209)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#73209)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#73210)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#73210)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#73211)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#73211)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#73212)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#73212)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#73213)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#73213)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#73214)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#73214)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#73215)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#73215)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#73216)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#73216)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#73217)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#73217)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#73218)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#73218)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#73219)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#73219)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#73220)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#73220)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#73221)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#73221)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#73222)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#73222)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#73223)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#73223)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#73224)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#73224)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#73225)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#73225)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#73226)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#73226)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#73227)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#73227)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#73228)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#73228)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#73229)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#73229)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#73230)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#73230)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#73231)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#73231)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#73232)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#73232)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#73233)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#73233)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#73234)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#73234)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#73235)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#73235)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#73236)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#73236)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#73237)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#73237)), MAISON) END)

(4) Project [codegen id : 1]
Output [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#73194 AS COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#73458, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#73195 AS COL_956F91E2_2027_457F_A229_B9CF20D9FF63#73459, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#73196 AS COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#73460, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#73197 AS COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#73461, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#73198 AS COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#73462, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#73199 AS COL_FB65F162_1AB6_4971_99DA_F8A943944A66#73463, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#73200 AS COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#73464, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#73201 AS COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#73465, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#73202 AS COL_573E3A58_7401_4F3F_9EFA_058729D28B72#73466, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#73203 AS COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#73467, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#73204 AS COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#73468, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#73205 AS COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#73469, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#73206 AS COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#73470, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#73207 AS COL_C42F735E_237B_4569_996D_76FF5A4A65DF#73471, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#73208 AS COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#73472, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#73209 AS COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#73473, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#73210 AS COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#73474, COL_0DB61D05_5348_40DB_8F16_C7916849A669#73211 AS COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#73475, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#73212 AS COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#73476, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#73213 AS COL_98B2878A_418E_4331_B333_2493994BB807#73477, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#73214 AS COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#73478, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#73215 AS COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#73479, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#73216 AS COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#73480, COL_33CEA792_75B9_44A1_896B_B422BD28B923#73217 AS COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#73481, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#73218 AS COL_E722B691_2CA2_4160_A578_D9CD4920A842#73482, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#73219 AS COL_D600764E_8D81_4891_BF21_ACC3F0938E57#73483, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#73220 AS COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#73484, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#73221 AS COL_D897344F_9AC3_429E_A95D_88390F445758#73485, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#73222 AS COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#73486, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#73223 AS COL_52167438_70F6_4E26_B5CD_17C5990F8948#73487, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#73224 AS COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#73488, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#73225 AS COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#73489, COL_924860D6_14C4_4F33_B84C_E428E89E2817#73226 AS COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#73490, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#73227 AS COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#73491, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#73228 AS COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#73492, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#73229 AS COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#73493, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#73230 AS COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#73494, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#73231 AS COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#73495, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#73232 AS COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#73496, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#73233 AS COL_D0A8A26A_A602_4462_BBB1_8286F0724054#73497, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#73234 AS COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#73498, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#73235 AS COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#73499, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#73236 AS COL_1FF33786_C88A_4789_B428_364FF98B1905#73500, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#73237 AS COL_5CDC74F0_3D28_463C_9042_237BDAB52540#73501]
Input [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#73194, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#73195, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#73196, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#73197, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#73198, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#73199, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#73200, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#73201, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#73202, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#73203, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#73204, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#73205, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#73206, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#73207, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#73208, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#73209, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#73210, COL_0DB61D05_5348_40DB_8F16_C7916849A669#73211, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#73212, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#73213, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#73214, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#73215, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#73216, COL_33CEA792_75B9_44A1_896B_B422BD28B923#73217, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#73218, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#73219, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#73220, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#73221, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#73222, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#73223, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#73224, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#73225, COL_924860D6_14C4_4F33_B84C_E428E89E2817#73226, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#73227, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#73228, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#73229, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#73230, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#73231, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#73232, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#73233, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#73234, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#73235, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#73236, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#73237]

(5) CollectLimit
Input [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#73458, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#73459, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#73460, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#73461, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#73462, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#73463, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#73464, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#73465, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#73466, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#73467, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#73468, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#73469, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#73470, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#73471, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#73472, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#73473, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#73474, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#73475, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#73476, COL_98B2878A_418E_4331_B333_2493994BB807#73477, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#73478, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#73479, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#73480, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#73481, COL_E722B691_2CA2_4160_A578_D9CD4920A842#73482, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#73483, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#73484, COL_D897344F_9AC3_429E_A95D_88390F445758#73485, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#73486, COL_52167438_70F6_4E26_B5CD_17C5990F8948#73487, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#73488, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#73489, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#73490, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#73491, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#73492, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#73493, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#73494, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#73495, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#73496, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#73497, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#73498, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#73499, COL_1FF33786_C88A_4789_B428_364FF98B1905#73500, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#73501]
Arguments: 1500

SQL / DataFrame Properties

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