SP1 - Details for Query 17588

Submitted Time: 2026/06/10 16:03:26
Duration: 1.3 min
Succeeded Jobs: 23928
Failed Jobs: 23929

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))\n62 ms (0 ms, 3 ms, 53 ms (stage 45087.0: task 64493))"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="Filter number of output rows: 202"]; 5 [labelType="html" label="ColumnarToRow number of output rows: 1,458,176 number of input batches: 356"]; } 6 [labelType="html" label="Scan parquet number of files read: 1 scan time total (min, med, max (stageId: taskId)) 972 ms (2 ms, 4 ms, 911 ms (stage 45087.0: task 64492)) metadata time: 0 ms size of files read: 192.7 MiB number of output rows: 1,458,176"]; 2->0; 3->2; 4->3; 5->4; 6->5; }

CollectLimit 1500

Project [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889131, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889132, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889133, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889134, COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889135, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889144, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889145, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889148, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889149, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889150, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889151, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889152, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889153, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889154, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889155, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889156, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889157, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889158L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889159, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189, str_if_with_rule(((((COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189 <=> CS) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189 <=> CS N)) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189 <=> CS F)) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189 <=> APC)), str_join(array(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889145), -), null) AS COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889272]

Project [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899 AS COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889131, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888900 AS COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889132, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888901 AS COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889133, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 AS COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889134, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888903 AS COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889135, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888912 AS COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889144, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913 AS COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889145, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888916 AS COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889148, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888917 AS COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889149, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888918 AS COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889150, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888919 AS COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889151, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888920 AS COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889152, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888921 AS COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889153, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888922 AS COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889154, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888923 AS COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889155, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888924 AS COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889156, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888927 AS COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889157, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888925L AS COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889158L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888926 AS COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889159, str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) AS COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189]

Filter ((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899)), CS N) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888900)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888900)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888901)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888901)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888912)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888912)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888916)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888916)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888917)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888917)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888918)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888918)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888919)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888919)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888920)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888920)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888921)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888921)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888922)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888922)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888923)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888923)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888924)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888924)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888927)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888927)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888926)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888926)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE))), CS N)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE))), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913), -), null))), CS N)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913), -), null))), CS N) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888900,COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888901,COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902,COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888903,COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888912,COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913,COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888916,COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888917,COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888918,COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888919,COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888920,COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888921,COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888922,COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888923,COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888924,COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888925L,COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888926,COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888927] Batched: true, DataFilters: [((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_..., 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 (6)
+- * Project (5)
   +- * Project (4)
      +- * Filter (3)
         +- * ColumnarToRow (2)
            +- Scan parquet  (1)


(1) Scan parquet 
Output [19]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888900, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888901, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888903, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888912, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888916, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888917, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888918, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888919, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888920, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888921, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888922, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888923, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888924, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888925L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888926, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888927]
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_410747F2_ADCB_4C39_B9B9_C56104DAC484:string,COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5: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 [19]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888900, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888901, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888903, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888912, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888916, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888917, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888918, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888919, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888920, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888921, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888922, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888923, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888924, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888925L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888926, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888927]

(3) Filter [codegen id : 1]
Input [19]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888900, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888901, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888903, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888912, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888916, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888917, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888918, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888919, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888920, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888921, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888922, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888923, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888924, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888925L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888926, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888927]
Condition : ((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899)), CS  N) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888900)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888900)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888901)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888901)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888912)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888912)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888916)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888916)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888917)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888917)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888918)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888918)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888919)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888919)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888920)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888920)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888921)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888921)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888922)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888922)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888923)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888923)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888924)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888924)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888927)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888927)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888926)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888926)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE))), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE))), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913), -), null))), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913), -), null))), CS  N) END)

(4) Project [codegen id : 1]
Output [20]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899 AS COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889131, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888900 AS COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889132, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888901 AS COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889133, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 AS COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889134, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888903 AS COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889135, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888912 AS COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889144, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913 AS COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889145, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888916 AS COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889148, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888917 AS COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889149, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888918 AS COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889150, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888919 AS COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889151, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888920 AS COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889152, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888921 AS COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889153, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888922 AS COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889154, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888923 AS COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889155, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888924 AS COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889156, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888927 AS COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889157, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888925L AS COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889158L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888926 AS COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889159, str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, 78, 5), )), ONLY_ONE) AS COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189]
Input [19]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888899, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888900, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888901, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888902, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#3888903, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888912, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888913, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888916, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888917, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888918, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888919, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888920, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888921, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888922, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888923, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888924, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#3888925L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888926, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888927]

(5) Project [codegen id : 1]
Output [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889131, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889132, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889133, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889134, COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889135, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889144, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889145, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889148, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889149, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889150, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889151, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889152, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889153, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889154, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889155, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889156, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889157, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889158L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889159, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189, str_if_with_rule(((((COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189 <=> CS) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189 <=> CS N)) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189 <=> CS F)) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189 <=> APC)), str_join(array(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889145), -), null) AS COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889272]
Input [20]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889131, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889132, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889133, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889134, COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889135, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889144, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889145, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889148, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889149, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889150, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889151, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889152, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889153, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889154, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889155, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889156, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889157, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889158L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889159, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189]

(6) CollectLimit
Input [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889131, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889132, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889133, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889134, COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889135, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889144, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889145, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889148, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889149, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889150, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889151, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889152, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889153, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889154, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889155, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889156, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889157, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889158L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889159, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889189, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889272]
Arguments: 1500

SQL / DataFrame Properties

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