SP1 - Details for Query 2516

Submitted Time: 2026/06/11 09:55:37
Duration: 0.4 s
Succeeded Jobs: 3819 3820

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 2"]; } 4 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 26 ms"; 6 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label=" Project "]; } 9 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 69 ms"; 11 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 12 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 532.0 B number of coalesced partitions: 1"]; 13 [labelType="html" label="Exchange shuffle records written: 7 local merged chunks fetched: 0 shuffle write time: 0 ms 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: 7 local bytes read: 516.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 1120.0 B 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: 516.0 B"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 19 ms"; 15 [labelType="html" label=" Project "]; } 16 [labelType="html" label="CartesianProduct number of output rows: 7"]; subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 29 ms"; 18 [labelType="html" label=" Project "]; 19 [labelType="html" label="Filter number of output rows: 7"]; 20 [labelType="html" label="ColumnarToRow number of output rows: 7 number of input batches: 1"]; } 21 [labelType="html" label="Scan parquet number of files read: 1 scan time: 3 ms metadata time: 0 ms size of files read: 20.3 KiB number of output rows: 7"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 7 ms"; 23 [labelType="html" label=" Project "]; 24 [labelType="html" label="Filter number of output rows: 1"]; } 25 [labelType="html" label="Scan csv number of output rows: 1 number of files read: 1 metadata time: 0 ms size of files read: 174.0 B"]; 2->0; 3->2; 4->3; 6->4; 7->6; 8->7; 9->8; 11->9; 12->11; 13->12; 15->13; 16->15; 18->16; 19->18; 20->19; 21->20; 23->16; 24->23; 25->24; }

AdaptiveSparkPlan isFinalPlan=true

Filter (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628 <=> 1)

WholeStageCodegen (6)

Window [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST]

Sort [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST], false, 0

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, str_if_with_rule(CASE WHEN isnull(Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSN)) THEN false ELSE Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSN) END, str_join(array(SSN, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485), *), str_if_with_rule(CASE WHEN isnull(Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSF)) THEN false ELSE Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSF) END, str_join(array(SSF, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485), *), null)) AS COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]

WholeStageCodegen (5)

Window [collect_set(COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485], [1 DESC NULLS LAST]

Sort [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, 10), ENSURE_REQUIREMENTS, [plan_id=488677]

WholeStageCodegen (3)

CartesianProduct

Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056 AS COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108 AS COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]

Filter (COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 <=> 011040518)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056,COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077,COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089,COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103,COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108] Batched: true, DataFilters: [(COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 <=> 011040518)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_210234], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_64ED17E5_A991_405B_AEED_8A2977283F76,011040518)], ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62:s...

Project

Filter ((isnotnull(REGLES#792180) AND (RC-SSN-SSF = REGLES#792180)) AND (APPLICABLE#792181 <=> O))

WholeStageCodegen (2)

FileScan csv [REGLES#792180,APPLICABLE#792181] Batched: false, DataFilters: [isnotnull(REGLES#792180), (RC-SSN-SSF = REGLES#792180), (APPLICABLE#792181 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_209983/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SSN-SSF), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (37)
+- == Final Plan ==
   * Project (20)
   +- * Filter (19)
      +- Window (18)
         +- * Sort (17)
            +- * Project (16)
               +- * Project (15)
                  +- Window (14)
                     +- * Sort (13)
                        +- AQEShuffleRead (12)
                           +- ShuffleQueryStage (11), Statistics(sizeInBytes=1120.0 B, rowCount=7)
                              +- Exchange (10)
                                 +- * Project (9)
                                    +- CartesianProduct Inner (8)
                                       :- * Project (4)
                                       :  +- * Filter (3)
                                       :     +- * ColumnarToRow (2)
                                       :        +- Scan parquet  (1)
                                       +- * Project (7)
                                          +- * Filter (6)
                                             +- Scan csv  (5)
+- == Initial Plan ==
   CollectLimit (36)
   +- Project (35)
      +- Filter (34)
         +- Window (33)
            +- Sort (32)
               +- Project (31)
                  +- Project (30)
                     +- Window (29)
                        +- Sort (28)
                           +- Exchange (27)
                              +- Project (26)
                                 +- CartesianProduct Inner (25)
                                    :- Project (22)
                                    :  +- Filter (21)
                                    :     +- Scan parquet  (1)
                                    +- Project (24)
                                       +- Filter (23)
                                          +- Scan csv  (5)


(1) Scan parquet 
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_210234]
PushedFilters: [EqualNullSafe(COL_64ED17E5_A991_405B_AEED_8A2977283F76,011040518)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62:string,COL_7D270645_B926_42AF_A110_EB3A1A53031B:string,COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157:string,COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28:string,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A:string,COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF:timestamp>

(2) ColumnarToRow [codegen id : 1]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108]

(3) Filter [codegen id : 1]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108]
Condition : (COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 <=> 011040518)

(4) Project [codegen id : 1]
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056 AS COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108 AS COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108]

(5) Scan csv 
Output [2]: [REGLES#792180, APPLICABLE#792181]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_209983/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SSN-SSF), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(6) Filter [codegen id : 2]
Input [2]: [REGLES#792180, APPLICABLE#792181]
Condition : ((isnotnull(REGLES#792180) AND (RC-SSN-SSF = REGLES#792180)) AND (APPLICABLE#792181 <=> O))

(7) Project [codegen id : 2]
Output: []
Input [2]: [REGLES#792180, APPLICABLE#792181]

(8) CartesianProduct
Join type: Inner
Join condition: None

(9) Project [codegen id : 3]
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, LEFT) AS COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]

(10) Exchange
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, 10), ENSURE_REQUIREMENTS, [plan_id=488677]

(11) ShuffleQueryStage
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: 0

(12) AQEShuffleRead
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: coalesced

(13) Sort [codegen id : 4]
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(14) Window
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: [collect_set(COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485], [1 DESC NULLS LAST]

(15) Project [codegen id : 5]
Output [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, str_list_as_str(COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509) AS COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509]

(16) Project [codegen id : 5]
Output [13]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, str_if_with_rule(CASE WHEN isnull(Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSN)) THEN false ELSE Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSN) END, str_join(array(SSN, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485), *), str_if_with_rule(CASE WHEN isnull(Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSF)) THEN false ELSE Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSF) END, str_join(array(SSF, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485), *), null)) AS COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571]

(17) Sort [codegen id : 5]
Input [13]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST], false, 0

(18) Window
Input [13]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]
Arguments: [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST]

(19) Filter [codegen id : 6]
Input [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628]
Condition : (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628 <=> 1)

(20) Project [codegen id : 6]
Output [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Input [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628]

(21) Filter
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108]
Condition : (COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 <=> 011040518)

(22) Project
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056 AS COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108 AS COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108]

(23) Filter
Input [2]: [REGLES#792180, APPLICABLE#792181]
Condition : ((isnotnull(REGLES#792180) AND (RC-SSN-SSF = REGLES#792180)) AND (APPLICABLE#792181 <=> O))

(24) Project
Output: []
Input [2]: [REGLES#792180, APPLICABLE#792181]

(25) CartesianProduct
Join type: Inner
Join condition: None

(26) Project
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, LEFT) AS COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]

(27) Exchange
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, 10), ENSURE_REQUIREMENTS, [plan_id=488633]

(28) Sort
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(29) Window
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: [collect_set(COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485], [1 DESC NULLS LAST]

(30) Project
Output [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, str_list_as_str(COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509) AS COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509]

(31) Project
Output [13]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, str_if_with_rule(CASE WHEN isnull(Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSN)) THEN false ELSE Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSN) END, str_join(array(SSN, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485), *), str_if_with_rule(CASE WHEN isnull(Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSF)) THEN false ELSE Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSF) END, str_join(array(SSF, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485), *), null)) AS COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571]

(32) Sort
Input [13]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST], false, 0

(33) Window
Input [13]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]
Arguments: [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST]

(34) Filter
Input [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628]
Condition : (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628 <=> 1)

(35) Project
Output [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Input [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628]

(36) CollectLimit
Input [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Arguments: 1500

(37) AdaptiveSparkPlan
Output [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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