SP1 - Details for Query 17592

Submitted Time: 2026/06/10 16:05:00
Duration: 5 s
Succeeded Jobs: 23933 23935 23936

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))\n13.9 s (912 ms, 1.4 s, 2.0 s (stage 45094.0: task 64509))"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 453"]; 4 [labelType="html" label="ColumnarToRow number of output rows: 2,996,010 number of input batches: 737"]; } 5 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 2.8 s (184 ms, 304 ms, 413 ms (stage 45091.0: task 64506)) metadata time: 0 ms size of files read: 186.5 MiB number of output rows: 2,996,010"]; 2->0; 3->2; 4->3; 5->4; }

CollectLimit 1500

Project [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889633 AS COL_COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889789, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889634 AS COL_COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889790, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889635 AS COL_COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889791, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889636 AS COL_COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889792, COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889637 AS COL_COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889793, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889638 AS COL_COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889794, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889639 AS COL_COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889795, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889640 AS COL_COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889796, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889641 AS COL_COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889797, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889642 AS COL_COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889798, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889643 AS COL_COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889799, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889644 AS COL_COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889800, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889645 AS COL_COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889801, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889646 AS COL_COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889802, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889647 AS COL_COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889803, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889648 AS COL_COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889804, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889649 AS COL_COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889805, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889650L AS COL_COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889806L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889651 AS COL_COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889807, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889652 AS COL_COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889808, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#3889653 AS COL_COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#3889809, COL_00870525_B429_406C_B5B2_48E81839DF83#3889654 AS COL_COL_00870525_B429_406C_B5B2_48E81839DF83#3889810, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#3889655 AS COL_COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#3889811, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#3889656 AS COL_COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#3889812, ... 2 more fields]

Filter (((((((((((((((((((CASE WHEN isnull(Contains(COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889633, CS N)) THEN false ELSE Contains(COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889633, CS N) END OR CASE WHEN isnull(Contains(COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889634, CS N)) THEN false ELSE Contains(COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889634, CS N) END) OR CASE WHEN isnull(Contains(COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889635, CS N)) THEN false ELSE Contains(COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889635, CS N) END) OR CASE WHEN isnull(Contains(COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889636, CS N)) THEN false ELSE Contains(COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889636, CS N) END) OR CASE WHEN isnull(Contains(COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889638, CS N)) THEN false ELSE Contains(COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889638, CS N) END) OR CASE WHEN isnull(Contains(COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889639, CS N)) THEN false ELSE Contains(COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889639, CS N) END) OR CASE WHEN isnull(Contains(COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889640, CS N)) THEN false ELSE Contains(COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889640, CS N) END) OR CASE WHEN isnull(Contains(COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889641, CS N)) THEN false ELSE Contains(COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889641, CS N) END) OR CASE WHEN isnull(Contains(COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889642, CS N)) THEN false ELSE Contains(COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889642, CS N) END) OR CASE WHEN isnull(Contains(COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889643, CS N)) THEN false ELSE Contains(COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889643, CS N) END) OR CASE WHEN isnull(Contains(COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889644, CS N)) THEN false ELSE Contains(COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889644, CS N) END) OR CASE WHEN isnull(Contains(COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889645, CS N)) THEN false ELSE Contains(COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889645, CS N) END) OR CASE WHEN isnull(Contains(COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889646, CS N)) THEN false ELSE Contains(COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889646, CS N) END) OR CASE WHEN isnull(Contains(COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889647, CS N)) THEN false ELSE Contains(COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889647, CS N) END) OR CASE WHEN isnull(Contains(COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889648, CS N)) THEN false ELSE Contains(COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889648, CS N) END) OR CASE WHEN isnull(Contains(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889649, CS N)) THEN false ELSE Contains(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889649, CS N) END) OR CASE WHEN isnull(Contains(COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889651, CS N)) THEN false ELSE Contains(COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889651, CS N) END) OR CASE WHEN isnull(Contains(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889652, CS N)) THEN false ELSE Contains(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889652, CS N) END) OR CASE WHEN isnull(Contains(COL_00870525_B429_406C_B5B2_48E81839DF83#3889654, CS N)) THEN false ELSE Contains(COL_00870525_B429_406C_B5B2_48E81839DF83#3889654, CS N) END) OR CASE WHEN isnull(Contains(COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889657, CS N)) THEN false ELSE Contains(COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889657, CS N) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889633,COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889634,COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889635,COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889636,COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889637,COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889638,COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889639,COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889640,COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889641,COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889642,COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889643,COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889644,COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889645,COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889646,COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889647,COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889648,COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889649,COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889650L,COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889651,COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889652,COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#3889653,COL_00870525_B429_406C_B5B2_48E81839DF83#3889654,COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#3889655,COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#3889656,... 2 more fields] Batched: true, DataFilters: [(((((((((((((((((((CASE WHEN isnull(Contains(COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889633, C..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/01_A_STEP_1_RSF_215951], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243:string,COL_6F5E8886_D62F_4949_8CEA_F222954BFC84:s...

Details

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


(1) Scan parquet 
Output [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889633, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889634, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889635, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889636, COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889637, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889638, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889639, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889640, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889641, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889642, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889643, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889644, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889645, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889646, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889647, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889648, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889649, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889650L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889651, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889652, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#3889653, COL_00870525_B429_406C_B5B2_48E81839DF83#3889654, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#3889655, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#3889656, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889657, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#3889658]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/01_A_STEP_1_RSF_215951]
ReadSchema: struct<COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243:string,COL_6F5E8886_D62F_4949_8CEA_F222954BFC84:string,COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2:string,COL_16E424CE_9B54_4F68_B514_607D2B496B5E:string,COL_76DBABA9_CE78_451B_9E43_031763A13C92:int,COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86:string,COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F:string,COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50:string,COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690:string,COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D:string,COL_90F15518_AEAA_468F_80BE_4F4773EFDA05:string,COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839:string,COL_346C27DC_6D06_4FCF_A022_7FF177053D81:string,COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62:string,COL_B41CF42C_004D_4F47_A1D6_C923097E3079:string,COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE:string,COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0:string,COL_969EAFA1_AD39_4285_AD05_6146CD6F9342:bigint,COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487:string,COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC:string,COL_714AB906_7002_4ADC_AA1A_38467A3EDE10:array<string>,COL_00870525_B429_406C_B5B2_48E81839DF83:string,COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6:int,COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1:int,COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641:string,COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C:array<string>>

(2) ColumnarToRow [codegen id : 1]
Input [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889633, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889634, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889635, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889636, COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889637, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889638, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889639, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889640, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889641, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889642, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889643, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889644, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889645, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889646, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889647, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889648, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889649, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889650L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889651, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889652, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#3889653, COL_00870525_B429_406C_B5B2_48E81839DF83#3889654, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#3889655, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#3889656, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889657, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#3889658]

(3) Filter [codegen id : 1]
Input [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889633, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889634, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889635, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889636, COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889637, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889638, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889639, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889640, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889641, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889642, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889643, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889644, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889645, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889646, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889647, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889648, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889649, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889650L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889651, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889652, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#3889653, COL_00870525_B429_406C_B5B2_48E81839DF83#3889654, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#3889655, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#3889656, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889657, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#3889658]
Condition : (((((((((((((((((((CASE WHEN isnull(Contains(COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889633, CS  N)) THEN false ELSE Contains(COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889633, CS  N) END OR CASE WHEN isnull(Contains(COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889634, CS  N)) THEN false ELSE Contains(COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889634, CS  N) END) OR CASE WHEN isnull(Contains(COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889635, CS  N)) THEN false ELSE Contains(COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889635, CS  N) END) OR CASE WHEN isnull(Contains(COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889636, CS  N)) THEN false ELSE Contains(COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889636, CS  N) END) OR CASE WHEN isnull(Contains(COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889638, CS  N)) THEN false ELSE Contains(COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889638, CS  N) END) OR CASE WHEN isnull(Contains(COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889639, CS  N)) THEN false ELSE Contains(COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889639, CS  N) END) OR CASE WHEN isnull(Contains(COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889640, CS  N)) THEN false ELSE Contains(COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889640, CS  N) END) OR CASE WHEN isnull(Contains(COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889641, CS  N)) THEN false ELSE Contains(COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889641, CS  N) END) OR CASE WHEN isnull(Contains(COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889642, CS  N)) THEN false ELSE Contains(COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889642, CS  N) END) OR CASE WHEN isnull(Contains(COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889643, CS  N)) THEN false ELSE Contains(COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889643, CS  N) END) OR CASE WHEN isnull(Contains(COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889644, CS  N)) THEN false ELSE Contains(COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889644, CS  N) END) OR CASE WHEN isnull(Contains(COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889645, CS  N)) THEN false ELSE Contains(COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889645, CS  N) END) OR CASE WHEN isnull(Contains(COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889646, CS  N)) THEN false ELSE Contains(COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889646, CS  N) END) OR CASE WHEN isnull(Contains(COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889647, CS  N)) THEN false ELSE Contains(COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889647, CS  N) END) OR CASE WHEN isnull(Contains(COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889648, CS  N)) THEN false ELSE Contains(COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889648, CS  N) END) OR CASE WHEN isnull(Contains(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889649, CS  N)) THEN false ELSE Contains(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889649, CS  N) END) OR CASE WHEN isnull(Contains(COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889651, CS  N)) THEN false ELSE Contains(COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889651, CS  N) END) OR CASE WHEN isnull(Contains(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889652, CS  N)) THEN false ELSE Contains(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889652, CS  N) END) OR CASE WHEN isnull(Contains(COL_00870525_B429_406C_B5B2_48E81839DF83#3889654, CS  N)) THEN false ELSE Contains(COL_00870525_B429_406C_B5B2_48E81839DF83#3889654, CS  N) END) OR CASE WHEN isnull(Contains(COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889657, CS  N)) THEN false ELSE Contains(COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889657, CS  N) END)

(4) Project [codegen id : 1]
Output [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889633 AS COL_COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889789, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889634 AS COL_COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889790, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889635 AS COL_COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889791, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889636 AS COL_COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889792, COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889637 AS COL_COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889793, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889638 AS COL_COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889794, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889639 AS COL_COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889795, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889640 AS COL_COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889796, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889641 AS COL_COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889797, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889642 AS COL_COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889798, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889643 AS COL_COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889799, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889644 AS COL_COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889800, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889645 AS COL_COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889801, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889646 AS COL_COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889802, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889647 AS COL_COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889803, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889648 AS COL_COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889804, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889649 AS COL_COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889805, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889650L AS COL_COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889806L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889651 AS COL_COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889807, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889652 AS COL_COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889808, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#3889653 AS COL_COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#3889809, COL_00870525_B429_406C_B5B2_48E81839DF83#3889654 AS COL_COL_00870525_B429_406C_B5B2_48E81839DF83#3889810, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#3889655 AS COL_COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#3889811, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#3889656 AS COL_COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#3889812, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889657 AS COL_COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889813, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#3889658 AS COL_COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#3889814]
Input [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889633, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889634, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889635, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889636, COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889637, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889638, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889639, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889640, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889641, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889642, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889643, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889644, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889645, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889646, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889647, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889648, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889649, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889650L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889651, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889652, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#3889653, COL_00870525_B429_406C_B5B2_48E81839DF83#3889654, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#3889655, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#3889656, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889657, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#3889658]

(5) CollectLimit
Input [26]: [COL_COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#3889789, COL_COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#3889790, COL_COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#3889791, COL_COL_16E424CE_9B54_4F68_B514_607D2B496B5E#3889792, COL_COL_76DBABA9_CE78_451B_9E43_031763A13C92#3889793, COL_COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#3889794, COL_COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#3889795, COL_COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#3889796, COL_COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#3889797, COL_COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#3889798, COL_COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#3889799, COL_COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#3889800, COL_COL_346C27DC_6D06_4FCF_A022_7FF177053D81#3889801, COL_COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#3889802, COL_COL_B41CF42C_004D_4F47_A1D6_C923097E3079#3889803, COL_COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#3889804, COL_COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#3889805, COL_COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#3889806L, COL_COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#3889807, COL_COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#3889808, COL_COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#3889809, COL_COL_00870525_B429_406C_B5B2_48E81839DF83#3889810, COL_COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#3889811, COL_COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#3889812, COL_COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#3889813, COL_COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#3889814]
Arguments: 1500

SQL / DataFrame Properties

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