SP1 - Details for Query 17584

Submitted Time: 2026/06/10 16:01:02
Duration: 1.9 min
Succeeded Jobs: 23921 23922 23924

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: total (min, med, max (stageId: taskId))\n1.9 m (2 ms, 5 ms, 1.3 m (stage 45079.0: task 64469))"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 85"]; 4 [labelType="html" label="ColumnarToRow number of output rows: 2,996,010 number of input batches: 732"]; } 5 [labelType="html" label="Scan parquet number of files read: 1 scan time total (min, med, max (stageId: taskId)) 2.3 s (2 ms, 5 ms, 1.6 s (stage 45079.0: task 64469)) metadata time: 0 ms size of files read: 192.7 MiB number of output rows: 2,996,010"]; 2->0; 3->2; 4->3; 5->4; }

CollectLimit 1500

Project [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888071 AS COL_COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888245, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888072 AS COL_COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888246, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888073 AS COL_COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888247, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888074 AS COL_COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888248, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888075 AS COL_COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888249, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888076 AS COL_COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888250, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888077 AS COL_COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888251, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888078 AS COL_COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888252, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888079 AS COL_COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888253, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888080 AS COL_COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888254, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888081 AS COL_COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888255, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888082 AS COL_COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888256, COL_553A0519_208D_498B_AEFE_829D7F40180B#3888083 AS COL_COL_553A0519_208D_498B_AEFE_829D7F40180B#3888257, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888084 AS COL_COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888258, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888085 AS COL_COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888259, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#3888086L AS COL_COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#3888260L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888087 AS COL_COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888261, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888088 AS COL_COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888262, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888089 AS COL_COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888263, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888090 AS COL_COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888264, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888091 AS COL_COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888265, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888092 AS COL_COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888266, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888093 AS COL_COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888267, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888094 AS COL_COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888268, ... 5 more fields]

Filter (((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888071)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888071)), CS F) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888072)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888072)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888073)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888073)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888074)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888074)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888076)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888076)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888077)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888077)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888078)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888078)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888079)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888079)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888080)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888080)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888081)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888081)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888082)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888082)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3888083)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3888083)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888084)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888084)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888085)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888085)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888087)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888087)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888088)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888088)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888089)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888089)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888090)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888090)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888091)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888091)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888092)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888092)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888093)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888093)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888094)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888094)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888095)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888095)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888096)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888096)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888098)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888098)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888099)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888099)), CS F) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888071,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888072,COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888073,COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888074,COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888075,COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888076,COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888077,COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888078,COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888079,COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888080,COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888081,COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888082,COL_553A0519_208D_498B_AEFE_829D7F40180B#3888083,COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888084,COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888085,COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#3888086L,COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888087,COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888088,COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888089,COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888090,COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888091,COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888092,COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888093,COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888094,... 5 more fields] Batched: true, DataFilters: [(((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_A_RSF_SOURCE_215882], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF:string,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730:s...

Details

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


(1) Scan parquet 
Output [29]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888071, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888072, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888073, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888074, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888075, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888076, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888077, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888078, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888079, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888080, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888081, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888082, COL_553A0519_208D_498B_AEFE_829D7F40180B#3888083, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888084, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888085, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#3888086L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888087, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888088, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888089, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888090, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888091, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888092, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888093, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888094, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888095, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888096, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888097L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888098, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888099]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_A_RSF_SOURCE_215882]
ReadSchema: struct<COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF:string,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730:string,COL_D16817E6_135B_4508_A082_6C19AC9542DE:string,COL_2EE853AF_4512_4E8D_ABAE_19143D81E357:string,COL_631C3DFF_F530_4B1D_BF92_7D730B52002B:int,COL_71C73F12_7D79_456A_A833_96D8469F46F2:string,COL_E9867A66_711B_4AA1_A283_E4318900C80F:string,COL_DECBC528_D590_4F99_88FD_C86D82DEF299:string,COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6:string,COL_15227A48_1CE9_407E_A0B2_D27AC3B06473:string,COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1:string,COL_6DFC44EF_67E4_461D_912F_4BA7773246D2:string,COL_553A0519_208D_498B_AEFE_829D7F40180B:string,COL_410747F2_ADCB_4C39_B9B9_C56104DAC484:string,COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5:string,COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D:bigint,COL_A655765E_D1A6_4D67_8879_F5186F86A670:string,COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A:string,COL_07AE9250_614D_4D42_854B_0EDF3D549B40:string,COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A:string,COL_06D0B7A1_9E5A_4504_BE77_E30488C56572:string,COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7:string,COL_F76740BC_E84C_42AE_9492_D66CDA0E9344:string,COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B:string,COL_BFA8E75B_6083_4911_8D50_3443279CCEC8:string,COL_86734EEA_482B_4537_86F3_6ACCB97C98E9:string,COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900:bigint,COL_119C9448_3C3F_46EA_80E7_062422A2830D:string,COL_06CB38F0_2321_426B_AA44_D37094826BC3:string>

(2) ColumnarToRow [codegen id : 1]
Input [29]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888071, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888072, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888073, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888074, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888075, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888076, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888077, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888078, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888079, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888080, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888081, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888082, COL_553A0519_208D_498B_AEFE_829D7F40180B#3888083, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888084, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888085, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#3888086L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888087, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888088, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888089, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888090, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888091, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888092, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888093, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888094, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888095, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888096, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888097L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888098, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888099]

(3) Filter [codegen id : 1]
Input [29]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888071, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888072, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888073, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888074, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888075, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888076, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888077, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888078, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888079, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888080, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888081, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888082, COL_553A0519_208D_498B_AEFE_829D7F40180B#3888083, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888084, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888085, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#3888086L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888087, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888088, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888089, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888090, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888091, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888092, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888093, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888094, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888095, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888096, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888097L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888098, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888099]
Condition : (((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888071)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888071)), CS  F) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888072)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888072)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888073)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888073)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888074)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888074)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888076)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888076)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888077)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888077)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888078)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888078)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888079)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888079)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888080)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888080)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888081)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888081)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888082)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888082)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3888083)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3888083)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888084)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888084)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888085)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888085)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888087)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888087)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888088)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888088)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888089)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888089)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888090)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888090)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888091)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888091)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888092)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888092)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888093)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888093)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888094)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888094)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888095)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888095)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888096)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888096)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888098)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888098)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888099)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888099)), CS  F) END)

(4) Project [codegen id : 1]
Output [29]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888071 AS COL_COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888245, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888072 AS COL_COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888246, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888073 AS COL_COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888247, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888074 AS COL_COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888248, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888075 AS COL_COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888249, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888076 AS COL_COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888250, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888077 AS COL_COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888251, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888078 AS COL_COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888252, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888079 AS COL_COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888253, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888080 AS COL_COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888254, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888081 AS COL_COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888255, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888082 AS COL_COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888256, COL_553A0519_208D_498B_AEFE_829D7F40180B#3888083 AS COL_COL_553A0519_208D_498B_AEFE_829D7F40180B#3888257, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888084 AS COL_COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888258, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888085 AS COL_COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888259, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#3888086L AS COL_COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#3888260L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888087 AS COL_COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888261, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888088 AS COL_COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888262, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888089 AS COL_COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888263, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888090 AS COL_COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888264, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888091 AS COL_COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888265, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888092 AS COL_COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888266, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888093 AS COL_COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888267, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888094 AS COL_COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888268, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888095 AS COL_COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888269, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888096 AS COL_COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888270, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888097L AS COL_COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888271L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888098 AS COL_COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888272, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888099 AS COL_COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888273]
Input [29]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888071, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888072, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888073, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888074, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888075, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888076, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888077, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888078, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888079, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888080, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888081, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888082, COL_553A0519_208D_498B_AEFE_829D7F40180B#3888083, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888084, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888085, COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#3888086L, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888087, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888088, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888089, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888090, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888091, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888092, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888093, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888094, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888095, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888096, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888097L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888098, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888099]

(5) CollectLimit
Input [29]: [COL_COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888245, COL_COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888246, COL_COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888247, COL_COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888248, COL_COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888249, COL_COL_71C73F12_7D79_456A_A833_96D8469F46F2#3888250, COL_COL_E9867A66_711B_4AA1_A283_E4318900C80F#3888251, COL_COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3888252, COL_COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3888253, COL_COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3888254, COL_COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3888255, COL_COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3888256, COL_COL_553A0519_208D_498B_AEFE_829D7F40180B#3888257, COL_COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888258, COL_COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888259, COL_COL_E8205BF0_BAD2_4E91_95DE_2D0BB7771C6D#3888260L, COL_COL_A655765E_D1A6_4D67_8879_F5186F86A670#3888261, COL_COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888262, COL_COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888263, COL_COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888264, COL_COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888265, COL_COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888266, COL_COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888267, COL_COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888268, COL_COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888269, COL_COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888270, COL_COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888271L, COL_COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888272, COL_COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888273]
Arguments: 1500

SQL / DataFrame Properties

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