SP1 - Details for Query 609

Submitted Time: 2026/08/28 12:27:16
Duration: 17 s
Succeeded Jobs: 727 729

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="Filter number of output rows: 1,500"]; } 5 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; 7 [labelType="html" label="Sort sort time: 35 ms peak memory: 152.0 MiB spill size: 0.0 B"]; } 8 [labelType="html" label="Exchange shuffle records written: 2,996,009 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 682 ms (106 ms, 575 ms, 575 ms (stage 1189.0: task 1607)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 298,799 local bytes read: 24.7 MiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 1375.6 MiB (204.9 MiB, 1170.7 MiB, 1170.7 MiB (stage 1189.0: task 1607)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 247.3 MiB (37.0 MiB, 210.4 MiB, 210.4 MiB (stage 1189.0: task 1607))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n18.9 s (3 ms, 6 ms, 15.8 s (stage 1189.0: task 1607))"; 10 [labelType="html" label=" Project "]; 11 [labelType="html" label=" Project "]; 12 [labelType="html" label="ColumnarToRow number of output rows: 2,996,009 number of input batches: 732"]; } 13 [labelType="html" label="Scan parquet number of files read: 1 scan time total (min, med, max (stageId: taskId)) 1.7 s (2 ms, 5 ms, 1.4 s (stage 1189.0: task 1607)) metadata time: 0 ms size of files read: 150.9 MiB number of output rows: 2,996,009"]; 1->0; 3->1; 4->3; 5->4; 7->5; 8->7; 10->8; 11->10; 12->11; 13->12; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#107776, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]

Filter (COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737 <=> 1)

WholeStageCodegen (3)

Window [collect_set(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, 0, 0) windowspecdefinition(COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#107776], [COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667], [1 DESC NULLS LAST]

Sort [COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (2)

Exchange hashpartitioning(COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, 10), ENSURE_REQUIREMENTS, [plan_id=29776]

Project [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, str_join(array(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704), -) AS COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, str_if_with_rule((((COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689 <=> SAS) OR (COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689 <=> SUF)) OR (COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689 <=> SUN)), 1, 0) AS COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]

Project [COL_B706A975_F287_4DC9_B631_A35735FE936F#107559 AS COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#107560 AS COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#107561 AS COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 AS COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#107563 AS COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#107564 AS COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#107565 AS COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#107566 AS COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#107567 AS COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#107568 AS COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#107569 AS COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_C7343A35_76C1_46A3_B74D_C7263B786745#107570 AS COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_52134AAB_9340_42E7_9290_A298AF6C9438#107571 AS COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#107559, 78, 5), null), ONLY_ONE) AS COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#107559, 68, 2), null), ONLY_ONE) AS COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_B706A975_F287_4DC9_B631_A35735FE936F#107559,COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#107560,COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#107561,COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562,COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#107563,COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#107564,COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#107565,COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#107566,COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#107567,COL_E53A575D_3952_4C14_AC9F_075847D06BB1#107568,COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#107569,COL_C7343A35_76C1_46A3_B74D_C7263B786745#107570,COL_52134AAB_9340_42E7_9290_A298AF6C9438#107571] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_A_LIGNES_RSF_345253], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_B706A975_F287_4DC9_B631_A35735FE936F:string,COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (20)
+- == Final Plan ==
   CollectLimit (11)
   +- * Project (10)
      +- * Filter (9)
         +- Window (8)
            +- * Sort (7)
               +- ShuffleQueryStage (6), Statistics(sizeInBytes=1375.6 MiB, rowCount=3.00E+6)
                  +- Exchange (5)
                     +- * Project (4)
                        +- * Project (3)
                           +- * ColumnarToRow (2)
                              +- Scan parquet  (1)
+- == Initial Plan ==
   CollectLimit (19)
   +- Project (18)
      +- Filter (17)
         +- Window (16)
            +- Sort (15)
               +- Exchange (14)
                  +- Project (13)
                     +- Project (12)
                        +- Scan parquet  (1)


(1) Scan parquet 
Output [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#107559, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#107560, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#107561, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#107563, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#107564, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#107565, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#107566, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#107567, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#107568, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#107569, COL_C7343A35_76C1_46A3_B74D_C7263B786745#107570, COL_52134AAB_9340_42E7_9290_A298AF6C9438#107571]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_A_LIGNES_RSF_345253]
ReadSchema: struct<COL_B706A975_F287_4DC9_B631_A35735FE936F:string,COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8:string,COL_AAF7896D_A513_4CEC_9984_26D0D5838E44:int,COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38:string,COL_0767075F_6D90_4406_A1C5_BC087A39F7CE:string,COL_95A012EF_312B_40A6_8CFC_200BFD4465E3:string,COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D:string,COL_B72BD372_650E_474E_B8E0_7CB995AE80BF:string,COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA:string,COL_E53A575D_3952_4C14_AC9F_075847D06BB1:string,COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4:string,COL_C7343A35_76C1_46A3_B74D_C7263B786745:string,COL_52134AAB_9340_42E7_9290_A298AF6C9438:string>

(2) ColumnarToRow [codegen id : 1]
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#107559, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#107560, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#107561, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#107563, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#107564, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#107565, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#107566, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#107567, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#107568, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#107569, COL_C7343A35_76C1_46A3_B74D_C7263B786745#107570, COL_52134AAB_9340_42E7_9290_A298AF6C9438#107571]

(3) Project [codegen id : 1]
Output [15]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#107559 AS COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#107560 AS COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#107561 AS COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 AS COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#107563 AS COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#107564 AS COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#107565 AS COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#107566 AS COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#107567 AS COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#107568 AS COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#107569 AS COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_C7343A35_76C1_46A3_B74D_C7263B786745#107570 AS COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_52134AAB_9340_42E7_9290_A298AF6C9438#107571 AS COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#107559, 78, 5), null), ONLY_ONE) AS COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#107559, 68, 2), null), ONLY_ONE) AS COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704]
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#107559, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#107560, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#107561, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#107563, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#107564, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#107565, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#107566, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#107567, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#107568, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#107569, COL_C7343A35_76C1_46A3_B74D_C7263B786745#107570, COL_52134AAB_9340_42E7_9290_A298AF6C9438#107571]

(4) Project [codegen id : 1]
Output [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, str_join(array(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704), -) AS COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, str_if_with_rule((((COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689 <=> SAS) OR (COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689 <=> SUF)) OR (COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689 <=> SUN)), 1, 0) AS COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704]

(5) Exchange
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Arguments: hashpartitioning(COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, 10), ENSURE_REQUIREMENTS, [plan_id=29776]

(6) ShuffleQueryStage
Output [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Arguments: 0

(7) Sort [codegen id : 2]
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Arguments: [COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(8) Window
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Arguments: [collect_set(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, 0, 0) windowspecdefinition(COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#107776], [COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667], [1 DESC NULLS LAST]

(9) Filter [codegen id : 3]
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#107776]
Condition : (COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737 <=> 1)

(10) Project [codegen id : 3]
Output [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#107776, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#107776]

(11) CollectLimit
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#107776, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Arguments: 1500

(12) Project
Output [15]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#107559 AS COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#107560 AS COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#107561 AS COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 AS COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#107563 AS COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#107564 AS COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#107565 AS COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#107566 AS COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#107567 AS COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#107568 AS COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#107569 AS COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_C7343A35_76C1_46A3_B74D_C7263B786745#107570 AS COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_52134AAB_9340_42E7_9290_A298AF6C9438#107571 AS COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#107559, 78, 5), null), ONLY_ONE) AS COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#107559, 68, 2), null), ONLY_ONE) AS COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704]
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#107559, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#107560, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#107561, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#107562, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#107563, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#107564, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#107565, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#107566, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#107567, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#107568, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#107569, COL_C7343A35_76C1_46A3_B74D_C7263B786745#107570, COL_52134AAB_9340_42E7_9290_A298AF6C9438#107571]

(13) Project
Output [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, str_join(array(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704), -) AS COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, str_if_with_rule((((COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689 <=> SAS) OR (COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689 <=> SUF)) OR (COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689 <=> SUN)), 1, 0) AS COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704]

(14) Exchange
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Arguments: hashpartitioning(COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, 10), ENSURE_REQUIREMENTS, [plan_id=29754]

(15) Sort
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Arguments: [COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(16) Window
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Arguments: [collect_set(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, 0, 0) windowspecdefinition(COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#107776], [COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667], [1 DESC NULLS LAST]

(17) Filter
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#107776]
Condition : (COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737 <=> 1)

(18) Project
Output [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#107776, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#107776]

(19) CollectLimit
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#107776, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Arguments: 1500

(20) AdaptiveSparkPlan
Output [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#107663, COL_A86D3251_6564_4706_815A_936FA28EC2B7#107664, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#107665, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#107666, COL_86264515_64DE_4F5A_B65C_1F224369C11E#107667, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#107668, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#107669, COL_A90C305E_35FC_4943_AAB5_5689729329D0#107670, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#107671, COL_A125700F_63CC_436A_9370_99E22C285ACF#107672, COL_8678C313_B7BE_49C0_A54D_231C14C94790#107673, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#107674, COL_8C91B482_E1DB_447D_99E8_C109117EA414#107675, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#107689, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#107776, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#107704, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#107720, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#107737]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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