SP1 - Details for Query 475

Submitted Time: 2026/06/25 16:31:55
Duration: 0.3 s
Succeeded Jobs: 655

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

CollectLimit 1500

Project [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#207949 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#208116, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#207950 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#208117, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#207951 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#208118, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#207952 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#208119, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#207953 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#208120, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#207954 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#208121, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#207955 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#208122, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#207956 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#208123, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#207957 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#208124, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#207958 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#208125, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#207959 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#208126, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#207960 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#208127, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#207961 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#208128, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#207962 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#208129, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#207963 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#208130, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#207964 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#208131, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#207965 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#208132, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#207966 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#208133, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#207967 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#208134, COL_D6895B92_8213_46E8_95DE_5711D209346E#207968 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#208135, COL_A06CD743_975B_480F_890C_78685E530CD1#207969 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#208136, COL_814180A7_65B9_4C68_A945_79F72A870824#207970 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#208137, COL_6126101C_76C5_4C25_A5F2_987862B98C80#207971 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#208138, COL_32583C88_3290_4A7F_A097_95297001B6D6#207972 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#208139, ... 3 more fields]

Filter ((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4EBCB649_BD59_44D4_93D8_0190857315F0#207949)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_4EBCB649_BD59_44D4_93D8_0190857315F0#207949)), MAISOSNS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#207950)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#207950)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#207951)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#207951)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5650E892_33D9_479C_80EA_2B2525AC4A45#207952)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_5650E892_33D9_479C_80EA_2B2525AC4A45#207952)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#207953)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#207953)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#207954)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#207954)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#207955)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#207955)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#207956)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#207956)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#207957)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#207957)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#207958)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#207958)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F187B9B8_0063_41CE_9385_F751840CD2EB#207959)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_F187B9B8_0063_41CE_9385_F751840CD2EB#207959)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#207960)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#207960)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#207961)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#207961)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B697D958_0150_4D9A_9824_47CA5DE6D555#207962)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B697D958_0150_4D9A_9824_47CA5DE6D555#207962)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#207963)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#207963)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#207964)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#207964)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2292659F_7091_49C8_ABBD_97FCDEADA803#207965)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_2292659F_7091_49C8_ABBD_97FCDEADA803#207965)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#207966)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#207966)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#207967)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#207967)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D6895B92_8213_46E8_95DE_5711D209346E#207968)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D6895B92_8213_46E8_95DE_5711D209346E#207968)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A06CD743_975B_480F_890C_78685E530CD1#207969)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A06CD743_975B_480F_890C_78685E530CD1#207969)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_814180A7_65B9_4C68_A945_79F72A870824#207970)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_814180A7_65B9_4C68_A945_79F72A870824#207970)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6126101C_76C5_4C25_A5F2_987862B98C80#207971)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_6126101C_76C5_4C25_A5F2_987862B98C80#207971)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_32583C88_3290_4A7F_A097_95297001B6D6#207972)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_32583C88_3290_4A7F_A097_95297001B6D6#207972)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#207973)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#207973)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#207974)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#207974)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EB3E9294_C63E_4108_AB19_81F98873297C#207975)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EB3E9294_C63E_4108_AB19_81F98873297C#207975)), MAISOSNS) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#207949,COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#207950,COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#207951,COL_5650E892_33D9_479C_80EA_2B2525AC4A45#207952,COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#207953,COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#207954,COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#207955,COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#207956,COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#207957,COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#207958,COL_F187B9B8_0063_41CE_9385_F751840CD2EB#207959,COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#207960,COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#207961,COL_B697D958_0150_4D9A_9824_47CA5DE6D555#207962,COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#207963,COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#207964,COL_2292659F_7091_49C8_ABBD_97FCDEADA803#207965,COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#207966,COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#207967,COL_D6895B92_8213_46E8_95DE_5711D209346E#207968,COL_A06CD743_975B_480F_890C_78685E530CD1#207969,COL_814180A7_65B9_4C68_A945_79F72A870824#207970,COL_6126101C_76C5_4C25_A5F2_987862B98C80#207971,COL_32583C88_3290_4A7F_A097_95297001B6D6#207972,... 3 more fields] Batched: true, DataFilters: [((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4EBCB649_BD59_44..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/PATRIMOINE_NT_405178], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_4EBCB649_BD59_44D4_93D8_0190857315F0:string,COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D:s...

Details

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


(1) Scan parquet 
Output [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#207949, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#207950, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#207951, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#207952, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#207953, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#207954, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#207955, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#207956, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#207957, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#207958, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#207959, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#207960, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#207961, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#207962, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#207963, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#207964, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#207965, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#207966, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#207967, COL_D6895B92_8213_46E8_95DE_5711D209346E#207968, COL_A06CD743_975B_480F_890C_78685E530CD1#207969, COL_814180A7_65B9_4C68_A945_79F72A870824#207970, COL_6126101C_76C5_4C25_A5F2_987862B98C80#207971, COL_32583C88_3290_4A7F_A097_95297001B6D6#207972, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#207973, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#207974, COL_EB3E9294_C63E_4108_AB19_81F98873297C#207975]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/PATRIMOINE_NT_405178]
ReadSchema: struct<COL_4EBCB649_BD59_44D4_93D8_0190857315F0:string,COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D:string,COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982:string,COL_5650E892_33D9_479C_80EA_2B2525AC4A45:string,COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E:string,COL_A43814C6_7077_46AF_835B_D0B18EDC70A4:string,COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8:string,COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01:string,COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7:string,COL_89DC6301_086A_4E9C_8672_8F2751FE3B89:string,COL_F187B9B8_0063_41CE_9385_F751840CD2EB:string,COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D:string,COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE:string,COL_B697D958_0150_4D9A_9824_47CA5DE6D555:string,COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3:string,COL_437E7927_9755_4EE7_B335_1FE4CA5F9327:string,COL_2292659F_7091_49C8_ABBD_97FCDEADA803:string,COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A:string,COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6:string,COL_D6895B92_8213_46E8_95DE_5711D209346E:string,COL_A06CD743_975B_480F_890C_78685E530CD1:string,COL_814180A7_65B9_4C68_A945_79F72A870824:string,COL_6126101C_76C5_4C25_A5F2_987862B98C80:string,COL_32583C88_3290_4A7F_A097_95297001B6D6:string,COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86:string,COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B:string,COL_EB3E9294_C63E_4108_AB19_81F98873297C:string>

(2) ColumnarToRow [codegen id : 1]
Input [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#207949, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#207950, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#207951, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#207952, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#207953, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#207954, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#207955, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#207956, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#207957, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#207958, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#207959, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#207960, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#207961, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#207962, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#207963, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#207964, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#207965, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#207966, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#207967, COL_D6895B92_8213_46E8_95DE_5711D209346E#207968, COL_A06CD743_975B_480F_890C_78685E530CD1#207969, COL_814180A7_65B9_4C68_A945_79F72A870824#207970, COL_6126101C_76C5_4C25_A5F2_987862B98C80#207971, COL_32583C88_3290_4A7F_A097_95297001B6D6#207972, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#207973, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#207974, COL_EB3E9294_C63E_4108_AB19_81F98873297C#207975]

(3) Filter [codegen id : 1]
Input [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#207949, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#207950, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#207951, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#207952, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#207953, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#207954, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#207955, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#207956, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#207957, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#207958, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#207959, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#207960, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#207961, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#207962, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#207963, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#207964, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#207965, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#207966, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#207967, COL_D6895B92_8213_46E8_95DE_5711D209346E#207968, COL_A06CD743_975B_480F_890C_78685E530CD1#207969, COL_814180A7_65B9_4C68_A945_79F72A870824#207970, COL_6126101C_76C5_4C25_A5F2_987862B98C80#207971, COL_32583C88_3290_4A7F_A097_95297001B6D6#207972, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#207973, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#207974, COL_EB3E9294_C63E_4108_AB19_81F98873297C#207975]
Condition : ((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4EBCB649_BD59_44D4_93D8_0190857315F0#207949)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_4EBCB649_BD59_44D4_93D8_0190857315F0#207949)), MAISOSNS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#207950)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#207950)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#207951)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#207951)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5650E892_33D9_479C_80EA_2B2525AC4A45#207952)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_5650E892_33D9_479C_80EA_2B2525AC4A45#207952)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#207953)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#207953)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#207954)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#207954)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#207955)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#207955)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#207956)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#207956)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#207957)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#207957)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#207958)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#207958)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F187B9B8_0063_41CE_9385_F751840CD2EB#207959)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_F187B9B8_0063_41CE_9385_F751840CD2EB#207959)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#207960)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#207960)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#207961)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#207961)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B697D958_0150_4D9A_9824_47CA5DE6D555#207962)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B697D958_0150_4D9A_9824_47CA5DE6D555#207962)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#207963)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#207963)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#207964)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#207964)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2292659F_7091_49C8_ABBD_97FCDEADA803#207965)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_2292659F_7091_49C8_ABBD_97FCDEADA803#207965)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#207966)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#207966)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#207967)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#207967)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D6895B92_8213_46E8_95DE_5711D209346E#207968)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D6895B92_8213_46E8_95DE_5711D209346E#207968)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A06CD743_975B_480F_890C_78685E530CD1#207969)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A06CD743_975B_480F_890C_78685E530CD1#207969)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_814180A7_65B9_4C68_A945_79F72A870824#207970)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_814180A7_65B9_4C68_A945_79F72A870824#207970)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6126101C_76C5_4C25_A5F2_987862B98C80#207971)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_6126101C_76C5_4C25_A5F2_987862B98C80#207971)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_32583C88_3290_4A7F_A097_95297001B6D6#207972)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_32583C88_3290_4A7F_A097_95297001B6D6#207972)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#207973)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#207973)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#207974)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#207974)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EB3E9294_C63E_4108_AB19_81F98873297C#207975)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EB3E9294_C63E_4108_AB19_81F98873297C#207975)), MAISOSNS) END)

(4) Project [codegen id : 1]
Output [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#207949 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#208116, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#207950 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#208117, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#207951 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#208118, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#207952 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#208119, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#207953 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#208120, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#207954 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#208121, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#207955 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#208122, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#207956 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#208123, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#207957 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#208124, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#207958 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#208125, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#207959 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#208126, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#207960 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#208127, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#207961 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#208128, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#207962 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#208129, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#207963 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#208130, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#207964 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#208131, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#207965 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#208132, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#207966 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#208133, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#207967 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#208134, COL_D6895B92_8213_46E8_95DE_5711D209346E#207968 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#208135, COL_A06CD743_975B_480F_890C_78685E530CD1#207969 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#208136, COL_814180A7_65B9_4C68_A945_79F72A870824#207970 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#208137, COL_6126101C_76C5_4C25_A5F2_987862B98C80#207971 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#208138, COL_32583C88_3290_4A7F_A097_95297001B6D6#207972 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#208139, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#207973 AS COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#208140, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#207974 AS COL_730C7D9D_95B5_4388_983E_C4F260C553BD#208141, COL_EB3E9294_C63E_4108_AB19_81F98873297C#207975 AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#208142]
Input [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#207949, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#207950, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#207951, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#207952, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#207953, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#207954, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#207955, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#207956, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#207957, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#207958, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#207959, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#207960, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#207961, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#207962, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#207963, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#207964, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#207965, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#207966, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#207967, COL_D6895B92_8213_46E8_95DE_5711D209346E#207968, COL_A06CD743_975B_480F_890C_78685E530CD1#207969, COL_814180A7_65B9_4C68_A945_79F72A870824#207970, COL_6126101C_76C5_4C25_A5F2_987862B98C80#207971, COL_32583C88_3290_4A7F_A097_95297001B6D6#207972, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#207973, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#207974, COL_EB3E9294_C63E_4108_AB19_81F98873297C#207975]

(5) CollectLimit
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#208116, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#208117, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#208118, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#208119, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#208120, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#208121, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#208122, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#208123, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#208124, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#208125, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#208126, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#208127, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#208128, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#208129, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#208130, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#208131, COL_0DB61D05_5348_40DB_8F16_C7916849A669#208132, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#208133, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#208134, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#208135, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#208136, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#208137, COL_33CEA792_75B9_44A1_896B_B422BD28B923#208138, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#208139, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#208140, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#208141, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#208142]
Arguments: 1500

SQL / DataFrame Properties

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