SP1 - Details for Query 489

Submitted Time: 2026/06/25 16:33:39
Duration: 0.3 s
Succeeded Jobs: 672

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: 79 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#214898 AS COL_COL_4EBCB649_BD59_44D4_93D8_0190857315F0#215066, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#214899 AS COL_COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#215067, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#214900 AS COL_COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#215068, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#214901 AS COL_COL_5650E892_33D9_479C_80EA_2B2525AC4A45#215069, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#214902 AS COL_COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#215070, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#214903 AS COL_COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#215071, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#214904 AS COL_COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#215072, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#214905 AS COL_COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#215073, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#214906 AS COL_COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#215074, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#214907 AS COL_COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#215075, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#214908 AS COL_COL_F187B9B8_0063_41CE_9385_F751840CD2EB#215076, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#214909 AS COL_COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#215077, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#214910 AS COL_COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#215078, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#214911 AS COL_COL_B697D958_0150_4D9A_9824_47CA5DE6D555#215079, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#214912 AS COL_COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#215080, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#214913 AS COL_COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#215081, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#214914 AS COL_COL_2292659F_7091_49C8_ABBD_97FCDEADA803#215082, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#214915 AS COL_COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#215083, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#214916 AS COL_COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#215084, COL_D6895B92_8213_46E8_95DE_5711D209346E#214917 AS COL_COL_D6895B92_8213_46E8_95DE_5711D209346E#215085, COL_A06CD743_975B_480F_890C_78685E530CD1#214918 AS COL_COL_A06CD743_975B_480F_890C_78685E530CD1#215086, COL_814180A7_65B9_4C68_A945_79F72A870824#214919 AS COL_COL_814180A7_65B9_4C68_A945_79F72A870824#215087, COL_6126101C_76C5_4C25_A5F2_987862B98C80#214920 AS COL_COL_6126101C_76C5_4C25_A5F2_987862B98C80#215088, COL_32583C88_3290_4A7F_A097_95297001B6D6#214921 AS COL_COL_32583C88_3290_4A7F_A097_95297001B6D6#215089, ... 4 more fields]

Filter (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4EBCB649_BD59_44D4_93D8_0190857315F0#214898)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_4EBCB649_BD59_44D4_93D8_0190857315F0#214898)), MAISOSNS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#214899)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#214899)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#214900)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#214900)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5650E892_33D9_479C_80EA_2B2525AC4A45#214901)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_5650E892_33D9_479C_80EA_2B2525AC4A45#214901)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#214902)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#214902)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#214903)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#214903)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#214904)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#214904)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#214905)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#214905)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#214906)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#214906)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#214907)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#214907)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F187B9B8_0063_41CE_9385_F751840CD2EB#214908)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_F187B9B8_0063_41CE_9385_F751840CD2EB#214908)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#214909)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#214909)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#214910)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#214910)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B697D958_0150_4D9A_9824_47CA5DE6D555#214911)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B697D958_0150_4D9A_9824_47CA5DE6D555#214911)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#214912)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#214912)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#214913)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#214913)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2292659F_7091_49C8_ABBD_97FCDEADA803#214914)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_2292659F_7091_49C8_ABBD_97FCDEADA803#214914)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#214915)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#214915)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#214916)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#214916)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D6895B92_8213_46E8_95DE_5711D209346E#214917)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D6895B92_8213_46E8_95DE_5711D209346E#214917)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A06CD743_975B_480F_890C_78685E530CD1#214918)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A06CD743_975B_480F_890C_78685E530CD1#214918)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_814180A7_65B9_4C68_A945_79F72A870824#214919)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_814180A7_65B9_4C68_A945_79F72A870824#214919)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6126101C_76C5_4C25_A5F2_987862B98C80#214920)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_6126101C_76C5_4C25_A5F2_987862B98C80#214920)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_32583C88_3290_4A7F_A097_95297001B6D6#214921)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_32583C88_3290_4A7F_A097_95297001B6D6#214921)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#214922)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#214922)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#214923)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#214923)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EB3E9294_C63E_4108_AB19_81F98873297C#214924)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EB3E9294_C63E_4108_AB19_81F98873297C#214924)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#214925)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#214925)), MAISOSNS) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#214898,COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#214899,COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#214900,COL_5650E892_33D9_479C_80EA_2B2525AC4A45#214901,COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#214902,COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#214903,COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#214904,COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#214905,COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#214906,COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#214907,COL_F187B9B8_0063_41CE_9385_F751840CD2EB#214908,COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#214909,COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#214910,COL_B697D958_0150_4D9A_9824_47CA5DE6D555#214911,COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#214912,COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#214913,COL_2292659F_7091_49C8_ABBD_97FCDEADA803#214914,COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#214915,COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#214916,COL_D6895B92_8213_46E8_95DE_5711D209346E#214917,COL_A06CD743_975B_480F_890C_78685E530CD1#214918,COL_814180A7_65B9_4C68_A945_79F72A870824#214919,COL_6126101C_76C5_4C25_A5F2_987862B98C80#214920,COL_32583C88_3290_4A7F_A097_95297001B6D6#214921,... 4 more fields] Batched: true, DataFilters: [(((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4EBCB649_BD59_4..., 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 [28]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#214898, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#214899, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#214900, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#214901, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#214902, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#214903, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#214904, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#214905, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#214906, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#214907, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#214908, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#214909, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#214910, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#214911, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#214912, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#214913, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#214914, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#214915, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#214916, COL_D6895B92_8213_46E8_95DE_5711D209346E#214917, COL_A06CD743_975B_480F_890C_78685E530CD1#214918, COL_814180A7_65B9_4C68_A945_79F72A870824#214919, COL_6126101C_76C5_4C25_A5F2_987862B98C80#214920, COL_32583C88_3290_4A7F_A097_95297001B6D6#214921, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#214922, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#214923, COL_EB3E9294_C63E_4108_AB19_81F98873297C#214924, COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#214925]
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,COL_91CCDC8B_39E5_4964_B896_E001F6DD512A:string>

(2) ColumnarToRow [codegen id : 1]
Input [28]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#214898, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#214899, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#214900, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#214901, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#214902, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#214903, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#214904, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#214905, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#214906, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#214907, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#214908, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#214909, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#214910, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#214911, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#214912, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#214913, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#214914, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#214915, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#214916, COL_D6895B92_8213_46E8_95DE_5711D209346E#214917, COL_A06CD743_975B_480F_890C_78685E530CD1#214918, COL_814180A7_65B9_4C68_A945_79F72A870824#214919, COL_6126101C_76C5_4C25_A5F2_987862B98C80#214920, COL_32583C88_3290_4A7F_A097_95297001B6D6#214921, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#214922, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#214923, COL_EB3E9294_C63E_4108_AB19_81F98873297C#214924, COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#214925]

(3) Filter [codegen id : 1]
Input [28]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#214898, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#214899, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#214900, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#214901, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#214902, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#214903, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#214904, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#214905, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#214906, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#214907, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#214908, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#214909, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#214910, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#214911, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#214912, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#214913, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#214914, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#214915, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#214916, COL_D6895B92_8213_46E8_95DE_5711D209346E#214917, COL_A06CD743_975B_480F_890C_78685E530CD1#214918, COL_814180A7_65B9_4C68_A945_79F72A870824#214919, COL_6126101C_76C5_4C25_A5F2_987862B98C80#214920, COL_32583C88_3290_4A7F_A097_95297001B6D6#214921, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#214922, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#214923, COL_EB3E9294_C63E_4108_AB19_81F98873297C#214924, COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#214925]
Condition : (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4EBCB649_BD59_44D4_93D8_0190857315F0#214898)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_4EBCB649_BD59_44D4_93D8_0190857315F0#214898)), MAISOSNS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#214899)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#214899)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#214900)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#214900)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5650E892_33D9_479C_80EA_2B2525AC4A45#214901)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_5650E892_33D9_479C_80EA_2B2525AC4A45#214901)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#214902)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#214902)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#214903)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#214903)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#214904)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#214904)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#214905)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#214905)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#214906)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#214906)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#214907)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#214907)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F187B9B8_0063_41CE_9385_F751840CD2EB#214908)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_F187B9B8_0063_41CE_9385_F751840CD2EB#214908)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#214909)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#214909)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#214910)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#214910)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B697D958_0150_4D9A_9824_47CA5DE6D555#214911)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B697D958_0150_4D9A_9824_47CA5DE6D555#214911)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#214912)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#214912)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#214913)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#214913)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2292659F_7091_49C8_ABBD_97FCDEADA803#214914)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_2292659F_7091_49C8_ABBD_97FCDEADA803#214914)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#214915)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#214915)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#214916)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#214916)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D6895B92_8213_46E8_95DE_5711D209346E#214917)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D6895B92_8213_46E8_95DE_5711D209346E#214917)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A06CD743_975B_480F_890C_78685E530CD1#214918)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A06CD743_975B_480F_890C_78685E530CD1#214918)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_814180A7_65B9_4C68_A945_79F72A870824#214919)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_814180A7_65B9_4C68_A945_79F72A870824#214919)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6126101C_76C5_4C25_A5F2_987862B98C80#214920)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_6126101C_76C5_4C25_A5F2_987862B98C80#214920)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_32583C88_3290_4A7F_A097_95297001B6D6#214921)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_32583C88_3290_4A7F_A097_95297001B6D6#214921)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#214922)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#214922)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#214923)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#214923)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EB3E9294_C63E_4108_AB19_81F98873297C#214924)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EB3E9294_C63E_4108_AB19_81F98873297C#214924)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#214925)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#214925)), MAISOSNS) END)

(4) Project [codegen id : 1]
Output [28]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#214898 AS COL_COL_4EBCB649_BD59_44D4_93D8_0190857315F0#215066, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#214899 AS COL_COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#215067, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#214900 AS COL_COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#215068, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#214901 AS COL_COL_5650E892_33D9_479C_80EA_2B2525AC4A45#215069, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#214902 AS COL_COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#215070, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#214903 AS COL_COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#215071, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#214904 AS COL_COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#215072, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#214905 AS COL_COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#215073, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#214906 AS COL_COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#215074, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#214907 AS COL_COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#215075, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#214908 AS COL_COL_F187B9B8_0063_41CE_9385_F751840CD2EB#215076, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#214909 AS COL_COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#215077, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#214910 AS COL_COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#215078, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#214911 AS COL_COL_B697D958_0150_4D9A_9824_47CA5DE6D555#215079, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#214912 AS COL_COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#215080, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#214913 AS COL_COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#215081, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#214914 AS COL_COL_2292659F_7091_49C8_ABBD_97FCDEADA803#215082, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#214915 AS COL_COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#215083, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#214916 AS COL_COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#215084, COL_D6895B92_8213_46E8_95DE_5711D209346E#214917 AS COL_COL_D6895B92_8213_46E8_95DE_5711D209346E#215085, COL_A06CD743_975B_480F_890C_78685E530CD1#214918 AS COL_COL_A06CD743_975B_480F_890C_78685E530CD1#215086, COL_814180A7_65B9_4C68_A945_79F72A870824#214919 AS COL_COL_814180A7_65B9_4C68_A945_79F72A870824#215087, COL_6126101C_76C5_4C25_A5F2_987862B98C80#214920 AS COL_COL_6126101C_76C5_4C25_A5F2_987862B98C80#215088, COL_32583C88_3290_4A7F_A097_95297001B6D6#214921 AS COL_COL_32583C88_3290_4A7F_A097_95297001B6D6#215089, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#214922 AS COL_COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#215090, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#214923 AS COL_COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#215091, COL_EB3E9294_C63E_4108_AB19_81F98873297C#214924 AS COL_COL_EB3E9294_C63E_4108_AB19_81F98873297C#215092, COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#214925 AS COL_COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#215093]
Input [28]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#214898, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#214899, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#214900, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#214901, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#214902, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#214903, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#214904, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#214905, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#214906, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#214907, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#214908, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#214909, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#214910, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#214911, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#214912, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#214913, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#214914, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#214915, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#214916, COL_D6895B92_8213_46E8_95DE_5711D209346E#214917, COL_A06CD743_975B_480F_890C_78685E530CD1#214918, COL_814180A7_65B9_4C68_A945_79F72A870824#214919, COL_6126101C_76C5_4C25_A5F2_987862B98C80#214920, COL_32583C88_3290_4A7F_A097_95297001B6D6#214921, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#214922, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#214923, COL_EB3E9294_C63E_4108_AB19_81F98873297C#214924, COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#214925]

(5) CollectLimit
Input [28]: [COL_COL_4EBCB649_BD59_44D4_93D8_0190857315F0#215066, COL_COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#215067, COL_COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#215068, COL_COL_5650E892_33D9_479C_80EA_2B2525AC4A45#215069, COL_COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#215070, COL_COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#215071, COL_COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#215072, COL_COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#215073, COL_COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#215074, COL_COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#215075, COL_COL_F187B9B8_0063_41CE_9385_F751840CD2EB#215076, COL_COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#215077, COL_COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#215078, COL_COL_B697D958_0150_4D9A_9824_47CA5DE6D555#215079, COL_COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#215080, COL_COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#215081, COL_COL_2292659F_7091_49C8_ABBD_97FCDEADA803#215082, COL_COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#215083, COL_COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#215084, COL_COL_D6895B92_8213_46E8_95DE_5711D209346E#215085, COL_COL_A06CD743_975B_480F_890C_78685E530CD1#215086, COL_COL_814180A7_65B9_4C68_A945_79F72A870824#215087, COL_COL_6126101C_76C5_4C25_A5F2_987862B98C80#215088, COL_COL_32583C88_3290_4A7F_A097_95297001B6D6#215089, COL_COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#215090, COL_COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#215091, COL_COL_EB3E9294_C63E_4108_AB19_81F98873297C#215092, COL_COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#215093]
Arguments: 1500

SQL / DataFrame Properties

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