SP1 - Details for Query 5024

Submitted Time: 2026/10/21 10:07:05
Duration: 0.4 s
Succeeded Jobs: 7686 7687 7688

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))\n418 ms (34 ms, 42 ms, 57 ms (stage 15227.0: task 19413))"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 1"]; 4 [labelType="html" label="ColumnarToRow number of output rows: 6,253 number of input batches: 10"]; } 5 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 87 ms (4 ms, 9 ms, 12 ms (stage 15227.0: task 19413)) metadata time: 0 ms size of files read: 1383.2 KiB number of output rows: 6,253"]; 2->0; 3->2; 4->3; 5->4; }

CollectLimit 1500

Project [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094142 AS COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094328, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094143 AS COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094329, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094144 AS COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094330, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094145 AS COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094331, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094146 AS COL_6D461599_696B_4415_9E1E_62284656C432#1094332, COL_351EE403_0229_4432_B273_A1F41BC78672#1094147 AS COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094333, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094148 AS COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094334, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094149 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094335, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094150 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094336, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094151 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094337, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094152 AS COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094338, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094153 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094339, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094154 AS COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094340, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094155 AS COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094341, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094156 AS COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094342, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094157 AS COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094343, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094158 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094344, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094159 AS COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094345, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1094160 AS COL_FA4C9871_A66B_4A6A_B1CA_5BD2B9E657E2#1094346, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1094161 AS COL_B567B242_E9FB_477C_9A17_BDEE4FCB4902#1094347, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094162 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094348]

Filter ((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094142)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094142)), 001503492) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094143)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094143)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094144 as string), 1503492)) THEN false ELSE Contains(cast(COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094144 as string), 1503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094145)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094145)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094146)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094146)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_351EE403_0229_4432_B273_A1F41BC78672#1094147)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_351EE403_0229_4432_B273_A1F41BC78672#1094147)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_12B44094_B64E_4779_A967_D983CDAB1370#1094148)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_12B44094_B64E_4779_A967_D983CDAB1370#1094148)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094149)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094149)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094150)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094150)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094151)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094151)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094152)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094152)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094153 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094153 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094154)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094154)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094155)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094155)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_43523D61_1E4B_4377_998B_7E898D87B867#1094156)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_43523D61_1E4B_4377_998B_7E898D87B867#1094156)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094157)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094157)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F7C888_9836_4535_A22F_D43D2994E019#1094158)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F7C888_9836_4535_A22F_D43D2994E019#1094158)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094159)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094159)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094162 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094162 as string), 1503492.0) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094142,COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094143,COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094144,COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094145,COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094146,COL_351EE403_0229_4432_B273_A1F41BC78672#1094147,COL_12B44094_B64E_4779_A967_D983CDAB1370#1094148,COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094149,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094150,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094151,COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094152,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094153,COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094154,COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094155,COL_43523D61_1E4B_4377_998B_7E898D87B867#1094156,COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094157,COL_60F7C888_9836_4535_A22F_D43D2994E019#1094158,COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094159,COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1094160,COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1094161,COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094162] Batched: true, DataFilters: [((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B0A29476_8712_4938_9AAA_..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_232867], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_B0A29476_8712_4938_9AAA_2B3FED3AA843:string,COL_2C57AE56_072C_4967_B155_3BCF550AC929:s...

Details

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


(1) Scan parquet 
Output [21]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094142, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094143, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094144, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094145, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094146, COL_351EE403_0229_4432_B273_A1F41BC78672#1094147, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094148, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094149, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094150, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094151, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094152, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094153, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094154, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094155, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094156, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094157, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094158, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094159, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1094160, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1094161, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094162]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_232867]
ReadSchema: struct<COL_B0A29476_8712_4938_9AAA_2B3FED3AA843:string,COL_2C57AE56_072C_4967_B155_3BCF550AC929:string,COL_1856697C_8DD2_425F_AA61_054524CA3E4B:int,COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F:string,COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_351EE403_0229_4432_B273_A1F41BC78672:string,COL_12B44094_B64E_4779_A967_D983CDAB1370:string,COL_8761272F_9915_40EB_8429_20EFEF6A9A31:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:string,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46:string,COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8:string,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A:double,COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00:string,COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720:string,COL_43523D61_1E4B_4377_998B_7E898D87B867:string,COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94:string,COL_60F7C888_9836_4535_A22F_D43D2994E019:string,COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506:string,COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB:array<string>,COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3:array<string>,COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2:double>

(2) ColumnarToRow [codegen id : 1]
Input [21]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094142, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094143, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094144, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094145, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094146, COL_351EE403_0229_4432_B273_A1F41BC78672#1094147, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094148, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094149, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094150, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094151, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094152, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094153, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094154, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094155, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094156, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094157, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094158, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094159, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1094160, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1094161, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094162]

(3) Filter [codegen id : 1]
Input [21]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094142, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094143, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094144, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094145, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094146, COL_351EE403_0229_4432_B273_A1F41BC78672#1094147, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094148, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094149, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094150, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094151, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094152, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094153, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094154, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094155, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094156, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094157, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094158, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094159, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1094160, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1094161, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094162]
Condition : ((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094142)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094142)), 001503492) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094143)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094143)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094144 as string), 1503492)) THEN false ELSE Contains(cast(COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094144 as string), 1503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094145)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094145)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094146)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094146)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_351EE403_0229_4432_B273_A1F41BC78672#1094147)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_351EE403_0229_4432_B273_A1F41BC78672#1094147)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_12B44094_B64E_4779_A967_D983CDAB1370#1094148)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_12B44094_B64E_4779_A967_D983CDAB1370#1094148)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094149)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094149)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094150)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094150)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094151)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094151)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094152)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094152)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094153 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094153 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094154)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094154)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094155)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094155)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_43523D61_1E4B_4377_998B_7E898D87B867#1094156)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_43523D61_1E4B_4377_998B_7E898D87B867#1094156)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094157)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094157)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F7C888_9836_4535_A22F_D43D2994E019#1094158)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F7C888_9836_4535_A22F_D43D2994E019#1094158)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094159)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094159)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094162 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094162 as string), 1503492.0) END)

(4) Project [codegen id : 1]
Output [21]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094142 AS COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094328, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094143 AS COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094329, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094144 AS COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094330, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094145 AS COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094331, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094146 AS COL_6D461599_696B_4415_9E1E_62284656C432#1094332, COL_351EE403_0229_4432_B273_A1F41BC78672#1094147 AS COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094333, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094148 AS COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094334, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094149 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094335, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094150 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094336, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094151 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094337, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094152 AS COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094338, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094153 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094339, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094154 AS COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094340, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094155 AS COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094341, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094156 AS COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094342, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094157 AS COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094343, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094158 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094344, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094159 AS COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094345, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1094160 AS COL_FA4C9871_A66B_4A6A_B1CA_5BD2B9E657E2#1094346, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1094161 AS COL_B567B242_E9FB_477C_9A17_BDEE4FCB4902#1094347, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094162 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094348]
Input [21]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094142, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094143, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094144, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094145, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094146, COL_351EE403_0229_4432_B273_A1F41BC78672#1094147, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094148, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094149, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094150, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094151, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094152, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094153, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094154, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094155, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094156, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094157, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094158, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094159, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1094160, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1094161, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094162]

(5) CollectLimit
Input [21]: [COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094328, COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094329, COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094330, COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094331, COL_6D461599_696B_4415_9E1E_62284656C432#1094332, COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094333, COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094334, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094335, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094336, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094337, COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094338, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094339, COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094340, COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094341, COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094342, COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094343, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094344, COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094345, COL_FA4C9871_A66B_4A6A_B1CA_5BD2B9E657E2#1094346, COL_B567B242_E9FB_477C_9A17_BDEE4FCB4902#1094347, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094348]
Arguments: 1500

SQL / DataFrame Properties

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